MDX Parameter Filter for SSRS 2005

• SQL Thetan

  Say Hey Kid

  Points: 664

  More actions

  September 29, 2008 at 2:16 pm

  #194261

  My brain has melted from the last few days of learning MDX! I seem hung up on how to dynamically filter years (current year and previous year) from a hierarchy. The dataset from one of my test reports is pasted below

  WITH MEMBER [Measures].[ParameterCaption] AS '[Posting Date].[Year - Month].CURRENTMEMBER.MEMBER_CAPTION'

  MEMBER [Measures].[ParameterValue] AS '[Posting Date].[Year - Month].CURRENTMEMBER.UNIQUENAME'

  MEMBER [Measures].[ParameterLevel] AS '[Posting Date].[Year - Month].CURRENTMEMBER.LEVEL.ORDINAL'

  SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,

  [Posting Date].[Year - Month].ALLMEMBERS ON ROWS

  FROM [Test]

  The levels are [Posting Date].[Year - Month].[Calendar Year].[Calendar Month]. I like the display of the parameter list. I just want it to be filtered properly. Any hints?

  TIA

  Taylor

• w.lengenfelder

  SSC Eights!

  Points: 884

  More actions

  September 30, 2008 at 12:48 am

  #878688

  Hi,

  to filter your result you can replace

  [Posting Date].[Year - Month].ALLMEMBERS

  by

  DESCENDANTS( [Posting Date].[Year - Month].[<VALUE>])

  Wole