Issue in where condition while using in mdx

Question

I have parameter value: 'Paris carlton' when 'm trying to pass this value in mdx as (StrTomember(@Parameter)) i'm getting error.

How to pass the total name 'Paris Carlton' in where condtn. to filter the parameter value.

when i tried:when pass this parameter value, it is considering only Paris and not Carlton thus resulting in error. how to consider the full name while passing a value in mdx?

Answer 1

If you are doing this :

(StrTomember(@Parameter))

Then @Parameter will need to be a string that represents the full member name. So you can either do an expression in SSRS to create a string that looks like this:

"[Geo Dimension].[Country hierarchy].&[Paris Carlton]"

Or you could build it inside the strToMember function:

 (StrTomember("[Geo Dimension].[Country hierarchy].&[" + @Parameter +"]"))