SQL Server - Duplicate Attribute Key Found in SSAS

Asked By Cindy Mikeworth

16-Nov-09 10:09 AM

I am fairly new to SSAS 2008, and am having some challenges with duplicates
in my dimensions.  When I was working with just a customer master table, the
dimension processed fine.  When I linked in an address table, I am now
getting duplication errors.  The customer master table (CustMstr) has the
primary key of customer number, and also contains a primary bill-to address
id.  I am linking this table to a customer address table (CustAddr), where
the primary key is both customer number and address id.  I have pulled fields
from both of these tables for dimensions.  I opened the properties of the
Customer Number and added the primary billto as the second part of the key
column collection, and selected customer number as the name column.

When I process the dimension I get the following error: A duplicate
attribute key has been found when processing table CustMstr Column Custnmbr
Value 1000 Table CustMstr Column PrimBillTo Value Primary.  The attribute is
Customer Number.

Looking at the source data, my CustMstr table has one entry for 1000, with a
Primary Bill To Value of Primary.  In the CustAddr table, I have 4 records
for Customer 1000, but only one with a Customer Address ID of Primary.

What am I missing here?

06-Dec-09 02:12 PM

s
, the
he
ss
re
elds
he
y
br
te is
h a
rds

You can set the dim processing to ignore duplicates, but if you do
this, make sure that somewhere else in your ETL you have data-quality
checks to prevent any problems.  I'd look at this as a last, but
workable, resort.

Preferable, and depending on your dimension relationship designs, a
redesign of your dimension relationship structures would eliminate
this SSAS message.