Lower Limit and Upper Limit in generic data source in BW

[abhimanyu_sharma]

Hi Experts

I have a generic data source having generic delta on CPUDT ( Created on field) with upper safety limit = 1. hence, it is fetching delta till system date - 1.

But my requirement is to fetch the delta till date. So if i set lower limit = 1 it will fetch data from system date -2 to System date.

My question is if i set lower limit = 1 and fetch the delta today at 3 AM , i will get all the records posted till 3 AM. But if suppose any new delta records gets created at 4 AM, and then if I run the delta IP , should it bring the new delta records?

Please note I am loading to DSO only.

[former_member586947]

Hi Abhimanyu,

There is no harm in setting the lower limit to 1, provided if all the keyfigures of the DSO are set to overwrite. Moreover, you will not miss any data and you will have latest data(current day's data) always in the BW.

But if you set upper limit you will not get the recent data (i.e (current day's data)).. data is always old based on the upper limit set.

In a day you can load delta once, because CPUDT set as the delta pointer. Hope, you are aware of this.

"My question is if i set lower limit = 1 and fetch the delta today at 3 AM , i will get all the records posted till 3 AM. But if suppose any new delta records gets created at 4 AM, and then if I run the delta IP , should it bring the new delta records?"

Answer:

No you will not get the records created after 3AM if you run the delta IP on the same day (i.e at 4AM or afterwards).

If you want to do so, add a dummy time stamp field in the data source and use the FM to get the delta more often. Let me know if you want to try this option.

Regards,

Satya.

[FCI]

Yes. If you set the upper limit to 0 and the lower limit to 1, a run at 3 PM at J will extract all records with the date until the current date (upper limit to 0). A run at 3 PM at J+1 will extract all records with the date between J and J+1 (lower limit to 1). Thus, you won't miss any record.

[abhimanyu_sharma]

So,are you suggesting to set Lower limit = 1 and upper limit = 0 ?

[FCI]

If you want to catch the records until the current date, the upper limit should be set to 0.

Due to this upper limit, if you want to not miss any record, you should set the lower limit to a value > 0.

[abhimanyu_sharma]

I dont want to miss any records. So in that case, should i set lower limit = 1 and upper limit = 0 or blank ?