Business Intelligence Tutorial
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.
- 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.
- Follow the same process for the Product and Market dimensions. The
window now looks like this:

- 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.
- In the Dimension List field, click the Scenario
dimension.
- 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.
- 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:

- Click Next and the Fact Table Joins page is displayed.
[ Top of Page | Previous Page | Next Page | Table of Contents ]