MicroStrategy ONE

Quick calculations

Using right-click options, you can group attribute elements and derived elements into a single derived element using the following quick calculations. Quick calculations enable you to view various types of data and analysis on the same report.

If you select exactly two attribute elements, you can choose from all of the calculations listed below.

If you select more than two attribute elements, Subtract and Divide are not available calculations as they can only accept two operands.

If you want to create a subtraction or division including more than two attribute elements, you must use the Derived Elements Editor.

  • Sum: Performs an addition of two or more attribute elements, derived elements, or a combination of both.

  • Subtract: Performs a subtraction of two attribute elements, derived elements, or a combination of both. The element that is at the higher position on the report is the first operand of the subtraction, and the element at the lower position is the second operand of the subtraction.

  • Average: Performs an average of two or more attribute elements, derived elements, or a combination of both.

  • Divide: Performs a division of two attribute elements, derived elements, or a combination of both. The element that is at the higher position is the first operand of the division, and the element at the lower position is the second operand of the division.

  • Greatest: Performs a greatest calculation of two or more attribute elements, derived elements, or a combination of both. In other words, the metric values for attribute and derived elements are compared, and the greatest value is displayed for each metric.

    The two tables below show an example of creating a greatest calculation on the books and electronics categories.

    Category Revenue Profit

    Books

    $1,000

    $500

    Electronics

    $2,000

    $300
    Category Revenue Profit

    Greatest of Books and Electronics

    $2,000

    $500

  • Least: Performs a least calculation of two or more attribute elements, derived elements, or a combination of both. In other words, the metric values for attribute and derived elements are compared, and the smallest value is displayed for each metric.

    Using the same example used to illustrate the Greatest calculation listed above, the table below shows an example of a creating a least calculation on the books and electronics categories.

    Category Revenue Profit

    Least of Books and Electronics

    $1,000

    $300

For information on Calculation derived elements, see calculation derived element in Types of derived elements. The procedure below describes the general procedure to create a quick calculation on a report connected to an Intelligent Cube.

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 calculation

  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.

  4. Right-click your selection, point to Quick Calculation, and then select one of the following calculations:

    • Sum

    • Subtract

    • Average

    • Greatest

    • Least

    • Divide

    The Defining Group dialog box opens.

    If you selected exactly two attribute elements, you can choose from all of the calculations listed above. However, if you select more than two attribute elements, Subtract and Divide are not available calculations as they can only accept two operands. If you want to create a subtraction or division including more than two attribute elements, you must use the Derived Elements Editor.

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

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

Related Topics