Semi-Additive Measures (Human Resources Model)

Return to

The Personnel Costs and Personnel Cost Parameters cubes are set up to handle semi-additive measures. The semi-additive behavior can be declared for elements of the Personnel Costs_measure and Personnel Cost Parameters_measure dimensions of each respective cube. Semi-additive behavior will affect the aggregation along the Month dimension. This can be useful if, in addition to amounts stored in regular accounts, non-additive statistical figures (e.g. FTE or headcount) are also added to these dimensions and thus stored in the cubes. The semi-additive behavior can be set to Average of children, First child, or Last child (see related article Using Semi-Additive Measures).

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 25, 2023