|Many-to-many in attribute relationship|
|Written by Vincent Rainardi|
|Tuesday, 05 January 2010 23:07|
In SSAS cube there is a potential that hierarchies are not working correctly because of attribute relationship. Say in the cube we have a hierarchy consisting of:
We also have an attribute relationship that links attribute1 to attribute2. If you click + on attribute2, you can see attribute1 appears ‘under’ attribute2.
And the data in the dim table is as follows: