we have a timebyweek dimension, where week members are base members and on top of that i have month, quarter, year as parents. Also I need to load some data at month level so I have created another hierarachy with month.input members as base. Ex: 2012.Feb.input
In the reports my Evgets for YTD works fine for normal members but YTD for month.input members for last quarters are calculating wrongly. we follow retail year calender which starts with feb and ends with Jan. so my last quarter is nov, dec, Jan.
I have tried using ISbegining property setup to feb as 1.
Any suggestions greatly appreciated. Thanks in advance for help.
Please let me know if you need any more information.