• 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

Creating Presentation Tables 

• 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

Associating Time Logical Columns with Logical Levels

• 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

Using Aggregates   

• Creating New Logical Table Sources
• Setting Aggregate Content
• Using Initialization Blocks and Variables
• Creating an Initialization Block
• Creating Variables

Creating a Measure

• 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

Formatting a Pivot Table and Adding Calculation

• 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

Creating a Variable Prompt