I want to create two financeial years in single dimension [Months dimension]
1.First financial year: apr to Mar
2. Another financial year: Sep to Oct
how can i create two financial year in one dimension?
if i create A and B hierarchies then which hierarchy i need to load data?
as of my knowledge with help of shared member we can create another financial hierarchy in months dimension.Is it correct? if i am wrong please suggest the better way to do this scenario.
you are right, you can build the first structure with stored members. Then you can build the second structure using shared members which will occurr another time. The stored members need to appear in the outline above the shared ones.
Do not forget to put a tilde, so there are no double counting of values.