Aggregation Settings

The aggregation setting of a node defines how the data is summarized when shown with less than its "full dimensionality". This setting is very visible when looking at the data in a tree view, as there the data is often shown on a per-year level. It also affects how the data is "Rolled up", if the ROLLUP or DROPLEVEL function is used.

Among the standard options you will find:

  • SUM
  • AVG (See weighted average below)
  • MIN
  • MAX
  • CLOSINGSUM
  • CLOSINGAVG
  • NONE
Aggregation Type Notes
SUM (default) Sum of all values
AVG The average value. To calculate weighted averages, see below
MIN / MAX The minimal value (on that specific aggregation level), e.g. can be a min-value per year & product
CLOSINGSUM The sum of the values at the end of each time value (e.g. Stock level on a node that contains in/out to warehouse)
CLOSINGAVG The avg value within a time period, e.g. average cash balance on a node that contains the balance.
NONE The node will not be shown aggregated.

NEW IN VERSION 2.1

Weighted Average by

You can specify a node which is used for weighting, e.g. use volume to weight the price to get an average price of products sold. See details below.


Weighted Average

The standard aggregation types only use the data of the node itself. However, typical drivers are cost ratios, prices, etc that must be weighted by a volume to make sense on an aggregated level. The weighted average aggregation setting allows you to define such a node. When using the weighted average, keep the following in mind:

  • The weighting node needs to have at least the levels of the node.
  • The weighted average is not supported for nodes using the RATIO function.
  • The average is calculated as 'Node' * 'Weight' / 'Weight'. When using the node in a chart, the aggregation to the requested chart dimensionality happens individually for the numerator ( 'Node' * 'Weight') and the denominator ('Weight') before the division and always using SUM as aggregation method (independent of the aggregation settings of 'Node' and 'Weight').




Was this helpful?

Yes | Somewhat | No