title: Self-Join in SSAS
body: <p>I have a table like this:</p>
  
  <pre><code>PersonId    Job    City    ParentId
  ---------   ----   -----   --------
  101          A      C1      105
  102          B      C2      101
  103          A      C1      102
  </code></pre>
  
  <p>Then I need to getting the association rules between <strong>Person's job</strong> and <strong>parent's city</strong>.</p>
  
  <p>I've used self-referencing and define case/nested tables but at the result of dependency graph there is no difference between person's job or city and parent's job or city!</p>
  
  <p>What is the best solution for this problem in SSAS project?</p>