Skip to Content

Doubt on Delta mechanism

Hi

I'm loading data in this manner.

DSO1 -> CUBE -> DSO2

Data in DSO1 is correct and data in CUBE is also correct. While moving the data from CUBE to DSO2, the delta mechanism is not working fine. Especially the first initial load which contains both New Image, Before Image and After Image. As we don't have RECORDMODE in cube, the DSO2 is not able to pick the After Image and randomly picks anyone of the 3 records and considers it as the latest record.

Suppose changelog of DSO1 contains below records:

MATERIAL QTY RECORDMODE

S1 10 N

S1 -10 X

MAT001 10 ' '

The records in DSO2 should show MAT001 but it doesn't pick that. But the data in cube is fine.

Now, my doubt is, if I map 0RECORDMODE from DSO1 to CUBE to DSO2, will it work?

Regards

Murthy

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2012 at 10:34 PM

    You can't have recordmode in cube. It will generate new record for each record mode. If you have issues in delta, i'd recommend to pull from base DSO instead cube. You may have to rewrite some routines from DSO1 to cube .....to DSO1 to DSO2....Delta from cube is just based on request and not based on change log (coz there ain't any)....

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 08, 2012 at 05:18 AM

    Hi Murthy,

    If you have MATERIAL as the key field in DSO2, and change the Transformation between the Cube and DSO2 to Addition instead of Overwrite, you'd see same data in the cube and DSO2.

    Thanks,

    Ranga.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 10, 2012 at 04:33 PM

    Hi,

    To be precise about delta mechanism--In case of DSO if you are loading data from dso to dso or dso to cube it takes it from change log table based on 0RECORDMODE

    In case of cube---If you are loading data from cube to dso or cube to cube the delta works based on request ID.

    Cube doesnt have 0RECORDMODE concept its only dsos property.

    Refer the below thread as well.

    http://scn.sap.com/thread/2106940

    Hope that helps.

    Regards,

    AL

    Message was edited by: Anshu Lilhori

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      The data will be populated correct if you add material in the Key field of DSO2 .

      Also , as suggested previously , instead of having the cube in between , you can link DSO1 to DSO2 directly .

  • Posted on Nov 08, 2012 at 11:59 PM

    Since this is a question about BW, it belongs in the BW space (called SAP Netweaver Business Warehouse) and not the Data Warehousing space. I've moved the thread, but please use this space for these types of questions in the future.

    Regards,

    Ethan

    (moderator)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2012 at 11:53 AM

    hii ..i think itz possible only when u change the rule type for keyfigures in transformation for dso2

    make itz overwritten to addition..then u may get correct records whatever have been loaded data in infocube

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 12, 2012 at 05:53 AM

    Hi All

    Thanks for your valuable inputs.

    After going through lot of posts and inputs, I have planned to exclude the cube and directly map DSO1 to DSO2.

    Let me explain you why I had to use cube in between.

    I'm loading the Order data from DSO1 to DSO2. Now I had to load Quote data as well so instead of using DSO1 to DSO2, I used DSO1 to CUBE to DSO2. As this isn't working, I will be using DSO1 to DSO2 with the help of rule groups.

    As this will be the first time I will be working with rule groups, any good inputs and precautions would be really helpful.

    Regards

    Murthy

    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.