MS SQL Server Reporting Services - Query Builder 2005: Drillthrough (MDX) impossible?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Query Builder 2005: Drillthrough (MDX) impossible?

Ralph Watermann

2005-11-29, 7:23 am

Hi,

I'm using RS 2005 and I'm trying to display the "source" data of a cube cell
in a report table. Therefore I wanted to define a new Dataset to do a
drillthrough (MDX). If I enter:

SELECT
[Order Date].[Date].[Date].[July 5, 2001] on ROWS,
[Measures].[Internet Sales-Sales Amount] on Columns
FROM
[Analysis Services Tutorial]

into the query desginer, everything works fine. If I now enter a
DRILLTHROUGH above:

DRILLTHROUGH
SELECT
[Order Date].[Date].[Date].[July 5, 2001] on ROWS,
[Measures].[Internet Sales-Sales Amount] on Columns
FROM
[Analysis Services Tutorial]

I get the following error:

"Query preparation failed. Additional information: Failed to parse the
query to detect if it is MDX or DMX. (MDXQueryGenerator)."

What does this mean?
Am I doing something wrong?
Is there an other solution to display this data?

Any help appreciated,
Ralph

Sponsored Links