Oracle BI Administration Tool Overview and building the Physical layer of a repository.
- Overview of Business Intelligence
- Architecture of Oracle Business Intelligence 11g
- Introduction to the Admin Tool in Business Intelligence
- Building the Physical Layer of a Repository
- Creating a New Repository
- Importing Metadata
- Verifying Connection
- Creating Aliases
- 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
- Renaming Objects Using the Rename Wizard
- Deleting Unnecessary Logical Objects
- Creating Simple Measures
Building The Presentation Layer of the Repository
- Creating a Subject Area
- Creating Presentation Tables
- Creating Presentation Columns
- Renaming Presentation Columns
- Reordering Presentation Columns
Testing and Validating Repository
- Checking Consistency
- Disabling Cache
- Loading the Repository
- Setting Up Query Log
- Creating and Running Analysis
- Checking the Query Log
Managing Logical Table Sources
- Opening the Repository in Offline Mode
- Adding a New Logical Table Source
- Creating Presentation Layer Objects
- Loading the Repository
- Creating and Running an Analysis
- Checking the Query Log
Creating Calculation Measure
- Opening the Repository in Offline Mode
- Creating a Calculation Measure Derived from Existing Columns
- Creating a Calculation Measure Using a Function
- Loading the Repository
- Creating and Running an Analysis
- Checking the Query Log
Creating Logical Dimensions With Level-Based Hierarchies
- Opening the Repository in Offline Mode
- 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
- Testing Your Work
Creating level-based Measures
- Opening the Repository in Offline Mode
- Creating Level-Based Measures
- Creating a Share Measure
- Testing Your Work
Creating Logical Dimension With Parent-Child Hierarchy
- Opening the Repository in Offline Mode
- Importing Metadata and Define Physical Layer Objects
- Creating Logical tables and Logical Columns
- Creating a Logical Join
- Creating a Parent-Child Logical Dimension
- Defining Parent-Child Settings
- Creating Presentation Layer Objects
- Testing Your Work
Creating Logical Dimension With Ragged and Skipped-Level Hierarchy
- Importing Metadata and Define Physical Layer Objects
- Creating Logical tables and Logical Columns
- Creating a Ragged/Skipped Levels Logical Dimension
- Creating Presentation Layer Objects
- Testing Your Work
Using Aggregates and Initialization Blocks Variables
- Importing Metadata
- Creating New Logical Table Sources
- Setting Aggregate Content
- Testing Your Work
- Creating an Initialization Block
- Creating Variables
- Testing Your Work
Creating Time Series Measures
- Identifying a Logical Dimension as a Time Dimension
- Identifying Level Keys as Chronological Keys
- Creating a Measure Using the AGO Function
- Creating a Measure Using the TODATE Function
- Creating a Measure Using the PERIODROLLING Function
Creating Time Series Measures
- Identifying a Logical Dimension as a Time Dimension
- Identifying Level Keys as Chronological Keys
- Creating a Measure Using the AGO Function
- Creating a Measure Using the TODATE Function
- Creating a Measure Using the PERIODROLLING Function
Beginning the Analytic Process and Creating Analysis
- Logging In
- Favorites Menu
- Searching the Catalog (Basic Search)
- BI Client Installer
- 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 Graph to an Analysis and Working with Pivot Tables and Master-Detail Linking
- Enhancing an Analysis by Adding a Graph
- Formatting the Graph
- Creating an Analysis with a Pivot Table View
- Formatting a Pivot Table and Adding Calculations
- Creating a Master-Detail Linking
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
- Adding Performance Tile to Analysis
- Adding simple Tiles to an Analysis
- Working with Other View Types