Hi, I'm using a drop down in SSRS. The values for the drop down coming from a MDX query,since i'm making reports on cube. below is the query: select [Measures].[Sales Amount] on columns, filter([Dim Product].[Product Name].[Product Name],[Measures].[Sales Amount]>0) on rows from (select STRTOSet(@[sub_category])on columns from [Product Sales Analysis]); this query works fine, if i select values which don't contain any space in between. but when i select values with space "Bike racks", the report is not processing, its throwing error. help!!!!

Hello, You eighter have to pass the values with brackets [] or you have to add them in the query, like: ... (select STRTOSet("[" + @sub_category + "]")on columns from [Product Sales Analysis]); Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich http://olafhelper.over-blog.de

hi, its not working still. "[" is getting concatenating at the start of the dimension hierarchy, so the query is not able to parse. error: the [[dim product] was not found in the cube when the string parsed.

How doesn the values excatly look like you are passing through the query?Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich http://olafhelper.over-blog.de

I'm using a drop down in SSRS, from there i select values. values in drop down like: "Bottles and cages", "Helmets". when i select helmets where it wont contain any space in between it works fine. but when i select "bottles and cages" , report is not processing.

Did you ever find out the answer to this? I'm having the same issue but will update here if I figure it out before you reply back...

Are you using StrToTuple? I don't know if that's the issue or not.. I had strToTuple(@parmname) and it ran fine in the query designer, but when the report itself ran it when I selected a parm with a space in it then it dumped with a parser error.. Since I wasn't actually showing it on the report I was able to 'fix' it with a '--' in front of strToTuple(@parmname) ;-)

Hey, I found the correct answer to this.. My report parameter was using the parm text instead of parm value and as soon as I fixed it at the top level then everything flowed through.. hth, CRT.

i got same issue, i use following query, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@P_Region, CONSTRAINED) ) ON COLUMNS FROM [Cube Name]) WHERE ( IIF( STRTOSET(@P_Region, CONSTRAINED).Count = 1, STRTOSET(@P_Region, CONSTRAINED), [Geography].[REGION].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

I have same issue any solution ??