I'm builind a mdx query to my report in ssrs 2005 with ssas 2005 all on SP3.
I'm having the hardest time to add a custom parameter to the query, I add it to the dataser parameters tab ("..." button). Then when I try to use it in my query I get an error: The query uses a parameter, which is not declared.
I've seen some examples on the goo.. internet but none seems to work.
My query runs fine like this STRTOMEMBER("[dimension].[entity].&") but it fails if I try to do this.. STRTOMEMBER("[dimension].[entity].&[" + @entityid + "]")
Am I trying to do impossible? :) Any idea on how to get such filter to work? My filters are a bit complex that's why I can't simply use the "Parameter" checkbox in the query designer mode.
View Complete Post