OBIEE 11g Repository (RPD) Modeling

Course 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.

Who Should Attend

Developers and Tech Leads

Previous Knowledge

None Required

Duration

2 Days

Course Agenda

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

Advanced Repository Modeling From Relational Sources

  • ID Columns for Descriptive Columns (“Double-columns”)
  • Lookup Tables
  • Horizontal & Vertical Federation (Drill-Up and Drill-Across)
  • LTS Priority Ordering
  • Modeling Transactional (3NF) Data Sources