title: SSAS 2012 Using a dimension value to filter other dimension tables
body: <p>I have a Customer table and several other dimension tables that contain a Customer Id.</p>
  
  <p>What I'd like to have is the dimension tables filtered by the top level Customer selection.</p>
  
  <p>So if I have:</p>
  
  <p><strong>Customers</strong><br/>
  Id | Name</p>
  
  <p><strong>DimensionA</strong><br/>
  Id | CustomerId | Value1<br/>
  Id | CustomerId | Value2</p>
  
  <p><strong>DimensionB</strong><br/>
  Id | CustomerId | Value3<br/>
  Id | CustomerId | Value4</p>
  
  <p><strong>Fact</strong><br/>
  Id | DimensionBId | FactValue1 ...<br/>
  Id | DimensionBId | FactValue2 ...</p>
  
  <p>..is it possible to have the CustomerId filtered and trickle down through the dimension values to the fact table?</p>
  
  <p>Or, do I always need to relate Customer to Fact in the Dimension Usage? I can see how I could relate Customer to Fact via DimensionA, but I can only relate it with one intermediary table, not two or more.</p>
  
  <p>Alternatively do I need to actually have CustomerId in the Fact table as well?</p>
  
  <p>Any help would be gratefully received.</p>