Time dimension having 2 hiearchies - want the intersection
Two hierarchies - Calendar and Financial have been defined on it
The Time dimension is based on the view Time_vw
Attributes are
1. TimeID
2. Year
3. Month
4. Financial Year
5. Financial Month
Financial Year starts from October
i.e. if Calendar time is Year:2007, Month:12 (Dec),
then Financial time is Financial Year:2008, Financial Month:3
Time.Calendar has the following levels
. Year
.. Month
Time.Financial has the following levels
. Financial Year
.. Financial Month
I want the intersections of these two hierarchies
Say, Time.Calendar points to [2008].[2]
Time.Financial points to [2008].[10] (refers to Calendar time Year:2008, Month:7)
I want the resultant set as [2008].[2], [2008].[3], [2008].[4], [2008].[5], [2008].[6], [2008].[7]
[852 byte] By [Sanjay] at [2008-2-19] 