Take the 2-minute tour ×
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.

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
3  
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
add comment

1 Answer

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 .

http://www.jamesserra.com/archive/2011/06/can-you-query-a-ssas-cube-while-it-is-processing/

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:

http://stackoverflow.com/questions/11899250/how-to-determine-which-ssas-cube-is-processing-now

share|improve this answer
add comment

Your Answer

 
discard

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.