NullProcessing Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies what action Analysis Services takes when it encounters a Null value in a data item.
[System.Runtime.InteropServices.Guid("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")]
public enum NullProcessing[<System.Runtime.InteropServices.Guid("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")>]
type NullProcessing = Public Enum NullProcessing- Inheritance
-
NullProcessing
- Attributes
Fields
| Name | Value | Description |
|---|---|---|
| Preserve | 0 | Specifies that the Null value is preserved. |
| Error | 1 | Null value is illegal in this data item. |
| UnknownMember | 2 | Specifies that the Null value is treated as the unknown member. This value is applicable only for attribute key columns. |
| ZeroOrBlank | 3 | Specifies that the Null value is converted to zero (for numeric data items) or blank string (for string data items). |
| Automatic | 4 | Specifies that for the Cube or Dimension data items, Null values are treated as ZeroOrBlank. |
Remarks
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.