Report Portal

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

Read more...

Tags: design, many-to-many

 

2007-2015 VidasSoft Systems Inc.