This works if I hard code my Parmeter as [Dim Sales Group].[Sales
Group].&[1] but if I code it as
[Dim Sales Group].[Sales Group].[Sales Group Name] it does not work. I
only know the Sales Group name from the data set not the Key. Anyone no
any other way to do this? I know you can create whole MDX string and
pass it but how to I pass that to another report in reporting Services?
Also if I make the parmeter a text box and type in the value [Dim
Sales Group].[Sales Group].[Sales Group Name] name the report works
but when I hide the parameter and try to pass it as [Dim Sales
Group].[Sales Group].[Sales Group Name] it does not work yet passing
it as [Dim Sales Group].[Sales Group].&[1] does.

Did you confirm that the exact string being passed is what you expect -
you could temporarily add a text box to the report, to display it? Also,
what does the parametrized MDX query, which usees this string, look
like?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

You have to enter property MDXUniqueName = 2 in you connection string to get
dimension path by name instaed of key.

Ramunas

"Susan" <Susan.Swanger (AT) Siemens (DOT) com> wrote