Report Portal

Processing using Snapshot Isolation in Analysis Services (SSAS)

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.

Read more...

Tags: management, process

 

2007-2015 VidasSoft Systems Inc.