title: ssas attribute key cannot be found even though it exists and is not due to duplicates
body: <p>I was trying to rebuild my cube after making some changes the other day to the table/column names in the fact and dimension tables.</p>
  
  <p>The process cube action kept returning the following error message:</p>
  
  <blockquote>
    <p>The attribute key cannot be found when processing: Table:
    'MyFactTableName', Column: 'MyDimensionKey', Value: 'SomeValue'. The
    attribute is 'MyDimensionKey'.</p>
  </blockquote>
  
  <p>The other answers to similar questions referred to attributes with duplicate values, and cases where the attribute value was null in the or missing in either the Dimension or the Fact table.</p>
  
  <p>Example related posts are:</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/12544323/ssas-dimension-processing-key-not-found-error">ssas dimension processing key not found error</a>  </li>
  <li><a href="https://stackoverflow.com/questions/9738803/key-not-found-error">key not found error</a>  </li>
  </ul>
  
  <p>There were no duplicate values in my case and the attribute value was not missing from either the Fact or Dimension table. </p>
  
  <p>Thankfully the information in this post <a href="http://www.sqlservercentral.com/Forums/Topic1219713-17-1.aspx" rel="noreferrer">here</a> solved my problem.</p>
  
  <p>The suggestion was to process the affected Dimension by itself, and then process the affected measure group.</p>
  
  <p>Any idea why this happens, how I could reproduce this? I'd like to know so that I can avoid it next time or so that it doesn't pop up again at a bad time while deploying an upgrade to the production environment.</p>
  
  <p>Thanks in advance for your help.</p>
  
  <p>EDIT: I'm using SSAS-2008, and the error occurred while trying to process the cube from within BIDS-2008.</p>