SAP BW GENERIC DATA SOURCE SAFETY TIME INTERVAL

[#1]

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