title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
---|---|---|---|---|---|---|---|---|
Columns Element (ASSL) | Microsoft Docs |
Learn about the Columns collection element in the Analysis Services Scripting Language (ASSL) schema. |
10/31/2023 |
analysis-services |
assl |
reference |
kfollis |
kfollis |
kfollis |
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 -->
<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>
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. |
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 xref:Microsoft.AnalysisServices.TraceColumnCollection, xref:Microsoft.AnalysisServices.MiningModelColumnCollection, and xref:Microsoft.AnalysisServices.MiningStructureColumnCollection.