MDX -> What is the best way to splice the below set via a date?

• UserSmith

  SSC Enthusiast

  Points: 110

  More actions

  January 26, 2012 at 9:17 am

  #391413

  I am creating a set of data that ranks customers by their revenue. I can do this fairly easily. :

  WITH SET [RevRank] AS

  ORDER (

  [Customer].[Customer Id].CHILDREN ,

  [Measures].[Revenue], BDESC)

  The above when pulled into a query works great and shows me the overall rank of customers via their revenue.

  I am now wondering how I can splice this set by a date. I know that I can add a where clause to my query to show rank by a day, etc.

  I am wondering how to create a set specific to a day (for my situation).

  Any ideas/direction will be greatly appreciated.

  Thanks.

• Martin Schoombee

  SSCoach

  Points: 19131

  More actions

  January 26, 2012 at 11:53 am

  #1438974

  Have a look at the following: http://social.msdn.microsoft.com/Forums/eu/sqlanalysisservices/thread/ffd0c8a7-c3df-484b-b413-4e468f7d2211

  I think your problem can be solved in a similar manner.

• UserSmith

  SSC Enthusiast

  Points: 110

  More actions

  January 26, 2012 at 12:16 pm

  #1438992

  Thank you for your post Martin, I believe this will help me with my issue.

• Martin Schoombee

  SSCoach

  Points: 19131

  More actions

  January 26, 2012 at 12:18 pm

  #1438994

  Sure mate, no problem.