Skip to Content
avatar image
Former Member

Loading 0ic_c03 for the first time

Hello,

we have BI 7.0 installed and we are trying to load data into 0IC_C03 cube using 2lis_03_BX, 2lis_03_BX and 2lis_03_UM data sources. Iin our r/3 system, we have data from 1997. I loaded data into the cube from these data sources. But, the issue is that the quantity (Valuated Stock Qty) is showing negitive for most of the past months in the BW report. These should not be negative and I don't know why.

These are the steps that I took for loading:

locked the r/3 system from users

created "Opening Stocks" using the transaction MCNB (BX).

Executed OLI1BW (material movements) for the period of 1/1/2006--> 10/3/2008. (BF)

Executed OLIZBW (Revaluation) for the period of 1/1/2006--> 10/3/2008 (UM)

Loaded data into BW for BX and compressed the data in 0IC_C03 without marker update.

Loaded data for BF and compressed the data in 0IC_C03 with marker update.

Loaded data for UM and compressed the data in 0IC_C03 with marker update.

Then, I ran a query and looked at the Valuated stock qty and they are showing up as negative for all the numbers in the past... Some are 0's.

One thing I noticed after loading BW with BX data, the date field in the cube had the day of the Openinig stock for the all the records (10/2/2008). Should they all have the same dates in the cube?

Any help will be appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 03, 2008 at 10:17 AM

    Hi sam,

    I think you've got the marker update option wrong.

    This is what you wrote:

    Loaded data into BW for BX and compressed the data in 0IC_C03 without marker update. This request should be compressed with marker update as it carries the opening stock balance.

    Loaded data for BF and compressed the data in 0IC_C03 with marker update. This should be compressed without marker update as this carries all the historical material movement. I'm assuming that this request is for historical data

    Loaded data for UM and compressed the data in 0IC_C03 with marker update. This should be compressed without marker update as this carries all the historical revaluation date. I'm assuming that this request is for historical data

    After these three steps are done, perform the normal delta load. And delta load should be compressed with marker update (don't check "no marker update") only if you would like to compress the infocube. Else you can leave them uncompressed.

    Remember, the first three initial requests (BX, BF and UM) must be compressed with the correct marker update option.

    This SAP doc is pretty helpful:

    http://help.sap.com/bp_biv270/documentation/HowToInventoryNW.pdf

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I am very sorry... I did compress BX (with marker update); BF and UM (without marker update). I just typed them wrong in the above message.

      I still have the issue of numbers being negative.

  • avatar image
    Former Member
    Oct 03, 2008 at 06:11 AM

    Hi Sam,

    It is problem with BX datadata and Marker Update.

    After BX data loading and compression cube should contain records with latest date(today or future). and also record type(available in datapaket dimension) should be 1. For Zero no records should be available.

    After loading BF and UM, and no marker update we should get records record type Zero.

    Even i faced the same problem. I think some thing related to support pack level.

    I solved this problem by not loading BX data. As we are loading all moments, we no need to load BX data.

    Just setup, BF and UM and loading into BW, and Compress with Marker update. Your stock matches with R/3(TCode: MC.1 or MB5b....ect).

    Hope it Helps

    Srini

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Gurus,

      We have implemented BI 7.0 with the latest support package as of 1st May 2011. Issues are coming relavent to 0IC_C03 infocube for inventory control. I have followed the how to guideline but issues are there.

      I have done all the steps in the how to do note but issues persist. If i were to just follow the 2LIS_3_BF & 2LIS_3_UM Scenario and not follow 2LIS_3_BX, do i have to make some changes in the transformations and infosources for the Infocube 0IC_C03.

      Kindly Give me a feedback even though this question is answered.

      regards,

      Shahzad