Post reply

A duplicate attribute key has been found

  • February 29, 2016 at 10:13 am

    #150483

    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

    #1863554

    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

    #1958858

    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