OBIEE 10G & 11G Online Training and Job Support @ OnlineTrainings9

Email :ravitejaobiee@gmail.com

Contact No : +91 8861201149


1.Course Content:


2.Concept of Dimensional Modelling

• Star Schema.
• Snow Flake.
• Fact Table.
• Dimensional Table.

3. OBIEE Architecture 


4. Components of OBIEE

• Oracle BI Presenation Server
• Oracle BI Server
• Oracle BI Scheduler
• Admin Tool

5.Oracle BI User Interface

• Answers.
• Dashboards.
• Views.
• Prompts.
• Variables.
• User and Groups.
• Previllages.
• GoNav.
• Filters.

6. Oracle BI Admin Tool

I. Physical Layer

• Importing Physical Tables .
• Creation of Physical Joins .
• Configuring Connection Pools.
• Exploring Views.

II. Logical Layer

• Creation of Business Model
• Creation of Logical Facts
• Creation of Dimensions.
• Creation of Dimension Hierarchies/Levels
• Creation of Measures
• Aggregate Navigation
• Creation of timeseries measures
• Creation of level based metrics
• Creation of MLTS (multiple logical table sources)

III. Presentation Layer

• Creation of Presentation Catalog
• Creation of Presentation tables
• Creation of Presentation Columns

IV. Groups, Users, Repository Variables, Session Variables, Initialization Blocks

7. Enabling Cache

• Creating iBots
• Automated Cache Purging using Event Polling

8. Security

I. Authentication

• LDAP
• Database
• Repository
• External Table

II. Authorization

• Filters,
• Data Security – GROUP

9. BI Analytics Time Series functions

• Year Ago, Quarter Ago, Month Ago
• To_date

10. OBIEE Repository Tricks

11. OBIEE 11g

12. Assignments.