Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Are you looking to see weather the cube's are processing or are you trying to see what the latest records that you have available in your cubes? – Zane Nov 26 '12 at 14:46
I'd like to know weather the cube is processing – ObinnaJuan Jan 7 '13 at 20:05

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:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.