Hi

I am using MDX in RS and am currently constructing a chart where by the
series part is inputted by a user. This is fine for construction of the
MDX via a STRTOSET command however this changes the structure of the
result set everytime the user inputs something new.

A simple way around this is to construct a measure that can be be
outputted everytime in the dataset and will contain the MEMBER_CAPTION
of Axis(1). This can then be referenced in the chart.

So the important part of the query is

SET [Series] AS STRTOSET(@Series)

Then I want to do something like

MEMBER [Measures].[Series] AS Axis(1).CURRENTMEMBER.MEMBER_CAPTION

OR

MEMBER [Measures].[Series] AS [Series].CURRENTMEMBER.MEMBER_CAPTION

Then the usual

SELECT Measures ON 0
[Series] ON 1
FROM [Cube]

I know these are wrong but I hope you can see what I am talking about

Thanks in advance

Denver