Home Library Metric Studio: Stage Watchlist File (.cwl)
Follow us on Twitter


Countries

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

Visitors

Today: 40
Yesterday: 573
This Week: 40
Last Week: 3348
This Month: 9425
Last Month: 15365
Total: 383512


Metric Studio: Stage Watchlist File (.cwl) Print E-mail
(0 votes, average 0 out of 5)
Tuesday, 22 March 2011 08:13

The stage watchlist file contains information for adding a portlet.

The stage watchlist file loads the stage_watchlist table. The columns in the stage watchlist file are as follows.

 

No. Column Description
1 kpi_id

A unique identifier for the metric.

Maximum length: 255

Required

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 user_namespace_id

The identifier of a Cognos 8 authentication namespace used to resolve the reference in the owner_user_id column.

Used to differentiate the value in the owner_user_id when more than one Cognos 8 authentication namespace is configured.

Maximum length: 255

Required

6 user_id

The unique identifier for the owner of the object.

The name of the user, the identification of the user, or the search-path field in IBM Cognos 8.

Value: owner ID

Maximum length: 2000

Required

7 email_alert

The flag indicating if the email alert is on or off.

Values: Y (Yes), N (No)

8 alert_start_dt

The start date and time of the email alert.

9 delete_flag

The flag indicating whether the object is to be deleted.

Values: Y (Yes), N (No)

Setting the flag to Y deletes metric custom titles (alias).

Default: N

10 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

 

www.cogknowhow.com

 
 

Login

For more content en features!



CogKnowHow Newsletter

Season's Greetings


Receive HTML?

Polls

How many users are working on your Cognos environment?