OBIEE 11g Training Chennai

Module 1

OBIEE Overview

OBIEE Architecture

Clients

OBIEE 11 BI Services

OBIEE Weblogic Admin

OBIEE Repository (rpd)

Data Sources

Module 2

OBIEE Components

OBIEE Administration Tool

OBIEE Analysis

Intelligence Dashboards

BI Publisher-BI Agents/Actions-KPI/Scorecard

BI Office

Module 3

Repository Basics

Oracle Business Analysis Warehouse

Weblogic Server

Enterprise Manager

Sample Request Processing

Using the OracleBI Administration Tool

Repository Directory

Repository Files ( Initialization files and log files)

Loading a repository into Oracle BI Server memory

Creating a repository

Connection Pool

Repository Modes ( ONLINE and OFFLINE )

Physical Layer

Business Model & Mapping Layer

Presentation Layer

Presentation Catalogs, Folders and Columns

Error Messages

Module 4

Building the Physical Layer of a Repository

Defining an ODBC System DSN

Setting up connection pool properties

Importing data sources ( Physical Schema )

Verifying the import

Defining physical keys and joins

Creating alias and select tables

Module 5

Building the Business Model and Mapping Layer of a Repository

Creating the logical business model

Creating the logical tables, columns, and sources

Defining logical joins

Adding Calculation to a Fact Table

Building measures

Module 6

Building the Presentation Layer of a Repository

Creating a new Presentation Catalog

Modifying Presentation layer objects

Rename tables

Reorder Table

Testing and Validating a Repository

Checking repository consistency

Defining a repository in the initialization file

Testing a repository using Oracle BI Answers

Adding Multiple Logical Table Sources

Adding multiple logical table sources to a logical table

Specifying logical content

Adding Calculations to a Fact Table

Creating new calculation measures based on existing logical columns

Creating new calculation measures based on physical columns

Creating new calculation measures using the Calculation Wizard

Creating Dimension Hierarchies and Level-Based Measures

Creating dimension hierarchies

Creating level

Based measures

Module 7

Creating & Using Aggregates

Purpose of aggregate tables in dimensional modeling

Modeling aggregate tables to improve query performance

Testing aggregate navigation

Using Initialization Blocks Repository Variables

Creating Dynamic Repository Variables

Execute Direct Database Requests

Accessing database directly

Creating Time series Measures

Using time comparisons in business analysis

Using Oracle BI time series functions to model time series data

BI Analysis and Dash board & Publisher

Creating and Editing Analysis

Creating Interactive Dashboards using Analysis

Creating query and chart

Module 8

Working with Filters

Working with Pivot Table

Building Views and Charts in Requests

Creating and Configuring Interactive Dashboards

Creating and Configuring Dashboard Prompts

Configuring Action Links

Creating and understanding KPI,KPI Watchlists and Scorecards

Oracle BI for MS Office

Sending Alerts Using Delivers

Using Job Manager