dbTalk Databases Forums  

Many Time Dimension Hierarchies

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


Discuss Many Time Dimension Hierarchies in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom DAurizio
 
Posts: n/a

Default Many Time Dimension Hierarchies - 10-27-2004 , 09:06 AM






I am working on a cube that serves several client companies, and I
have to support many calendars.

Levels:
Year, Quarter, Month, Week

Calendars:
Standard
Jan - Dec
Merchandising
Feb - Jan, 4-5-4

I've got the standard and merchandising calendars working fine, based
on the 'normal' starting dates of 1/1 and 2/1, respectively.

The way I see it (so far), I would have to create 12 hierarchies under
each of the two main types (standard and merchandising), one for each
starting month. Is this feasible/wise? It doesn't seem so, but I'm
new to all of this.

The client for this application is asp.net, so I do have the ability
to take care of this in code, or through MDX sets, but it seems much
more elegant to have AS handle these rollups, if possible. I'm
looking for any input on a best practice approach to this requirement.

Thanks, and have a good day.
Tom

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.