MicroStrategy ONE

Quick groups

Using right-click options, you can group attribute elements into a single derived element. The derived element created by this action aggregates and displays all the data for the attribute elements selected, into one set of data. For information on Group derived elements, see group derived element in Types of derived elements.

For example, you have a report that displays the number of sales orders, sales order items, and sales order amounts for customer industry sectors. Your report displays this information over a number of months. To get a more summarized view of the data, you decide to group months into seasons. You group December 2025, January 2026, and February 2026 into a single derived element by selecting the attribute elements, right-clicking the selection, and selecting Group.

Prerequisites

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

  • 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 group

  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. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute.

    Do not select derived elements for the attribute, as you cannot create quick groups on derived elements. To group derived elements, you must use the Derived Elements Editor.

  4. Right-click your selection and select CreateGroup. The Defining Group dialog box opens.

  5. Type a name for the derived element, and click OK.

The group is created as a derived element and displayed on the report. You can modify the derived element using the Derived Elements Editor.

Related Topics