Metric Studio: Cube Query Stage File (.ccq)

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.


Source: Metric Studio User Guide 8.4.1