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 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Analysis Services - Multidimensional Data

Technical Reference

Analysis Services Scripting Language Reference

Analysis Services Scripting Language XML Elements (ASSL)

Properties (ASSL)

Access Element (ASSL)

Account Element (ImpersonationInfo) (ASSL)

AccountType Element (ASSL)

ActionID Element (ASSL)

Administer Element (ASSL)

AggregateFunction Element (ASSL)

AggregationDesignID Element (ASSL)

AggregationFunction Element (ASSL)

AggregationID Element (ASSL)

AggregationInstanceSource Element (ASSL)

AggregationPrefix Element (ASSL)

AggregationStorage Element (ASSL)

AggregationType Element (ASSL)

AggregationUsage Element (ASSL)

Algorithm Element (ASSL)

Alias Element (ASSL)

AllMemberAggregationUsage Element (ASSL)

AllMemberName Element (ASSL)

AllowBrowsing Element (ASSL)

AllowDrillThrough Element (ASSL)

AllowDuplicateNames Element (ASSL)

AllowedSet Element (ASSL)

Application Element (ASSL)

AssociatedMeasureGroupID Element (ASSL)

AttributeAllMemberName Element (ASSL)

AttributeHierarchyDisplayFolder Element (ASSL)

AttributeHierarchyEnabled Element (ASSL)

AttributeHierarchyOptimizedState Element (ASSL)

AttributeHierarchyOrdered Element (ASSL)

AttributeHierarchyVisible Element (ASSL)

AttributeID Element (ASSL)

Audit Element (ASSL)

AutoRestart Element (ASSL)

BackColor Element (ASSL)

CacheMode Element (ASSL)

CalculationReference Element (ASSL)

CalculationType Element (ASSL)

CalendarEndDate Element (ASSL)

CalendarLanguage Element (ASSL)

CalendarStartDate Element (ASSL)

Caption Element (ASSL)

CaptionIsMdx Element (ASSL)

Cardinality Element (ASSL)

CaseCubeDimensionID Element (ASSL)

ClassifiedColumnID Element (ASSL)

Collation Element (ASSL)

ColumnID Element (ColumnBinding) (ASSL)

ColumnID Element (EventColumn) (ASSL)

Condition Element (ASSL)

ConnectionString Element (ASSL)

ConnectionStringSecurity Element (ASSL)

Content Element (ASSL)

CreatedTimestamp Element (ASSL)

CubeDimensionID Element (ASSL)

CubeID Element (ASSL)

CurrentStorageMode Element (ASSL)

CurrentTimeMember Element (ASSL)

DataAggregation Element (ASSL)

DatabaseID Element (ASSL)

DataSize Element (ASSL)

DataSourceID Element (ASSL)

DataSourceImpersonationInfo Element (ASSL)

DataSourceViewID Element (ASSL)

DataType Element (ASSL)

DbSchemaName Element (ASSL)

DbTableName Element (ASSL)

Default Element (ASSL)

DefaultMeasure Element (ASSL)

DefaultMember Element (ASSL)

DefaultScript Element (ASSL)

DefaultValue Element (ASSL)

DeniedSet Element (ASSL)

DependsOnDimensionID Element (ASSL)

Description Element (ASSL)

DimensionID Element (ASSL)

DiscretizationBucketCount Element (ASSL)

DiscretizationMethod Element (ASSL)

DisplayFlag Element (ASSL)

DisplayFolder Element (ASSL)

Distribution Element (ASSL)

Edition Element (ASSL)

Enabled Element (ASSL)

EndOfData Element (ASSL)

EstimatedCount Element (ASSL)

EstimatedPerformanceGain Element (ASSL)

EstimatedRows Element (ASSL)

EstimatedSize Element (ASSL)

EventID Element (ASSL)

Expression Element (ASSL)

Filter Element (Binding) (ASSL)

Filter Element (Trace) (ASSL)

FirstDayOfWeek Element (ASSL)

FiscalFirstDayOfMonth Element (ASSL)

FiscalFirstMonth Element (ASSL)

FiscalYearName Element (ASSL)

FoldingParameters Element (ASSL)

FontFlags Element (ASSL)

FontName Element (ASSL)

FontSize Element (ASSL)

ForceRebuildInterval Element (ASSL)

ForeColor Element (ASSL)

Format Element (ASSL)

FormatString Element (ASSL)

Goal Element (ASSL)

GranularityAttributeID Element (ASSL)

HideMemberIf Element (ASSL)

HierarchyID Element (ASSL)

HierarchyUniqueNameStyle Element (ASSL)

HoldoutActualSize Element

HoldoutMaxCases Element

HoldoutMaxPercent Element

HoldoutSeed Element

ID Element (ASSL)

IgnoreUnrelatedDimensions Element (ASSL)

ImpersonationInfo Element (ASSL)

ImpersonationInfoSecurity Element (ASSL)

ImpersonationMode Element (ASSL)

InstanceSelection Element (ASSL)

IntermediateCubeDimensionID Element (ASSL)

IntermediateGranularityAttributeID Element (ASSL)

InvalidXmlCharacters Element (ASSL)

Invocation Element (ASSL)

IsAggregatable Element (ASSL)

IsKey Element (ASSL)

Isolation Element (ASSL)

KeyDuplicate Element (ASSL)

KeyErrorAction Element (ASSL)

KeyErrorLimit Element (ASSL)

KeyErrorLimitAction Element (ASSL)

KeyErrorLogFile Element (ASSL)

KeyNotFound Element (ASSL)

KeyUniquenessGuarantee Element (ASSL)

KpiID Element (ASSL)

Language Element (ASSL)

LastProcessed Element (ASSL)

LastSchemaUpdate Element (ASSL)

LastUpdate Element (ASSL)

Latency Element (ASSL)

LogFileAppend Element (ASSL)

LogFileName Element (ASSL)

LogFileRollover Element (ASSL)

LogFileSize Element (ASSL)

ManagedProvider Element (ASSL)

ManufacturingExtraMonthQuarter Element (ASSL)

ManufacturingFirstMonth Element (ASSL)

ManufacturingFirstWeekOfMonth Element (ASSL)

MasterDatasourceID Element (ASSL)

Materialization Element (ASSL)

MaxActiveConnections Element (ASSL)

MdxMissingMemberMode Element (ASSL)

MeasureExpression Element (ASSL)

MeasureGroupID Element (ASSL)

MeasureID Element (ASSL)

MeasureQualificaton Element (ASSL)

MemberNamesUnique Element (ASSL)

MemberUniqueNameStyle Element (ASSL)

MembersWithData Element (ASSL)

MembersWithDataCaption Element (ASSL)

MimeType Element (ASSL)

MiningModelID Element (ASSL)

Name Element (ASSL)

NamingTemplate Element (ASSL)

NonEmptyBehavior Element (ASSL)

NotificationTechnique Element (ASSL)

NullKeyConvertedToUnknown Element (ASSL)

NullKeyNotAllowed Element (ASSL)

NullProcessing Element (ASSL)

OnlineMode Element (ASSL)

OptimizedState Element (ASSL)

Optionality Element (ASSL)

OrderBy Element (ASSL)

OrderByAttributeID Element (ASSL)

Ordinal Element (ASSL)

OverrideBehavior Element (ASSL)

PartitionID Element (ASSL)

Password Element (ASSL)

Path Element (ASSL)

PendingValue Element (ASSL)

PermissionSet Element (ASSL)

Persistence Element (ASSL)

Process Element (ASSL)

ProcessingMode Element (ASSL)

ProcessingPriority Element (ASSL)

ProcessingQuery Element (ASSL)

ProductName Element (ASSL)

Query Element (ASSL)

QueryDefinition Element (ASSL)

Read Element (ASSL)

ReadDefinition Element (ASSL)

ReadSourceData Element (ASSL)

RefreshInterval Element (ASSL)

RefreshPolicy Element (ASSL)

RelationshipType Element (ASSL)

RemoteDatasourceID Element (ASSL)

ReportingFirstMonth Element (ASSL)

ReportingFirstWeekOfMonth Element (ASSL)

ReportingWeekToMonthPattern Element (ASSL)

ReportServer Element (ASSL)

RequiresRestart Element (ASSL)

RoleID Element (ASSL)

Root Element (ASSL)

RootMemberIf Element (ASSL)

Schema Element (ASSL)

ScriptCacheProcessingMode Element (ASSL)

SilenceInterval Element (ASSL)

SilenceOverrideInterval Element (ASSL)

Slice Element (ASSL)

SolveOrder Element (ASSL)

Source Element (Binding) (ASSL)

Source Element (ComAssembly) (ASSL)

Source Element (Measure) (ASSL)

SourceAttributeID Element (ASSL)

SourceColumnID Element (ASSL)

State Element (ASSL)

Status Element (ASSL)

StatusGraphic Element (ASSL)

StopTime Element (ASSL)

StorageLocation Element (ASSL)

StorageMode Element (ASSL)

TableID Element (ASSL)

Target Element (ASSL)

TargetType Element (ASSL)

Text Element (ASSL)

Timeout Element (ASSL)

Trend Element (ASSL)

TrendGraphic Element (ASSL)

Trimming Element (ASSL)

Type Element (Action) (ASSL)

Type Element (Binding) (ASSL)

Type Element (ClrAssemblyFile) (ASSL)

Type Element (Dimension) (ASSL)

Type Element (DimensionAttribute) (ASSL)

Type Element (MeasureGroup) (ASSL)

Type Element (MeasureGroupAttribute) (ASSL)

Type Element (MiningStructureColumn) (ASSL)

Type Element (Partition) (ASSL)

Type Element (PerspectiveCalculation) (ASSL)

UnknownMember Element (ASSL)

UnknownMemberName Element (ASSL)

Usage Element (DimensionAttribute) (ASSL)

Usage Element (MiningModelColumn) (ASSL)

Value Element (ASSL)

Version Element (ASSL)

Visibility Element (ASSL)

Visible Element (ASSL)

VisualTotals Element (ASSL)

Write Element (ASSL)

WriteEnabled Element (ASSL)

Minimize

This topic has not yet been rated - Rate this topic

KeyErrorAction Element (ASSL)

SQL Server 2008 R2

Specifies the action for Microsoft SQL Server Analysis Services to take when an error occurs on a key.


<ErrorConfiguration>
   ...
      <KeyErrorAction>...</KeyErrorAction>
   ...
</ErrorConfiguration>

Element Characteristics

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

Element Relationships

Relationship	Element
Parent element	ErrorConfiguration
Child elements	None

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

Value	Description
ConvertToUnknown	Convert the problem key to the unknown member value.
DiscardRecord	Discard the record.

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

Reference

Properties (ASSL)

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.