Skip to Content
author's profile photo Former Member
Former Member

continuous loading of an infosource

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!

Add comment
10|10000 characters needed characters exceeded

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 11:45 PM

    Hi,

    Have you tried using a SAP RemoteCube instead?

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 10:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 11:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 11:22 AM

    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!!!

    Add comment
    10|10000 characters needed characters exceeded