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

Procedures for implementing a snapshot scenario with custom DataSources

Hi Gurus,

I have checked the How To paper ([How to Handle Inventory Management Scenarios in BW (NW2004)|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e328]). However, only SAP standard BW objects are mentioned in the paper e.g. InfoCube (0IC_C03), Material Stock InfoSource (2LIS_03_BX), Material movements IS (2LIS_03_BF) and Revaluations IS (0LIS_03_UM).

On the contrary, I need to handle custom DataSources for the Snapshot scenario. Are there any differences in the implementation methodology? Which additional aspects should I take into consideration? For example, the load sequence, delta type, etc.

Could you please list out the step-by-step procedures for such an implementation?

Thanks in advance!

Regards,

Meng

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2011 at 03:09 PM

    Hi Meng,

    Which custom data source ( based on which R/3 table ) would you like to create for implementing snapshot inventory scenario?

    It is highly recommended to use the standard extractors for reporting inventory, as this covers all the business scenarios, which might get missed out in your custom extractor.

    Towards the end of the document, you could see a section which explains implementing snapshot scenario on top of this standard flow.

    Please let me know, if you need more details.

    Thanks,

    Krishnan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2011 at 08:16 AM

    Hi,

    Why do you want to use a custom DS for IM?? What are the req which even enahncing the std DS would suffice your requirements.

    Its highly unlikely to use custom data dources for Implementing inventory logic, the complex logic involved makes it hard to maintain and support a custom DS.

    Enhance DS to include any addition fields.

    On the BW side however, you can customize evrything from Cubes to DSO to Transformation to InfoPackage.

    The methodology of loading the data remains the same even if you dnt use std Business custom on the BW side.

    Reg,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Meng,

      Since, you have due date in your scenario, the balance should not include any amount which is not due.

      I am suggesting following simple approach in your case.

      Your source data is shown below

      Employee Due date Credit Debit

      E1 01.06.2011 100 20

      E1 01.07.2011 00 50

      E1 01.08.2011 30 00

      The intermediate DSO data has to be transformed as shown below.

      Employee Calmonth Balance

      E1 06.2011 80

      E1 07.2011 -50

      E1 08.2011 30

      In the above transformation Calmonth is derived from due date and balance is calculated as ( Credit - Debit ) in addition mode.

      The load to this DSO can be delta.

      Now, while loading from the DSO to cube, if you are loading the balance for 06.2011, then you have to load all data where calmonth is less than or equal to 06.2011, similarly the balance for 07.2011 would be data where calmonth is less than equal to 07.2011.

      The load from DSO to Cube will be full uload.

      The cube data after each month snapshot will look as shown below.

      Employee Calmonth Balance

      E1 06.2011 80

      E1 07.2011 30

      E1 08.2011 60

      The user should be given a mandatory single variable in calmonth on the report, that is created on the cube.

      Hope this explains.

      Thanks,

      Krishnan.

      Edited by: Krishnan Rajamani on Jul 21, 2011 11:25 PM

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.