NullProcessing NullProcessing NullProcessing Enum

Definition

Specifies what action Analysis Services takes when it encounters a Null value in a data item.

public enum class NullProcessing
[System.Runtime.InteropServices.Guid("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")]
public enum NullProcessing
Public Enum NullProcessing
Inheritance
NullProcessingNullProcessingNullProcessing
Attributes

Fields

Automatic Automatic Automatic 4

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

Error Error Error 1

Null value is illegal in this data item.

Preserve Preserve Preserve 0

Specifies that the Null value is preserved.

UnknownMember UnknownMember UnknownMember 2

Specifies that the Null value is treated as the unknown member. This value is applicable only for attribute key columns.

ZeroOrBlank ZeroOrBlank 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