Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Getting error in firing MDX Query

Author  Topic 

Priya Rawat
Starting Member

6 Posts

Posted - 2010-12-09 : 02:29:50
Hi,

While firing MDX Query in our cube I am getting error "The AdventurousWorksDW cube either does not exist or has not been processed." I have already creted a role in analysis service database with full permission and also I am the member of the Administrators group on the server that is running the instance of Analysis Services

Priya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-12-09 : 12:22:02
looks like you've made some metadata changes in your analysis service project of cube and not processed it after that. try processing cube from business intelligence studio. reconnect to cube in management studio and try again

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -