When I try to create a new dimension (from visual studio 2005) using the Dimension Wizard, after selecting the related tables and clicking next, visual studio hangs. CPU hits 100%. It seems to only happen when I add one particular table to the dimension. The only thing "special" about this table is that it has a many-to-many relationship with one of the other related tables. When I removed one of the relationships the dimension created successfully. Is this the correct behaviour? Should multiple relationship cause this kind of problem?
If you were trying to include a many to many relationship within the one dimension I would guess that the wizard is scanning your tables trying to figure out which attribute is the "parent" of the other (which does not make sense for a many to many relationship).
If you take the classic many to many example of bank accounts and account owners, in SSAS 2005 these are each separate dimensions and they are related by an intermediate measure group. Maybe you need to split your dimension up.
No comments:
Post a Comment