OBIEE 11g Course Content

Data Warehouse concepts

  1. What is Data
  2. Types of Data
  3. Types of Databases
  4. What is Data Warehouse?
  5. Data Warehouse Architecture
  6. Difference between OLTP Vs OLAP
  7. Types of Columns
  8. Types of Tables
  9. What is schema and types of Schemas
  10. Difference between Star and Snow Flake Schemas


OBIEE Introduction :

  1. Why Oracle BI ?
  2. What is Oracle BI?
  3. History of Oracle BI
  4. Oracle BI architecture 11G
  5. Oracle BI components 11G

OBIEE 11g Practitioner Level


  1. Repository Basics
  2. Building the Physical Layer of a Repository
  3. Building the BMM Layer of a Repository
  4. Building the Presentation Layer of a Repository
  5. Testing Repository
  6. Working with  Multiple Logical Table Sources
  7. Adding Calculations to Fact Table
  8. Creating Dimensional Hierarchies& Level based measures

OBIEE 11g Lerner Level

Presentation Services or Analytics

  1. Introduction to Presentation Services
  2. What is Web Catalog & Instanceconfig.xml
  3. Difference between Shared Folders & My Folders


  1. Working with OBI Answers
  2. OBI Column Properties
  3. Style ,Column Format ,Data Format , Conditional Format ,Intraction and Write Back
  4. Hide Column
  5. Edit Formulas / Report level Calculations
  6. Filters
  7. Column ,image and Variable Prompts
  8. Sorting of Columns
  9. OBI 17 Views
  10. Combining  With Similar Request
  11. Direct Database Requests


  1. Creating Oracle Business Intelligence Interactive Dashboards
  2. Working With Dashboard Objects
  3. Column , Section ,Link or Image ,Embedded Content ,Text, Folder, Action Link ,Action Link Menu ,Alert Section
  4. Hiding or showing Section Dynamically based on condition
  5. Working With Dashboard Prompts
  6. Column ,Image and Variable Dashboard Prompts
  7. Presentation Variables
  8. Request Variable


  1. Introduction to Oracle BI Delivers
  2. Oracle BI Deliveries Tables
  3. Configuring delivery devices
  4. Adding delivery profiles
  5. Developing Agents
  6. Building Alerts
  7. Creating Agents Based on Time
  8. Creating Agents Based on Time and Condition
  9. Creating Chain of Agents

Job Manager

  1. Monitoring Agents

Oracle BI for Microsoft Office

  1. Introduction to Oracle BI for Microsoft Office
  2. Installation of Oracle BI for MS Office
  3. Accessing OBI reports in MS Excel
  4. Accessing OBI Reports in MS Power Point

Catalog Manager

  1. Deploying Dev to test or test to prod
  2. Deploying in Offline or Online Mode
  3. Catalog Back Up and Restore
  4. Providing Permissions
  5. Documentation of Web Catalog

OBIEE 11g Specialist Level

  1. Using Aggregate Tables
  2. Using Partitions and Fragments
    1. Value Based
    2. Fact Based
    3. Level Based
  3. Variables
    1. Static Repository
    2. Dynamic Repository
    3. Repository Initialization Blocks
    4. System Session
    5. Non System Session
    6. Session Initialization Blocks
    7. Row Wise Initialization Blocks
    8. Presentation Variables
    9. Request Variables
  4. Time Series Functions
    1. AGO
    2. TODATE
  1. Configuring Many To Many Relationships
    1. Bridge Table
    2. Helper Table
  1. Deploying Oracle Bi application to multiple countries
    1. Localizing Oracle BI Metadata
    2. Localizing Oracle BI Data
  2. Setting Implicit Fact Column
  3. Third Party Reporting Tool Integration
  4. Creating Repositories From Multi-dimensional Data Sources
  5. Security
    1. Authentication
      1. LDAP
      2. External Table
    2. Authorization
      1. Object Level
        1. RPD
        2. Web Catalog
      2. Data / Row  Level
  1. Administering Usage Tracking
  2. Multi-User Development Environment (MUDE)
  3. Utilities
  4. Cache Management
  5. Optimizing Query Performance
  6. Cluster Servers
  7. Alias ,Circular Joins & Opaque Views or Select Tables

OBIEE 11g Advanced Level

  1. Introduction about EM, CONSOLE, ANALYTICS, ..etc
  2. Parent Child Hierarchies
  3. Unbalanced Hierarchies
    1. Ragged Hierarchies
    2. Skipped Hierarchies
  4. Hierarchical Columns and Selection Steps
  5. Action Links
  6. Creating Simple Action Links
  7. Creating Advanced Action Links
  8. Master Detail Reports
  9. Creating  KPI
  10. Creating KPI Watch List
  11. Creating Scorecards
  12. Assign ID columns to descriptive columns


  1. Moving RPD and Web Catalog from Development server to Testing Server
  2. Moving RPD and Web Catalog from Testing Server to Production Server



  1. Under Standing Pre Migration Process
  2. Understanding Upgrade Assistant Wizard
  3. Migrating from OBIEE 10G to OBIEE 11G
  4. Under Standing Post Migration Process.