OBJECTIVE of the Training:

Oracle BI Enterprise Edition (sometimes simply referred to as Oracle Business Intelligence) provides a full range of business intelligence capabilities that allow you to:

• Collect up-to-date data from your organization
• Present the data in easy-to-understand formats (such as tables and graphs)
• Deliver data in a timely fashion to the employees in your organization
• These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.

OBIEE Administrator Course Content:

1.OBI Architecture

• Clients
• OBI Presentation Services
• OBI Server
• OBI Repository (.rpd)
• Data Sources

2.OBI Components

• OBI Administration Tool
• OBI Answers
• Intelligence dashboards

3.Repository Basics

• Oracle Business Analysis Warehouse
• DAC and Informatica Server
• Informatica Server ETL
• Sample Request Processing
• Using the OracleBI Administration Tool
• Repository Directory
• Repository Files ( Initialization files and log files)
• Informatica Server ETLLoading 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

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

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

6.Building The Presentation Layer Of a Repository

• Creating a new Presentation Catalog
• Modifying Presentation layer objects
• Rename tables
• Reorder Table

7.Testing And Validating a Repository

• Checking repository consistency
• Defining a repository in the initialization file
• Testing a repository using Oracle BI Answers
• Message Severity
• Viewing Server Logs

8.Adding Multiple Logical Table Sources

• Adding multiple logical table sources to a logical table
• Specifying logical content

9.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

10.Creating Dimension Hierarchies And Level-Based Measures

• Creating dimension hierarchies
• Creating level-based measures

11.Creating And Using Agrregates

• Purpose of aggregate tables in dimensional modeling
• Modeling aggregate tables to improve query performance
• Testing aggregate navigation
• Using Initialization Blocks Repository Variables

12.Creating Dynamic Repository Variables

13.Execute Direct Database Requests

• Accessing database directly

14.Creating Time Series And Measures

• Using time comparisons in business analysis
• Using Oracle BI time series functions to model time series data

15Creating Dimension Hierarchies And Level-Based Measures

• Creating dimension hierarchies
• Creating level-based measures

16.Providing Security for Groups & Users:

17.Answers(Reports)

18.Working With ORACLE Business Intelligence Answers

• Introduction to Oracle BI Answers
• Working with requests in Oracle BI Answers
• Using advanced formatting
• Creating report Level Hierarchy

19.Filtering Requests in ORACLE Business Intelligence Answers

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

20.Building Views And Charts in Requests

• Introduction to Answers views and charts
• Creating and editing charts
• Performing common view tasks
• Creating a Narrative View
• Creating a column Selector

21.Showing Results with Pivot Tables

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