Online OBIEE 11g Training

Oracle Business Intelligence Enterprise Edition (OBIEE1 11g / 10g)

1) DW Concepts

2) Common concepts of OBIEE 11g and 10g
1. Practitioner Level
2. Lerner Level
3. Specialist Level

3) OBIEE 11g New Features

4) BI Publisher

5) Deployment Server to Server

6) Migration From 10g to 11g

7) Live Tasks

Data Warehouse concepts

1. Why we need Data Warehouse?
2. What is Data Warehouse?
3. Data Warehouse Architecture
4. What is Data Acquisition?
5. Types of Tables
6. What is schema and types of Schemas
7. What is Data Mart?
8. Data Warehousing Approaches?

Common concepts of OBIEE 11g and 10g

OBIEE Introduction:

9. Why Oracle BI ?
10. What is Oracle BI?
11. History of Oracle BI
12. Oracle BI architecture 11g Vs 10g
13. Oracle BI components 11g Vs 10g

OBIEE 11G & 10G Practitioner Level Administration

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 & 10G Specialist Level

1. Using Aggregate Tables
2. Using Partitions and Fragments
3. Variables (Repository,session,presentation &Request
4. Modeling Time Series Data & Time based Measures
5. Configuring Many To Many Relationships(Bridge &Helper Table)
6. Deploying Oracle Bi application to multiple countries
1. Localizing Oracle BI Metadata
2. Localizing Oracle BI Data
7. Setting Implicit Fact Column
8. Third Party Reporting Tool Integration
9. Creating Repositories From Multi dimensional Data Sources
10. Security
1. Authentication and Authorization
2. Creating Users and Groups
3. Object Level Security
4. Data Level Security
11. Administering Usage Tracking
12. Multi-User Development Environment (MUDE)
13. Utilities
14. Cache Management
15. Optimizing Query Performance
16. Repository Design Principles
17. Model First
18. Cluster Servers
19. Disconnected Analytics
20. Alias ,Circular Joins & Opaque Views or Select Tables

OBIEE 11G & 10G Lerner Level

Presentation Services or Analytics

1. Introduction to presentation Services
2. What is Web Catalog & instance con fig file
3. Shared Folders, My folders, Shared Filters, My Filters ,My Briefing Books


1. Working with OBI Answers
2. OBI Column Properties
3. Drill
4. Navigation
5. Conditional formatting
6. OBI Formulas
7. OBI Filters
8. OBI Sorting
9. OBI 17 Views
10. OBI Request Level Prompts
11. Cascading Prompts
12. Combining With Similar Request
13. Direct Database Requests
14. Presentation Catalog Permissions(Full Control,NoAccess,Change/Delete,Read,Traverse Folder)
15. Presentation Catalog Privileges(Granted, Denied)


1. Creating Oracle Business Intelligence Interactive Dashboards
2. Working With 8 Dashboard Objects
3. Section
4. Link or Image
5. Embedded Content
6. Text
7. Folder
8. Guided Navigation Link(Static , Conditional and section )
9. Briefing Book Navigation Link
10. BI Publisher Report
11. Working With Dashboard Prompts
12. What is Dashboard Prompt
13. Types of Dashboard Prompts
14. Page level prompts
15. Dashboard level prompts
16. Presentation Variables
17. Request Variable


1. Introduction to Oracle BI Delivers
2. Developing IBOTS
3. Configuring delivery devices
4. Adding delivery profiles
5. Building Alerts

Job Manager

1. Configuring Job Manager
2. Monitoring Scheduled requests

Oracle BI for Microsoft Office

1. Introduction to Oracle BI for Microsoft Office
2. Working with Oracle BI content in Microsoft Office applications

Catalog Manager

1. Documentation of Web Catalog
2. Deploying Dev to test or test to prod

OBIEE 11G New Futures:

1. Introduction about EM, CONSOLE, ANALYTICS, XMLPSERVER…etc
2. OBIEE 11g Advanced Workshop Setup
3. Parent Child Hierarchies
4. Ragged and Skipped hierarchies
5. Assign ID columns to descriptive columns
6. Using Lookup Table
7. Horizontal Federation
8. Vertical Federation
9. Combined Horizontal & Vertical Federation
10. Hierarchical Columns and Selection Steps
11. Advanced Reporting, Master Detail Linking
12. New Graphing Options
13. BI Publisher 11g Online Template Builder and Interactive Viewer
14. New Dashboard Features
15. Creating Simple Action Links
16. Creating Advanced Action Links
17. Creating Time Series Measures using PERIODROLLING
18. Creating Scorecards
19. Creating KPI
20. Working with XML API

BI Publisher 11G & 10G

1. Introduction to BI Publisher or XML publisher
2. Integrating database
3. Integrating Oracle BI Presentation server
4. Integrating Oracle BI Discoverer
5. Configuring Scheduler
6. Installing Oracle BI Publisher Desktop
7. Develop BI Publisher Templates using OBI Answer Request
8. Develop BI Publisher Templates using OBI Subject Areas
9. Develop BI Publisher Templates Directly From Data Base
10. Develop BI Publisher Templates using XML file
11. Working with Parameters and List Of Values (LOVs)
12. Scheduling BI Publisher templates

Live Tasks:

1. Gathering Requirement
2. Understanding & Analyzing Requirement
3. Developing Business Specification Document
4. Developing High Level Design Document
5. Developing Low level Design Document
6. Following Unique Coding Standards

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."