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

Situation: We initial data in WBP from PF1 datasource and reload historical data without compress. Then, comparing with PQ1 data before decommissioning PQ1. 

Case: 

Material 000000000000036753

Plant BWF

PQ1 report (Expected result of WBP)

Initial stock from BX on WBP

Record mode = 1 (to display marker value),  the calday will be 31.12.9999 (no time for non-cumulative key figure)

It is correct with 2736 kg in PQ1 (latest value comparing to the example above, it must be value in 09.2017)

Run query in WBP and we get -4826 because all movement record effect value of opening stock (same case if the cube compress with update marker because default of loading is 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 after compress with "No Marker Update", data will be corrected.