February 29, 2016 at 10:13 am
I am trying to process Customer dimension form AdventureWorksDW2012 database and getting following error.
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimCustomer', Column: 'FirstName', Value: 'Ramón'. The attribute is 'First Name'.
I am beginner in SSAS, could anyone help please.
Thanks,
March 7, 2016 at 1:24 pm
Hi,
You have to make sure one FirstName has only one unique key.
For example, you cannot have one keyColumns = 1234, which has two members:
NameColumn = 'John X';
NameColumn = 'John Z';
Hope it helpful.
September 10, 2017 at 1:45 am
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimCustomer', Column: 'FirstName', Value: 'Ramón'. The attribute is 'First Name'.
Solution:
select properties for 'FIRST NAME' column avalable in Attributes tab
in properties
go to -> Key Columns ->DimCustomer.FirstName (WChar) ->Collation -> click Ellipsis symbol (...) then 'Define Collation' will open
Collation Designator: Latin 1_General
Sort Order: Select Below order
Case Sensitive
Accent Sensitive
Kana Sensitive
Width Sensitive
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply