开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜