Date dimension custom rollup

#1

I have a standard date dimension, but I want the week to rollup into the
year and not the default of rolling up into the month, Is this possible, if
so, how do I do it?

TIA,
Scott

#2

"Scott Riehl" wrote:

Quote:

I have a standard date dimension, but I want the week to rollup into the
year and not the default of rolling up into the month, Is this possible, if
so, how do I do it?

Scott,

I'd recommend deleting the Month level. Actually, that's what the Dimension wizard sets up for you when you create a Time Dimension that includes Week.

Regards,

Jonathan

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

Date dimension custom rollup

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

Date dimension custom rollup - 06-14-2004 , 12:35 PM

RE: Date dimension custom rollup - 06-18-2004 , 03:29 AM