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

Objects

Account Element

Aggregation Element

AggregationDesign Element

AggregationInstance Element

AlgorithmParameter Element

AllMemberTranslation Element

Annotation Element

Assembly Element

Attribute Element

AttributeAllMemberTranslation Element

AttributePermission Element

AttributeRelationship Element

Block Element

Calculation Element

CalculationProperty Element

CaptionColumn Element

CellPermission Element

Command Element

Cube Element

CubePermission Element

CustomRollupColumn Element

CustomRollupPropertiesColumn Element

Data Element

Database Element

DatabasePermission Element

DataSource Element

DataSourcePermission Element

DataSourceView Element

Dimension Element

DimensionPermission Element

ErrorConfiguration Element

Event Element

File Element

ForeignKeyColumn Element

Group Element

Hierarchy Element

IncrementalProcessingNotification Element

KeyColumn Element

Kpi Element

Level Element

MdxScript Element

Measure Element

MeasureGroup Element

MiningModel Element

MiningModelPermission Element

MiningStructure Element

MiningStructurePermission Element

ModelingFlag Element

NameColumn Element

NamingTemplateTranslation Element

Partition Element

Perspective Element

ProactiveCaching Element

QueryNotification Element

ReportFormatParameter Element

ReportParameter Element

Role Element

ServerProperty Element

SkippedLevelsColumn Element

SourceMeasureGroup Element

TableNotification Element

Trace Element

Translation Element

UnaryOperatorColumn Element

UnknownMemberTranslation Element

ValueColumn Element

Minimize

This topic has not yet been rated - Rate this topic

Column Element (ASSL)

SQL Server 2005

Describes a column in the collection of columns associated with the parent element.


<Columns>
   <Column xsi:type="MeasureBinding">...</Column> <!-- parent of collection: DrillThroughAction -->
   <!-- or -->
   <Column xsi:type="CubeAttributeBinding">...</Column> <!-- parent of collection: DrillThroughAction -->
   <!-- or -->
   <Column xsi:type="EventColumn">...</Column> <!-- parent of collection: Event -->
   <!-- or -->
   <Column xsi:type="MiningModelColumn">...</Column> <!-- parent of collection: MiningModel or MiningModelColumn -->
   <!-- or -->
   <Column xsi:type="MiningStructureColumn">...</Column> <!-- parent of collection: MiningStructure or TableMiningStructureColumn -->
</Columns>

Element Characteristics

Characteristic

Description

Data type and length

DrillThroughAction MeasureBinding, CubeAttributeBinding

Event EventColumn

MiningModel, MiningModelColumn MiningModelColumn

MiningStructure, TableMiningStructureColumn MiningStructureColumn

Ancestor or Parent	Data Type

Default value

None

Cardinality

Event 1-n: Required element that can occur more than once.

All others 0-1: Optional element that can occur once and only once.

Ancestor or Parent	Cardinality

Element Relationships

Relationship	Element
Parent elements	Columns
Child elements	None

Reference

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.