MicroStrategy ONE

Using derived elements in reports and Grid/Graphs

You can use a stand-alone derived element in multiple reports and Grid/Graphs in documents. To use a stand-alone derived element, you can connect the derived element to an attribute in a report connected to an Intelligent Cube or to an attribute in a Grid/Graph in a Report Services document. However, a derived element can only be connected to the attribute used to define the derived element.

For example, if a derived element is created on the Year attribute, this derived element can only be connected to the Year attribute in reports and Grid/Graphs. You cannot connect this derived element to any other attributes such as Quarter, Month, Category, Customer, and so on.

The steps below show you how to apply a stand-alone derived element to an attribute in a report or Grid/Graph.

Prerequisites

  • The report on which you connect the derived element to an attribute is connected to an active Intelligent Cube, or the Report Services document with a Grid/Graph included in one of the document sections, on which you connect the derived element to an attribute.

  • 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 apply a stand-alone derived element to an attribute

  1. Log in to a project in MicroStrategy Developer.

  2. Access the Derived Elements Editor to open the report or Grid/Graph.

    • To access the Derived Elements Editor for a report connected to an Intelligent Cube, open the report and run it in Grid View or Grid and Graph View. Right-click the attribute to create or modify derived elements for, and click Derived Elements. The Derived Elements Editor opens.

    • To access the Derived Elements Editor for a Grid/Graph in a Report Services document, expand the document section that contains the Grid/Graph. Double-click the Grid/Graph to edit it. Right-click the attribute to create or modify derived elements for, and click Derived Elements. The Derived Elements Editor opens.

    • To connect a stand-alone derived element to an attribute

      If an attribute already has a derived element defined for it in the report or Grid/Graph, connecting a stand-alone derived element overwrites the existing definition.

  3. Click Link Groups. The Select Group dialog box opens.

  4. Browse to and select the derived element to link to the attribute, and then click Open.

  5. Click OK to save your changes and close the Derived Elements Editor.

Related Topics