OBIEE 10g and 11g Online Training

Oracle BI Suite : OBIEE 10g &11g

Lesson 1

• Repository basics
• Major Components of Oracle BI Architecture
• Identify and Describe the layers of OBI repository
• Use OBI Admin tool to explore repository objects

Lesson 2

• Identify and Describe the objects in the Physical layer of a repository
• Create the physical layer of repository

Lesson 3

• Identify the objects in the BMM Layer of a Repository
• Build a Business model
• Create Measures in Business Model

Lesson 4

• Identify the objects of the presentation layer of a repository
• Modify the properties of the presentation layer objects
• Build the presentation layer of a repository

Lesson 5

• Test and validate a repository

Lesson 6

• Describe normalized and de-normalized table structures in a database design
• Add multiple sources to a LTS for a dimension in a Business model

Lesson 7

• Describe a calculation measure and its views in a business model
• Create new calculation measure based on logical columns
• Create new calculation measures based on physical columns
• Create new calculation measure by using a calculation wizard

Lesson 8

• Create dimension hierarchies
• Create level based measures
• Create rank and share measures

Lesson 9

• Aggregate tables in dimension modeling

Lesson 10

• Create session variables
• Create repository variables
• Create initialization blocks
• Implement a dynamic repository variables

Lesson 11

• Use of Time comparison for business analysis
• Implement time comparison measures in business model

Lesson 12

• Describe the purpose and process of Setting an implicit fact column
• Set an implicit fact column for a presentation catalog

Lesson 13

• define users and groups
• set permissions for users and groups to control access to repository objects
• explain group inheritance
• identify and describe authentication methods used by Oracle BI server

Working with Oracle Business Intelligence Answers

• Introduction to Oracle BI Answers
• Working with requests in Oracle BI Answers
• Using advanced formatting

Filtering Requests in Oracle Business Intelligence Answers

• Introduction to filters in Answers
• Adding filter prompts to requests
• Using saved requests as filters

Oracle Business Intelligence Answers: Advanced Features

• Combining request criteria using set operations
• Executing direct database requests
• Editing logical SQL generated by a request

Building Views and Charts in Requests

• Introduction to Answers views and charts
• Creating and editing charts
• Performing common view tasks

Showing Results with Gauge Views

• Introduction to Gauge views
• Working with Gauge views

Showing Results with Pivot Tables

• Introduction to pivot tables
• Formatting pivot tables
• Setting aggregation rules and building formulas

Creating Oracle Business Intelligence Interactive Dashboards

• Introduction to Interactive Dashboards and pages
• Dashboard Editor UI elements
• Composing dashboard elements

Configuring Oracle Business Intelligence Interactive Dashboards

• Types of dashboard content
• Embedding content in Interactive Dashboards
• Using bookmark links to distribute and save Interactive Dashboards

Customizing the Oracle Business Intelligence User Interface

• Modifying cascading style sheets
• Modifying XML message files
• Making configuration changes using the instance config file

Configuring Guided Navigation Links

• Building guided navigation with static links
• Building guided navigation with conditional links and sections

Administering the Oracle Business Intelligence Presentation Catalog

• Maintaining the Oracle BI Presentation Catalog
• Managing security
• Understanding security inheritance
• Describing the Presentation Catalog structure
• Permission types
• Setting permissions using the Manage Catalog screen    
•  
• http://www.monstertrainings.com/datawarehouse/obiee.php