Oracle BI
Oracle Business Intelligence Enterprise Edition Plus, also termed as the OBI EE Plus, is Oracle Corporation’s set of business intelligence tools consisting of former Siebel Systems business intelligence and Hyperion Solutions business intelligence offerings.
Instructor: Tom Steven
- Lectures: 20
- Duration: 10 weeks
This is the most important IT training association that has been in use for the past 15 years. Our Expertise & Technology Trainer is for college students, freshmen, professionals, and non-professionals, who want to create a bright career at Oracle and are targeted at people with high demand and demand in the industry. Oracle-Business Intelligence is a comprehensive and innovative business intelligence platform that delivers a wide range of BI features. It does not matter
if you feel that you do not have such knowledge and still want to go for this. We prepare batches for the student’s convenient weekdays and weekends. You can join the demo class for free and then register yourself.
Content
Overview
Building the Physical Layer of a Repository
Building the Business Model and Mapping Layer of a Repository
Building the Presentation Layer of a Repository
Testing and Validating a Repository
Managing Logical Table Sources
Creating Calculation Measures
Creating Logical Dimensions with Level-Based Hierarchies
Creating Level-Based Measures
Creating Logical Dimensions with Parent-Child Hierarchies
Creating Logical Dimensions with Ragged and Skipped-Level Hierarchies
Using Aggregates
Using Initialization Blocks and Variables
Creating Time Series Measures
Creating Time Series Measures
Importing a Multidimensional Data Source into a Repository Importing an Essbase cube into the repository.
Exploring the multidimensional schema in the Physical layer
Converting the Measure dimension to flat measures
Verifying the connection to the Essbase data source
Creating the business model
Creating the subject area
Performing Ad Hoc Analysis on the Imported Data Source Creating a simple chart
Performing Ad Hoc Analysis on the Imported Data Source Creating a simple chart
Performing Ad Hoc Analysis on the Imported Data Source Creating a simple chart
Examining Merge Scenarios Describing Merge Types
Merging Objects from Different Repositories with a Common Parent (Standard Three-Way Merge)
Merging Objects from Different Repositories with a Common Parent (Standard Three-Way Merge)
Merging Objects from Different Repositories without a Common Parent (Two-Way Merge)
Merging Objects from Different Repositories without a Common Parent (Two-Way Merge)
Preparing the Environment – Initial Administrative Tasks
Working in a Multiuser Development Environment
Checking In and Publishing a MUDE Project
Checking In and Publishing a MUDE Project
Building a Business Model to Provide Horizontal Federation Adding Relational Measures
Creating Logical Joins in the Business Model: Products Dimension
Creating a Subject Area and Saving the Repository
Verifying your Work in Oracle BI EE
Building a Business Model to Provide Vertical Federation Modifying the Months Hierarchy for Vertical Federation
Building a Business Model to Provide Vertical Federation Modifying the Months Hierarchy for Vertical Federation
Mapping Facts to Multiple Sources and Setting Logical Levels
Checking Vertical Federation in Oracle BI EE
Checking Vertical Federation in Oracle BI EE
Creating the Usage Tracking Subject Area in the Repository
Configuring Usage Tracking in Enterprise Manager
Populating the Usage Tracking Table and Verifying Usage Tracking
Creating Aggregates using Aggregate Persistence Wizard in Oracle BI 11g
Creating Aggregates using Aggregate Persistence Wizard in Oracle BI 11g
Creating the Aggregates
Verifying that the Aggregates were Successfully Created
Creating Analysis to Use the Aggregates
Creating Analysis to Use the Aggregates
Deleting Aggregates
Setting Up Summary Advisor
Running Summary Advisor Wizard
Creating Aggregates
Using the Aggregates
Using the Aggregates
Presentation Services Selecting a Recommended Visualization
Using Breadcrumbs to Navigate Oracle BI Content
Creating Custom Print Layouts
Freezing Dashboard Columns
Creating a Performance Tile View
Using the Current View or All Views Option
Limiting Values in a Column Prompt Value List
Replacing an Analysis in a Dashboard
Specifying Fixed Headers or Paging Controls
BI Mobile
BI Mobile
Installation
Metadata Repository
System Administration
Security
Security
Beginning the Analytic Process
Creating Analysis
Adding a Graph to an Analysis
Working with Pivot Tables, and Master-Detail Linking
Adding Performance Tile to an Analysis
Adding a Simple Trellis to an Analysis
Working with Other View Types
Building Dashboards
Prompting to Filter Analysis
Prompting to Filter Analysis
Setting Up Smart View
Inserting Oracle BI EE Views into Smart View Clients
Working with Views in Smart View Clients
Copying and Pasting Oracle BI EE Objects
Creating and Publishing Views Using the View Designer
Creating and Publishing Views Using the View Designer
Enabling BI Navigation Log in to Oracle BI EE and Create an Analysis
Add an Action Link to the Analysis
Test the Action Link
Save the Action in the Presentation Catalog
Enabling Web Navigation and Passing Parameters Set the Action Link to Display Conditionally
Enabling Web Navigation and Passing Parameters Set the Action Link to Display Conditionally
Creating a New Action Execute the Action
Creating a New Action Execute the Action
Creating a Web Service Action
Creating a Web Service Action
Consuming Actions
Consuming Actions
Deploying analyticsRes and developing a Custom Skin Exposing a Static Directory in WebLogic Server
Deploying a Custom Skin
Deploying a Custom Style
Deploying a Custom Style
Deploying Custom Messages
Deploying Custom Messages
Installing the ArGoSoft Mail Server
Configuring the eMail Client
Creating a New Analysis
Creating a Condition-Based Agent/Alert
Verifying the Mail Client for the Agent/Alert
Verifying the Mail Client for the Agent/Alert
General Navigation and Preferences Logging in to Oracle BI Publisher and Navigating Through the Home Page
Browsing the Catalog and Viewing Reports
Managing Favorites
Creating a New Folder
Uploading a Resource to the Catalog
Setting My Account Preferences
Configuring the Data Sources
Creating a Data Model
Creating a Data Model
Creating Reports
Creating Report Jobs / Scheduling Reports
Creating Report Jobs / Scheduling Reports
Creating a Master Detail Report (Creating Detailed Summary Reports) Creating Reports with Consistent Look and Feel Using Subtemplates
Digitally Signing and Securing PDF Documents
Bursting
Translating Reports
Creating a Data Model with Multiple Data Sets
Creating RTF Templates Using BI Publisher 11g Template Builder for Word Installing Template Builder and Exploring the Template Builder User Interface
Creating RTF Templates Using BI Publisher 11g Template Builder for Word Installing Template Builder and Exploring the Template Builder User Interface
Building an RTF Template in Offline Mode
Building an RTF Template in Online Mode
Working with a Pivot Table in an Existing RTF Template
Using Template Builder Utilities: Field Browser, Validate Template, and Check Accessibility
Setting Configuration Options for Template Builder
Oracle Enterprise Manager 12c: Install and Integrate BI Publisher
Oracle Enterprise Manager 12c: Install and Integrate BI Publisher
Oracle Enterprise Manager 12c: Implement the BI Publisher Security Model
Oracle Enterprise Manager 12c: Create a BI Publisher Report
Oracle Enterprise Manager 12c: Create a BI Publisher Report