BW Broadcast

[Former Member]

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

[Former Member · Accepted solution]

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.

[former_member202718]

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

[Former Member]

Hi Keith,

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

[sander_vanwilligen]

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