Many-to-many in attribute relationship
User Rating: / 0
PoorBest 
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:

  • 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...
 
Comments (1)
1 Wednesday, 06 January 2010 07:04
Vincent Rainardi
wow that was quick! I just wrote it yesterday. It even includes the revision I made last night!
Thanks Vidas,
Vincent

 

Pyramid Analytics