MicroStrategy ONE

Quick sorts

Using right-click options, you can group attribute elements into a single derived element that sorts the attribute elements in any order you choose. This enables you to do more advanced attribute element sorting than simple ascending or descending sorts.

A quick sort is created as Group derived element. For information on Group derived elements, see group derived element in Types of derived elements.

Prerequisites

  • The report on which you create the derived element is connected to an active Intelligent Cube.

  • The attribute you select to create a quick sort for cannot have any existing derived elements defined on it for the report.

  • You need the Define Derived Elements (MicroStrategy Developer) and/or the Web Define Derived Elements (MicroStrategy Web) privileges. These privileges are part of OLAP Services.

To create a derived element with a quick sort

  1. In MicroStrategy Developer, log in to a project that contains reports connected to Intelligent Cubes.

  2. Open the Intelligent Cube reports and run the report. Then view the report in either Grid View or Grid and Graph View.

  3. Right-click an attribute in the grid display, point to Sort, and then select List (custom). The Derived Elements Editor opens with all of the attribute elements listed as selected objects.

    If List (custom) is not an option in the Sort options, this means that the attribute has a derived element defined for it on the report. You must remove any derived elements defined for the attribute before you can create a quick sort to re-order the attribute elements.

  4. In the Selected objects list, move the attribute elements to the order you want them displayed on the report.

  5. Once the attribute elements are ordered appropriately, click OK. The Derived Elements Editor closes and you are returned to the report.

The report displays the attribute elements in the new order. You can modify the derived element using the Derived Elements Editor.

Related Topics