0

When I try to process my cube and specifically the Employee_DIM, I get the following error :

Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_Employee_DIM', Column: 'Firstname', Value: 'Aurélie'. The attribute is 'Firstname'.

I think that duplicate values for the column Firstname are considered as keys. After checking with the Employee_DIM : 

 SELECT [Firstname], COUNT([Firstname]) AS dup_count
     FROM [Database].[dbo].[Employee]
        GROUP BY [Firstname]
             HAVING (COUNT([Firstname]) > 1)
                ORDER BY [Firstname]

enter image description here

Is there any alternative to leave only the business key in Employee_DIM and get Lastname and Firstname without adding them in the dimension for a future use?

Improve this question

1 Answer 1

Reset to default
-1

You can find the solution here : Errors in the OLAP storage engine: A duplicate attribute key has been found when processing

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.