title: Handling duplicate values in Business Intelligence Studio Cube dimensions
body: <p>I have a Cube dimension which has a relationship between tier and market.  </p>
  
  <p><img src="https://i.stack.imgur.com/hecGN.jpg" alt="enter image description here"></p>
  
  <p>They are contained in the same table, with structure id, tier, market. However, when I create the dimension, it's showing a row in member properties for EACH row in the table. Is there any way to construct this again so that it becomes :<br>
  Tier1<br>
  Tier2<br>
  Tier3<br>
  with the markets listed underneath each relevant tier when I expand it?</p>