NullProcessing Enumeration
TOC
Collapse the table of content
Expand the table of content

NullProcessing Enumeration

 

Applies To: SQL Server (starting with 2016)

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. This value is not supported for distinct count measures.

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

Return to top
Show:
© 2016 Microsoft