Metric Studio: Stage Custom Parameters File (.cmp)

You can create custom parameters and associate them with Metric Studio metrics, metric types, and scorecards. Use custom parameters to pass information in a URL that is not normally stored in Metric Studio, such as an object identifier for another system.

The stage custom parameters file loads the stage_custom_params table. The columns in the stage custom parameters file are as follows.

























































No. Column Description
1 object_type_cd

The code indicating the type of object with which this parameter is associated.

Values: KPI (metric), KPICL (metric type), SC (scorecard)

2 object_id

The external ID of the object with which this parameter is associated.

3 kpi_indicator_type

The metric type identifier for the first metric.

This is the identifier that was staged for the metric type in the .cmm file or metric_type_stage table, or that was entered in the user interface.

4 kpi_home_sc_id

The home scorecard identifier of the first metric.

This is the identifier that was staged for the scorecard in the .cmo file or object_stage table, or that was entered in the user interface.

5 kpi_qualifier_id

The unique identifier of the qualifier that distinguishes the first metric from other metrics of the same type on the same home scorecard.

This is the identifier that was staged for the qualifier in the .cmo file or object_stage table, or that was entered in the user interface.

6 parameter_name

The parameter name to be used in URLs.

7 parameter_value

The value of this parameter for this object.

8 delete_flag

The flag indicating whether the parameter is to be deleted.

Values: Y (Yes), N (No)

Default: N

9 created_dt

The date the object 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