title: How to define which join a dimension is using in ssas
body: <p>I have a sales fact table with two dates:  order received and order shipped.</p>
  
  <p>I have a time dimension table in the data source view.  </p>
  
  <p>I have defined two relationships between the time dimension table and the sales fact table, one on order received date and order shipped date.  </p>
  
  <p>In the Cube definition I have two dimensions defined:  one for order date and one for shipping date.  </p>
  
  <p>I have time hierarchy defined for both dimensions (the fiscal calendar).</p>
  
  <p>I can't figure out which relationship either of the dimensions are using.  It would appear that they are both using the join to order received date.  How do I tell SSAS to use the shipping date for one dimension and the order received date for the other.  </p>
  
  <p>Thanks,  --sw</p>