NullProcessing Enumeration
Specifies what action SQL Server 2005 Analysis Services (SSAS) takes when it encounters a Null value in a data item.
Namespace: Microsoft.AnalysisServices
Assembly: Microsoft.AnalysisServices (in microsoft.analysisservices.dll)
Syntax
'Declaration
<GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")> _
Public Enumeration NullProcessing
[GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")]
public enum NullProcessing
[GuidAttribute(L"23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")]
public enum class NullProcessing
/** @attribute GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A") */
public enum NullProcessing
GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")
public enum NullProcessing
Members
| Member name | Description |
|---|---|
| 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). |
Remarks
New:17 July 2006
ZeroOrBlank is how Analysis Services 2000 handles Null values.
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.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.