SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

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
• 2^nd 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