SSAS Articles 
Time Dimension Handling Multiple Calendars with a M2M Scenario
Time Dimension Handling Multiple Calendars with a M2M Scenario | Handling Multiple Calendars with a M2M Scenario |
| Written by Dave Fackler | |
| Wednesday, 25 June 2008 00:00 | |
|
Most dimensional models and BI solutions implement a date dimension of one type or another and many of them include multiple calendars -- the "wall" (or Gregorian) calendar, a fiscal calendar, a manufacturing calendar, etc. Handling multiple calendars is fairly simple and most people approach the problem by adding additional columns to a date dimension table that holds a row for each date they need. Read more Part 1 ... |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- 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
- Measures and calculations in cubes without natural hierarchies
- Forget SQL Management Studio, Stick to BIDS
- Null processing of measures in SSAS2005
