Aggregation Behavior of Non- Cumulative Key
Figures
The aggregational behavior determines whether, and how, key figure values are aggregated in reports using the different characteristics or characteristic values. The aggregational behavior depends on whether you are aggregating using time characteristics or other characteristics.
You can see how aggregation affects the query result under Interpreting Query Results.
If you add up all the cumulative values such as Sales Revenue using all characteristics (that is, time characteristics as well), the non-cumulative key figure relating to the time characteristic, the first value (FIRST aggregation), the last value (LAST aggregation) or the average is often taken.
You can find additional information about aggregate types under Tab Page: Aggregation.
In the following example, the difference between the FIRST aggregation and the LAST aggregation is made clear. If one considers, for example, the aggregated values for 02.02.02, then the non-cumulative is considered 90 with the FIRST aggregation, which is the non-cumulative without receipts. The non-cumulative with the LAST aggregation is considered 110, which is the non-cumulative from 90 plus the receipts of 20.
There are two possible kinds of aggregational behavior for non-cumulative key figures:
· The standard aggregation specifies how a key figure is compressed using all characteristics (but not time characteristics).
· The exception aggregation specifies how a key figure is compressed using all time characteristics.
Exception aggregations with regard to time
Every key figure has a standard aggregation and an exception aggregation. Non-cumulative key figures always have summation as standard aggregation, whereas time characteristics have an exception aggregation of not equal to summation.
The non-cumulative key figure Warehouse Stock is aggregated using Summation for characteristics that are not time-related such as Articles or Stock. For time characteristics such as Calendar Month, however, the non-cumulative key figure Warehouse Stock has the exception aggregation Last Value.
Meaningful aggregations for non-cumulative key figures are primarily Average Weighted According to Calendar Days (AV1) and Last Value (LAS). Additional, possible exception aggregations for non-cumulative key figures are listed in the following table.
Exception aggregation for non-cumulative key figures
Technical name |
Description |
AV1 |
Average (weighted with the number of calendar days) |
AV2 |
Average (weighted with the number of working days according to the factory calendar with the ID 01) |
FIR |
First value |
LAS |
Last value |
MAX |
Maximum |
MIN |
Minimum |
The time at which non-cumulatives were posted for different materials is displayed in the following graphic. The evaluation results for the non-cumulative for Material 1, for exception aggregation Average, and the exception aggregation Last Value, are listed in the following tables, where they are displayed once by calendar month and once by calendar day.
Drilldown on the non-cumulative value for Material 1 by calendar month
|
Average (calendar day) |
Last value |
January |
100 |
110 |
February |
140 |
160 |
March |
150 |
140 |
Drilldown on the non-cumulative value for material 1 by calendar day
Note that non-cumulatives that are evaluated by calendar day, both for the average and for the last value, always produce the same result. The reason for this is that Calendar Day is the smallest unit of time to which the data is transferred. This always occurs when you drilldown on the most detailed time characteristic.
|
Average (calendar day) |
Last value |
01.01.2000 |
90 |
90 |
02.01.2000 |
90 |
90 |
03.01.2000 |
90 |
90 |
04.01.2000 |
90 |
90 |
... |
... |
... |
09.01.2000 |
90 |
90 |
10.01.2000 |
90 |
90 |
11.01.2000 |
99 |
99 |
... |
... |
... |