OBIEE 11g Create Reports, Dashboards, Alerts and Scorecards

Course Overview

This two day course is aimed at developers, and business power-users who wish to create their own reports and dashboards using Oracle BI EE 11g Enterprise Edition. Written for Oracle BI EE 11g, it takes delegates through the basics of creating reports, adding graphics and interactivity, creating pivot tables and graphs, alerts, KPIs and Scorecards, and delivering them through an interactive dashboard.
No prior knowledge is assumed, and delegates by the end of the course will have a good understanding of what is involved in creating an end-to-end dashboard using Oracle BI EE, together with alerts, offline analysis and boardroom quality reports using Oracle BI Publisher.

Note: This course is no longer offered in North America.


2 Days


Instructor-led with labs, on-site at client location


End-Users, Developers, and Project Managers


None Required

Course Agenda

Day 1
1. OBIEE 11g Overview

2. Creating Analyses using Tables, Charts, Maps and Prompts
• Dashboard and Analyses Overview
• Creating Table Views
• Creating Totals and Subtotals
• Filters and Prompts
• Title Views and Icons
• Working with the Compound Layout
• Adding Charts
• Adding Gauges
• Briefing Books
• Microsoft Office Integration
• Column Selectors
• View Selectors
• Narrative Views
• Formatting & Conditional Formatting
• Hierarchical Columns and Selection Steps
• Master-Detail Linking
• Trellis Charts
• Mapping
• Dashboard Overview
• Adding Requests to the Dashboard
• Adding Dashboard Prompts
3. Actionable Intelligence
• Creating Basic Actions and Action Links
• Creating Agents and Conditions

4. Creating Published Reports Using BI Publisher
• BI Publisher Overview
• BI Publisher User Interface
• Online Data Modeller
• Online Template Editor
• Combining Data Sources in the Online Data Modeller
• Report Bursting

5. Key Performance Indicators and Scorecards
• Defining Key Performance Indicators
• Creating KPI Watchlists
• Creating Scorecards