TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

NullProcessing Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Defines how null values are processed.

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

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

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

ValueDescription
PreservePreserves the null value.

Note: This value is not supported for distinct count measures.
ErrorRaises a null key error. The value of NullKeyNotAllowed determines how the instance reacts to the error.

Note: This value is not supported for measures.
UnknownMemberGenerates 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.
ZeroOrBlankConverts 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 MicrosoftSQL ServerAnalysis Services.
AutomaticUses 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.

Properties (ASSL)

Community Additions

ADD
Show:
© 2016 Microsoft