Hi,

I am writing a dynamic MDX query for Reporting services.
The column names are generated dynamically from the parameters.

I am able to create an alias of a member by saying:

WITH member [date].[month].[first] as '[date].[month].[410]',
SOLVE_ORDER = 1
select
{[date].[month].[first], [date].[month].[411] } on columns
from [policies by date]



But i need both columns to be dynamic.
So i was trying something :

WITH member [date].[month].[first] as '[date].[month].[410]',
SOLVE_ORDER = 1 member [date].[month].[second] as
'[date].[month].[411]', SOLVE_ORDER = 2

select
{[date].[month].[first] , [date].[month].[second]} on columns
from [policies by date]

but it fails and says:
"Unable to open cellset Connection to the server is lost. Formula
member name ... not valid"


Am i missing anything? Can anyone help me in making the second query
work.

You must be wondering that what makes me take this approach. Well, in
reporting services, i will be passing these month number as parameters
and as a limitation it doesnt supports dynamic binding of columns. Any
other approach is also welcomed.

Thanks in advance.

cheers
Rasti