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.

Who Should Attend

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

Previous Knowledge

None Required


5 Days

Course Agenda

Day One

  • Creating an Oracle BI Repository from a star-schema Oracle RDBMS source
  • Parent-Child, Skipped Level and Ragged Hierarchies

Day Two

  • Lookup Tables and Double-Columns
  • Horizontal & Vertical Federation (Drill-Up and Drill-Across)
  • Server Variables
  • Modeling Transactional (3NF) Data Sources

Day Three

  • 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

Day Four

  • Basic Action Links (Navigation Actions)
  • Creating Agents & Conditions

  • BI Publisher Overview
  • BI Publisher User Interface
  • Online Data Modeler
  • Online Template Editor

Day Five

  • 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

  • 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

  • Understanding OBIEE and WLS Clustering Concepts
  • Vertical Scaleout
  • Horizontal Scaleout
  • Deploying for High-Availability

Training Dates

July 18 - 22, 2016

Alpharetta, Ga


August 1 - 5, 2016

Brighton, UK


Sept. 19 - 23, 2016

Alpharetta, Ga


Nov. 14 - 18, 2016

Alpharetta, Ga



/ /
/ /
* indicates required