SSAS Articles 
Time Dimension Get the ISO Week correct in the Adventure Works cube
Time Dimension Get the ISO Week correct in the Adventure Works cube
| Get the ISO Week correct in the Adventure Works cube |
| Written by Thomas Ivarsson |
| Friday, 19 September 2008 14:57 |
|
A few months ago I wrote about how you can calculate the ISO week by creating a user defined function with TSQL in your database. You will need to read that blog post first and use the code for the UDF that you can find there. What I did not show was how to create a hierarchy in the date dimension in a SSAS 2005 cube. If you simply add the calendar year level above the ISO week level(Date, ISO week, Calendar Year) you will see a problem if you expand the dates between the last week of previous year and the first week of the following year. 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)
