MDX-Drillthrough

Hi,
I am trying to display the results of for example:
DRILLTHROUGH SELECT FROM [Request] WHERE [Day].[Day_Id].[5501]
inside a table of a report. I tried to follow
http://www.databasejournal.com/features/mssql/article.php/10894_3557476_10
but I didn't succeed:
I created a new dataset and entered the above statement into the Design mode
of the query builder. When I execute the statement, an error shows up:
"Query preparation failed. Additional information: Failed to parse the
query to detect if it is MDX or DMX. (MDXQueryGenerator)."
(In the Management Studio the query doesn't fail and shows the expected
results.)
What am I doing wrong?Use OLEDB instead of "Microsoft Analysis Services" as Datasource-Typ and it
works!
"Ralph Watermann" <We.Want@.NoSpam.de> schrieb im Newsbeitrag
news:eRMfBtQ8FHA.1276@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am trying to display the results of for example:
> DRILLTHROUGH SELECT FROM [Request] WHERE [Day].[Day_Id].[5501]
> inside a table of a report. I tried to follow
> http://www.databasejournal.com/features/mssql/article.php/10894_3557476_10
> but I didn't succeed:
> I created a new dataset and entered the above statement into the Design
> mode of the query builder. When I execute the statement, an error shows
> up:
> "Query preparation failed. Additional information: Failed to parse the
> query to detect if it is MDX or DMX. (MDXQueryGenerator)."
> (In the Management Studio the query doesn't fail and shows the expected
> results.)
> What am I doing wrong?
>