
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):
- Select the UNI_relational_data project and choose File | New Data Foundation
- Enter UNI_eFashion as the resource name and choose Next
- 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 Key | Primary.
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.