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 |
|
Data Total: the value will be added to the first, last, or average value of the regular month elements. |
|
Include in First/Last: |
|
Remove from First/Last: |
Updated August 25, 2023