KeyErrorAction Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Specifies the action for Microsoft SQL Server Analysis Services to take when an error occurs on a key.

  
<ErrorConfiguration>  
   ...  
      <KeyErrorAction>...</KeyErrorAction>  
   ...  
</ErrorConfiguration>  

CharacteristicDescription
Data type and lengthString (enumeration)
Default valueConvertToUnknown
Cardinality0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementErrorConfiguration
Child elementsNone

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

ValueDescription
ConvertToUnknownConvert the problem key to the unknown member value.
DiscardRecordDiscard the record.

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

Properties (ASSL)

Community Additions

ADD
Show: