Creating a time dimension table

Rational ProjectConsole Designer Help

To create a time dimension table:

  1. On the Designer toolbar, click , or, on the Designer File menu, point to New, and then click Time Dimension Table.
  2. In the Target Table window, on the General page, in the Name field, type a unique name for the table.
  3. (Optional) In the Description field, you can type information about the table.
  4. On the Designer File menu, click Save, or, on the Designer toolbar, click.
  5. To view the target fields generated in the table, click the Target Fields tab.

    The names of fields in a time dimension table all begin with the table name.

    Note: Because you cannot modify the target field set, the Add, Edit, and Delete buttons are unavailable.
  6. Close the Time Dimension Table window.
After you have created all the time dimension tables you need, you can perform the following tasks in sequence:
  1. Create a measure table.
  2. Check in the ProjectConsole schema.
  3. Populate the time dimension table.