MDX - Filter by Date

• sugaz007

  Old Hand

  Points: 310

  More actions

  July 4, 2010 at 2:56 am

  #387273

  In my fact table I have 2 dates - StartDate & EndDate.

  When I create a cube these 2 columns will be in the fact dimension.

  The end user will select a date in front end.

  The user selected date is in variable @dtdate

  I need to use MDX to retrieve only those rows where this date falls in the range.

  ie. @dtdate between StartDate and EkndDate.

  Please help me with the MDX query.

  Thanks

  Suga

• gsc_dba

  SSCertifiable

  Points: 5407

  More actions

  July 7, 2010 at 10:01 am

  #1189719

  This may be of use to you:

  http://www.eggheadcafe.com/software/aspnet/31535858/date-range-in-mdx.aspx

  gsc_dba