Thursday, September 29, 2011

Analysis Services - A duplicate attribute key has been found when processing

 

When you get a warning like the following when processing an Analysis Services Cube, it will usually be related to other errors in Processing. 

image

This has something to do with trimming in char columns.  To fix the problem, go into the properties of the offending column, and change Trimming to None:

image