Condividi tramite


Enumerazione NullProcessing

Specifies what action SQL Server 2005 Analysis Services (SSAS) takes when it encounters a Null value in a data item.

Spazio dei nomi  Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

Sintassi

'Dichiarazione
<GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")> _
Public Enumeration NullProcessing
'Utilizzo
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

Membri

Nome membro Descrizione
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.

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

Osservazioni

Novità:   17 luglio 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.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.AnalysisServices