title: Analysis Services Error: 'table that is required for a join cannot be reached'
body: <p>In SSAS I have three dimensions one of which relates to a fact table. When I process the dimension with attributes from each of the other two dimensions I get the above error.</p>
  
  <p>There is definitely a join, between the main dimension and the other two dimensions. The primary key in the same dimension i.e book also relates to the other book foreign keys in the other dimensions.</p>
  
  <p>If I script with two joins it works but SSAS doesn't seem to pick this up.</p>
  
  <p>I have looked at previous posts and tried their recomendation but they are not appropriate for my issue it seems.</p>