TRN202 Oracle BI EE 11g “Bootcamp”

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 BI EE system. Over five intensive days, it covers all that you will need to know to deliver an initial Oracle BI EE 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 the WLST scripting environment.

This course has been updated for OBIEE, but is just as relevant if your organisation is on an earlier release of 11g.

Duration : 5 Days

Course Delivery : Instructor-led with labs, on-site at customer location

Who Should Attend : Developers, consultants, project managers, technical leads, DBAs

Prerequisites : None

Detailed Course Agenda :

Day 1

  1. OBIEE 11g Overview & Product Architecture
  • Overview of OBIEE, and New Features in 11g
  • Product Demonstration
  1. Installation, Configuration & Upgrades
  • OBIEE 11g installation on Microsoft Windows Server
  • Post-Install Configuration Steps
  • Upgrading 10g Metadata to 11g using the Upgrade Assistant
  1. Creating Repositories from Relational Sources
  • Creating an Oracle BI Repository from a star-schema Oracle RDBMS source

Day 2

  1. Creating Repositories from Relational Sources (cont.)
  • Parent-Child, Skip-Level and Ragged Heirarchies
  1. 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

Day 3

  1. 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
  1. Creating Analyses and Dashboards
  • Creating Simple Table and Title Views
  • Adding Filters and Prompts
  • Creating Pivot Table Views
  • Charts and Gauges
  • Conditional Formatting
  • View and Column Selectors
  • Narrative and Ticker View
  • Creating Basic Dashboards
  • Dashboard Prompts
  • Hierarchical Columns and OLAP Analysis
  • Master-Detail Linking
  • New Graphing Features in OBIEE 11g
  • Trellis Charts
  • Mapping and Spatial Analysis
  • Using Variables in Answers

Day 4

  1. Actionable Intelligence
  • Basic Action Links (Navigation Actions)
  • Creating Agents and Conditions
  1. KPIs, Scorecards & Strategy Management
  • Creating KPIs and KPI Watchlists
  • Creating Scorecards
  1. 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

  1. OBIEE 11g Security
  • Understanding the OBIEE 11g Security Model
  • Creating Users and Groups in the WLS LDAP Server
  • Creating and working with Application Roles and Policies
  • Integrating with Microsoft Active Directory
  1. High-Availability, Scaleout & Clustering
  • Understanding OBIEE and WLS Clustering Concepts
  • Vertical Scaleout
  • Horizontal Scaleout
  • Deploying for High-Availability


To book this course for your organization, or for more information, contact for more details.

Website Design & Build: