Define Sorting

You can define data sorting for the report via XML configuration.

Sorting field members

Insert sort attribute to hierarchy tag:

<hierarchy sort="desc">
<dimensionName>[Color]</dimensionName>
<hierarchyName>[Color].[Color]</hierarchyName>
</hierarchy>

Possible values:

asc – arrange values in ascending order
desc – arrange values in descending order

Sorting values

Add <sort/> tag to an <axis/> (rows or colums).
Attributes:

tuple – tuple to sort
measure – measure to sort by

Possible values:

asc – arrange values in ascending order
desc – arrange values in descending order

<axis name="rows">
  <hierarchy>
    <dimensionName>[Color]</dimensionName>
    <hierarchyName>[Color].[Color]</hierarchyName>
  </hierarchy>
  <hierarchy>
    <dimensionName>[Category]</dimensionName>
    <hierarchyName>[Category].[Category]</hierarchyName>
  </hierarchy>
  <sort tuple="[Color].[Color].[red], [Category].[Category].[Cars]" measure="[Measures].[Price]">desc</sort>
</axis>