I used my time dimension to create 2 different hierarchies, the first consisting of 4 level, the second 3 level. In both cases the toplevel is year. When adding attribute relations 2 relations now converge on the year:
________________--> monthlevel1 --> quarterlevel1
date(key) ________________________________________________ ---> year
________________----------> monthlevel2
No warnings are displayed, but after processing the dimension and browsing the members the 2nd hierarchy makes no sense at all with members randomly missing.
Do I need to add a second year column to avoid the convergion (on to year)
Should I create seperate dimensions each with its own hierarchy?