SQL Data Cube

All,

I'm getting the following error when I try and process my SQL data cube:

Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DIM_GEO', Column: 'CITY', Value: 'COLUMBUS'. The attribute is 'CITY'.

How do I correct the issue?
LVL 1
isamesAsked:
Who is Participating?
 
Mark WillsConnect With a Mentor Topic AdvisorCommented:
This is part of the reason why I dont get involved in SSAS, it can be a headache....

Especially this particular error....

Basically you have duplicate values of 'COLUMBUS' but it could be coming from different parents, it could be upper / lower case, it could be a range of things.

Now the reason why I am answering is I have just been reviewing some documentation for a client and came across these two entries :
https://blog.tallan.com/2017/01/10/part-1-analysis-services-multidimensional-a-duplicate-attribute-key-has-been-found-when-processing/ and the one that applies to you is https://blog.tallan.com/2017/03/21/part-2-analysis-services-multidimensional-a-duplicate-attribute-key-has-been-found-when-processing/

Found them to be very good / detailed explanations with "how to find" and fix the error. Well worth reading.
0
 
Máté FarkasConnect With a Mentor Database Developer and AdministratorCommented:
Attribute keys and values must be unique within a Dimension.
Please show us design of your Dimension in SSAS and the result of the following query:
SELECT CITY, * FROM dbo_DIM_GEO WHERE CITY = 'COLUMBUS'

Open in new window

Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.