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

NullProcessing Element (ASSL)

Defines how null values are processed.


<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.

This value is not supported for measures.
ms127041.note(en-US,SQL.90).gifNote:

UnknownMember

Generates an unknown member and raises a null conversion error. The value of NullKeyConvertedToUnknown determines how the instance reacts to the error.

This value is not supported for columns associated with measures.
ms127041.note(en-US,SQL.90).gifNote:

ZeroOrBlank

Converts the null value to zero (for numeric data items) or a blank string (for string data items).

This value provides compatibility with previous versions of Microsoft SQL Server Analysis Services.
ms127041.note(en-US,SQL.90).gifNote:

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.