title: dimension hierarchy in SSAS (multiple relationships?)
body: <p>I have a fact table with columns Product Model and measure Installed base(not important, any other measure would do the same).</p>
  
  <p>Than I have dimension table, and here comes the tricky part:</p>
  
  <p>I have many product models, and each belong to higher level custom_groups (4 in total),
  Same product model may belong to more than one custom groupX, and custom groupX may belong to more than one custom groups X-1.</p>
  
  <p>for example hierarchy from highest CG1 to lowest PM Level:</p>
  
  <ul>
  <li>XXX=>YYY=>ZZZ=>WWW </li>
  <li>LLL=>MMM=>QQQ=>WWW</li>
  <li>RRR=>PPP=>QQQ=>TTT</li>
  </ul>
  
  <p>you can see, that last level PM WWW belongs to 2 different custom groups 3 (QQQ and ZZZ) whereas custom group 3 QQQ may belong to two different custom groups 2 (MMM and PPP in this case).</p>
  
  <p>I tried to model this via hierarchies in SSAS but either I got wrong measure results (IB is summed up without aggregations and results are same for all custom groups), or I get missing some custom groups in my hierarchy.</p>