OBIEE 11g Training Course

by Comprehensive OBIEE Training

1

Introduction to the Course and Course Contents

2

Installation and configuration of OBIEE 11g

3

Oracle Business Intelligence Enterprise Edition Overview
Oracle Business Intelligence Enterprise Edition Architecture
Brief Introduction to Warehousing Concepts
Dimension
Fact
Star Schema
Oracle BI Application Overview
Oracle BI Repository Basics

4

Building the Physical Layer of a Repository

Create a New Repository

Import a Schema

Create Physical Joins

5

Building the Business Layer of a Repository
Create a Business Model
Create Logical Tables
Create Logical Columns
Create Logical Joins

6

Building the Presentation Layer of a Repository

7

Testing and Validating a Repository
Run a Consistency Check
Enable Query Logging
Start Oracle BI Services
Use Oracle BI Analysis to Execute Queries
Use Query Log to Verify Queries

8

Creating Calculation Measures
Load a Prebuilt Repository
Create a New Measure
Create a Calculation Measure Using Administration Tool
Create a Calculation Measure Using Analysis

9

Building Dimension Hierarchies
Using hierarchy in OBIEE analysis
Creating Level Based Measures
Cache Management
Creating Presentation Hierarchies

10

Security in OBIEE
Data Level Security
Object Level Security
Creating Initialization Blocks and Variables
Repository Variables
Session Variables

11

Working with various views in Analysis

12

Dashboard Creation and Modification

Creating Prompts
Dashboard
Column Filter
Adding report to the dashboard
Creating Presentation Variables
Drill and Navigate Option
Creating drill report
Using repository, session and presentation variables
Filtering Requests in Oracle Business Intelligence Analysis
Interview Questions and Project write-ups for resume