Handling Transactional-Level Data - Expert Cube Development with SSAS Multidimensional Models - page 120

As we can see, the XML definition does not have constraints that force the
columns of the same dimension to stay grouped together. In fact, we can move the
columns in any order. For example, the following XML shows us how to arrange the
columns definition to get the order Sales Amount , Product , List Price , Tax Amount ,
and Category .
<Actions>
<Action xsi:type="DrillThroughAction">
<ID>Drillthrough Action</ID>
<Name>Sales Details</Name>
<TargetType>Cells</TargetType>
<Target>MeasureGroupMeasures("Sales")</Target>
<Type>DrillThrough</Type>
<Default>true</Default>
<Columns>
<Column xsi:type="MeasureBinding">
<MeasureID>Sales Amount</MeasureID>
</Column>
<Column xsi:type="CubeAttributeBinding">
<CubeID>Adv DM 1</CubeID>
<CubeDimensionID>Product</CubeDimensionID>
<AttributeID>Products</AttributeID>
<Type>All</Type>
</Column>
<Column xsi:type="CubeAttributeBinding">
<CubeID>Adv DM 1</CubeID>
<CubeDimensionID>Product</CubeDimensionID>
<AttributeID>List Price</AttributeID>
<Type>All</Type>
</Column>
<Column xsi:type="MeasureBinding">
<MeasureID>Tax Amount</MeasureID>
</Column>
<Column xsi:type="CubeAttributeBinding">
<CubeID>Adv DM 1</CubeID>
<CubeDimensionID>Product</CubeDimensionID>
<AttributeID>Category</AttributeID>
<Type>All</Type>
</Column>
</Columns>
</Action>
</Actions>