Processing using Snapshot Isolation in Analysis Services (SSAS)
User Rating: / 0
Written by Gautham Kamath   
Tuesday, 28 February 2012 22:14

Just a few months ago I was hit with an issue of dimension processing failure. The error read

Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: '<>', Column: '<>', Value: 'XXXXXXX'. The attribute is '<>'.

On investigation I found that constant updates to the dimension were the main cause. One of my dimensions had as many as 15 attributes and the processing failed when any update occurred during dimension processing. Generally speaking, the first attribute's SELECT DISTINCT statement would conflict with the SELECT DISTINCTs of other attributes because of the constant update.




Pyramid Analytics