Oracle Analytics Repository (RPD) Modeling

Course Overview

This course provides in-depth details of the principles and practicalities of Repository (RPD) design in Oracle Analytics (OBIEE, OAS and OAC). The course explains the difference layers in the RPD and walk delegates through the process of creating a semantic model and exposing it to users.

Who Should Attend

BI Developers, Modeller, Architects and Tech Leads

Prior Knowledge

A basic understand of Oracle Analytics and dimensional modelling


2 Days

Course Agenda


  • What is the RPD?
  • Overview of features and functions
  • Design objectives

Creating a basic RPD Model

  • Data sources and connections
  • Creating a Basic Repository
  • Creating the Business Model and Mapping Layer
  • Creating Hierarchies
  • Adding Calculations
  • Creating the Presentation Layer
  • Offline vs Online Development

Advanced RPD Modelling

  • Time-Series Calculations
  • Complex Hierarchies
  • Horizontal & Vertical Federation
  • Fragmentation
  • Modelling over 3NF Sources

Security and Variables

  • Repository & Session Variables
  • Implementing Row-Level Security

Software Development Lifecycle (SDLC)

  • What is SDLC
  • Merging and Patching
  • Multi-User Development (MUD)
  • Version Control