NullProcessing Element (ASSL)
Defines how null values are processed.
Syntaxe
<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 |
Notes
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.
.gif "ms127041.note(fr-fr,SQL.90).gif")
Remarque :
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.
Remarque :
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).
Remarque :
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.