Creating a measure table

Rational Rational ProjectConsole Designer Help

To create a measure table:

  1. If you have not done so already, check out the Rational ProjectConsole schema.
  2. On the Designer File menu, point to New, and then click Measure Table, or, on the Designer toolbar, click .
  3. In the Target Table window that opens in the right pane, on the General page, type a unique name for the table, and if you choose to, a table description.
    Note: Although it is not required, you should follow a naming convention. One useful naming convention is to append _measure to signify a measure table.

    Rational ProjectConsole automatically creates four default fields in a new measure table.

  4. To view the default fields, click the Target Fields tab.

    The Target Fields page lists the following four fields:

    Field Name Field Type Description
    calendardate_fk Reference A reference to the predefined calendardate time dimension table
    coll_instance_log_id String A string associated with a scheduled task log report
    collectiondate_fk Reference A reference to the predefined collectiondate time dimension table
    measure Integer A field used to execute a simple count function (You can specify a more meaningful name for this field.)
  5. To rename the measure field, in the Display Name column, click measure, and then click Edit.
  6. Perform the following procedure in the Field Information window:
    1. Type a more meaningful name for the field.
    2. Clear the Nonadditive check box only for additive measures.

      For information about additive and non-additive fields, see Additive and non-additive data.

    3. Click OK.
  7. To add a new field, click Add.
  8. Perform the following procedure in the Field Information window:
    1. In the Name field, type a unique name for the target table field. If this is to be a reference field, you should append _fk to the field name.
    2. In the Type field, select the type of field you are adding.
    3. If you selected a reference field type, from the Reference list, select a dimension table to reference.
    4. If you selected an integer or float field type and you are creating an additive measure, clear the Non-additive check box. If you are creating a measure that is not additive, leave the Non-additive check box selected.
    5. To indicate that the field is a unique key, select the Unique Key check box.
    6. (Optional) In the Description field, type a field description.
    7. Click OK.