title: In SSAS, can you ignore table relationships at the cube level?
body: <p>We have a situation where, because OLAP is using a single DataSource view for all cubes, some of our aggregations are getting confused.</p>
  
  <p>The problem is the following:
    - Multiple fact tables join to another table to make a dimension
    - Another fact table joins to those fact tables to make dimensions
    - OLAP doesn't know which join to follow and picks the wrong one</p>
  
  <p>Here is how our cubes are defined</p>
  
  <pre><code>Cube A:
  [FactTable A]-&gt;[Dim A]
  
  Cube B:
  [FactTable B]-&gt;[Dim A]
  
  Cube C:
  [FactTable C]
      |---------&gt;[FactTable A]-&gt;[Dim A]
      |---------&gt;[FactTable B]        
  </code></pre>
  
  <p>Because of this the datasource view looks like this:</p>
  
  <pre><code>[FactTable C]
      |---------&gt;[FactTable A]-&gt;[Dim A]
      |---------&gt;[FactTable B]-&gt;[Dim A]
  </code></pre>
  
  <p>OLAP doesn't know how to aggregate Dim A. Is there a way to ignore that join for Cube C? Can you define the relations at the cube level alone?</p>