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 |