Columns Element (ASSL)

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Contains the collection of columns associated with the parent element.


<Action xsi:type="DrillThroughAction"> <!-- or one of the elements listed below in the Element Relationships table -->  
      <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 -->  

Element Characteristics

Characteristic Description
Data type and length None
Default value None
Cardinality See the table below.
Ancestor or Parent Cardinality
Event 1-1: Required element that occurs once and only once.
All others 0-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 See the table below.
Ancestor or Parent Child Elements
DrillThroughAction CubeAttributeBinding or MeasureBinding
Event EventColumn
MiningModel, MiningModelColumn MiningModelColumn
MiningStructure, TableMiningStructureColumn MiningStructureColumn


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

Collections (ASSL)