I'm trying to create a dynamic query for a Reporting Services report. I want
to be able to replace the word "Company" in my example with any other
dimension name, and have the set be named "ListRows", instead of Company, or
Country or whatever. It works for measures, but the set always changes name
to what the dimension is called, and that messes up the next step of my
report.

Is this possible? How?
Example:

WITH set[Listrows] as '{[Company].members}'
MEMBER [MEASURES].[List_Qualified_Name] AS
'[Company].CurrentMember.UniqueName' MEMBER [MEASURES].[List_Report_Name] AS
'[Company].CurrentMember.Name' SELECT non empty
{[MEASURES].[List_Report_Name], [MEASURES].[List_Qualified_Name]} ON
AXIS(0), {[Listrows]} ON AXIS(1) FROM [MyCube]

All help appreciated!

Kaisa M. Lindahl