Skip to Content

Value difference after transformation

Hello Experts,

I'm facing an stranger error between my two ODSs.

This is the first one (Write to optmization - I need to have unique registers here):

Then I do a simple transformation (without formules, abap routines, etc):

And this is my result in my second ODS (Standard type with aggregation characteristics):

Before you tell me there's another values aggregating here, this is a single record. I tried a DTP using only this register.

What my transformation are doing with these values (ZID_MONT and ZID_STOT)?

Hope you can help me.

Thanks,

FThomazetti

pastedImage_1.png (11.0 kB)
pastedImage_2.png (11.4 kB)
pastedImage_3.png (24.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 20, 2016 at 07:26 PM

    Hi Flavio,

    DSO1 is a Write Optimized DSO with a semantic key of ZIODOCREF and 0COMP_CODE, correct?

    DSO2 is a Standard DSO,correct?

    The key field(s) for DSO2 are also ZIODOCREF and 0COMP_CODE,


    ZID_MONT and ZID_STOT appear to be key figures - correct?


    If so, what are the update rules, SUM or Overwrite?


    My guess is that original designer wants to keep a store of all records received in DSO1 , but knew there could duplicated records from delta to delta, and wanted to filter them out - so DSO2 was created.

    However, for this to work, the rule for ZID_MONT and ZID_STOT must be set to OVERWRITE, not SUM.

    (This assumes, of course, that the last value received is always the most correct one)


    If this is the case, try setting the rule for ZID_MONT and ZID_STOT to OVERWRITE, not SUM.


    If not, please try to explain the purpose of having to two such similar DSOs in the same data flow.



    Please don't forget to record your final solution and to mark the question as answered.

    Good luck,

    John Hawk




    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2016 at 04:23 PM

    Hello,

    Can you send the changelog of second DSO regarding the document number and company code please ?

    It will help to analyze problem.

    Regards,

    Christian

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2016 at 04:44 PM

    Hi,

    Could be that the record already exists in the second DSO before your update?

    The change log will give you some answers.

    Regards from Mx.

    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.