OBIEE Administration Online Training


OBIEE Administration Online Training Course Details.

OBIEE Administration Online Training 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