Aggregation and Special Values

The aggregation rules outlined in the previous sections produce unique results for value sets with valid values. There are also more complex value sets that contain special values such as 0, NULL , or DIV0.

The following example shows that a value set of this kind does not lead to a unique result based on the previous rules.

The following section explains the different combinations for exception aggregation rules (AVG, AV0, and so on) and special value sets (for example, { 0€ }, { 0€, DIV0 }, { 42€, 13$ }, { 0€, DIV0, 42€, 13$ } ) and the results that they produce. Firstly, the special behavior and results of the standard and exception aggregations for basis key figures are described as well as for calculated and restricted key figures (known as formula exception aggregation). These aggregation rules are then compared with different value sets that contain the values which appear in the special situations (for example, ERROR or mixed currencies).

There are the following types of special values that have to be included in value sets:

The order of this list corresponds to the priority with which the OLAP processor includes the special values in an aggregation: Firstly ERROR, then NOP, then *, and finally NULL.

Special value NOP is handled like ERROR so that the following rules apply:

The following tables apply the priority rules to some example sets (in the columns) and show the different aggregation rules (in the rows). For the sake of charity, the characteristic names are left out of the example sets. The special exception rules AV1, average (weighted with number of days), and AV2, average (weighted with number of working day; factory calendar) are not displayed: As the displayed value sets do not reference the time characteristics, AV1 and AV2 behave like AVG. (For hierarchy exception aggregations NHA and NGA, seeHierarchy Exception Aggregation NGA and NHA).