title: Joining two fact tables with common dimensions
body: <p>I get the concept on how to join dimensions to a fact table. However, I am having some difficulties in joining multiple (two) fact tables through common dimension tables. </p>
  
  <p>To be specific, I have a fact table with actual sales figures, and a fact table with budget figures. Each fact table share two dimension tables (a customer table and an item table)</p>
  
  <p>My question is, how do I join the two fact tables through the two dimensions tables? </p>
  
  <p>Please see the attached, simplified example below, which illustrates the result set I am looking for.</p>
  
  <p><img src="https://i.stack.imgur.com/Zn81k.png" alt="Table 1 and 2 are fact tables and table 3 and 4 dimension tables. Table 5 the desired result set."></p>