Hi

I have some problems with the week level of the time dimension. I´m located
in denmark and therefore we use the ISO 8601 standards fore week numbering.

When I create a standard week level i get an error because DATEPART and
DATENAME functions return different results for the same date.

fx select datepart(week, '28-12-2003'), datename(week, '28-12-2003')
returns 52 and 53

This result in an error processing the cube. No problem I just use the
datepart function as both key and name. This solves the problem but now i
have the problem with wrong week-numbers acording to the ISO 8601 standard.

fx select datepart(week, '29-12-2003') returns 53 but the correct week
number is 1.

Is there any way to solve this problem using standard time dimension or do I
have to create a table with the correct weeknumber per date??

Any comment is appreciated.