TRN206 – OBIEE 11g Repository (RPD) Modeling

Overview: This advanced course spends two days looking in-depth at the principles and practicalities of Repository (RPD) design in OBI 11g. The course has been updated for OBIEE 11.1.1.7, but is just as relevant if your organisation is on an earlier release of 11g.

Course Delivery: Instructor-led with labs

Duration: 2 days

Who Should Attend: Developers, technical leads

Prerequisites: None

Detailed Course Agenda :

  1. 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
    • Parent-Child, and Ragged / Skip-Level Hierarchies
  2. Advanced Repository Modelling from Relational Sources
    • ID Columns for Descriptive Columns (“Double-columns”)
    • Lookup Tables
    • Horizontal & Vertical Federation (Drill-Up and Drill-Across)
    • LTS Priority Ordering
    • Modelling Transactional (3NF) Data Sources

To book this course for your organization, or for more information, contact training@rittmanmead.com for more details.

Website Design & Build: tymedia.co.uk