Metric Studio: Import Source Time Levels Stage File (.ctl)

The import source time levels stage file specifies the time levels from the import source and the corresponding time level in Metric Studio.

The import source time levels stage file loads the import_source_tl_stage table. The columns in the import source time levels stage file are as follows.





































No. Column Description
1 level_id

The unique identifier for the time level.

2 import_source_id

The unique identifier of the cube import source.

3 time_level_exp

The IBM Cognos 8 expression for a time level in a cube.

4 time_level_path

The time level path in a cube.

5 created_dt

The date the import was created.

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

(hh:mm:ss values are optional)

Required


Source: Metric Studio User Guide 8.4.1

www.cogknowhow.com