NullProcessing Element (ASSL)
Defines how null values are processed.
Syntax
<DataItem>
...
<NullProcessing>...</NullProcessing>
...
</DataItem>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data type and length | String (enumeration) |
| Default value | Automatic |
| Cardinality | 0-1: Optional element that can occur once and only once. |
Element Relationships
| Relationship | Element |
|---|---|
| Parent element | DataItem |
| Child elements | None |
Remarks
The value of this element is limited to one of the strings listed in the following table.
| Value | Description |
|---|---|
| Preserve | Preserves the null value. Note: This value is not supported for distinct count measures. |
| 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 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.