OBIEE 11g Bootcamp

Course Overview

Completely rewritten and updated for OBIEE 11g, this course is designed for customers who wish to quickly train up a team of developers so that they can deliver an end-to-end Oracle BIEE system. Over five intensive days, it covers all that you will need to know to deliver an initial OBIEE 11g system, and assumes no prior knowledge up-front. Course materials are in English, but we can deliver the course in other languages including Italian, French, German, Spanish, Portuguese and Greek using our own native-speaking trainers.
From installation through to deploying reports and dashboards, this course starts by covering architecture and deployment, creating repositories and catalogs, and sourcing data from relational and file sources. It then takes delegates through building analyses and dashboards, and using the new Scorecard & Strategy Management feature to create key performance indicators and scorecards. New features such as the Action Framework are covered in detail, together with areas such as security, deployment between environments, and performing systems managements tasks using Enterprise Manager and WLST scripting environment.


5 Days


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


Developers, Consultants, Project Managers, Tech Leads, and DBAs


None Required

Course Agenda

Day 1
1. OBIEE 11g Overview & Product Architecture
• Overview of OBIEE and New Features in 11g
• Product Demonstration

2. Installation, Configuration & Upgrades
• OBIEE 11g installation on Microsoft Windows Server
• Post-Install Configuration Steps
• Upgrading 10g Metadata to 11g using the Upgrade Assistant
4. Creating Repositories from Relational Sources
• The OBIEE Common Enterprise Information Model ("Oracle BI Repository")
• Oracle BI Repository Components & Layers
• Oracle BI Repository Design Objectives
• Creating a Basic Oracle BI Repository from a Data Mart / Data Warehouse Source
• Online vs Offline Development and Uploading Using Enterprise Manager

5. Advanced Repository Modelling from Relational Sources
• Lookup Tables and Double-Columns
• Horizontal & Vertical Federation (Drill-Up and Drill-Across)
• Server Variables
• Modelling Transactional (3NF) Data Sources
6. Systems Management using Oracle Enterprise Manager
• Stopping, Starting and Restarting OBIEE 11g
• FMW – Metrics, Logging and Diagnostics
• Managing RPDs and Web Catalogs using Enterprise Manager
• Query Caching
• Usage Tracking
• The Aggregate Persistence Wizard
• Write Back
• Direct Database Requests

7. Creating Analyses and Dashboards
• Creating Simple Table & Title Views
• Adding Filters & Prompts
• Creating Pivot Table Views
• Charts & Gauges
• Conditional Formatting
• View & Column Selectors
• Narrative & Ticker View
• Creating Basic Dashboards
• Dashboards Prompts
• Hierarchical Columns & OLAP Analysis
• Master-Detail Linking
• New Graphing Features in OBIEE 11g
• Trellis Charts
• Mapping & Spatial Analysis
• Using Variables in Answers
8. Actionable Intelligence
• Basic Action Links (Navigation Actions)
• Creating Agents & Conditions

9. KPIs, Scorecards & Strategy Management
• Creating KPIs & KPI Watchlists
• Creating Scorecards

10. Creating Published Reports (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
day 5
11. OBIEE 11g Security
• Understanding the OBIEE 11g Security Model
• Creating Users & Groups in the WLS LDAP Server
• Creating & working with Application Roles & Policies
• Integrating with Microsoft Active Directory

12. High-Availability, Scaleout & Clustering
• Understanding OBIEE and WLS Clustering Concepts
• Vertical Scaleout
• Horizontal Scaleout
• Deploying for High-Availability