2lis_11_VAITM Delta record processing

[Former Member]

Friends,

I am using 2LIS_11_VAITM to fill an ODS which further populates a cube.

I am struggling with what date to use when I update the cube. If I use the created on date, then if there is a change to the line in the future, it posts back on the original creation date. This means history gets restated. If I use the statistics update date (generally the date of the change), it moves the entire order quantity to this date, not just the changed amount.

Consider the example:

2/1 order is created for 10 pcs, Cube shows 10 pcs on 2/1.

2/5 change order quantity to 15 pieces.

Using the created on date, 2/1 now shows 15pcs.

Using the statistics date 2/1 now shows 0 and 2/5 shows 15pcs.

What we want is 10 on 2/1 and 5 on 2/5 for a total of 15.

My ODS has keys of document number and item number, do I need something else like STORNO in the key?

Any help is appreciated.

[Former Member · Accepted solution]

Hi Kevin,

As far as my knowledge goes

if your ODS is having this record

2/1,,10pcs

and you have updated this record to cube

2/1..10pcs

and later you had another record which is updated on 2/5...15 pcs

now your ODS will have only 2/5 ....15pcs becoz its having overwrite option

but when you update it to cube the ODS change log will send

2/5...+5 pcs

and in total for a Order u will have 15pcs but when you query it on date wise it will show as on 2/1 it will show 10pcs ...

becoz the ods will overwrite and cube addition and it will keep the history.

thanks

Neel