SAP BW GENERIC DATA SOURCE SAFETY TIME INTERVAL

[Former Member]

Hello Experts,

Would like to know if we set a safety time interval lower limit as 1 in case of calday based delta, would it work fine?

I read lot of threads but everyone suggested to use upper limit as 1 in case of calday.

but in my case if I am putting upper limit as 1 , and did init on 25.09.2015 and afterwards I am doing delta but its not working.

But If I put lower limit as 1 and then fetch delta , what it is doing that it is fetching only 25.09 data but as lower limit works I guess it should pick 24th data till the day when delta is happening. am I right? 24 has data in ECC.

so I would like to know with lower limit as 1 , how does it will work?

Regards,

Ankie

[sander_vanwilligen · Accepted solution]

Hi Ankie,

The lower limit is based on the highest calendar day of the previous delta extraction. I expect that in case of calendar day, it will take the next day. E.g. the last extraction is up to and including September 25, 2015, it will take September 26, 2015 as lower limit.

Depending on the time of extraction, it could lead to missing data for a part of the day. In this case it would be wise to define a value of 1 (calendar day) so that the lower limit will become September 25, 2015. Be aware that some data will be extracted a second time which you cannot avoid.

I would leave the upper limit on 0. E.g. if your extraction runs on September 27, 2015, it will take September 27, 2015 as upper limit and the data will be fetched up to and including September 27, 2015.

Best regards,
Sander

[Former Member]

Hello Ankie,

Check this

[Former Member]

Hi Ankie, The current time stamp can always be used as the upper limit when extracting: The lower limit of the next extraction is not seamlessly joined to the upper limit of the last extraction, if the lower limit left blank. Instead, its value is the same as this upper limit minus a safety margin. This safety margin needs to be big enough to contain all values in the extraction which already had a time stamp when the last extraction was carried out but which were not read. Note 1) records can be transferred twice if you using lower margin. 2) Filed should carefully chosen for calendar day, changed on date or created date. Example posting date can back dated entry which may not fall under safe limits some times. 3) When setting the lower limits please consider number of days process chain schedule. Example if the chain doesn't run on weekend then Mondays should pick all the records created on the weekend plus expected safe limits. Your Example 1) But If I put lower limit as 1 and then fetch delta , what it is doing that it is fetching only 25.09 data but as lower limit works I guess it should pick 24th data till the day when delta is happening. am I right? 24 has data in ECC. Yes it will pick the 25th data and 26 th data,  if the process chain run on 26th. Thanks, Shakthi Raj Natarajan.