How to Create New RPD - Part1


Hi All,
   Through this post I'm explaining how to create the RPD for Sample SH schema in OBIEE 11g. This will be a good starting point for someone who wants to learn OBIEE10g. It covers the following,

1. Building Physical Layer 
2. Buiding BMM layer
3. Building Presentation Layer

Business Scenario:

Sales history schema comes with Oracle database as one of the sample schema. It explains a business scenario where company has products which are sold through multiple channels to customers with seasoned promotions to make the sales effective.

Tables of the SH Schema:                                                                                       

Table Name
COUNTRIES
CUSTOMERS
PRODUCTS
TIMES
PROMOTIONS
CHANNELS
SALES
COSTS


Relational Diagram between the tables:                                                                 




In Next Post, we will see How to import this tables into New SH rpd and how to build all three layers of repository.



0 comments to "How to Create New RPD - Part1"

Post a Comment

About This Blog

Labels

Views

Followers