I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services cubes are processing using SQL Server Reporting Services? I would like to be able to run this report without affecting the cube process, in real-time. The end product of this process is to create a way to let end users know the a report cannot be created because cube is processing.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I guess you are worried about the downtime due to cube processing. As detailed in the post below, the downtime, due to processing, is very minimal .
In the comments section, there is an approach mentioned by which you can reduce this downtime (with few caveats) by using one server to do the processing and then sync the DBs.
If you still want to do the report, you can follow the approach suggested here: