The cube query stage file contains information for creating the dimensions to be displayed as a report. This file can be generated only from Metric Designer for OLAP sources such as PowerCube and Microsoft analysis services. The information contained in this file is sourced from the Select dimension page of the Time and Currency Mappings portlet wizard in Metric Designer.
The cube query stage file loads the cube_query_stage table. The columns in the cube query stage file are as follows.
No. | Column | Description |
1 | external_object_id |
The external ID of the metric. Maximum length: 60 |
2 | kpi_indicator_type_id |
The unique identifier of the metric type for the metric. Value: metric type ID Required for a metric |
3 | kpi_home_sc_id |
The unique identifier of the home scorecard for the metric. Value: home scorecard ID Required for a metric |
4 | kpi_qualifier_id |
The unique identifier of the qualifier to distinguish this metric from other metrics of the same type on the same home scorecard. Corresponds to Qualifier Name and the object_id in the .cmo file. Required if there is more than one metric of this type on the same home scorecard |
5 | data_source_id |
The unique identifier for the import source. We strongly recommend that you use object_id in the .cmo file to define it. Maximum length: 255 Required if the import source is new; if it does not exist, Metric Studio creates it |
6 | sc_exp |
Filter on kpi_qualifier. Maximum length: 512 |
7 | measure_exp |
Value (fact) expression. Maximum length: 512 |
8 | filter_exp |
Filter to restrict query. Maximum length: 1024 |
9 | url_id |
The external ID for the autoreport URL. |
10 | has_children |
A flag indicating if the autoreport has children. Values: Y (Yes), N (No) |
11 | created_dt |
The date the value was set in the source system. 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