Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

NullProcessing Enumeration

 

Applies To: SQL Server 2016 Preview

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

Namespace:   Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

[GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")]
public enum NullProcessing

Member nameDescription
Automatic

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

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.

Return to top

Community Additions

Show:
© 2015 Microsoft