Oracle BI Enterprise Edition (BI EE)
By taking this course, you’ll get a chance to work with expert instructors who will help you explore Oracle BI Enterprise Edition user interfaces, including Oracle BI Analyses and Interactive Dashboard. You’ll get hands-on practice learning how these solutions are used to generate, modify, organize and share analytical requests for viewing within Intelligence Dashboards.
Oracle Business Intelligence Enterprise Edition Overview
Creating a Repository Using the Oracle BI Administration Tool
Building the Physical Layer of a Repository
Creating a New Repository
Importing Metadata
Verifying Connection
Creating Keys and Joins
Building the Business Model and Mapping Layer of a Repository
Creating a Business Model
Examining Logical Joins
Examining Logical Columns
Examining Logical Table Sources
Renaming Logical Objects Manually
Creating Simple Measures
Building the Presentation Layer of a Repository
Creating a Subject Area
Testing and Validating a Repository
Checking Consistency
Disabling Cache
Setting up Query Log
Managing Logical Table Sources
Adding a New Logical Table Source
Creating Presentation Layer Objects
Loading the Repository
Checking the Query Log
Creating Calculation Measures
Checking the Query Log
Creating Logical Dimensions with Level-Based Hierarchies
Creating a Logical Dimension for Product
Creating Logical Levels
Associating Logical Columns with Logical Levels
Setting Logical Level Keys
Creating a Logical Dimension for Time
Creating a Logical Dimension for Customer
Setting Aggregation Content for Logical Table Sources
Creating Level-Based Measures
Opening the Repository in Offline Mode
Creating Level-Based Measures
Creating Logical Dimensions with Parent-Child Hierarchies
Opening the Repository in Offline Mode
Importing Metadata and Define Physical Layer Objects
Creating Logical Table and Logical Columns
Creating a Parent-Child Logical Dimension
Creating Presentation Layer Objects
Creating Logical Dimensions with Ragged and Skipped-Level Hierarchies
Importing Metadata and Define Physical Layer Objects
Creating Logical Table and Logical Columns
Creating a Ragged/Skipped Levels Logical Dimension
Creating Presentation Layer Objects
Creating New Logical Table Sources
Setting Aggregate Content
Using Initialization Blocks and Variables
Creating an Initialization Block
Creating Variables
Creating an Analysis and Using the Analysis Editor
Filtering, Sorting, and Saving your Analysis
Creating Selection Steps for your Analysis
Formatting and Adding Totals to your Analysis
Adding a Graph to an Analysis
Enhancing an Analysis by Adding a Graph
Formatting the Graph
Working with Pivot Tables, and Master-Detail Linking
Creating an Analysis with a Pivot Table View
Creating a Master-Detail Linking
Adding Performance Tile to an Analysis
Adding a Simple Trellis to an Analysis
Working with Other View Types
Creating a Narrative View
Creating Column Selector and View Selector Views
Building Dashboards
Exploring and Editing My Dashboard
Creating a Dashboard
Editing a Dashboard
Saving a Customized Dashboard and Setting Preferences
Exporting the Dashboard to Excel Spreadsheet
Prompting to Filter Analysis
Creating a Named Dashboard Prompt
Creating a Column prompt