Business Intelligence Tutorial

Creating the standard dimensions

In this exercise, you will create standard dimensions for the model, and associate each standard dimension with a relational table that contain the data for that dimension. The dimensions are:

Scenario dimension
Describes likely scenarios for analyzing data.

Product dimension
Describes the products in your business. In this tutorial, your products are soft drinks.

Market dimension
Describes the markets in which you operate. For example, you can organize your markets into regions and cities.
  1. On the Name Dimensions page, type Scenario in the Name field and click Add to list. The Scenario dimension is added to the Dimension List field.
  2. Follow the same process for the Product and Market dimensions. The window now looks like this:
    Name Dimensions page
  3. Click Next and the Select Relational Tables page is displayed.

On the Select Relational Tables page, you can associate one or more tables with the dimensions you created. Each dimension must have at least one table. The Accounts and Time dimensions are not listed because you have already created them.

  1. In the Dimension List field, click the Scenario dimension.
  2. Scroll down the Available Relational Tables list to the TBC.LOOKUP_SCENARIO table. Select the table and click the right arrow button next to the Primary Dimension Table field, and the table is added to the field. The table is also added under the Primary Table heading in the Dimension List field.

    If you wanted to associate additional tables for this dimension, you could select the table and click the right arrow next to the Additional Dimension Tables field. But for this lesson, do not add additional tables.

  3. Follow the same process for the Product and Market dimensions. For the Product dimension, use the TBC.LOOKUP_PRODUCT table. For the Market dimension, use the TBC.LOOKUP_MARKET table. The window looks like this:
    Select Relational Tables page
  4. Click Next and the Fact Table Joins page is displayed.


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