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
-
Log in to a project in MicroStrategy Developer.
-
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.
-
-
Click Link Groups. The Select Group dialog box opens.
-
Browse to and select the derived element to link to the attribute, and then click Open.
-
Click OK to save your changes and close the Derived Elements Editor.