Skip to Content
avatar image
Former Member

BW Broadcast

I am using Broadcasting to fill query cache for faster query execution. I load transactional data followed by broadcast job to Fill OLAP Cache. When I execute the query following the Broadcast job, it takes about 3 minutes to return data.  After the first query execution, all subsequent executions return data in 2-3 seconds.

My question is shouldn't the Broadcast job do the same thing for query cache as the actual execution of the query?  For me that is not the case but my understanding of how it should work.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 15, 2015 at 03:44 PM

    Thanks for input.  What I found out is we have an intraday load process for one of the cubes under the MultiProvider and this was invalidating the cache.  I added a process to the process chain for the intraday load to refill cache and query execution is fast.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 10:49 PM

    Hi Keith,

    According to SAP Help it should be possible although a few remarks are made. Did you everything as instructed here? Did you analyze any log (e.g. process Chain, Broadcaster) to check the execution?

    Best regards,
    Sander

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2015 at 11:10 PM

    Hi Keith,

    your understanding is right, check your settings again in the process chain variant and broadcaster settings.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 05:01 AM

    Hi Keith,

    I think something is not working or some setting are not in place..we have implemented this and it works quite fine...

    The Query gets executed in the backend and fills OLAP Cache..and when the user executes its much faster..

    rgds

    SVU

    Add comment
    10|10000 characters needed characters exceeded