DRILLTHROUGH MDX statement n SQL AS 2005

With SQL RS 2000 and SQL AS 2000 I'm using DRILLTHROUGH MDX statement. But when I try to use it with SQL RS 2005 and SQL AS 2005 I get an error:

TITLE: Microsoft Visual Studio

Query preparation failed.

ADDITIONAL INFORMATION:

Failed to parse the query to detect if it is MDX or DMX. (MDXQueryGenerator)

Do you have any solution?

If you're trying to use the Analysis Services Provider in RS 2005, you may want to try the OLE DB for OLAP 9.0 Provider instead, based on this thread from the SQL Server OLAP newsgroup:

http://groups.google.com/group/microsoft.public.sqlserver.olap/browse_frm/thread/f5e2bc488f4f78bf/4870097ed8fcffda#4870097ed8fcffda

>>

How about trying the OLE DB option? I couldn't get the following AW
Drillthrough query to work with the RS 2005 Analysis Services Provider;
but it returned 8 records when I used OLE DB for OLAP 9.0 instead:

Drillthrough
Select [Ship Date].[Calendar].[Calendar Year].&[2001] on columns,
[Customer].[Customer Geography].[State-Province].&[TAS]& on rows
from [Adventure Works]
where [Measures].[Internet Order Quantity]

>>