mdx parameter that contains two words causing an error
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
[CTT开发者_开发技巧T]
)
CELL PROPERTIES VALUE,
BACK_COLOR,
FORE_COLOR,
FORMATTED_VALUE,
FORMAT_STRING,
FONT_NAME,
FONT_SIZE,
FONT_FLAGS
Thanks a lot in advance.
Cheers.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.
精彩评论