OBIEE 11g Course Content

Repository Basics 

  •  Exploring Oracle BI architecture components
  •  Exploring a repository’s structure, features, and functions
  •  Using the Oracle BI Administration Tool
  •  Creating a repository
  •  Loading a repository into Oracle BI Server memory 

Building the Physical Layer of a Repository

  •   Importing data sources
  •   Setting up connection pool properties
  •   Defining keys and joins
  •   Examining physical layer object properties
  •   Creating alias tables 

Building the Business Model and Mapping Layer of a Repository

  •  Building a business model
  •  Building logical tables, columns, and sources
  •  Defining logical joins
  •  Building measures
  •  Examining business model object properties 

Building the Presentation Layer of a Repository

  •  Exploring Presentation layer objects
  •   Creating Presentation layer objects
  •   Modifying Presentation layer objects
  •   Examining Presentation layer object properties 

Testing and Validating a Repository

  •  Checking repository consistency
  •  Turning on logging
  •  Defining a repository in the initialization file
  •  Executing analyses to test a repository
  •  Inspecting the query log 

Managing Logical Table Sources

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

Adding Calculations to a Fact

  •  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 measures using functions 

Working with Logical Dimensions

  •  Creating logical dimension hierarchies
  •  Creating level-based measures
  •  Creating share measures
  •  Creating dimension-specific aggregation rules
  •  Creating presentation hierarchies
  •  Creating parent-child hierarchies
  •  Using calculated members 

Using Aggregates

  •  Modeling aggregate tables to improve query performance
  •  Setting the number of elements in a hierarchy
  •  Testing aggregate navigation
  •  Using the Aggregate Persistence Wizard 

Using Repository Variables

  •  Creating session variables
  •  Creating repository variables
  •  Creating initialization blocks
  •  Using the Variable Manager
  •  Using dynamic repository variables as filters 

Modeling Time Series Data

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

Setting an Implicit Fact Column

  • Adding fact columns automatically to dimension-only queries
  •  Ensuring the expected results for dimension-only queries
  •  Selecting a predetermined fact table source
  • Specifying a default join path between dimension tables 


  •  Exploring Oracle BI default security settings
  •  Creating users and groups
  •  Creating application roles
  •  Setting up object permissions
  •  Setting row-level security (data filters)
  •  Setting query limits and timing restrictions

Cache Management

  •  Restricting tables as non-cacheable
  •  Using Cache Manager
  •  Inspecting cache reports
  •  Purging cache entries
  •  Modifying cache parameters and options
  •  Seeding the cache 

Multiuser Development

  •  Setting up a multiuser development environment
  •  Developing a repository using multiple developers
  •  Tracking development project history 

Working with Oracle Business Intelligence Analyses

  • Introduction to Oracle BI Analysis Editor
  •  Oracle BI column types
  •  Working with analyses in Oracle BI
  •  Using advanced formatting 

Administering the Presentation Catalog

  •  Oracle BI and catalog security overview
  •  Managing security using roles
  •  Understanding security inheritance
  •  Setting object permissions
  •  Setting system privileges
  •  Archiving catalog items 

Limiting and Grouping Data in Analyses

  •  Introduction to filters and selections
  •  Creating, editing, and grouping filters
  •  Adding prompts to analyses
  •  Dynamic filtering
  •  Using saved analyses as filters
  •  Creating groups
  •  Creating calculated items
  •  Creating selection steps 

Oracle Business Intelligence Analyses: Advanced Features

  •  Setting analysis properties
  •  Combining analysis criteria by using set operations
  •  Executing direct database analyses
  •  Editing logical SQL generated by an analysis
  •  Creating a link to a saved analysis
  •  Creating an Excel Web Query file 

Creating Oracle Business Intelligence Dashboards

  •  Creating and editing dashboards
  •  Using the Dashboard Builder
  •  Exploring dashboard object properties and options
  •  Publishing dashboard pages
  •  Creating personal customizations and using other page options 

Configuring Oracle Business Intelligence Dashboards

  •  Exploring types of dashboard content
  •  Embedding content in dashboards 

Creating Dashboard Prompts and Variables

  •  Understanding variables
  •  Adding a named dashboard prompt to a dashboard
  •  Adding a hidden named dashboard prompt to a dashboard
  •  Creating additional prompt page and setting page preferences
  •  Adding variable prompts to a dashboard 

Using Oracle Business Intelligence Delivers

  •  Configuring delivery devices and adding delivery profiles
  •  Adding an Alert Section to a dashboard
  •  Configuring an Agent
  •  Using Analysis and KPI conditions to deliver content with Agents
  •  Subscribing to an Agent


Quick Contact