NullProcessing Enum

Definition

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

Automatic 4

Specifies that for the Cube or Dimension data items, Null values are treated as ZeroOrBlank.

Error 1

Null value is illegal in this data item.

Preserve 0

Specifies that the Null value is preserved.

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).

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.

Applies to