MicroStrategy ONE
Creating derived elements
Derived elements require static report results so that they can be evaluated without regenerating or re-executing SQL. Due to this requirement, derived elements can only be created in the following types of reports and documents:
-
Intelligent Cube reports: An Intelligent Cube report is a report that is connected to and retrieves its data from an Intelligent Cube.
-
Grid/Graphs in Report Services documents: A Grid/Graph is a control placed in a document that displays information in the same way a MicroStrategy report does. In other words, a Grid/Graph is a report that has been added to a section of a Report Services document.
You can create derived elements in Grid/Graphs regardless of whether its displayed results come from an Intelligent Cube, directly from a data warehouse, or from some other type of data storage system.:
If a report containing derived elements is included as a dataset of a Report Services document, derived elements are displayed for any associated attributes added to the details or grouping sections. However, you cannot create or modify derived elements for attributes added to the grouping or details sections.
You can create derived elements with the following methods:
-
Quickly creating groups, calculations, and sorts: While reviewing the data on a report or document, you can quickly group attribute elements into derived elements for further analysis of your data.
-
Using the Derived Elements Editor: Using the Derived Elements Editor provides the full set of derived elements functionality when creating derived elements.
-
Creating and using stand-alone derived elements: You can create stand-alone derived elements that can be used in multiple reports and Grid/Graphs. You use the Derived Elements Editor to create stand-alone derived elements, but you do not have to create them from within a report or Grid/Graph.