Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Full DTP and Delta DTP overwrite keyfigure

Dear expert,

Currently I need ask an expert a question regarding Full DTP and Delta DTP overwrite method. I have this scenario at my site. Currently I do full dtp at my XYZ infocube  from ABC dso. I do this because there something wrong at my cube record after its already loaded inside cube from dso. I didn't want to delete all record and loaded back due to huge volume of records. Therefore I do selection deletion from my cube and full dtp the selection record back from dso.

My question is, if tomorrow delta load run from info package and delta dtp to my ABC dso, then its dtp delta again the same record in my XYZ cube, do the delta dtp will overwrite my record figure in the XYZ cube? or it just add up the record?  If you see my example below, the end result will be Result A? or Result B? Can experts answer me. tq.

Result A:                                       

Today FULL DTP:

Car  MYR5.00

Tomorrow DELTA DTP:

Car MYR3.00

End Result at XYZ cube:

Car MYR3.00

Result B:

Today FULL DTP

Car MYR5.00

Tomorrow DELTA DTP:

Car MYR3.00

End Result at XYZ cube:

Car MYR8.00

replied

Hi,

   It depends on the keyfigure property set in the transformation from DSO1 to DSO2.

If Keyfigure is set to Overwrite then record will over write the values.

If keyfigure is set to summation then record values get added in the DSO.

Considering overwrite option:

If you run full today and you load delta one next day, doesn't impact the record values mismatch from DSO1 to DSO2 if the keyfigures are set to overwrite. In this case only after image records will be sent to the DSO2 from DSO1.

Ex: DSO1 has the data like below

06.10.2015--> Key1 100

Now you have loaded a full DTP from DSO1 to DSO2 then DSO2 has the record as below

06.01.2015 -->KEY1 100

Now the record values changed in the source and you have got the changes to your DSO1.

Active Table of DSO1:

06.01.2015 --> KEY1 50


Chnagelog table of DSO1:


KEYValueRecord Mode
KEY1100N (New image)
KEY1-100X (Before image)
KEy150' ' (After Image)

Delta DTP picks up the data from change log where as the full DTP pics up the data from Active table of DSO.

1. Now if you run delta load from DSO1 to DSO2 then only After image record will be sent to the DSO2. Means record with value 50.

So you DSO2 has the record as below

KEY1 50 ( 100 will be overwritten with 50)

2. If you run full load from DSO1 to DSO2 then record with value 50 is selected from DSO1 and will be loaded/inserted to DSO2.

KEY1 50 ( 100 will be overwritten with 50)

In full and delta, you will not get any issue if the key figure is set to overwrite. If the keyfigures are set to summation then while loading full data from DSO1 to DSO2, you need to delete the records from DSO2 and then you have to do a full load.

pls check the below link:

http://scn.sap.com/docs/DOC-54330

Regards,
Satya.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question