Regarding Inventory Movements Data in InfoCube
Just a tricky question. Is anyone aware of the reason so as to why do we do Compression in the Inventory Material Movements InfoCube "0IC_C03" in my case it is BC Enhanced as ZIC_C03.
Apart from the technical reasons for the Compression.
Hope some one has the exact answer I want to know.
Praveen Kumar Jaggasa replied
An infocube containing non-cumulative KF is called non-cumulative cube. Compression of this cube updates the marker, which is actually a reference point and is considered as the starting point while calculating the value of non-cumulative key figures at query execution time.
When you include a non-cumulative KF in the cube, the inflow and outflow cumulative key figures associated with it will automatically be included e.g. in the cube 0IC_C03, 0VALSTCKVAL is the non cumulative KF while 0RECVS_VAL and 0ISSVS_VAL are the inflow and outflow kfs respectively. In the update rule, you actually update these two cumulative key figires and also your fact table will store values for these KFs.
Hence when you upload data into the cube, data is stored in the two cumulative key figures. If you run transaction LISTCUBE and see the contents of cube, there also you will find values for these two KFs and not for the non-cumulative KF.
Value of the non-cumulative KF is calculated at the query run time in OLAP engine. For calclulating it takes into account the marker, inflow and outflow KFs. You would be able to see the value of non-cumulative KF in the query output.
When you compress the cube with marker update, all the data till that point is stored physically. Suppose you plan to update marker monthly, then you compress the cube once a month. After the compression, marker is updated with latest data and all the new movements will be stored in inflow and outflow KFs.
Hope it helps.