I hate a date dimension set up with fiscal year, fiscal quarter, and month. There is also an alternate drill-down from calendar year and calendar quarter. They converge on month.
All levels/categories appear as expected in the diagram view.
However, when viewed in analysis studio, there is a folder for dates - a level for fiscal year (as expected), and multiple levels for each individual calendar year. These should be rolled up into one level for calendar year with sub-levels for quarter and month. I am not sure why the fiscal year path is working correctly, but the calendar year is not.
Opening the .mdc with Powerplay displays correctly.
Help please?