Delta for generic datasource

[charla_robertson]

Hi all,

I created a generic datasource against the VBFA table. The delta uses the date on which the record was created.

I ran the delta this morning and it picked up records. After the delta this morning, we then created a sales document with all the subsequent documents. Now when I run the delta for my datasource, the delta gets 0 records.

Alot of the posts I'm reading in the forums here say that if a generic datasource is run once, and the delta is based on created date, any new deltas that come in after that run will only be picked up the next day.

Would that be the case in my situation? If I run my delta tomorrow, should it pick up the deltas that I created today?

Thanks

Charla

[mr_v · Accepted solution]

Try with Upper Limit = blank and Lower Limit =1 in Generic delta (RSO2)

[charla_robertson · Accepted solution]

Can you explain what that does? Currently I have no limits set in RSO2.

Thanks

[dennis_scoville4 · Accepted solution]

This creates a safety interval whereby the generic delta will pull anything that has a create date of today or yesterday.

Alternatively, you can change this generic DataSource and delta by doing the delta on both the create date (VBFA-ERDAT) and (VBFA-AEDAT). This change would require that the DataSource be built off of an FM and you would have to create a custom FM to handle the delta mechanism for both fields.

[former_member213233 · Accepted solution]

Hi,

Safety delta interval ensures that no documents should missed even if it was created or posted in Database tables during the delta data extraction.

For delta based on 0CALDAY delta selection crieteria will be

"Last delta extracted < new delta records <= Current date"

and upper and lower safety interval values will be subtracted from the upper and lower range. so if you set the safety interval to Zero it will bring the data for updated day before.

it is recomonded If delta determining field is Date (Create Date or change date), then use Upper Limit of 1 day.This will load Delta in BW as of yesterday. Leave Lower limit blank.

Dev

[charla_robertson · Accepted solution]

Hi folks,

Now I'm a bit confused. I have one response saying the lower limit should be 1, with upper limit blank. And another response saying lower limit should be blank and upper limit should be 1.

I changed my lower limit to 1 and left upper limit blank, and that allowed me to run the delta again in the same day and it picked up my deltas.

Which way is best?

Thanks

Charla

[dennis_scoville4 · Accepted solution]

Lower limit of 1 and upper limit of blank is what you want. If you have it the other way (upper of 1 and lower of blank) you'll get undesired results because that means you'll be trying to pull today through today + 1. The lower limit set to 1 will get today - 1 through today.

[Former Member · Accepted solution]

Hopes this will gives you clarity on this

[How to Create Generic Delta|http://www.scribd.com/doc/3857088/How-to-Create-Generic-Delta]

[mr_v · Accepted solution]

To get delta (changes on same day after the previous load), I suggested u to try with Upper Limit = blank and Lower Limit =1.. No confusion.. U can stick to it.

(If u keep lower limit=blank and upper limit=1, I donot think u will get ONLY new (or changed) records. Chances of getting duplicate records.)

[charla_robertson · Accepted solution]

Thanks to all for your replies. I've kept the upper limit blank and lower limit 1. This seems to be working ok in our test environment.