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

NullKeyNotAllowed Element (ASSL)

Determines how the Microsoft SQL Server Analysis Services processing engine handles a null key error encountered during processing.


<ErrorConfiguration>
   ...
   <NullKeyNotAllowed>...</NullKeyNotAllowed>
   ...
</ErrorConfiguration>

Characteristic

Description

Data type and length

String (enumeration)

Default value

ReportAndContinue

Cardinality

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

Relationship

Element

Parent element

ErrorConfiguration

Child elements

None

Null key errors occur when a null value is encountered in a key column in which null values are not allowed, forcing the record to be discarded during processing. However, this error occurs only if the NullProcessing element for the DataItem ancestor of the ErrorConfiguration parent element is set to Error.

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

Value

Description

IgnoreError

Processing ignores the error and continues.

ReportAndContinue

Processing reports the error and continues.

ReportAndStop

Processing reports the error and stops.

The enumeration that corresponds to the allowed values for NullKeyNotAllowed 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

ADD
Show:
© 2014 Microsoft. All rights reserved.