Columns Element (ASSL)

Contains the collection of columns associated with the parent element.

Syntax

<Action xsi:type="DrillThroughAction"> <!-- or one of the elements listed below in the Element Relationships table -->
   <Columns>
      <Column xsi:type="MeasureBinding">...</Column> <!-- parent: DrillThroughAction -->
      <!-- or -->
      <Column xsi:type="CubeAttributeBinding">...</Column> <!-- parent: DrillThroughAction -->
      <!-- or -->
      <Column xsi:type="EventColumn">...</Column> <!-- parent: Event -->
      <!-- or -->
      <Column xsi:type="MiningModelColumn">...</Column> <!-- parent: MiningModel or MiningModelColumn -->
      <!-- or -->
      <Column xsi:type="MiningStructureColumn">...</Column> <!-- parent: MiningStructure or TableMiningStructureColumn -->
   </Columns>
</DrillThroughAction>

Element Characteristics

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

Ancestor or Parent

Cardinality

Event1-1: Required element that occurs once and only once.

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

Element Relationships

Relationship

Element

Parent elements

Action of type DrillThroughAction, Event, MiningModel, MiningModelColumn, MiningStructure, TableMiningStructureColumn

Child elements

Ancestor or Parent

Child Elements

DrillThroughActionCubeAttributeBinding or MeasureBinding

EventEventColumn

MiningModel, MiningModelColumnMiningModelColumn

MiningStructure, TableMiningStructureColumnMiningStructureColumn

Remarks

For DrillThroughAction elements, the Columns collection identifies the columns that contain data to be returned when the action is performed.

For TableMiningStructureColumn elements, the Columns collection allows only one level of recursion. In other words, any TableMiningStructureColumn element included in this collection cannot contain any TableMiningStructureColumn elements in its Columns collection.

Some of the corresponding elements in the Analysis Management Objects (AMO) object model are TraceColumnCollection, MiningModelColumnCollection, and MiningStructureColumnCollection.

See Also

Reference

Collections (ASSL)

Help and Information

Getting SQL Server 2005 Assistance