Hi Chaps I have a burning query, I ask this question because I keep getting conflicting answers. It's a rather simple question. If we have a SSAS server cube which we are querying against, using for example (Proclarity, Excel or SSRS). Can we run a query against the SSAS server cube while it is being processed? Some chaps advise me you can't query a cube while it is being processed, some people say yo can as SSAS creates a shadow partiton so queries can still be answered from the SSAS cube even when it is being processed and some people say to have two SSAS servers. One server for processing (No user access) the other server synchronises against the first server (no downtime) and users query against the synchronised server. Which is it. Can you still query cubes while they are being processed or not? Thanks in advance
Hi Chaps I have a burning query, I ask this question because I keep getting conflicting answers. It's a rather simple question. If we have a SSAS server cube which we are querying against, using for example (Proclarity, Excel or SSRS). Can we run a query against the SSAS server cube while it is being processed? Some chaps advise me you can't query a cube while it is being processed, some people say yo can as SSAS creates a shadow partiton so queries can still be answered from the SSAS cube even when it is being processed and some people say to have two SSAS servers. One server for processing (No user access) the other server synchronises against the first server (no downtime) and users query against the synchronised server.
Which is it. Can you still query cubes while they are being processed or not?
Thanks in advance
Well, this is not quite right . Even if the cube is processed with Full Process, the cube is available for querying while is being processed. However, once the cube is processed, users must reconnect to continue browsing the cube. If you fully process a dimension, such as after making dimension structural changes, but you don't process a cube that references that dimension, the cube will be left in an unprocessed state and it will be unavailable for querying.
The other more light-weight processing options don't require the user to re-connect after the object is processed.
Hi Paul,
Here is yet another answer. It depends on the processing type. If you process an object with Full Process, the object won't be available for querying. For example, fully procesing a dimension invalidates the all cubes that reference the dimension and the cubes won't be available for querying until they are fully processed as well. However, if you use more lightweight processing options, such as Update or Add, the users will be able to query the cube.