Semi-Additive Measures (Cash Flow Cube)
Return to Cash Flow Model Overview.
The Cash Flow
cube is set up to handle semi-additive measures. The semi-additive behavior can be declared for elements of the CF Account
dimension and 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. Cash funds at the or at the end beginning of period) are also added to the CF Account
dimension and thus stored in the Cash Flow
cube. 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 as follows:
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 February 7, 2024