Call Us: +91 95000 19355


Oracle Business Intelligence Enterprise Edition (OBIEE) is another core part of Datawarehousing concepts. Our team can provide a professional training session for the students by teaching the essential parts that are highly required to learn the techniques of OBIEE in an easy way. Expert training at a cost-effective fee is our unique goal at all the time.

OBIEE 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

Enabling Usage Tracking

– Setting up the sample usage tracking repository

– Tracking and storing Oracle BI Server usage at the detailed query level

– Using usage tracking statistics to optimize query performance and aggregation strategies

– Analyzing usage results using Oracle BI Answers and other reporting tools

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

Working with Views and Graphs in Analyses

– Introduction to views, graphs, and editors

– Working with views in Compound Layouts

– Creating and editing graphs

– Linking master-detail views

– Performing common view tasks

Showing Results With Pivot Tables

– Creating, arranging, and formatting a pivot table

– Using hierarchical columns

– Sorting in pivot tables

– Setting aggregation and using totals

– Showing an item’s relative value

– Building calculations and displaying running sums

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

Other Courses

Back to Top