Hi!

Our time dimension has the following structure:

Time_Key
Time_Day
Time_Month
Time_CalendarQuarter
Time_CalendarYear
Time_FiscalQuarter
Time_FiscalYear

Basically, depending on what the user wants, the drillpath is either:

i) Day->Month->CalendarQuarter->CalendarYear, or
ii) Day->Month->FiscalQuarter->FiscalYear

Our data needs to be looked at at these two paths, so I need to be able to
specify both of them.
Does anyone know how to specify multiple drillpaths within a single
dimension table in Analysis Services? Please let me know. I don;t want to
split our time dimension into two separate time dimensions (e.f.,
Dim_FiscalTime and Dim_CalendarTime) just to accomplish this.

Thanks !

Greg