Automatically created metadata and the date/time dimension

Rational ProjectConsole Designer Help

Rational ProjectConsole does not create time dimension tables automatically. This means that you cannot use an automatically created dimension table to specify date/time as the data type for a source field. The date/time data type can only be used for a field in time dimension tables. To collect date/time type data from a source, you must create a time dimension table manually.

If your source template includes a date/time source field, after Rational ProjectConsole creates the metadata for you, perform the following actions:

  1. Check out the schema.
  2. Edit the generated measure table. (The table name has the prefix you specified in the Create Metadata window.) Delete the references to the automatically created String date/time fields. Save the modified measure table.
  3. Create the time dimension table.
  4. Edit the measure table again. Add a field to reference the new time dimension table. Save, and then close the measure table.
  5. Edit the generated mapping. (The mapping name has the prefix you specified in the Create Metadata window.) On the Mappings page, select the row for the new time dimension target field. In the Source Field list, select the date/time source field name. Save the modified mapping.

    Map the new date/time target field (that you just created) to your date/time source field.

    Save the mapping and close it.

  6. Check in the schema.
  7. Populate the time dimension table.

For more information about automatically created metadata, see Create Metadata window.