| 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):
-
sym_KPI for metric shortcut
-
sym_KPX for metric placeholder
-
sym_grp for strategy element shortcut
-
sym_grx for strategy element placeholder
|
| |
|
|
| |
|
-
sym_VertLine for vertical line
-
sym_HorizLine for horizontal line
-
sym_Arrow for graphical free arrow
-
sym_DGM for diagram
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
|
