cancel
Showing results for 
Search instead for 
Did you mean: 

New, Before After Image Delta question

Former Member
0 Kudos

Hi All,

OUr consultant has rolled off and we are looking at the functionality of a delta extractor (ABR).

Everything looks good, we just don't understand the New Image.

Basically here is the scenerio. This will be based off 1 order and just 1 key figure field (qty)

Order is initially created and sent over to BW. This first time there is a new record sent over. After this before and after images are sent. Everything is working fine and we can see when changes happen the delta from the ODS to cube reads the change log and essentially past records zero out and latest after image is displayed in query output.

Our question is:

The first time a record comes over it has New image. After this it never does. Which we understand works great, but how does the extractor know it already sent a New Image? After this first initial time it only sends before and after. If days, weeks go by and then a second change to the order happens, how does the system know not to send a New image?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

former_member185132
Active Contributor
0 Kudos

CM,

I assume you are extracting from SAP. Generally SAP tables store the creation date/time and last change date/time. Based on this the extractor could be figuring out whether the record has been sent to BW earlier or not.

For instance, if the creation date is between the last delta date and the current date, it means the record has never been sent to BW, in which case the new image would be sent. But if the creation date is older than the last delta date, and the change date is between the last delta date and current date, the system knows that the new image would have been send under the previous delta, which means it needs to send the before and after images.

Regards,

Suhas

Former Member
0 Kudos

Hi All,

thanks for the replies. Makes complete sense now.

Answers (2)

Answers (2)

former_member208595
Active Participant
0 Kudos

Hi,

1.you are having 1order & 1quantity.

ex- order= 1000 quantity =10

first time it will come as new image. After that you changed quantity to 20. in DSO change log table you will have three records now.

order quantity

1000 (N) 10

1000 20 - After image

1000 10(-) - Before image

From DSO when you will load to Infocube, as infocube is additive, order= 1000 quantity= 20 will store.

2. When you are loading another order you will get New image.

3. Datasource delta type is ABR means-

Above example is After & Before image.

You loaded data to BW system, after that you deleted the record in R/3 system , now to reflect the deletion mark id in BW system Reverse image need.

Deletion mark id will be store in 0ROCANCEL field of datasource & in BW corresponding field will be 0RECORDMODE.

You can refer SDN Blogs also.

mansi_dandavate
Active Contributor
0 Kudos

Hi,

Whenever you create any new order, the extractor knows it is being sent to BI for the first time, so it sends a new image..

But when you change an existing order, it knows that it already exists in BI and it needs to send Before and after image.