Date Ranges in SSAS 2005 and ProClarity

Thanks to Dan Wilmot for this whitepaper.

Many users need the ability to run a query against an SSAS cube that includes a date range. Typically this date range consists of a “start date” and an “end date” selection.  The default behavior of dimensions in the cube makes this type of selection difficult.  This paper discusses how to design your cube to include a new “Start Date” and “End Date” dimension, then how to add those dimensions to the cube, and finally how to build a named set that represents your date range.