How to Initialize Delta for Generic Data source w/o any Delta enabled field
I have created a generic data source on view w/o any delta field. Requirement is, user wants to see a report on the data which got recorded yesterday. I want to load full history data at once, and then from tomorrow onwards would like to load only delta data (i.e. only new records which got captured/recorded). I have already loaded the history data, now my requirement is I want to do Delta Initialization, so that it won't load all the data again and again into DSO. I'm new to BI and currently working on BI 7.3.
There are a few points you need to understand.
If you want delta from a datasource it should be delta enabled. And if you are making a generic datasource based on view then you need to select a delta field in RSO2 similar like below:
If you do not want to set a delta field in the exractor in RSO2 then you need following is extractor structure:
1. Atleast one date/timestamp field in table/view
So in this case if you do not set a delta flag then in SAP BW and you have to:
1. Pull always a FULL load from Infopackage
2. In the data seletion part of Infopackage you will have to write a ABAP code which should set the selection conditions dynmically.
With this even if your datasource is FULL load you will get only one day old data and not full data always.
Let me know if this seems too complex for you. I will simplfy further.