Rog R
asked on
SSAS - Receiving duplicate attribute key error
SSAS - Cube Processing - Failing with the following error.
The error is originating from one of the Dimension. This dimension is based off of a fact table (instead of a dimension table). Therefore, duplicates always exists for fields such as city, state etc.
The cube was processing successfully for a long time and failing all of a sudden. The above duplicate error appears to be misleading.
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: TableName Column: 'ColumnName', Value: 'Value'. The attribute is 'AttributeName'.
The error is originating from one of the Dimension. This dimension is based off of a fact table (instead of a dimension table). Therefore, duplicates always exists for fields such as city, state etc.
The cube was processing successfully for a long time and failing all of a sudden. The above duplicate error appears to be misleading.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Please read up here as it might help you out.
Cheers