SSRS failing when parameter value contain SPACE in between(MDX StrToSet)
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!!!!
October 19th, 2010 9:47am
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
October 19th, 2010 10:30am
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.
October 19th, 2010 11:34am
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
October 19th, 2010 11:43am
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.
October 19th, 2010 11:50am
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...
January 11th, 2011 11:57pm
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) ;-)
January 12th, 2011 12:15am
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.
February 3rd, 2011 9:33pm
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
November 20th, 2011 7:40am
I have same issue any solution ??
December 10th, 2011 8:24am