WEEK as a Time-Date Period to report on and MSAS 2k5 cube's design

#1

I need to slice on WEEKS periods in many reports.

What is the best approach:
- to design the Date dimension with WEEK level
(YEAR-QUARTER-MONTH-WEEK-DAY) and have some complexity in logic to build
MDxes...
OR
have 'week#of the year' attribute and have WEEK not in
YEAR-QUARTER-MONTH-DAY hierarchy?
OR
?

Any whitepaper/example of best practices are highly appreciated.

thank you,
Alex Deiden

#2

If your time dimension has day, week, month, quarter and year attributes
(among others) you could build 2 (or more) hierarchies in your time
dimension

Year
Quarter
Month
Day

Year
Week
Day

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <F19619DE-DB6E-4986-A0B1-609DE3068197 (AT) microsoft (DOT) com>,
AlexDeiden (AT) discussions (DOT) microsoft.com says...

Quote:

I need to slice on WEEKS periods in many reports.

What is the best approach:
- to design the Date dimension with WEEK level
(YEAR-QUARTER-MONTH-WEEK-DAY) and have some complexity in logic to build
MDxes...
OR
have 'week#of the year' attribute and have WEEK not in
YEAR-QUARTER-MONTH-DAY hierarchy?
OR
?

Any whitepaper/example of best practices are highly appreciated.

thank you,
Alex Deiden

#3

Hi Daren,
This is perfectly great solution!
Thank you!
Alex

"Darren Gosbell" wrote:

Quote:

If your time dimension has day, week, month, quarter and year attributes
(among others) you could build 2 (or more) hierarchies in your time
dimension

Year
Quarter
Month
Day

Year
Week
Day

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <F19619DE-DB6E-4986-A0B1-609DE3068197 (AT) microsoft (DOT) com>,
AlexDeiden (AT) discussions (DOT) microsoft.com says...
I need to slice on WEEKS periods in many reports.

What is the best approach:
- to design the Date dimension with WEEK level
(YEAR-QUARTER-MONTH-WEEK-DAY) and have some complexity in logic to build
MDxes...
OR
have 'week#of the year' attribute and have WEEK not in
YEAR-QUARTER-MONTH-DAY hierarchy?
OR
?

Any whitepaper/example of best practices are highly appreciated.

thank you,
Alex Deiden

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

WEEK as a Time-Date Period to report on and MSAS 2k5 cube's design

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

WEEK as a Time-Date Period to report on and MSAS 2k5 cube's design - 02-15-2006 , 04:16 AM

Re: WEEK as a Time-Date Period to report on and MSAS 2k5 cube's design - 02-15-2006 , 06:34 AM

Re: WEEK as a Time-Date Period to report on and MSAS 2k5 cube's de - 02-15-2006 , 05:06 PM