Assign aggregation values

Aggregation values displayed in an aggregated EPC to make deleted dimension values visible are specified in the measure configuration (see Definition of dimensions).

You can assign aggregation values to the following process dimension types:

Example 1 (aggregation values for a two-level dimension)

You want to specify aggregation values only for the first level of the two-level Material process dimension:

...

<twoleveldim name="MATERIAL" dimtype="PROCESS"
dimgroup="DIM_GROUP_CRITERIA">

<description name="Material" language="en"/>

<leveldesc>

<dimitem attrname="AT_MATERIAL_KIND" colname="FIRST_ID"
calculated="FALSE">

<description language="en" name="Material type"/>

<compressionvalue>
Compressed (1st level ID)
</compressionvalue>

</dimitem>

<dimitem attrname="AT_MATERIALKIND_NAME"
colname="FIRST_DESC" calculated="FALSE">

<description language="en" name="Material type name"/>

<compressionvalue>
Compressed (1st level description)
</compressionvalue>

</dimitem>

</leveldesc>

<leveldesc>

<dimitem attrname="AT_MATERIAL"
colname="SECOND_ID" calculated="FALSE">
<description language="en" name="Material"/>

</dimitem>

<dimitem attrname="AT_MATERIAL_NAME"
colname="SECOND_DESC" calculated="FALSE">

<description language="en" name="Material type name"/>

</dimitem>

</leveldesc>

</twoleveldim>

...

For each key and description of the first level of the dimension, an aggregation value is specified with the compressionvalue XML element. For the permanent aggregation using command line aggregation, all identical and different values of the specified process dimensions are deleted. In the aggregated process instance, the specified aggregation values are displayed as the value of the dimension if the dimension is not included in the aggregation paramset. The default value for the aggregated second level is Not specified because no aggregation values are specified for the level items (dimitem) of the second level.

s_ppm_tr_customizing_59

Always specify the aggregation values of the relevant level in pairs (for key and description), otherwise the import of the measure configuration will abort with an error message.

Example 2 (Time dimension: Delete dimension values when aggregating)

You want to ensure that no values are displayed for the Process end time time dimension in permanently aggregated process instances, regardless of whether the dimension values of the process instances to be aggregated are identical or different.

...

<timedim name="PROZESSENDZEIT" dimtype="PROCESS" ...
attrname="AT_END_TIME" ...
calculated="TRUE" ...
deleteoncompression="TRUE" ... >

<description name="Process end time" language="en" />

</timedim>

...

If you specify deleteoncompression="TRUE" for the Process end time process dimension, identical and different dimension values of the process instances to be aggregated are deleted during permanent aggregation via command line if the Process end time dimension is not included as an iteration in the aggregation paramset. Dimension values no longer exist in the aggregated EPC.

Warning

If you add the Process end time dimension in the PPM analysis of the displayed aggregated process instance, data can no longer be displayed due to the deleted dimension values.

You cannot specify aggregation values for the Process type (PROCESSTYPE) dimension because this dimension is automatically included as an iteration in each aggregation paramset. Similarly, you cannot specify for the Time (TIME) process dimension that dimension values are to be deleted during aggregation.

You can conveniently specify aggregation values for the relevant process dimension in PPM Customizing Toolkit in the Dimensions component of the Measures and dimensions module. This is also where you can specify for time dimensions of the PROCESS type whether dimension values are to be deleted during aggregation. A prerequisite is that the AT_INTERNAL_COMPRESSCRITERION attribute has been specified, i.e., created.