Metric Studio: Stage Custom Parameters File (.cmp)

Home

Library

Main Menu

Member Menu (Login Required)

Countries

50.1%		United States
7.6%		India
7%		United Kingdom
5.1%		Australia
4.8%		Canada

Visitors

Today:	39
Yesterday:	573
This Week:	39
Last Week:	3348
This Month:	9424
Last Month:	15365
Total:	383511

Metric Studio: Stage Custom Parameters File (.cmp)

(0 votes, average 0 out of 5)

Monday, 21 March 2011 14:54

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

Login

CogKnowHow Newsletter

Polls

How many users are working on your Cognos environment?

	1 - 100 users
	101 - 250 users
	251 - 500 users
	501 - 1000 users
	1000 or more users