Metric Studio: Import Source Time Periods Stage File (.ctp)

The import source time periods stage file identifies time period information in the cube import source.

The import source time periods stage file loads the import_source_tp_stage table. The columns in the import source time periods stage file are as follows.

No. Column Description
1 level_id

The unique identifier for the time level.

2 start_time_cd

The calendar date that identifies the period for the current data row.

3 end_time_cd

The calendar-based end date for the specified period.

Value: yyyy-mm-dd hh:mm:ss (24-hour clock)

The end_time_cd value must be specified as the last minute of a time period. For example, 2005-01-01 23:59:00.


4 import_source_id

The unique identifier of the cube import source.

5 time_period_exp

The IBM Cognos 8 expression for the time period used in the cube.

6 created_dt

The date the import was created.

Format: yyyy-mm-dd hh:mm:ss (24-hour clock)

(hh:mm:ss values are optional)


Source: Metric Studio User Guide 8.4.1