Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
|
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. |
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:
|
The enumeration that corresponds to the allowed values for NullProcessing in the Analysis Management Objects (AMO) object model is NullProcessing.