Show TOC

 Aggregation

Use

This function enables you to aggregate values for specified format tree nodes (called aggregation nodes) and it makes this number available to a defined field in the DME file.

The aggregation function can be used at the end of a level or a file to:

  • Add the total value of specified nodes

In this case, you can only specify aggregation nodes that are filled with values (elements).

Example Example

This could be the amount of all payments in a level.

End of the example.

You can also specify that the absolute values are to be added, which means that the system ignores the + and - signs.

  • Add the number of nodes

In this case, you can specify any aggregation nodes because the system totals the number of occurrences, not specific values.

Example Example

This could be the number of payments in a level.

End of the example.

Activities

Outgoing Files

You can define an aggregation for elements or atoms. When you create either of these nodes, select the mapping procedure Aggregation . On the Aggregation tab, you enter the reference IDs of the nodes you wish to aggregate and the aggregation type – how the aggregation nodes are to be totaled to the target node (either summation of values or of total number of occurrences).

Incoming Files

You define an aggregation using a technical node. Assign it a reference ID and set the Aggregation node indicator on the Attributes tab, and enter the reference IDs of the nodes to be aggregated and how they are to be aggregated on the Aggregation tab. The technical node stores the aggregated value, which can then be used to:

  • Define a condition or a file check

  • Map the aggregated value to a target field in the converted file