Need Help in Inventory Exercise -

[#1]

Dear All,

I need your help to resolve the issue in Inventory Cube Exercise. I have searched the entire blog for similar problem but i didn't get any solution.

Here is the Problem.

Due to the marker problem the entire data in cube was corrupted, We have removed entire data in Cube. And we have taken the downtime and performed all necessary steps in R/3. The same was loaded to BW.

2lis_03_BX --> Loaded to BW (Initialization Stock, and one time job), But the request was Not Compressed.

2lis_03_BF--> initialize the delta without data transfer - Here i have only 1 record (initialized record) -- Request not compressed

2lis_03_UM--> Initialize the delta without data transfer - Here i have only 1 record (initialized record) -- Request not compressed

After Initialization, daily delta loads are running and those are fine. i am able to see the data in cube.

=>> After this i have loaded historical data from 2007 to 2010. (UM & BF) (each year One Request- Total 8 request for both).

NOW

1. i have Initialize Stock request in infocube for 2lis_03_BX

2. i have Initialization request, delta requests and historical data requests in infocube for 2lis_03_BF

3. i have Initialization request, delta requests and historical data requests in infocube for 2lis_03_UM

Here is the Big task for Me. Since Two months the delta loads are running. Now i need to do compression on this cube.

Please do remember, till now there is no compression (not even initial requests or no single requests) happened in this cube. Now i have to perform this task immedly.

• No requests are compression in the ZINV_C03_C (inventory cube) till now. ****

I need to perform immdly, because i have downtime fror three days from 28 dec to 30th Dec due to plant closing.

Please guide me to do this exercise.

Thanks in Advance

Venkat.

[maxilopez]

Hi Venkat,

Broadly speaking, the steps to initialize stocks InfoCube include:

1) Loading data from 2LIS_03_BX into the InfoCube.

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...

Take into account that if the InfoCube is already loaded and only compression is missing, you do not have to reload it. You can compress in different steps by selecting the corresponding requests ids and setting the checkbox "No marker update" as needed.

I hope this helps you.

Regards,

-

Maximiliano

Edited by: Maximiliano Ariel López on Dec 18, 2010 2:51 PM