Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.