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 Services Scripting Language (ASSL)

Analysis Services Scripting Language Reference

Analysis Services Scripting Language XML Elements

Properties

Account Element (ImpersonationInfo)

AccountType Element

ActionID Element

Administer Element

AggregateFunction Element

AggregationDesignID Element

AggregationFunction Element

AggregationID Element

AggregationInstanceSource Element

AggregationPrefix Element

AggregationStorage Element

AggregationType Element

AggregationUsage Element

Algorithm Element

Alias Element

AllMemberAggregationUsage Element

AllMemberName Element

AllowBrowsing Element

AllowDrillThrough Element

AllowDuplicateNames Element

AllowedSet Element

Application Element

AssociatedMeasureGroupID Element

AttributeAllMemberName Element

AttributeHierarchyDisplayFolder Element

AttributeHierarchyEnabled Element

AttributeHierarchyOptimizedState Element

AttributeHierarchyOrdered Element

AttributeHierarchyVisible Element

AttributeID Element

Audit Element

AutoRestart Element

BackColor Element

CacheMode Element

CalculationReference Element

CalculationType Element

CalendarEndDate Element

CalendarLanguage Element

CalendarStartDate Element

Caption Element

CaptionIsMdx Element

Cardinality Element

CaseCubeDimensionID Element

ClassifiedColumnID Element

Collation Element

ColumnID Element (ColumnBinding)

ColumnID Element (EventColumn)

Condition Element

ConnectionString Element

ConnectionStringSecurity Element

Content Element

CreatedTimestamp Element

CubeDimensionID Element

CurrentStorageMode Element

CurrentTimeMember Element

DataAggregation Element

DatabaseID Element

DataSize Element

DataSourceID Element

DataSourceImpersonationInfo Element

DataSourceViewID Element

DataType Element

DbSchemaName Element

DbTableName Element

Default Element

DefaultMeasure Element

DefaultMember Element

DefaultScript Element

DefaultValue Element

DeniedSet Element

DependsOnDimensionID Element

Description Element

DimensionID Element

DiscretizationBucketCount Element

DiscretizationMethod Element

DisplayFlag Element

DisplayFolder Element

Distribution Element

Edition Element

Enabled Element

EndOfData Element

EstimatedCount Element

EstimatedPerformanceGain Element

EstimatedRows Element

EstimatedSize Element

EventID Element

Expression Element

Filter Element (Binding)

Filter Element (Trace)

FirstDayOfWeek Element

FiscalFirstDayOfMonth Element

FiscalFirstMonth Element

FiscalYearName Element

FontFlags Element

FontName Element

FontSize Element

ForceRebuildInterval Element

ForeColor Element

FormatString Element

Goal Element

GranularityAttributeID Element

HideMemberIf Element

HierarchyID Element

HierarchyUniqueNameStyle Element

ID Element

IgnoreUnrelatedDimensions Element

ImpersonationInfo Element

ImpersonationInfoSecurity Element

ImpersonationMode Element

InstanceSelection Element

IntermediateCubeDimensionID Element

IntermediateGranularityAttributeID Element

InvalidXmlCharacters Element

Invocation Element

IsAggregatable Element

IsKey Element

Isolation Element

KeyDuplicate Element

KeyErrorAction Element

KeyErrorLimit Element

KeyErrorLimitAction Element

KeyErrorLogFile Element

KeyNotFound Element

KeyUniquenessGuarantee Element

KpiID Element

Language Element

LastProcessed Element

LastSchemaUpdate Element

LastUpdate Element

Latency Element

LogFileAppend Element

LogFileName Element

LogFileRollover Element

LogFileSize Element

ManagedProvider Element

ManufacturingExtraMonthQuarter Element

ManufacturingFirstMonth Element

ManufacturingFirstWeekOfMonth Element

MasterDatasourceID Element

Materialization Element

MaxActiveConnections Element

MdxMissingMemberMode Element

MeasureExpression Element

MeasureGroupID Element

MeasureID Element

MeasureQualification Element

MemberNamesUnique Element

MemberUniqueNameStyle Element

MembersWithData Element

MembersWithDataCaption Element

MimeType Element

MiningModelID Element

Name Element

NamingTemplate Element

NonEmptyBehavior Element

NotificationTechnique Element

NullKeyConvertedToUnknown Element

NullKeyNotAllowed Element

NullProcessing Element

OnlineMode Element

OptimizedState Element

Optionality Element

OrderBy Element

OrderByAttributeID Element

Ordinal Element

OverrideBehavior Element

PartitionID Element

Password Element

Path Element

PendingValue Element

PermissionSet Element

Persistence Element

Process Element

ProcessingMode Element

ProcessingPriority Element

ProcessingQuery Element

ProductName Element

Query Element

QueryDefinition Element

Read Element

ReadDefinition Element

ReadSourceData Element

RefreshInterval Element

RefreshPolicy Element

RelationshipType Element

RemoteDatasourceID Element

ReportingFirstMonth Element

ReportingFirstWeekOfMonth Element

ReportingWeekToMonthPattern Element

ReportServer Element

RequiresRestart Element

Root Element

RootMemberIf Element

ScriptCacheProcessingMode Element

SilenceInterval Element

SilenceOverrideInterval Element

Slice Element

SolveOrder Element

Source Element (Binding)

Source Element (ComAssembly)

Source Element (Measure)

SourceAttributeID Element

SourceColumnID Element

State Element

StatusGraphic Element

StopTime Element

StorageLocation Element

StorageMode Element

TableID Element

TargetType Element

Text Element

Timeout Element

Trend Element

TrendGraphic Element

Trimming Element

Type Element (Action)

Type Element (Binding)

Type Element (ClrAssemblyFile)

Type Element (Dimension)

Type Element (DimensionAttribute)

Type Element (MeasureGroup)

Type Element (MeasureGroupAttribute)

Type Element (MiningStructureColumn)

Type Element (Partition)

Type Element (PerspectiveCalculation)

UnknownMember Element

UnknownMemberName Element

Usage Element (DimensionAttribute)

Usage Element (MiningModelColumn)

Value Element

Version Element

Visibility Element

Visible Element

VisualTotals Element

Write Element

WriteEnabled Element

Minimize

This topic has not yet been rated - Rate this topic

NullProcessing Element (ASSL)

SQL Server 2005

SQL Server 2012

Defines how null values are processed.


<DataItem>
   ...
   <NullProcessing>...</NullProcessing>
   ...
</DataItem>

Element Characteristics

Characteristic	Description
Data type and length	String (enumeration)
Default value	Automatic
Cardinality	0-1: Optional element that can occur once and only once.

Element Relationships

Relationship	Element
Parent element	DataItem
Child elements	None

The value of this element is limited to one of the strings listed in the following table.

Value

Description

Preserve

Preserves the null value.

Error

Raises a null key error. The value of NullKeyNotAllowed determines how the instance reacts to the error.

This value is not supported for measures.

Note:

UnknownMember

Generates an unknown member and raises a null conversion error. The value of NullKeyConvertedToUnknown determines how the instance reacts to the error.

This value is not supported for columns associated with measures.

Note:

ZeroOrBlank

Converts the null value to zero (for numeric data items) or a blank string (for string data items).

This value provides compatibility with previous versions of Microsoft SQL Server Analysis Services.

Note:

Automatic

Uses the default processing appropriate for the element:

ZeroOrBlank for OLAP data items.
UnknownMember for data mining data items.

The enumeration that corresponds to the allowed values for NullProcessing in the Analysis Management Objects (AMO) object model is NullProcessing.

Reference

Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance

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.