continuous loading of an infosource

[Former Member]

During our year end close we would like to continually load a certain infosource during the day to keep the data as fresh as possible. I am looking for feedback on the best way to do this. I have tested a process chain that is started by an event, the last step in the chain ends with an abap program that calls the event again which kicks off the chain again. This works ok but i am wondering if there is a better way!

[Former Member · Accepted solution]

Hi,

Have you tried using a SAP RemoteCube instead?

[sachin_kulshrestha2]

Hi,

Is you event taking care of filling up the delta queue before loading.

You should keep some time in loading data to bw ideally it should be 30 miniutes.

Remember that every request which comes in to bw a partion in the fact table is created on a longer run let say for 1 months will create problem .

Hope this helps!!!

[Former Member]

Hi Tracy

I hope you are loading deltas in this scenario and not the full updates. Please try to keep distance of 15-20 min between two instances of process chain start. This will give a process chain some breathing space and withing 15-20 mins you will get good amount of delta data too.

Hope it helps

Regards

Pradip

[Former Member]

Schedule the process chain every five or ten minutes. This is the easiest way to solve the problem. A RemoteCube or VirtualProvider with Services is the most accurate way but depending on your data flow it may require lots of time to develop the logic to get the same results. Your solution is also a nice way to solve this.

Best regards

Dirk