MicroStrategy ONE
Creating and using stand-alone derived elements
A stand-alone derived element can be connected to matching attributes in reports connected to Intelligent Cubes and Grid/Graphs. This enables you to use a derived element in multiple reports and Grid/Graphs.
To use a derived element in multiple reports and Grid/Graphs, you must create a stand-alone derived element. There are two methods with to create a stand-alone derived element:
-
Create a derived element from within a report or Grid/Graph and then save it as a stand-alone object. You can use the Derived Elements Editor to create and save the derived element as a stand-alone derived element. For information on creating a derived element within a report or Grid/Graph using the Derived Elements Editor, see Using the Derived Elements Editor.
Once you save a derived element as a stand-alone derived element, it can no longer be modified from within the report or Grid/Graph. For information on how to modify a stand-alone derived element, see Modifying stand-alone derived elements. -
Create a stand-alone derived element outside of any report or Grid/Graph. You can use this method only in MicroStrategy Developer. To use this method, see Creating stand-alone derived elements.
Once created, a stand-alone derived element has the following functionality:
-
All Group, Calculation, Filter, and All Other derived elements are saved as part of the derived element. You cannot select a subset of the derived elements; you must save and share the entire collection of derived elements.
-
A stand-alone derived element can only be connected to the attribute that was used to define the derived element. For information on how to connect derived elements to attributes in other reports and Grid/Graphs, see Using derived elements in reports and Grid/Graphs.
-
The stand-alone derived element itself can be modified, but you cannot modify it from within a report or Grid/Graph. Any modifications for the derived element are applied to the derived element in all of the reports and Grid/Graphs that it is used in. For information on how to modify a stand-alone derived element, see Modifying stand-alone derived elements.
-
The stand-alone derived element can only be deleted if it is not used in any report or Grid/Graph. A list of reports and Grid/Graphs that use the derived element is displayed when you attempt to delete a stand-alone derived element.