question

Rajan avatar image
Rajan asked

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.
cubeanalysis
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Usman Butt avatar image Usman Butt commented ·
What MDX query you are executing?
1 Like 1 ·

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.