RPD Layers

Three Layers of RPD:

RPD (Repository) is divided into 3 layers

1. Physical Layer: This layer is used for

ü  Importing data

ü  Creating Aliases

ü  Building physical joins

ü  Setting up connection pool and its properties

ü  Enabling/ Disabling cache for individual table

2. BMM (Business Model & Mapping) Layer: This layer is used for

ü  Writing the business logic

ü  Creating Logical columns and tables

ü  Creating hierarchy

ü  Creating LBM (level based measures)

ü  Creating shares

ü  Creating Time series functions

ü  Creating Fragmentation on tables

ü  Creating filters on repository

3. Presentation Layer: This layer is used for

ü  Arranging the data for users view (Folder Structure)

ü  Creating Presentation hierarchy

ü  Creating Implicit Fact column

ü  Implementing Column level security

In short three layers of RDP consist of following functions:

PRESENTATION LAYER User Roles And Preferences Simplified Views Logical SQL Interface

BMM LAYER Dimensions Hierarchies Measures Calculations Aggregation Rules Time Series Functions

PHYSICAL LAYER Map Physical data Connections Schema Aliases, Joins