Semi-Additive Measures (Balance Sheet and Projected Balance Sheet Models)

Return to Models Overview

The Balance Sheet cube is set up to handle semi-additive measures. The semi-additive behavior can be declared for elements of the Transaction Type dimension and will affect the aggregation along the Month dimension. For some elements in the Transaction Type dimension, exceptions from semi-additive behavior have been defined:

Transaction Type element	Semi-additive aggregation
`Opening`	First child: only the first value is used for the aggregation along the `Month` dimension, e.g `2016` will be equal to `2016-01`.
`~` and `Closing`	Last child: only the last value is used for the aggregation along the `Month` dimension, e.g. `2016` will be equal to `2016-12`.

The semi-additive behavior can be set to Average of children, First child, or Last child

For some elements in the Month dimension, exceptions from aggregation behavior have been defined:

Month element	Aggregation inclusion
`2015-~`, `2016-~`, `2017-~`, etc.	Data Total: the value will be added to the first, last, or average value of the regular month elements.
`2015-00`, `2016-00`, `2017-00` etc.	Include in First/Last: `First child` aggregation will be e.g. `2016-00` + `2016-01`. First/Last: `Last child` aggregation will be e.g. `2016-00` + `2016-12`.
`2015-13`, `2015-14`, `2015-15`, `2015-16`, `2016-13`, `2015-14`, etc.	Remove from First/Last: `Last child` aggregation will be e.g. `2016-12` but not `2016-13`, `2016-14`, `2016-15` or `2016-16`.

Updated August 28, 2023