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
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.
Do you like this article? Share It!
0 comments to "How to Create New RPD - Part1"
Views
Post a Comment