Home Forums Data Warehousing Analysis Services Multiple dimensions from 1 table or 1 dimension with multiple hierarchies RE: Multiple dimensions from 1 table or 1 dimension with multiple hierarchies

  • 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?