The stage object note file (.cmn) contains comments about metrics, projects, and strategy elements. These comments are shown in a separate frame below the metrics. For example, the owner of a metric that is trending downwards can use comments to let other users know that action is being taken.
Comments can also be associated with tasks and actions.
Notes in Metrics Manager 2.2 or earlier did not have subject fields. Metric Studio does have subject fields. If you import notes from earlier versions, the import process populates the subject field with up to 255 characters from the body of the note. These characters are also imported into the body of the comment.
Metric Studio uniquely identifies each comment by the unique identifier comment_id.
The stage object note file loads the stage_object_note table. The columns in the stage object note file are as follows.
No. | Column | Description |
1 | object_id |
A unique identifier for the metric, project, or strategy element that has the associated comment. Maximum length: 255 Required |
2 | kpi_indicator_type_id |
The metric type identifier for the metric to which you are attaching a comment. 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. |
3 | kpi_home_sc_id |
The identifier of the home scorecard of the metric to which you are attaching a comment. 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. |
4 | kpi_qualifier_id |
The unique identifier of the qualifier used to distinguish the metric to which you are attaching a comment 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. |
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 | note |
The text of the comment. |
8 | start_time_cd |
The start date and time of the time period. Required for a comment added to a metric; not required for a comment added to a project or strategy element |
9 | level_id |
The unique identifier for the time level. Required for a comment added to a metric; not required for a comment added to a project or strategy element |
10 | priority |
The level of importance of the comment. Values: 1 (low), 2 (normal), 3 (high) Required |
11 | delete_flag |
The flag indicating whether the comment is to be deleted. Values: Y (Yes: the user, date, and time still show under action history); N (No: do not delete) Default: N |
12 | subject |
The title for the comment. Maximum: 255 Required |
13 | comment_id |
The unique identifier of the comment. Maximum: 255 Required |
14 | object_type_cd |
The object type code for the parent of the comment. Values: KPI (metric), PRO (project), STELM (strategy element) |
15 | created_dt |
The date the comment 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