NullProcessing 열거형
Specifies what action SQL Server 2005 Analysis Services(SSAS) takes when it encounters a Null value in a data item.
네임스페이스: Microsoft.AnalysisServices
어셈블리: Microsoft.AnalysisServices(Microsoft.AnalysisServices.dll)
구문
‘선언
<GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")> _
Public Enumeration NullProcessing
‘사용 방법
Dim instance As NullProcessing
[GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")]
public enum NullProcessing
[GuidAttribute(L"23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")]
public enum class NullProcessing
[<GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")>]
type NullProcessing
public enum NullProcessing
멤버
멤버 이름 | 설명 | |
---|---|---|
Preserve | Specifies that the Null value is preserved. | |
Error | Null value is illegal in this data item. | |
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). | |
Automatic | Specifies 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. |
주의
새 항목: 2006년 7월 17일
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.