<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE keyindicatorconfig SYSTEM
'KeyindicatorConfiguration.dtd'>
<keyindicatorconfig>
...
<nleveldim name="..." dimtype="..." internal="..."
importmode="..." dimgroup="...">
<description name="..." language="..."/>
<leveldesc>
<dimitem attrname="..." colname="..."
calculated="..." location="..." substvalue="...">
<description language="..." name="..." />
<defaultvalue="..."/>
</dimitem>
<dimitem attrname="..." colname="..."
calculated="...">
<description language="..." name="..."/>
<defaultvalue="..."/>
</dimitem>
</leveldesc>
<leveldesc>
...
</leveldesc>
<leveldesc>
...
</leveldesc>
...
</nleveldim>
...
</keyindicatorconfig>
By default, the values of the individual dimension levels are displayed in the form <Description (Key)> in PPM, provided that descriptions have been defined. Otherwise, only the key is displayed as the value.
Example
If the attribute referenced by the first dimitem contains the definition of a key ID and the attribute referenced by the second dimitem contains the corresponding description Text, the dimension values for this level are displayed by default in the form <Text> (<ID>) in the user interface.
The extract from the configuration file for a similar example looks like this.
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE keyindicatorconfig SYSTEM
'KeyindicatorConfiguration.dtd'>
<keyindicatorconfig>
...
<oneleveldim name="VTWEG" dimtype="PROCESS"
internal="no" importmode="OPTIONAL">
<description language="de" name="Vertriebsweg"/>
<description language="en"
name="Distribution channel"/>
<leveldesc>
<dimitem attrname="AT_VTWEG"
colname="FIRST_ID" calculated="FALSE">
<description language="de"
name="ID des Vertriebsweg"/>
<description language="en"
name="ID of distribution channel"/>
</dimitem>
<dimitem attrname="AT_VTWEG_NAME"
colname="FIRST_DESC" calculated="FALSE">
<description language="de"
name="Vertriebsweg"/>
<description language="en"
name="Distribution channel"/>
</dimitem>
</leveldesc>
</oneleveldim>
...
</keyindicatorconfig>
The dimitem XML element configures the following settings for the key or description of a dimension level:
XML tag |
Description |
---|---|
attrname |
Name of the referenced attribute. Only the TEXT data type is permitted. |
calculated |
TRUE: The attribute value is calculated. |
location |
Only for dimtype="RELATION" Valid values: SOURCE (attribute placement on source reference object of relation) |
defaultvalue |
Specifies a default value that is displayed if no attribute value can be retrieved and if no value is or can be retrieved using substvalue. If neither defaultvalue nor substvalue has been specified, the value of the PPM_NULL key from the file Database_settings.properties is displayed if an attribute value cannot be retrieved. |
substvalue |
Specifies a substitute value that is displayed if no attribute value can be retrieved. The attribute value from the previous, rougher level (PRED) or the next, more detailed level (SUCC) can be used as a substitute value. Substitute values may cover several consecutive levels. If no value can be retrieved using the specifications for substvalue (e.g. substvalue="SUCC" for a one-level dimension), no substitute value is displayed. Default value: NONE (no substitute value) |
XML element |
Description |
---|---|
compression |
The internal aggregation attribute AT_INTERNAL_COMPRESSCRITERION must be specified (Configure the internal aggregation attribute). Only for dimtype="PROCESS" Identical and differing dimension values are deleted when permanently aggregating using the command prompt (runppmcompress) (see PPM Operation Guide) and they are replaced by the specified aggregation value (Change aggregation behavior). |
Substitute and default values for one-, two-, and n-level dimensions
You can specify default values and substitute values for the keys and descriptions of each individual dimension level. These values are displayed if no attribute value can be retrieved. When you select the dimension value to be displayed, the sequence is as follows:
Warning
The two-level Process type dimension does not support default or substitute values. If you specify these in the configuration, they are deleted during the import.
Example (file extract from measure configuration)
...
<nleveldim name="SALE" dimtype="PROCESS"
dimgroup="DIM_GROUP_CRITERIA">
<description name="Sales" language="en"/>
<leveldesc>
<dimitem attrname="AT_VKORG" colname="NAME_1"
calculated="FALSE">
<description language="en"
name="Sales organization"/>
</dimitem>
<dimitem attrname="AT_VKORG_NAME"
colname="DESC_NAME_1" calculated="FALSE">
<description language="en"
name="Name of sales organization"/>
</dimitem>
</leveldesc>
<leveldesc>
<dimitem attrname="AT_DIVISION" colname="NAME_2"
calculated="FALSE" substvalue="SUCC">
<description language="en" name="Division"/>
<defaultvalue>defaultvalue 2nd level ID
</defaultvalue>
</dimitem>
<dimitem attrname="AT_DIVISION_NAME"
colname="DESC_NAME_2" calculated="FALSE"
substvalue="SUCC">
<description language="en" name="Division name"/>
<defaultvalue>defaultvalue 2nd level description
</defaultvalue>
</dimitem>
</leveldesc>
<leveldesc>
<dimitem attrname="AT_VTWEG" colname="NAME_3"
calculated="FALSE">
<description language="en"
name="Distribution channel"/>
</dimitem>
<dimitem attrname="AT_VTWEG_NAME"
colname="DESC_NAME_3" calculated="FALSE">
<description language="en"
name="Name of distribution channel"/>
</dimitem>
</leveldesc>
</nleveldim>
...
Substitute values (substvalue) are defined for the key and description of the second level of the SALE n-level dimension. These substitute values are transferred to the subsequent third level. If no substitute value can be retrieved, the specified default value (defaultvalue) is displayed instead.
Text dimensions are normally based on alphanumeric attribute types. The dimension values are displayed in the interface in alphanumeric order.
When using attributes based on numerical data types, the dimension values are written to the database as strings and are sorted in numerical order when displayed in the interface.