Get the ISO Week correct in the Adventure Works cube

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.