Business Intelligence Tutorial

Autojoining the tables

In this exercise, you will use the primary and foreign keys that you defined in Lesson 11, Defining keys on target tables to automatically join the dimension tables and the fact tables.

To autojoin the tables:

  1. Click the Save icon in the toolbar to save your work:
    Figure wc_save not displayed.
  2. Close the Warehouse Schema Model window.
  3. Right-click on Tutorial Schema and select Open to reopen the Warehouse Schema Model window.

    You must close and reopen the Warehouse Schema Model window after you add the fact and dimension tables in order to autojoin the tables.

  4. Select the LOOKUP_PRODUCT, LOOKUP_SCENARIO, LOOKUP_TIME, and FACT_TABLE tables by holding down the Ctrl key and clicking each table.
  5. Click the Autojoin icon on the toolbar.
    Figure autojn not displayed.

    The Data Warehouse Center draws green lines between the primary keys in the dimension tables and the foreign keys in the fact table. You can change these lines until you save. (To remove these lines, multiple-select them, right-click, and click Remove.

  6. Click the Save icon on the toolbar to save your work:
    Figure wc_save not displayed.

    The green autojoin lines become black.

  7. Close the Warehouse Schema Model window.


[ Top of Page | Previous Page | Next Page | Table of Contents ]