Skip to content

SSRS parameter values are filtered in accordance to other parameters values.

by tony on July 22nd, 2011

The below MDX fetches the Currency Codes based on the the @Agency parameter value.  The STRTOSET function convert string to SET.


WITH
MEMBER [Measures].[ParameterCaption] AS [Currency].[Currency Code].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue] AS [Currency].[Currency Code].CURRENTMEMBER.UNIQUENAME
MEMBER [Measures].[ParameterLevel] AS [Currency].[Currency Code].CURRENTMEMBER.LEVEL.ORDINAL

SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,
FILTER ( [Currency].[Currency Code].CHILDREN,NOT ISEMPTY( [Measures].[Closing Balance] ) ) ON ROWS

FROM ( SELECT ( STRTOSET(@Agency, CONSTRAINED) ) ON COLUMNS FROM [My Cube])

From → MDX, SSRS

2 Comments
  1. Hello. And thank you at once for such an amazing web site. I’ll be visiting it on a regular basis.

  2. Very nice site! is it yours too

Leave a Reply

Note: XHTML is allowed. Your email address will never be published.

Subscribe to this comment feed via RSS

Please type the characters of this captcha image in the input box

Please type the characters of this captcha image in the input box

Optimized by SEO Ultimate