NullProcessing Enumeration
Updated: May 24, 2016
Specifies what action Analysis Services takes when it encounters a Null value in a data item.
Assembly: Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)
| Member name | Description | |
|---|---|---|
| Automatic | ||
| Error | Null value is illegal in this data item. | |
| Preserve | Specifies that the Null value is preserved. | |
| UnknownMember | Specifies that the Null value is treated as the unknown member. This value is applicable only for attribute key columns. | |
| ZeroOrBlank | Specifies that the Null value is converted to zero (for numeric data items) or blank string (for string data items). |
ZeroOrBlank assigns a zero for numeric data types or blank for string data when null values are encountered.
UnknownMember causes a data integrity error at processing time.
Error causes a data integrity error at processing time and the server will discard the record.
Show: