Accessing Analysis Cube (sql server analysis service)
hi, I am rajan, i am working with sql server analysis service 2008 By using the analysis service 2008 i have successfully created the cube and deployed it. but i cant able to access the cube data through MDX queries using the Sql server 2008. If i fire the queries, it throws an errors like, the cube does not exist or it is not processed. Note: When i browse the cube i can able to find the data in the cube. But i can't able view or manipulate the data from the Analysis Service Cube Kindly, Help me to resolve this problem. Thankyou.
And how you are querying? Using SSMS? When connecting using SSMS to SSAS instance, did you changed the context to right database? Can you see dimensions and measure groups in MDX editor? As I mentioned above, after connecting using SSMS, you have probably not changed the context to correct SSAS database.