Regarding Inventory Movements Data in InfoCube

[Former Member]

Hi All,

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.

Thanks,

Pradip Parmar.

[Former Member · Accepted solution]

Hi,

Normally we do compression of cube to increase the performance. But at the same time there is one more reason to do compression incase of NON Cumulative Cubes.

Compression updates the Non Cumulative values(Stock..etc)at the time of Compression.

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

Hi Anil,

Can you please explain the same in a bit more detail ?

Non-Cumulative Cube: I am not aware of the same, Any specific properties which can be mentioned explicitly for the same.

And could you please explain a bit more about what does the updation of the Non Cumulative Values (Stock ... etc) mean at the time of Compression.

Thanks in Advance.

Pradip Parmar.

[Former Member · Accepted solution]

Hello Pradeep,

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.

Regards,

praveen

[Former Member · Accepted solution]

Hi Praveen,

Thanks a lot for the response. It was really very helpful.

Now I am getting the hint and idea so as to why was this being done to the Inventory Material Movements InfoCube. As it had Non-Cumulative Fields.

Thanks a lot.

Pradip Parmar

[Former Member]

Hi Pradip,

Go through the below document, it is explaining every thing.

<b>How to... Handle inventory management scenarios in SAP BW 3.x (pdf)</b>

https://websmp107.sap-ag.de/~sapidb/011000358700002121282004

Hope it Helps

Srini