SAP Business Intelligence Quick Start Guide
上QQ阅读APP看书,第一时间看更新

Creating a single source data foundation

Create a single source data foundation called UNI_eFashion, based on the secured version of the relational connection (.cns).

Include the  ARTICLE_LOOKUP, CALENDER_YEAR_LOOKUP, and SHOP_FACTS tables (download the tables from the preceding link):

  1. Select the UNI_relational_data project and choose File | New Data Foundation
  2. Enter UNI_eFashion as the resource name and choose Next
  3. In the Select Data Foundation type dialog box, select single source radio and then Next

We need to set the primary keys for the database tables. In the ARTICLE_LOOKUP table, we set the ARTICLE_ID field as the primary key; CALENDER_YEAR_LOOKUP will have WEEK_ID as the primary key; and SHOP_FACTS can be set to SHOP_FACTS_ID by right-clicking on the fields and choosing Set as KeyPrimary

Then we need to create the joins between the lookup table and the fact table with the transactional data. We will create the following joins:

ARTICLE_LOOKUP.ARTICLE_ID | SHOP_FACTS.ARTICLE_ID CALENDAR_YEAR_LOOKUP.WEEK_ID | SHOP_FACTS.WEEK_ID

To do so, we go to the Master panel of the data foundation and connect the fields by dragging a line between them.