NullProcessing Element (ASSL)

Defines how null values are processed.

Syntax

<DataItem>
   ...
   <NullProcessing>...</NullProcessing>
   ...
</DataItem>

Characteristic	Description
Data type and length	String (enumeration)
Default value	Automatic
Cardinality	0-1: Optional element that can occur once and only once.

Relationship	Element
Parent element	DataItem
Child elements	None

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

Value	Description
Preserve	Preserves the null value.
Error	Raises a null key error. The value of NullKeyNotAllowed determines how the instance reacts to the error. Note This value is not supported for measures.
UnknownMember	Generates an unknown member and raises a null conversion error. The value of NullKeyConvertedToUnknown determines how the instance reacts to the error. Note This value is not supported for columns associated with measures.
ZeroOrBlank	Converts the null value to zero (for numeric data items) or a blank string (for string data items). Note This value provides compatibility with previous versions of Microsoft SQL Server Analysis Services.
Automatic	Uses the default processing appropriate for the element: ZeroOrBlank for OLAP data items. UnknownMember for data mining data items.

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