ODS Delta Examples

[sap_cohort]

Hi, can someone point me to some decent documentation examples of how the ods delta process works with the before image and after image record mode indicators? I remember this in older documentation but I can seem to find it now.

Note: I have a record in my ODS that is showing no confirmed quantity and I believe it should show 1. and I have 2 records in the change log. one with a before image "" and an 'X' after image.

The ODS data shows my order qty as 1 and the confirmed qty as 0. it should be 1 and 1.

The "before image" shows the order qtys as negative and the confirmed qty as a postive 1.

The "After image" shows the order qtys as postive and the confirmed qty as 0.

Can you also explain if this scenario sounds right?

Thanks!

[sap_cohort]

Will revisit at a later time

[chemicala_srimallikarjuna]

Hi,

Lets assume you have a record into ODS like

0CALDAY SRPID PQTY SALES PROFIT

20060607 S001 10 1000 100

Now this will be marked as N. Now modify your flat file like this and load again into the ODS,

20060607 S001 15 1500 150

now 2 images will be created for the entry, it is identified by the Key Fields 0CALDAY & SRPID being same. The entries in the ODS looks like this

20060607 S001 10 1000 100 "N"

20060607 S001 15 1500 150 " "

20060607 S001 -10 -1000 -100 "X"

it means, the old record "N" has been overwritten as " " (After Image) and the "X" is the Before Image with - sign.

If u load this data to the InfoCube u can see

20060607 S001 10 1000 100

20060607 S001 5 500 50

This records are splitted up on analysing the 0RECORDMODE from the CHANGE LOG table of the ODS.

N - when a new record comes in.

- when a modified record comes in (After image)

X - the record which was marked N will he here with sigh in the front.

D - deletion mark, not sure abt the details

R - when a Reverse image comes

Pls Chk this link:

https://www.sdn.sap.com:443/irj/sdn/thread?threadid=158433&messageid=1777393

Regards

CSM Reddy

[sap_cohort]

Hello,

1. Can you explain why some of the key figures in the before image are not negative like you mention?

2. Also, I notice that the transformation rules into my key figures are cumulative. is this right?

I'm guessing it is since the LIS extractor uses the ADD method?

Thanks! This is very puzzling.

Also,

[Former Member]

Hi,

After image is simply a new record after the delta upload. First of all, request is activated, the data record with quantity X is posted into the active table and the change log. Afterwards, the data for the second request is activated. The new data record then overwrites the existent one. The changes are represented by before and after images in a new change log request. The before image represents the original status of the data record, the key figures have reversed signs however. The after image shows the new status.

You can check following links for more details.

http://help.sap.com/saphelp_erp2004/helpdata/en/84/81eb588fc211d4b2c90050da4c74dc/frameset.htm

http://help.sap.com/saphelp_erp2004/helpdata/en/57/b9d43d89e6b34aa2c6fa9fe2ab243f/frameset.htm.

hope this helps you ..

Regards ,

Shikha

[Former Member]

Read this Blog:

Thanks..

Shambhu