Appreciate Steve for your quick input. So there are no way of walking around, right? I think this phenomenon is very normal since in most fact table design, we allow...

Just got it solved. It is actually one of the dimension "Proactive Caching" was set to Automatic MOLAP instead of MOLAP. After I made the changes the MDX query runs...

Appreciate for your quick reply. I agree with the power brought by SSAS but just wondering the low marketshare by SSAS. Maybe it is because its dashboard tool, Excel and...

Have you tried to deploy the package to server and launch it from job agent? It work fine for me in VS 2008 however not working if launching from job...