Inventory Cube

[Former Member]

Dear All,

I request some clarification. We have an inventory cube that was getting loaded everyday from BF and UM. BX was done initially. So at the PSA level we have data of BF and UM from the day we started loading the cube till present day. But when we update the delta everyday for BF and UM the cube di not use marker update and it has been 6 months of everyday load. We are going to discard this cube shortly.

Now we are making a new inventory cube which gets updated using the same BX,BF,UM datasources.

This time , we already have PSA in BI for BF and UM. We plan to do a full BX pull first. Push that into the new cube. then,

Although I am aware, for the first time, when we do BF and UM, we do an init without data transfer at the datasource and then a full load and DTP to cube without marker update. Successive delta should have marker update.

1. Will this BX pull bring in history till present date?

2. Since I have PSAs for BF and UM updated already in BW on a daily basis, after the BX, how do I proceed?

A. Do I perform a DTP init without data transfer at the cube level for BF and UM. Then do a full update DTP without marker update. After that follow it up by successive deltas with marker update?

Regards,

Jack Silverz

[maxilopez]

Hi Jack,

Broadly speaking, the steps to initialize stocks InfoCube include:

1) Loading data from 2LIS_03_BX into the InfoCube, after running MCNB transaction in R/3.

2) Compressing the request with marker update (The checkbox "No marker update" should not be set).

3) Loading data historic data from 2LIS_03_BF and 2LIS_03_UM.

4) Compressing the request without marker update (The checkbox "No marker update" should be set).

5) From then on, deltas from 2LIS_03_BF and 2LIS_03_UM can be loaded. If you want to compress them, you should not set the aforementioned checkbox.

You can find the detailed procedure at:

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e...

Regarding your particular questions, MCNB transaction is used in R/3 to prepare balance figures to present date for extraction through 2LIS_03_BX DataSource.

Take into account that the historical movements from BF and UM should be compressed without marker update, whereas subsequent deltas can be optionally compressed with marker update. In order to avoid errors, you should analyze the possibility of emptying PSA tables and start deltas again.

I hope this helps you.

Regards,

-

Maximiliano