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.

DURATION

2 Days

COURSE DELIVERY

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

WHO SHOULD ATTEND

Developers and Tech Leads

PREVIOUS KNOWLEDGE

None Required

Course Agenda

Day 1
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
DAY 2
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