Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

KeyDuplicate Element (ASSL)

Determines how Microsoft SQL Server 2005 Analysis Services (SSAS) handles a duplicate key error if it encounters one during processing.


Characteristic Description

Data type and length

String (enumeration)

Default value



0-1: Optional element that can occur once and only once.

Relationship Element

Parent element


Child elements


Duplicate key errors are generated only during dimension processing, when an attribute key is encountered more than once. Because attribute keys must be unique, Analysis Services discards the duplicate records. Duplicate key errors typically indicate a flaw in the design of the dimension, specifically in the relationships between attributes.

The value of this element is limited to one of the strings in the following table.

Value Description


Processing should ignore the error and continue.


Processing should report the error and continue.


Processing should report the error and stop.

The enumeration that corresponds to the allowed values for KeyDuplicate in the Analysis Management Objects (AMO) object model is ErrorOption.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.