Many-to-many in attribute relationship
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:
- Top level: attribute1
- 2nd level: attribute2
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:
select attribute2, attribute1, count(*) from dim1 group by attribute2, attribute1