Oracle BI Enterprise Edition 11g: Reports, Dashboards and Repositories

Course:  OBIEER
Duration:  5 Days
Level:  I
Course Summary

This course will help students learn how to use Oracle Business Intelligence Enterprise Edition (OBIEE). It covers key elements in the OBIEE suite, including tools to build interactive dashboards, perform ad hoc analysis, configure information deliveries, alerts and produce reporting. Students will learn how to create tables, charts, narratives, and pivot tables. This course will also provide step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Administration Tool to construct a simple repository. They will import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface. In the process of constructing the repository, students learn how to build physical and logical joins, simple measures, and calculation measures.

« Hide The Details
Topics Covered In This Course

Oracle Business Intelligence Enterprise Edition Overview

  • OBIEE Architecture
  • Key Components
  • Presentation Catalog
  • Signing In/Out
  • Navigation
  • Setting Preferences
  • Interacting with Other Products
  • Integration with Publisher
  • Integration with Microsoft Office

Creating Analyses

  • What Are Analyses?
  • Dashboard embedding
  • Filtering Data
  • Data Hierarchies
  • Conditional Formatting
  • Using Analysis Prompts
  • Global Variables
  • Unions and Interactions
  • Reusable Calculations

Building and Using Dashboards

  • Dashboard Overview
  • Dashboard Builder
  • Creating/Editing Dashboards
  • Adding Oracle BI Publisher Reports to Dashboard Pages
  • Changing the Properties of a Dashboard and its Pages
  • Customizations
  • Template Pages
  • Working with Briefing Books

Adding Views for Display in Dashboards

  • Available Views
  • Editing Graph Views
  • Modifying Values using Write Back
  • Interactions in Views
  • Drilling in Views
  • Sorting Data in Views
  • Linking Views in Master-Detail

Filtering and Selecting Data for Analyses

  • Saving Objects as Inline or Named
  • Filters and Selection Steps
  • Creating or Editing Column Filters
  • Working with Groups and Calculated Items

Actionable Intelligence

  • Overview
  • Action Types
  • Navigation Actions
  • Action Links
  • Agents & Alerts
  • Conditions

Other options

  • Prompting in Dashboards and Analyses
  • Formatting Analyses, Views, and Dashboard Pages
  • Delivering Content
  • Working with Conditions
  • Working with Actions

KPIs and KPI Watchlists

  • Overview
  • Creating/Editing KPIs
  • Generating an Analysis from a KPI
  • Creating or Editing KPI Watchlists


  • Overview
  • Editor
  • Creating Scorecards
  • Vision Statements
  • Perspectives
  • Initiatives
  • Strategy Trees
  • Strategy Maps
  • Custom Views
  • Adding Scorecard Objects to Dashboards

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
  • Facts & Dimensions
  • Data Hierarchies
  • Derived Data
  • 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

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

Advanced RPD

  • Time Series Calculations
  • Horizontal & Vertical Federation
  • Row-level Security
  • Fragmentation

Using Repository Variables

  • Creating session variables
  • Creating repository variables
  • Creating initialization blocks
  • Using the Variable Manager
  • Using dynamic repository variables as filters
What You Can Expect

At the end of this course, delegates will be able to:

  • Understand OBIEE Architecture
  • Create BI Answers queries
  • Create KPIs
  • Create multiple query Views
  • Create BI Interactive Dashboards
  • Create scorecards
  • Use filters
  • Perform RPD Modeling
  • Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository
Who Should Take This Course

Business Users, Power Users, Business Analysts, and OBIEE Administrators

Recommended Prerequisites

Database Knowledge and some understanding of Oracle Business Intelligence Enterprise Edition (OBIEE).

Training Style

Instructor led with 50% lecture and 50% lab

« Hide The Details
Related Courses
Code Course Title Duration Level
Oracle BI Enterprise Edition (OBIEE) 11g: Reports and Dashboards
4 Days
Oracle BI Enterprise Edition (OBIEE) 11g: Boot Camp
5 Days
Oracle BI Enterprise Edition (OBIEE) 11g: Building Repositories
5 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]