title: SSAS: Errors in the OLAP storage engine: The attribute key cannot be found when processing
body: <p>In my searching, I have seen this error text been asked in different contexts, but specifically, I want to know if I am missing something here.</p>
  
  <p>In a basic setup, I have 1 measure table and 1 dimension table in my DSV. In my test, the measure table has about half of the sold products, but the dimension table has info on the entire product catalog.</p>
  
  <p>The relationship has the measure table as the foreign key and the dimension as the primary. Case is not an issue as both are integers. </p>
  
  <p>What am I doing wrong? I have tried reversing the relationship and I always process the dimension in full before processing the cube in full whenever I make a change. </p>
  
  <p>To avoid the errors, I can set the ignore key errors thing or ensure that the dimension only contains the products that the measure contains. I can do the latter, but I feel that using an unfiltered reference table is cleaner and more efficient - it's on that note that I say "am I missing something?" </p>