Show TOC

Rules for Standard Aggregation and Exception AggregationLocate this document in the navigation structure

The following table provides an overview of the rules for standard aggregation and exception aggregations in the BW system.

Use

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.