Export (0) Print
Expand All
Expand Minimize

NullProcessing Enumeration

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
AutomaticSpecifies that for the Cube or Dimension data items, Null values are treated as ZeroOrBlank.

And for MiningStructure or MiningModel data items, Null values are treated as UnknownMember.

ErrorNull value is illegal in this data item.
PreserveSpecifies that the Null value is preserved.
UnknownMemberSpecifies that the Null value is treated as the unknown member. This value is applicable only for attribute key columns.
ZeroOrBlankSpecifies 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft