MicroStrategy ONE

Creating consolidation elements

Each consolidation is composed of at least one consolidation element, which is displayed on reports. A consolidation element is defined by an expression, which contains at least one attribute element. The expression is the formula that determines what is included in the report. The consolidation elements appear as rows on a report.

A consolidation element can contain simple mathematical expressions. For example, you can have an expression that adds attribute elements together, such as combining June, July, and August for a Summer consolidation element.

Row level math occurs when mathematical operations are performed between elements. For example, the difference between two summer seasons can be calculated using previously defined consolidation elements, such as [Summer 2022] - [Summer 2023]. This functionality allows a row in a report to be specified by a mathematical operation. For more information, see Consolidations: Row level math.

For more details and examples, see the Consolidation elements section in the Custom Groups and Consolidations chapter of the Advanced Reporting Help.

To add a consolidation element

  1. If the Consolidation Editor is not open, access it. How?

  2. Do one of the following:

    • From the Object Browser, drag and drop an attribute element into the Elements for this consolidation pane. To add multiple elements, press Shift while you drag and drop them. Note that each attribute element is added as a separate consolidation element.

    • The expression is completed automatically and the consolidation element is named for the attribute element. You can rename the element and edit the expression, by adding additional attribute elements, for example.

      In the remaining methods, the corresponding expression is empty, so you must complete it.

    • In the Elements for this consolidation pane, click Click here to add new consolidation element. Type a new name, to replace the default of New Consolidation Element.

    • Right-click in the Elements for this consolidation pane and select Add Element. Type a new name, to replace the default of New Consolidation Element.

    • Click Add Element on the toolbar. Type a new name to replace the default of New Consolidation Element.

    • From the Elements menu, choose Add Element. Type a new name to replace the default of New Consolidation Element.

    • Import elements from an existing consolidation. How?

Your next step is to create a consolidation element expression for the element, or modify it if it was created automatically but is still incomplete. The expression is the formula defining what is included in the element, and therefore on the report.

Related Topics