We have YTD business intellegence time calculations in our cube. Here we have set YTD calculations for two time hierarchies TimeMonthHierarchy - Year-Qtr-Month-Date and TimeWeekHierarchy - Year-Week.
When I use two hierarchies seperately I get accurate figures for YTD but when I use both these hierarchies together it do not work as expected. Also at every month start - YTD restarts.
Please look at the discrepancy below: