Cascading Date Filters

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  October 20, 2015 at 12:16 pm

  #301662

  I've got a PPS BeginDate and EndDate filter (MDX filter) created. The source query is:

  NonEmpty( Hierarchize( Descendants( [Date].[Calendar Day].[All], [Date].[Calendar Day].[Year], SELF_AND_AFTER) ), [Measures].[Metric Quantity] )

  This allows the user to pick from any level of my date hierarchy: Year, Quarter, Month or Day.

  If the user selects at the Quarter level in the Begin Date, I only want quarter level values to appear in the End Date filter. Both of these MDX queries do that (bring back all values at the quarter level)

  SELECT

  DESCENDANTS (

  [Date].[Calendar Day].[Quarter].&[20143].Level, 0, SELF

  ) ON ROWS,

  {} ON COLUMNS

  FROM [RoyaltyPMA];

  or

  SELECT

  [Date].[Calendar Day].[Quarter].&[20143].Level.Members ON ROWS,

  {} ON COLUMNS

  FROM [RoyaltyPMA];

  But when I try to implement this in the filter's connection formula (End date has a connection to Start Date's Member Unique Name)

  DESCENDANTS (<<UniqueName>>, 0, SELF)

  or

  <<UniqueName>>.Level.Members

  It still brings back all of values for all levels in the End Date filter.

  Any ideas?

  Thanks,

  Rob