MicroStrategy ONE
Grouping attribute elements to create derived elements
When viewing a report you can combine attribute elements into a single group of aggregated data. This combined set of attribute elements is called a Group derived element. This derived element enables you to view and analyze the attribute elements' data as a single, distinct group. For information on Group derived elements, see Group derived elements.
The steps below show you how to create a Group derived element on a report.
Prerequisites
-
The report on which you create the derived element 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 create the derived element.
-
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 create a Group derived element
While this procedure creates only Group derived elements, you can create any combination of Group, Filter, and Calculation derived elements on a report or Grid/Graph.
-
Log in to a project in MicroStrategy Developer.
-
To access the Derived Elements Editor in reports and Grid/Graphs
-
-
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 create a Group derived element
-
-
To create a new Group derived element, from the New drop-down list, select Group.
Two new derived elements are created, a blank Group derived element and an All Other derived element. The All Other derived element is a collection of all attribute elements that are not included in any of the other derived elements for the attribute. For further explanation of the All Other derived element, see All Other. -
Select the new Group derived element. This displays the available attribute elements in the Definition tab.
-
From the left pane, select attribute elements to include in the derived element, and then click the right arrow (>) to add your selections to the Selected objects pane.
-
To rename the Group derived element, from the Change Group drop-down list, select Rename Group. Type a name for the Group derived element.
-
To make derived element modifications
-
-
From the Property tab, you can make various modifications to the new derived element such as:
-
From the Change Group drop-down list, you can format derived element headers and values. For information on these formatting techniques, see Formatting derived elements.
-
You can change the order in which the derived elements are displayed on the report using the up (
) and down (
) arrows.-
To complete derived element creation
-
-
You can save your derived element for the report or Grid/Graph, or save the derived element as a stand-alone object that can be used by multiple reports and Grid/Graphs:
-
To save the derived element for the report or Grid/Graph, click OK. The Derived Elements Editor closes and you are returned to the report or document.
-
To save the derived element as a stand-alone object that can be used by multiple reports and Grid/Graphs, click Save Groups. Choose a location to save the derived element to, type a name, and click Save. Click OK. The Derived Elements Editor closes and you are returned to the report or document.
Stand-alone derived elements can only be modified by editing the stand-alone object; you cannot modify them from within reports or Grid/Graphs. For information stand-alone derived elements, see Creating and using stand-alone derived elements.
-