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)

Collections (ASSL)

Accounts Element (ASSL)

Actions Element (ASSL)

AggregationDesigns Element (ASSL)

AggregationInstances Element (ASSL)

Aggregations Element (ASSL)

AlgorithmParameters Element (ASSL)

Aliases Element (ASSL)

AllMemberTranslations Element (ASSL)

Annotations Element (ASSL)

Assemblies Element (ASSL)

AttributeAllMemberTranslations Element (ASSL)

AttributePermissions Element (ASSL)

AttributeRelationships Element (ASSL)

Attributes Element (ASSL)

Blocks Element (ASSL)

CalculationProperties Element (ASSL)

Calculations Element (ASSL)

CellPermissions Element (ASSL)

ClassifiedColumns Element (ASSL)

Columns Element (ASSL)

Commands Element (ASSL)

CubePermissions Element (ASSL)

Cubes Element (ASSL)

DatabasePermissions Element (ASSL)

Databases Element (ASSL)

DataSources Element (ASSL)

DataSourcePermissions Element (ASSL)

DataSourceViews Element (ASSL)

DimensionPermissions Element (ASSL)

Dimensions Element (ASSL)

Events Element (ASSL)

Files Element (ASSL)

ForeignKeyColumns Element (ASSL)

Groups Element (ASSL)

Hierarchies Element (ASSL)

IncrementalProcessingNotifications Element (ASSL)

KeyColumns Element (ASSL)

Kpis Element (ASSL)

Levels Element (ASSL)

MdxScripts Element (ASSL)

MeasureGroups Element (ASSL)

Measures Element (ASSL)

Members Element (ASSL)

MiningModelPermissions Element (ASSL)

MiningModels Element (ASSL)

MiningStructurePermissions Element (ASSL)

MiningStructures Element (ASSL)

ModelingFlags Element (ASSL)

NamingTemplateTranslations Element (ASSL)

Partitions Element (ASSL)

Perspectives Element (ASSL)

QueryNotifications Element (ASSL)

ReportFormatParameters Element (ASSL)

ReportParameters Element (ASSL)

Roles Element (ASSL)

ServerProperties Element (ASSL)

TableNotifications Element (ASSL)

Traces Element (ASSL)

Translations Element (ASSL)

UnknownMemberTranslations Element (ASSL)

Minimize

This topic has not yet been rated - Rate this topic

KeyColumns Element (ASSL)

SQL Server 2008 R2

Contains the collection of KeyColumn element definitions for a parent object.


<DimensionAttribute> <!-- or AggregationInstanceAttribute, AggregationInstanceCubeDimension, MeasureGroupAttribute, ScalarMiningStructureColumn -->
   ...
   <KeyColumns>
      <KeyColumn xsi:type="DataItem"...</KeyColumn>
   </KeyColumns>
   ...
</Dimension>

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	1-n: Required element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	AggregationInstanceAttribute, AggregationInstanceCubeDimension, DimensionAttribute, MeasureGroupAttribute, ScalarMiningStructureColumn
Child elements	KeyColumn of type DataItem

The KeyColumns collection can contain multiple KeyColumn elements that represent a multipart key for an attribute or mining structure column.

Reference

Collections (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.