Non Cumulative key figures

Non-cumulative key figures are nothing but the key figure which will not be cumulative depending on some characteristic values. You will find these Non Cumulative KF's while you extract the data from MM data sources.

For example,you have a requirement of showing this month stock in the report. Means a key figure has not to be cumulated based on the char. While you create a KF, you will get the aggregation tab in the middle, there you have something called aggregation and summation aggregation. We put aggregation as summation and summation aggregation as last value. Once you select Non cumulative then it will ask for depending on what char this characteristic this KF has not to be cumulated.

Warehouse stock (non-cumulative key figure)

Stock 01.20 + stock 01.21 + stock 01.23 does not give the total stock for these three days.

Technically, non-cumulatives are stored using a marker for the current time (current non-cumulative) and the storage of non-cumulative changes, or inflows and outflows. The current, valid end non-cumulative (to 12.31.9999) is stored in the marker. You can determine the current non-cumulative at a particular point in time. You can do this from the current, end non-cumulative and the non-cumulative changes and/or the inflows and outflows.

Queries for the current non-cumulative can be answered very quickly, since the current non-cumulative is created as a directly accessible value. There is only one marker for each combination of characteristic values that is always updated when the non-cumulative InfoCube (InfoCube that includes the non-cumulative key figures) is compressed. So that access to queries is as quick as possible, compress the non-cumulative InfoCubes regularly

The important of marker update during compress

This is very important to compress the data correctly on the cubes that contain non-cumulative key figures, especially stock cubes. 

Test data

Case:

Material 000000000000036753

Plant BWF

PQ1 report (Expected result of WBP)

Initial stock from BX on WBP

Record mode = 1 (to display marker value)

It is correct with 2736 kg

Run query and we get -4826 because all movement record effect value of opening stock (same case if the cube compress with update marker)

You can see that the historical loading is not compress yet

Therefore, we need to compress historical data with mark “no marker update”

It will compress the data and will not change value of opening stock (Marker will not change)

Run query again