Business Intelligence Tutorial

Lesson 21. Joining and editing dimension tables

The star schema represents the relationships between the fact table and the other dimensions in the model. In this lesson, you will see how the structure of the star schema is defined by joins between the dimension tables and the fact table. You will learn how to hide columns in the dimension tables so that the columns do not appear as members of the dimensions in the model.

The left side of the Fact Table Joins page lists all the dimensions in the model. The right side shows which columns are joined between the dimension tables and the fact table, if a join exists. In the Dimension List field, an X next to a dimension means the dimension is joined with the fact table. Notice that all the dimensions are joined to the fact table.

  1. In this exercise you will show which column joins the fact table to the Time dimension. In the Dimension List field, select the Time dimension.
    Fact Table Joins page

    Notice that the TIME_ID column joins the fact table with the Time dimension.

  2. Click Next and the Dimension Table Joins page is displayed. You can use this page to create joins between the primary tables for the dimensions and any additional dimension tables you added on the Select Relational Tables page. In this tutorial, you did not add any additional relational tables, so none are listed.
  3. Click Next and the Edit Tables page is displayed.


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