Strategy ONE
Sorting on Attribute Element Orders from MDX Cube Sources
The order of MDX cube data mapped to attribute elements in Strategy can be defined to include the same order of the data in your MDX cube source. If the order is defined in this way, as described in Preserving Attribute Element Orders from MDX Cube Sources, you can sort MDX cube reports so that the data is in the same order as it exists in the MDX cube source.
Sorting MDX cube reports to represent data as it exists in your MDX cube source can be helpful in various scenarios. For example, this can help support financial balance sheet analysis in which you always want to see your accounts receivable information above your accounts payable information.
You can only sort an MDX cube report based on the order in your MDX cube source if the order has been integrated into Strategy. For information on defining MDX cubes to integrate their order of data into Strategy, see Preserving Attribute Element Orders from MDX Cube Sources.
To sort on attribute element orders from MDX cube sources
- Log in to a project in Developer.
- Browse to an MDX cube report, right-click and choose Run.
- Choose Data > Advanced Sorting.
- Choose Rows > Add.
-
From the Sort By column, choose an attribute on the MDX cube report.
If you are sorting multiple attributes in a hierarchy and want to replicate the order that exists in your MDX cube source, you should sort on higher level attributes first. For example, if your have attributes for Year, Quarter, and Day, you should first sort on Year, then on Quarter, and then on Day.
-
Choose Criteria > Source Order.
Source Order is an attribute form automatically created for any attributes within dimensions that are defined to integrate the order of their data into Strategy. If there is no Source Order form, the order information has not been integrated. For information on defining MDX cubes to integrate their order of data into Strategy, see Preserving Attribute Element Orders from MDX Cube Sources.
-
From the drop-down list in the Order column, choose Ascending.
An ascending sort on the Source Order form displays the data in the same order that exists in the MDX cube source.
- Click OK.
- Re-execute the report.