Sorting in ad-hoc report

You can sort elements on axes in ascending or descending order. You can define the sorting criteria based on the caption, unique name, or attributes of elements. You can create multiple criteria per dimension and apply them in defined order.

Sorting respects the hierarchy but you can break the hierarchy sorting. In this case, the sorting criteria are applied regardless of the hierarchy.

  1. In the Ad-Hoc Report dialog box select a data connection from the list.
  2. Select a cube from the list.
  3. Select the hierarchy and click the Sorting tab.
  4. Click Add Sorting and specify this information:
    Attribute Name
    Select the required attribute.
    Order
    Select Ascending or Descending.
  5. Click Add.
  6. To delete the sorting attribute, click the More icon next to the added sorting and select Delete.
  7. To break the hierarchy sorting, select Break Hierarchy from the list in the Selections pane on the Elements tab.
  8. Click Update report.