The following table provides an overview of the rules for standard aggregation and exception aggregations in the BW system.
Abbreviation |
Aggregation Rule |
Description |
---|---|---|
AVG |
Average (All Values) ( Average of All Values) |
The average of all values is displayed. |
AV0 |
Average (Values not Equal to Zero) ( Average of All Values < > 0) |
If you drill down to the reference characteristic, the average of the column values is displayed as not equal to zero in the result line. |
AV1 |
Average (Weighted with Number of Days) ( Average Weighted with Calendar Days) |
If you drill down to the reference characteristic, the average of the column values weighted with the number of days is displayed in the result line. |
AV2 |
Average (Weighted with Number of Work Days; Factory Calendar) ( Average Weighted with Working Days) |
If you drill down to the reference characteristic, the average of the column values weighted with the number of working days is displayed in the result line. |
CNT |
Counter (All Values) ( Count All Values) |
The number of available values is displayed in the result line. |
CN0 |
Counter (Values not Equal to Zero) ( Count All Values <> 0) |
The number of values <> zero is displayed in the result line. |
FIR |
First Value ( First Value) |
The first value in relation to the reference characteristic is displayed in the result line. |
LAST |
Last Value (Last Value) |
The last value in relation to the reference characteristic is displayed in the result line. |
MAX |
Maximum ( Maximum) |
The highest value of all displayed values in this column is shown in the result line. |
MIN |
Minimum ( Minimum) |
The lowest value of all displayed values in this column is shown in the result line. |
NGA |
( No Aggregation of Posted Nodes Along the Hierarchy) |
No aggregation of postable nodes along the hierarchy. |
NHA |
( No Aggregation Along the Hierarchy) |
No aggregation along the hierarchy. |
NO1 |
( Exception if More Than One Record Occurs) |
No aggregation; The special value NOP is displayed if more than one record occurs. |
NO2 |
( Exception if More Than One Value Occurs) |
No aggregation; The special value NOP is displayed if more than one record occurs. |
NOP |
( Exception if More Than One Value <> 0 Occurs) |
No aggregation; The special value NOP is displayed if more than one value <> 0 occurs. |
STD |
Standard Deviation ( Standard Deviation) |
After drilling down according to the reference characteristic, the standard deviation of the displayed values is displayed in the results row. |
SUM |
Summation ( Total) |
The total of all values in this column is shown in the result line. |
VAR |
Variance ( Variance) |
If you drill down to the reference characteristic, the variance of the displayed values is displayed in the result line. |