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

About DSO Keyfigures

Dear All,

As we have two options in tranformations for keyfigures in DSO

1. Overwrite and 2. Summation.

Could any one explain me when to go for which, examples will be very helpful. mainly i would like to know about summation.



Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2008 at 09:43 AM


    For DataStore Objects:

    Depending on the type of data and the DataSource, you have the options Summation, Minimum, Maximum or Overwrite. When you choose one of these options, new values are updated to the DataStore object.

    For numerical data fields, the system uses characteristic 0RECORDMODE to propose an update type. If only the after-image is delivered, the system proposes Overwrite. However, it may be useful to change this: For example, the counter data field u201C# Changesu201D is filled with a constant 1, but still has to be updated (using addition), even though an after-image only is delivered.

    The characteristic 0RECORDMODE is used to pass DataSource indicators (from SAP systems) to the update.

    If you are not loading delta requests to the DataStore object, or are only loading from file DataSources, you do not need the characteristic 0RECORDMODE.


    Summation is possible if the DataSource is enabled for an additive delta. Summation is not supported for data types CHAR, DAT, TIMS, CUKY or UNIT.


    Overwrite is possible if the DataSource is delta enabled.

    When the system updates data, it does so in the chronological order of the data packages and requests. It is your responsibility to ensure the logical order of the update. This means, for example, that orders must be requested before deliveries, otherwise incorrect results may be produced when you overwrite the data. When you update, requests have to be serialized.


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2008 at 10:12 AM

    Hi Rupa,

    check this link:

    hope this helps..........



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rupa,

      Let us discuss the difference between overwrite and summation with simple example.

      1. There is purchasing contract released in R/3 system which is extracted into BW system. The record has following values.

      Contract no: C1, Award value: 100 Dollar.

      If you update this record into ODS with overwrite as option. You will have Contract no: C1 and value : 100 dollar in the active data table. Let us say this contract is modifed into R/3 system like as shown below

      Contract no: C1 and Award value : 200 Dollar.

      With the overwrite option the previous record is replaced with this record in Active Data table.

      For the same example if you select summation as the option, the active data table will have record as show below.

      Contract no:C1, Award value: 300 Dollar.

      Which is not correct when we compare the data with R/3 data.

      For example Summation option can be used when we want to total the released values against a contract..

      Hope this information helps in understanding the difference between overwrite and summation.



  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2008 at 09:39 AM

    Hi Rupa,

    As you know each record in an ODS has an unique key.

    Sometimes you want to aggregate in an ODS like when you want to report about sales.

    Now you have all the sales records, but you only want to report total sales amount per cutomer an the average salesprice per item he buys.

    You use summation in the ODS for sales price and number of items. Then in your report you can divide total sales price by number of items to calculate the average salesprice per item.

    So you go for replace if your system has the pssibility to load data twice. (e.g. flat file load.) If you load the same record twice in a cube new records will be added and you report result will be wrong. In an ODS the values will be overwritten, so no problem.

    An other example is when you have intermediate results (e.g. numbers of subscriptions during the day). You receive the same records with a new value every 10 minutes. the old result will be overwritten with a new result.

    The ODS will make a record with the difference for example to load to a cube.

    Don't hesitate to ask more if you want to.


    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.