Monday, 6 February 2012

Processing a SSAS cube after dimension changes


If you change the dimensions and fail to process the SSAS database fully, you may get an error similar to this:

Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: '<table>', Column: '<column>', Value: '<value>'. The attribute is '<attribute name>'. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: <attribute name> of Dimension: <dimension name> from Database: <database>, Cube: <cube>, Measure Group: <measure group>, Partition: <partition>, Record: <record number>.

Processing the cube does not automatically process the dimensions. 
If you have changed the dimensions, then you should process the database.

No comments:

Post a Comment