SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Programming Reference

Analysis Services Administration Programming

Analysis Management Objects (AMO)

AMO Managed Programming Reference Documentation

AMO Class Library

Microsoft.AnalysisServices

Account Class

AccountCollection Class

AccountTypes Class

Action Class

ActionCollection Class

ActionInvocation Enumeration

ActionTargetType Enumeration

ActionType Enumeration

AddEventArgs Class

Aggregation Class

AggregationAttribute Class

AggregationAttributeCollection Class

AggregationCollection Class

AggregationDesign Class

AggregationDesignAttribute Class

AggregationDesignAttributeCollection Class

AggregationDesignCollection Class

AggregationDesignDimension Class

AggregationDesignDimensionCollection Class

AggregationDimension Class

AggregationDimensionCollection Class

AggregationFunction Enumeration

AggregationInstance Class

AggregationInstanceAttribute Class

AggregationInstanceAttributeCollection Class

AggregationInstanceCollection Class

AggregationInstanceDimension Class

AggregationInstanceDimensionCollection Class

AggregationInstanceMeasure Class

AggregationInstanceMeasureCollection Class

AggregationType Enumeration

AggregationUsage Enumeration

AlgorithmParameter Class

AlgorithmParameterCollection Class

AllowedBindingsHelper Class

AmoException Class

AnalysisState Enumeration

Annotation Class

AnnotationCollection Class

AnnotationVisibility Enumeration

AssemblyCollection Class

AssemblyReferencesHelper Class

AttributeBinding Class

AttributeBindingType Enumeration

AttributePermission Class

AttributePermissionCollection Class

AttributeRelationship Class

AttributeRelationshipCollection Class

AttributeTranslation Class

AttributeTranslationCollection Class

AttributeType Enumeration

AttributeUsage Enumeration

BackupInfo Class

BackupLocation Class

BackupLocationCollection Class

Binding Class

BindingCollection Class

CalculatedMeasureBinding Class

CalculationProperty Class

CalculationPropertyCollection Class

CalculationType Enumeration

CalendarType Enumeration

Cardinality Enumeration

CellPermission Class

CellPermissionAccess Enumeration

CellPermissionCollection Class

ClrAssembly Class

ClrAssemblyFile Class

ClrAssemblyFileCollection Class

ClrAssemblyFileType Enumeration

CollectionChangeEventArgs Class

CollectionChangeEventHandler Delegate

ColumnBinding Class

ComAssembly Class

Command Class

CommandCollection Class

ConnectionException Class

ConnectionExceptionCause Enumeration

ConnectionInfo Class

ConnectionStringSecurity Enumeration

ConnectionType Enumeration

Cube Class

CubeAttribute Class

CubeAttributeBinding Class

CubeAttributeCollection Class

CubeCollection Class

CubeDimension Class

CubeDimensionBinding Class

CubeDimensionCollection Class

CubeDimensionPermission Class

CubeDimensionPermissionCollection Class

CubeHierarchy Class

CubeHierarchyCollection Class

CubePermission Class

CubePermissionCollection Class

DataAggregationMode Enumeration

DatabaseCollection Class

DatabasePermission Class

DatabasePermissionCollection Class

DataItemCollection Class

DataMiningMeasureGroupDimension Class

DataSource Class

DataSourceCollection Class

DataSourceIsolation Enumeration

DataSourcePermission Class

DataSourcePermissionCollection Class

DataSourceView Class

DataSourceViewBinding Class

DataSourceViewCollection Class

DegenerateMeasureGroupDimension Class

DependenciesCalculator Class

DependencyResult Class

DependencyType Enumeration

DesignAggregationsResult Class

Dimension Class

DimensionAttribute Class

DimensionAttributeCollection Class

DimensionBinding Class

DimensionCollection Class

DimensionPermission Class

DimensionPermissionCollection Class

DimensionStorageMode Enumeration

DimensionType Enumeration

DiscretizationMethod Enumeration

DrillThroughAction Class

DropOptions Enumeration

DsvTableBinding Class

ErrorConfiguration Class

ErrorOption Enumeration

ErrorPriority Enumeration

FiscalYearName Enumeration

Group Class

GroupCollection Class

GroupingBehavior Enumeration

HideIfValue Enumeration

Hierarchy Class

HierarchyCollection Class

HierarchyUniqueNameStyle Enumeration

IConnectionStringHolder Interface

IDeserializationStartCallback Interface

IMajorObject Interface

IModelComponent Interface

IModelComponentCollection Interface

ImpactAnalysisType Enumeration

ImpactDetail Class

ImpactDetailCollection Class

ImpersonationInfo Class

ImpersonationInfoSecurity Enumeration

ImpersonationLevel Enumeration

ImpersonationMode Enumeration

INamedComponent Interface

INamedComponentCollection Interface

IncrementalProcessingNotification Class

IncrementalProcessingNotificationCollection Class

InheritedBinding Class

InstanceSelection Enumeration

IntegratedSecurity Enumeration

InvalidXmlCharacters Enumeration

IProcessable Interface

ITrace Interface

KeyErrorAction Enumeration

KeyErrorLimitAction Enumeration

Kpi Class

KpiCollection Class

Level Class

LevelCollection Class

MajorObject Class

MajorObjectCollection Class

ManyToManyMeasureGroupDimension Class

MdxMissingMemberMode Enumeration

MdxScript Class

MdxScriptCollection Class

Measure Class

MeasureBinding Class

MeasureCollection Class

MeasureDataType Enumeration

MeasureEnumerator Class

MeasureGroup Class

MeasureGroupAttribute Class

MeasureGroupAttributeCollection Class

MeasureGroupAttributeType Enumeration

MeasureGroupBinding Class

MeasureGroupCollection Class

MeasureGroupDimension Class

MeasureGroupDimensionBinding Class

MeasureGroupDimensionCollection Class

MeasureGroupType Enumeration

MembersWithData Enumeration

MemberUniqueNameStyle Enumeration

MiningModel Class

MiningModelAlgorithms Class

MiningModelCollection Class

MiningModelColumn Class

MiningModelColumnCollection Class

MiningModelColumnUsages Class

MiningModelingFlags Class

MiningModelPermission Class

MiningModelPermissionCollection Class

MiningStructure Class

MiningStructureCacheMode Enumeration

MiningStructureCollection Class

MiningStructureColumn Class

MiningStructureColumnCollection Class

MiningStructureColumnContents Class

MiningStructureColumnDiscretizationMethods Class

MiningStructureColumnDistributions Class

MiningStructureColumnTypes Class

MiningStructurePermission Class

MiningStructurePermissionCollection Class

ModelComponent Class

ModelComponentCollection Class

MoveEventArgs Class

NamedComponent Class

NamedComponentCollection Class

NotificationTechnique Enumeration

NullProcessing Enumeration

ObjectReference Class

OlapDataSource Class

OleDbTypeConverter Class

OperationException Class

OptimizationType Enumeration

Optionality Enumeration

OrderBy Enumeration

OutOfSyncException Class

OverrideBehavior Enumeration

Partition Class

PartitionCollection Class

PartitionType Enumeration

Permission Class

PermissionSet Enumeration

PersistenceType Enumeration

Perspective Class

PerspectiveAction Class

PerspectiveActionCollection Class

PerspectiveAttribute Class

PerspectiveAttributeCollection Class

PerspectiveCalculation Class

PerspectiveCalculationCollection Class

PerspectiveCalculationType Enumeration

PerspectiveCollection Class

PerspectiveDimension Class

PerspectiveDimensionCollection Class

PerspectiveHierarchy Class

PerspectiveHierarchyCollection Class

PerspectiveKpi Class

PerspectiveKpiCollection Class

PerspectiveMeasure Class

PerspectiveMeasureCollection Class

PerspectiveMeasureGroup Class

PerspectiveMeasureGroupCollection Class

ProactiveCaching Class

ProactiveCachingAggregationStorage Enumeration

ProactiveCachingBinding Class

ProactiveCachingIncrementalProcessingBinding Class

ProactiveCachingInheritedBinding Class

ProactiveCachingObjectNotificationBinding Class

ProactiveCachingOnlineMode Enumeration

ProactiveCachingQueryBinding Class

ProactiveCachingTablesBinding Class

ProcessableMajorObject Class

ProcessingGroup Enumeration

ProcessingMode Enumeration

ProcessType Enumeration

ProtectionLevel Enumeration

ProtocolFormat Enumeration

QueryBinding Class

QueryNotification Class

QueryNotificationCollection Class

ReadAccess Enumeration

ReadDefinitionAccess Enumeration

ReadSourceDataAccess Enumeration

ReferenceDimensionMaterialization Enumeration

ReferenceMeasureGroupDimension Class

RefreshPolicy Enumeration

RefreshType Enumeration

RegularMeasureGroupDimension Class

RelationalDataSource Class

RelationshipType Enumeration

RemoveEventArgs Class

ReportAction Class

ReportingWeekToMonthPattern Enumeration

ReportParameter Class

ReportParameterCollection Class

ResponseFormatException Class

RestoreFolder Class

RestoreFolderCollection Class

RestoreInfo Class

RestoreLocation Class

RestoreLocationCollection Class

RestoreSecurity Enumeration

Role Class

RoleCollection Class

RoleMember Class

RoleMemberCollection Class

RootIfValue Enumeration

RowBinding Class

ScalarMiningStructureColumn Class

ScriptAction Enumeration

ScriptCacheProcessingMode Enumeration

ScriptErrorHandlingMode Enumeration

ScriptInfo Class

ScriptOptions Enumeration

Server Class

ServerEdition Enumeration

ServerProperty Class

ServerPropertyCategory Enumeration

ServerPropertyCollection Class

SessionTrace Class

StandardAction Class

StorageMode Enumeration

TableBinding Class

TableMiningStructureColumn Class

TableNotification Class

TableNotificationCollection Class

TabularBinding Class

TimeAttributeBinding Class

TimeBinding Class

Trace Class

TraceCollection Class

TraceColumn Enumeration

TraceColumnCollection Class

TraceEvent Class

TraceEventArgs Class

TraceEventClass Enumeration

TraceEventCollection Class

TraceEventHandler Delegate

TraceEventSubclass Enumeration

TraceEventSuccess Enumeration

TraceStopCause Enumeration

TraceStoppedEventArgs Class

TraceStoppedEventHandler Delegate

Translation Class

TranslationCollection Class

TransportCompression Enumeration

Trimming Enumeration

UnknownMemberBehavior Enumeration

UpdateMode Enumeration

UpdateOptions Enumeration

UserDefinedGroupBinding Class

Utils Class

ValidationError Class

ValidationErrorCodes Class

ValidationErrorCollection Class

WriteAccess Enumeration

WriteBackTableCreation Enumeration

XmlaError Class

XmlaMessage Class

XmlaMessageCollection Class

XmlaMessageLocation Class

XmlaRequestType Enumeration

XmlaResult Class

XmlaResultCollection Class

XmlaWarning Class

XmlaWarningCollection Class

XmlSerializationException Class

Minimize

This topic has not yet been rated - Rate this topic

NullProcessing Enumeration

SQL Server 2005

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)

[GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A")] 
public enum NullProcessing

/** @attribute GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A") */ 
public enum NullProcessing

GuidAttribute("23CE68CA-EEC2-4488-93A9-2E9A20C2C17A") 
public enum NullProcessing

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

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.

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.

Reference

Microsoft.AnalysisServices Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.