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