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

Flat File- ODS Delta

Hello there,

I just got involved in BW. My question lies in the realm of using ODS & Flatfile for Delta.

Assuming an ODS is set to overwrite mode & Flatfile DataSource only knows new status of a change. Now, new & changed records are coming in from the flatfile. Will new record be saved or only changed records can be updated?

I see update mode for flatfile in the Datasource/Trans Structure tab having Full/FIL0/FIL1 modes. Is Delta Process always set here, eg. FIL0 = After images, even for other Extractions like LO / CO-PA ?

Does Delta Process = Update Method = Update Mode? I am just getting familiar with the new keywords.

  • Additive Delta *

If I set the update mode for flatfile to 'Additive delta', its said that BW would be expecting either 1 record containing the difference (additive image) or 2 records containing 'after' & 'reverse' images. I am not sure why this can be done given that after image = ODS in overwrite mode whereas reverse image = ODS in delete mode. How can the modes change during upload? I suspect this a typo error in BW340.

regards,

Ernesta

Message was edited by: Ernesta

Message was edited by: Ernesta

Message was edited by: Ernesta

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2005 at 07:01 AM

    Hi Ernesta,

    in overwrite mode the system checks the key of the ods and updates all fields with the new incoming values. If the 'key' does not exist, the record will be inserted.

    If you set your update mode to additive (basically you can only do this for the keyfigures) the value of your keyfigure will be summed up. In case your datasource is providing a additive delta you will receive a before image (the original record with all keyfigures reversed) and a after image with the new combination of characteristics and keyfigures. For some datasources you can also receive a delta that just contains the difference for the keyfigure (some positive number if the value raised in your SourceSystem and a negative number if the number increased in your SourceSystem).

    Hope this helps a bit.

    If you have more questions let us know.

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Siggi,

      Thanks for your wonderful explanations.

      I would like to confirm:

      Its not possible, in 1 upload process, to perform after and reverse images at the same time because the ODS needs to be set to delete mode via Update rules.

      Delta Method / Delta Type for FlatFile is manually set in Update Mode field found in DS/Transfer Structure tab whereas the same is determined by the Datasource / Extract structure / Extractor found in R/3?

      Could you explain what is meant by " 'non-summable' fields are added for 'summable' fields" in the case of ODS Update?

      Have a nice day.

      Ernesta

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.