Problem in before initialization stock value in 2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM

[former_member214878]

Hello Everyone,

Please have a look on below scenario with attached image - I am facing an issue in getting the correct stock value "Before initialization day".

1. I did initialization on 01.03.2015.

2. I have taken postings data from from 01.01.2015 - 31.12.2099 while filling up setup tables.

3. Now in my CUBE I have the stock from 01.01.2015 - 31.12.2099.

PROBLEM - In my query I am getting correct stock data if I see from 01.03.2015 (From the day of initialization), however I am not getting correct stock value before 01.03.2015 (Before initialization date).

I am not sure what is missing or what is going wrong in OLAP that I am getting big difference in stock before the initialization day.

Could you please give me any hint to resolve or at least understand the problem area?

Regards,

Rudra

Message was edited by: Rudra Sonar

[former_member214878 · Accepted solution]

I did resolve it by myself thanks for the replies

[anshu_lilhori · Accepted solution]

It would be nice if you can also share the way and technique of resolving the same with the community.

I believe majority of members will be benefited out of it.

Regards,

AL

[Former Member · Accepted solution]

Hi Rudra,

Can you tell me how did you resolve your issue.

I am getting total stock values and quantites from 2LIS_03_BX. But not from 2LIS_03_BF.

I am using the installed content.

Do i need to change any mapping or code to populate keyfigures from 2LIS_03_BF.

Thanks,

Vinod

[former_member214878 · Accepted solution]

Hi Vinod,

I have been struggling really hard the get the right values in reports. Finally after lot of RnD and trial and error basis I did manage to get it through.

I can give some heads up for you. Try it out it worked for me for sure.

1) First deeply go-through the "How-To" paper from SAP about stock. Go through each and every line carefully and understand it clearly - You need to focus on below points majorly.

          a) COMPRESSION

          b) How Marker works

          c) What is History data and usual delta in a data flow.

          d) "Process key" and how it is related to stock amendments in case of non-cumulative KFs'.

Click here to get the How-To paper from SAP. (FYI . Its quite old (2004) but helps in a great way)

2) If you have an additional layer (DSO Layer) between your CUBE and DATA_SOURCES, it saves your initialization and massive time in Trial and error method. If you do not have this layer that's okay, then you will have to load your CUBE from PSA everytime.

          a) You can clean your CUBE anytime u want and load it from intermediate DSO layer.

          b) It holds your Data Request forever for future references as well. (PSA can also give you thisfacility but  I kinda like this way)

3) Now the important steps for you to load the data in a CUBE -

          a) Go to page number 15 from the "How-To" PDF and see how the data load has been suggested from SAP Side.

          b) The request in which the opening stock was loaded must always be compressed with a marker update

          c) The request in which the historical material documents were contained must always be compressed without a marker update and

          d) Successive delta uploads must always be compressed with marker updates.

4) If you correctly follow the above compression settings while a data load in a CUBE, you get the right values in reporting level. I am emphasizing on these settings because in my case I was really very ignorant to these detailed explained steps. 

Note: I believe you have already gone through the need of the start/end routine in BF/UM/BX. If not please have a exact same implementation like what PDF suggests. Go from the page number 21 (Section 3.3.2 Process overview).

I believe it will work. Cuz it worked for me recently.

Cheers !!

Regards,

Rudra

[former_member1248897 · Accepted solution]

Could you please let us know what the Issue was, we had similar Issue ..

Regards,

RC

[former_member214878]

This message was moderated.

[sander_vanwilligen]

HI Rudra,

Please have a look at the document and make sure to follow this procedure carefully.

The principle is to initialize inventory on date x. After that the marker should be updated. All historical goods movements (i.e. before date x) should not update the marker.

Best regards,

Sander

[former_member214878]

Bringing up to notice...

Anyone had same issue ? or anyone can give me any idea of what must went wrong?

Regards,

Rudra

[former_member71289]

Hi Rudra,

most likely the following SAP Note can help: 1548125 - Interesting Facts about Inventory Cubes

That's a very good note with lot of information and examples how the OLAP actually handles and calculates non cumulative key figures especially in the inventory management scenario.

Generally remark: It depends if you use HANA optimized Inventory Cube or not.

In a not HANA optimized Inventory Cube maybe you have skipped the step to run the compression with "No marker update" after loading the historical movements OR

in a HANA optimized Inventory Cube maybe you have not executed the DTP with the flag "Historical Transactions".

In any case I would check the SAP Note and the referenced How To Guides.

Best regards and have a great weekend,

Andreas