Full DTP and Delta DTP overwrite keyfigure

[Former Member]

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

[Former Member · Accepted solution]

Dear experts,

If full dtp record from dso to another dso and then tomorrow delta load run and load the same record? it will be overwrite?

[former_member586947 · Accepted solution]

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:

KEY	Value	Record Mode
KEY1	100	N (New image)
KEY1	-100	X (Before image)
KEy1	50	' ' (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.

[KodandaPani_KV · Accepted solution]

Hi,

if have any changed reocrds or modified records will get as the delta records.

if have changed the exsiting record next day it will pick as the delta.

cube always addtion proparty and dso always overwrite.

but dso have summation proparty, check the all key figure proparty.

Thanks,

Phani.

[Former Member]

So it mean, let say, today

dso1

car 5.00

cube1

car 5.00

tomorrow, delta loaded

dso1

car 4.00 --> overwrite from 5.00

cube1

car 4.00 --> cube loaded just figure -1.00 from dso1

is my theory correct?

[former_member183519]

Yes.. your theory is absolutely correct .

Difference between DSO vs CUBE - Contributor Corner - SCN Wiki (check given example)

Regards,

Hitesh

[Former Member]

thanks Hitesh

[former_member586947]

Hi,

   Consider the example that I have given above.

KEY	Value	Record Mode
KEY1	100	N (New image)
KEY1	-100	X (Before image)
KEY1	50	' ' (After Image)

Now if you are loading the data from this DSO2 to Info cube.

Deltainfo Package or Delta DTP pics up the data from Chnageloag table.

Here the no.of records loaded to cube differs based on the data flow but the final value is same.

If you use 3.x data flow ( through Info Package) then 2 records will go and sit in the infocube. (Before and after Imgae records). Initial load to cube will already have the first record (KEY1 --> 100). Delta brings two records.

Data in the infocube:

KEY	Value
KEY1	100
KEY1	-100
KEY1	50

If you use DTP: DTP has a property that duplicated records with same key will be aggregated while loading the data infocube. Hence, delta DTP updates one record to infocube KEY1 -50 (Summation of -100  and 50)

Data in the infocube:

KEY	Value
KEY1	100
KEY1	-50

But data wise there will not be any mismatch in both the cases. I mean you will report KEY1-->50 value finally in both the cases.

Regards,

Satya.

[Former Member]

can experts explain how record from dso updated in cube? I know cube use summation and not overwrite, but how record updated from dso to cube? it have calculation?

[former_member183519]

Hello

First time DSO

Account     SourceID      Balance

A1               1           10

First time Cube

Account     SourceID      Balance

A1               1           10

-------------------------------------------

Second time DSO record received:

Account     SourceID      Balance

A1               2          50

Active table of the DSO will have

Account     SourceID      Balance

A1               2           50

Change log in DSO will have

Account     SourceID      Balance

A1             1           +10
A1             2           -10
A1             2           +50

Finally, records in the cube

Account     SourceID      Balance

A1               1           10

A1               2           50

Regards,

Hitesh Gavande

[former_member586947]

Hi,

   Result mentioned in B will be the final result in the cube.

Regards,

Satya.

[RamanKorrapati]

Hi,

Cube will shows as two records like Result B.

At bex level, for CAR it may shows total sum as MYR 8.00.

Cube never over writes the data. Cube property is Summation only.

Thanks