SSAS Articles 
Time Dimension Date Ranges in SSAS 2005 and ProClarity
Time Dimension Date Ranges in SSAS 2005 and ProClarity
| Date Ranges in SSAS 2005 and ProClarity |
| Written by Dan Wilmot |
| Thursday, 11 September 2008 23:44 |
|
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. Read more...
|
Tags: 2005, article, time dimension
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
