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 =...