cancel
Showing results for 
Search instead for 
Did you mean: 

About DSO Keyfigures

Former Member
0 Kudos

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.

Thanks

Rupa

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI,

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:

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:

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.

Tarak

Answers (2)

Answers (2)

ravikanth_indurthi
Active Contributor
0 Kudos
Former Member
0 Kudos

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.

Regards,

Sreenivas.

Former Member
0 Kudos

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.

Udo