Friday, February 18, 2011

Errors in the OLAP storage engine: The attribute key cannot be found when processing table

Error Message in SSAS:
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'factTable', Column: 'columnName', Value: 'value'; 

Solution 1: Remove bad records
I am using test data, so I simply ran this query:
DELETE FROM factTable
WHERE columnName NOT IN (SELECT columnName FROM dimensionTable)
To get rid of error-causing records, and then re-processed the cube.
Solution 2: Find and correct bad records
If you want 100% accuracy in your analysis, then you'll need to fix these records. To do that, find records that would cause these errors:
SELECT columnName FROM factTable
WHERE columnName NOT IN (SELECT columnName FROM dimensionTable)
Next, you'll want to add records in the dimensionTable for these records you found.

References
  1. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64035 
  2. http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/971e3e6b-a1a7-4a19-95af-78ef21d11678
  3. http://www.sqldev.org/sql-server-analysis-services/olap-cube-processing-the-attribute-key-cannot-be-found-12897.shtml

No comments:

Post a Comment

There was an error in this gadget