Data Warehousing Objects Fact tables and dimension tables are the two types of objects commonly used in dimensional data warehouse schemas. Fact tables are the large tables in your data warehouse schema that store business measurements. Fact tables typically contain facts and foreign keys to the dimension tables. Fact tables represent data, usually numeric and additive, that can be analyzed and examined. Examples include Sales, Cost and Profit. Dimension...

Creating Presentation Layer of SH Repository  The main purpose of building the Presentation catalog in Presentation Layer is to provide the useful and necessary data from the end-users perspective i.e. different view of data for business measures are provide for different type of users. Steps for making Presentation catalog in Presentation Layer are as follows: 1)In case you closed the rpd file, use the following steps to open the repository.  ...

Building the Business Model & Mapping Layer                                                              The main purpose of the business model is to capture how users think about their business using their own business terms. The business model simplifies the physical schema and...

In this post, we will learn How to create the relation between the tables using Physical Layer Diagram. Using the Physical Diagram approach you can define both Primary and Foreign keys in one step. In SH Schema, the following is the key that you are going to join between the table. PROMOTIONS. PROMO_ID = SALES. PROMO_ID TIMES. TIME_ID = SALES. TIME_ID           CUSTOMERS. CUST_ID =...

Importing Data source from SH Database:                                                              Open the Administration Tool and create New Repository by following the below steps: 1. Select Start > Programs > Oracle Business Intelligence > BI Administration 2. Click...