Report Portal

Can you query a SSAS cube while it is processing?

I have always wondered if queries against a SSAS cube while it is processing would be forced to wait the entire time the cube is processing, or just for a few minutes? Or would the query bomb out? Surprisingly, I found little information on the internet about this. Fortunately, with help from SSAS guru's Chris Webb and Adam Jorgensen, they lead me to an old posting that explained it. Here is my summation:

You can query a cube while it is processing. The worst that could happen is near the end of processing there is a brief period of time where your query could be killed or it might be queued, and it would be queued only for a short time, even if the cube processing takes hours. The reason is the way a cube is processed:

Read more...

Tags: management

 

2007-2015 VidasSoft Systems Inc.