Oracle BI Enterprise Edition (BI EE)

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