title: Chaining Many-To-Many Dimensional Relationships in SSAS
body: <p>I'm developing a cube in SSAS and attempting to model the following relationships:</p>
  
  <ul>
  <li>Many Facts to 1 Customer </li>
  <li>Many Customers to Many Sales Reps</li>
  <li>Many Sales Reps (Subordinates) to Sales Reps (Managers)</li>
  <li>Each M2M relationship is facilitated by a bridge table which also acts as a fact table in the cube</li>
  </ul>
  
  <p>I have most of this working.  I can slice Facts by Customer and by Sales Rep (Subordinate), but when I add Sales Rep (Manager) to the query it appears to return every subordinate/manager combination regardless of whether or not that relationship exists in the bridge table.</p>
  
  <p>Any ideas as to what I might be doing wrong?</p>