sql server reporting services: Specifying MDX Statement for dataset not possible (SQL Server 2005, RS 2005) -- sql server reporting services

Specifying MDX Statement for dataset not possible (SQL Server 2005, RS 2005)

ladam NO[at]SPAM petafuel.de
3/17/2006 2:50:44 AM

sql server reporting services:

Hi,
i have following MDX statement, which I want to use for a dataset in
reporting services:
---
SELECT {RS_ns_PX_Register} ON Columns, [Register].AllMembers ON ROWS
FROM [Main]
---
RS_ns_PX_Register is a named set and [Register] is a Hierarchy defined
in the [Main]-Cube.

The statement works as expected when I run it in the Management Studio.
However I am unable to create a dataset in the Report Designer for this
statement.
As [Register].AllMembers can't be selected in the Graphical query
editor, I tried to click on "Edit dataset and specify the query string
manually.
However this doesn't work, I get the error, that the changes to the
statement couldn't be saved.

It seems that I am unable to specify any query string manually for MDX
statements.

Is this a known error and do you know any workaround?

Best regards,
Ludwig

RE: Specifying MDX Statement for dataset not possible (SQL Server 2005

MrReportingSvcs
3/19/2006 5:20:27 AM

Hi Ludwig,
If you are in the Graphical Query Designer, look on the top of Parameters.
The Icon on Far most right with a right angled triangle switches you to MDX
query mode. Use this mode and you should be able to write whatever you want.
Reporting Services

[quoted text, click to view]

Re: Specifying MDX Statement for dataset not possible (SQL Server 2005

ladam NO[at]SPAM petafuel.de
3/19/2006 6:29:25 AM

Hi,
thank you very much, that solved the problem!

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.