Have a problem accessing/browsing a cube in Analysis Services 2005.
Cube was working one day and then the next it could not be browsed.
Have drop and redeployed and still will not browse. When I try to
browse, I get not respoding and the system hangs. I can't run MDX
against the cube or it hangs as well. Eventually have to stop/start
the service in order to get the cpu down. Other cubes on the server
can still be browsed. After rebuilding the cube/database, I was able
to browse all the dimensions, but no the cube itself. Tried deploying
on local machine and another server, but have had the same results.
Any help on this would be greatly appreciated as this is a heavily
used cube and right not it is offline. Not sure if could be caused by
some bad data, but it processed fine, etc. Closest issue I found was
this discussion on Microsoft, but there was no real solution.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2742144&SiteID=17
Thanks!