Semi-Additive Measures (Sales Model)


Return to Sales Model Overview

The Sales, Sales Planning, and Sales Order Backlog cubes are set up to handle semi-additive measures. The semi-additive behavior can be declared for elements of the Sales_measure, Sales Planning_measure, and Sales Order Status dimensions of each respective cube. For the Sales and Sales Order Backlog cubes, semi-additive behavior will affect the aggregation along the Day dimension; for the Sales Planning cube, it will affect 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 Day or Month dimensions, exceptions from aggregation behavior have been defined:

Day/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.