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