MDX Date Range Inclusive

• maddencircledme

  SSC Enthusiast

  Points: 157

  More actions

  April 30, 2012 at 8:06 am

  #255095

  I have the following MDX query that works:

  SELECT NON EMPTY [Measures].[M1] ON COLUMNS,

  NON EMPTY {[Dim1].[xyz].[xyz]} ON ROWS

  FROM [MyCube]

  WHERE ([Dim2].[ABC].Children - [Dim2].[ABC].[ABC].&[ExcludedValue],

  [Dim3].[QWERTY].&[Yes])

  I'm trying to add a date range but it is not returning any results by changing the WHERE clause to the following:

  WHERE ([Dim2].[ABC].Children - [Dim2].[ABC].[ABC].&[ExcludedValue],

  [Dim3].[QWERTY].&[Yes],

  [DimDate].[MyDates].&[2012/01/02] : [DimDate].[MyDates].&[2012/01/25]

  )

  Where's the best way to only return results between those dates? I've tried throwing the date range in a filter but that didn't work either.

  When I browse the cube and put the filters in at the top, it works just fine but I can't do it manually for some reason.

  Also, is there a better way to return the results where QWERTY is Yes and the ABC values are not equal to the ExcludedValue?

  Thanks,

  John