WEEK as TimeDimension in AS

[Greg007]

Hello

Based on a timetable for one year with fields like
"2004-02-18 18:52:00.000" the TimeDimension Year, Month, Day, Hour work very fine.

BUT, I can not switch to YEAR/WEEK as TimeDimension in Analysis Services.

Does anyone know why and how to set up WEEKs ?

knd rgds
Greg

 

[johnherman]

My advice would be to set up a calendar table on your source system. The calendar table would contain the date, week number, quarter number, fiscal year, and other info related to your specific application.

For instance, does your company work week start on Monday? Sunday? Saturday?

What about the week of Dec 28 - Jan 3? Which year is that part of when you drill from year to month to week?

I think you get the idea.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright