question

user-1529 (yahoo) avatar image
user-1529 (yahoo) asked

Running MDX query against cube in SQL Server Management Studio returns #Error

I have processed my cube successfully, and can browse it just fine from SSAS, but when trying to execute a MDX query against the cube in SSAS it returns #Error. Any idea what I have to do? – I’m using SQL Server 2005 – I have two cubes in one SSAS project – and only one of those two cubes have this problem.

Any help is appreciated. Thanks.

ssasmdx
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.

1 Answer

·
Queue avatar image
Queue answered

Check your MDX Query first. Try to see if you are able to connect to it through openrowset and retrieve records (or) using excel..or ssrs....

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.