title: Cube Design - Bridge Tables for Many To Many mapping with additional column
body: <p>Am making a cube in SQL Server Analysis Services 2005 and have a question about many to many relationships.</p>
  
  <p>I have a many to many relationship between two entities that contains an additional descriptive column as part of the relationship. </p>
  
  <p>I understand that I may need to a bridge table to model the relationship but I am not sure where to store the additional column - in the bridge table or elsewhere?</p>