The stage diagram file (.cdo) contains the data required to create a specific diagram. First, you create a diagram object and caption in the .cmo file. Then, in the stage diagram file, you specify where each object, such as a metric or an arrow, is to be placed on the diagram. You need one row in the stage diagram file for each object on the diagram.
The stage diagram file loads the stage_diagram table. The columns in the stage diagram file are as follows.
| No. | Column | Description |
| 1 | diagram_id |
The unique identifier for the diagram. The value is the object_id value in the .cmo file. Maximum length: 255 Required |
| 2 | image |
The .gif or .jpg file for the background image. Maximum length: 255 |
| 3 | palette |
The ID of the palette. Corresponds to the palette on the diagram property sheet. Maximum length: 60 |
| 4 | symbol_id |
The type of graphical object. Values (case sensitive):
|
|
||
Maximum length: 60 |
||
| 5 | object_id |
A unique identifier for the diagram object. Maximum length: 255 |
| 6 | object_type_cd |
The code indicating the type of object. The value is the object_type_cd in the .cmo file. If you are linking objects, this is the code for the linked from object. The linked to code is identified by the linked_object_type_cd. Values: DGMT (diagram), KPI (metric), DGM (caption) Maximum length: 50 |
| 7 | kpi_indicator_type_id |
The metric type identifier of the first metric in a diagram. This is the identifier that was staged for the metric type in the .cmm file or metric_type_stage table, or the identifier that was entered in the user interface. |
| 8 | kpi_home_sc_id |
The home scorecard identifier of the first metric in a diagram. 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. |
| 9 | kpi_qualifier_id |
The unique identifier of the qualifier of the first metric in a diagram. 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. |
| 10 | xpos |
The x axis on the diagram. Range in pixels: 0, 600 |
| 11 | ypos |
The y axis on the diagram. Range in pixels: 0, 600 |
| 12 | object_visible_flag |
The flag indicating whether a caption is shown in the diagram. Values: Y (Yes), N (No) Default: Y |
| 13 | linked_object_id |
The unique identifier of the object to which you are linking in a diagram. The object from which you are linking is identified by the object_id. Maximum length: 255 |
| 14 | linked_object_type_cd |
The unique code of the object to which you are linking in a diagram. The object from which you are linking is identified by the object_type_cd. Value: KPI Maximum length: 255 |
| 15 | linked_kpi_indicator_type_id |
The metric type identifier for the second metric in a diagram. 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. |
| 16 | linked_kpi_home_sc_id |
The home scorecard identifier of the second metric in a diagram. 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. |
| 17 | linked_kpi_qualifier_id |
The unique identifier of the qualifier of the second metric in a diagram. 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. |
| 18 | diagram_type |
Reserved for future applications. Value: 0 |
| 19 | symbol_type |
The type of status indicator symbols to display. Values: traffic, checks, symbol |
| 20 | symbol_size |
The size of the status indicator symbols. Values: 16, 32, 48 Required |
| 21 | symbol_text |
The flag indicating whether the metric name is displayed beside each status indicator. Optional Values: Y (Yes), N (No) |
| 22 | xend |
The coordinates of the second endpoint (lines) or opposite corners of a bounding rectangle. Required for ovals and rectangles |
| 23 | yend |
The coordinates of the second endpoint (lines) or opposite corners of a bounding rectangle. Required for ovals and rectangles |
| 24 | object_color |
The color of an object. Format: #RRGGBB (HTML format) where RR is the hexadecimal value for red, GG for green, and BB for Blue Default: Black |
| 25 | object_fill_color |
The fill color for ovals and rectangles. Can be different than the outline color. Format: #RRGGBB (HTML format) where RR is the hexadecimal value for red, GG for green, and BB for Blue Default: Black Optional |
| 26 | object_stroke |
The line width for line-based shapes. Values: an integer between 8 and 48 Required for line-based objects |
| 27 | object_font |
The font name for text objects. Values: Arial, Andale WT, Tahoma, Verdana, Times New Roman, Courier New Required for text objects |
| 28 | object_bold |
The flag indicating whether a sym_TitleText object should be displayed in bold. Optional Values: Y (Yes), N (No) Default: N |
| 29 | object_italics |
The flag indicating whether a sym_TitleText object should be displayed in italics. Italics do not apply to the Andale WT font. Optional Values: Y (Yes), N (No) Default: N |
| 30 | strategy_elem1_id |
The identifier of the primary strategy element. Applies only to strategy objects. |
| 31 | strategy_elem2_id |
The identifier of the secondary strategy element. Applies only to strategy objects. |
| 32 | strategy_id |
The identifier of the strategy. |
| 33 | x3 |
The x coordinate of the control point of a bezier curved line drawn between x1,y1 and x2,y2. |
| 34 | y3 |
The y coordinate of the control point of a bezier curved line drawn between x1,y1 and x2,y2. |
| 35 | z_index |
When objects are stacked, the layer to which this object belongs. |
| 36 | angle |
The angle at which to draw text and images. For future use. |
| 37 | image_source |
The file name of an image. Maximum length: 255 |
| 38 | arrow_from_obj-id |
The external identifier (object_id) of where the tail of the arrow starts. |
| 39 | arrow_to_obj-id |
The external identifier (object_id) of where the head of the arrow ends. |
| 40 | font_underline |
The flag indicating whether the text is underlined. Values: Y (Yes), N (No) Default: N |
| 41 | font_size |
The font size of the text. Values: an integer between 8 and 48 Default: 14 |
| 42 | show_name |
The flag indicating whether to display the metric name. Values: Y (Yes), N (No) Default: Y |
| 43 | name_position |
The position of the metric name. Values: 0 (right of indicator), 1 (above indicator), 2 (below indicator), 3 (left of indicator) Default: 0 |
| 44 | show_trend |
The flag indicating whether to display the metric trend icon. Values: 0 (do not show), 1 (show trend), 2 (show actual trend), 3 (use default) Default: 1 Option 3 (use default) uses the default set under Tools, Default Display Settings. |
| 45 | icon_size |
The size of the metric trend icon. Values: 16, 32, 48 Default: 32 |
| 46 | object_group_number |
For future use. |
| 47 | created_dt |
The date the diagram 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