mdx parameter that contains two words causing an error

Question

I require help of the experts again!

I have set up a drop down list to be a parameter of another dataset.

When I choose an item that contains two words, it gives me an error saying

the syntaxt for "the second word" is incorrect.

So is there any way to wrap the whole param as one single string entry?

This is the query of the dataset which is causing the error.

SELECT NON EMPTY { [Measures].[Matters Count] } ON COLUMNS, NON EMPTY { ([Matters].[By Division].[APPLICANT TYPE].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM

( select strtoset(@Division)on columns from [CTTT] )

CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

Thanks a lot in advance. Cheers.

Answer 1

Try doing:

(StrToSet("[Dimension].[Hierarchy].["+@Division+"]") ON COLUMNS FROM [CTTT])

Where the Dimension and Hierarchy are the ones from your Division dim (e.g. [Matters].[By Division]). This will be more correct anyway, as if you don't include the dim.hier SSAS tries to find the @Division parameter anywhere in the cube.