Rational ProjectConsole Designer Help
To use a new source template for data collection, you must create the associated metadata, which includes a measure table, one or more dimension tables, a mapping between your source fields and the target fields, and a scheduled collection task.
Use the controls in this window to provide the source field information that Rational ProjectConsole will then use to create the required metadata.
If your source template contains a date/time source field, leave the default data type, which is String. In this case, after the metadata has been created automatically for you, you are required to perform some manual steps.
If you select String, Rational ProjectConsole creates a new dimension table to hold the collected string data. It then creates a reference to this dimension table in the measure table that it generates. An example of this type of field is defectpriority. String is the most common field type.
If you select Integer or Float, Rational ProjectConsole creates a measure field for it (of type Integer or Float, depending on which you select) in the measure table that it generates. An example of this field type is the number of lines added in a Rational ClearCase source template.
The metadata that Rational ProjectConsole creates for a new source template includes new target tables. If you want to reuse existing tables, you must create the metadata manually.
A date/time source field must be mapped to a time dimension table. Rational ProjectConsole does not automatically create time dimension tables for you. In this case you should select String as the source field type, and then perform the additional steps described in Automatically created metadata and the date/time dimension.