x

login about faq Site discussion (meta-askssc)

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

0

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.

asked Apr 07 '10 at 12:04 PM in Default

user-1529 (yahoo)
1 ● 1 ● 1 ● 1

(comments are locked)

1 answer:

0

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

answered Apr 28 '10 at 10:34 AM

Queue
239 ● 2 ● 2 ● 3

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

ssas x141
mdx x50

asked: Apr 07 '10 at 12:04 PM

Seen: 2115 times

Last Updated: Apr 07 '10 at 12:49 PM

Related Questions

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.