Skip to Content
author's profile photo Former Member
Former Member

DSO in Inventory Management in BI 7.0

Hi Folks,

I have a question, and need your advice.

We are implementing Inventory Management in BI 7.0, and there is a SAP How-to guide 'How to Handle Inventory Management Scenarios in BW', it has a comment 'Don't update InfoCube 0IC_C03 from an ODS layer'.

Here are some technical details, the cube is 0IC_C03, and there are three extractors, 2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM. SAP recommends load the cube from DataSource/InfoSource directly without DSOs in the middle.

I am wondering if anyone has experience of having DSOs between the DataSources and the cube (listed above). What would be the issues? and what are the solutions/workaround to fix the issues?

Any advice/opinion would be appreciated!

Thanks and have a good day!

Freda

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 01:35 PM

    Hi,

    The cube uses non cumulative KFs and using DSOs you can't use non cumulative KFs for reporting. The non cumulative KFs work on the concept of inflow and outflow. If you look at the transformations you'll see that these values are calculated on the fly based on movement types and process keys directly in the cube.

    This concept can't be utilized when updating directly from DSO to the cube.

    If you want to utilize the DSO concept then its advisible to go with the second scenario in the how paper by using cumulative KFs and then creating a separate cube that can be updated from this DSO.

    Even if you feed the DSO from the datasources for Inventory, that reporting would work great from just movement type report listing, but wherever stocks are involved, its going to fail. All the stock values are coming from the MARD table and even if you enhance the datasource with these fields, the deltas don't work and you end up getting duplicate values. So all your stock reports will fail.

    Cheers,

    Kedar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 01:40 PM

    We are using DSO as a EDW layer in between 0IC_C03 and BF data source and UM data source. We used the keys of an DSO based on following note... 417703 for BF and following keys for UM BUKRS, BELNR, GJAHR, BUZEI. At this point my data in the cube looks good.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 18, 2008 at 01:41 PM

    Hi,

    Generally its loaded directly into Cube.

    There is an SAP note on this topic. Check that out.

    SAP Note 581778: ODS capability of extractors from Inventory Management

    Also see see notes 322303, 385703 and 323811.

    Hope this helps.

    Thanks,

    JituK

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.