Business Intelligence Tutorial

Creating the time dimension

In this exercise, you will create a Time dimension, which you use to describe how often you collect and update data. For example, you can organize time into years, quarters, and months.

  1. On the Select Time page, you can accept the default value of Time in the Name field.
  2. Click By Selecting Relational Tables, which activates the Available Relational Tables field.
  3. Select the TBC.LOOKUP_TIME table and click the right arrow button. The table is displayed in the Selected Relational Tables field. The window looks like this:
    Select Time page
  4. Click Next and the Name Dimensions page is displayed.


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