Creating stand-alone derived elements

The steps below show you how to create a stand-alone derived element.

Prerequisites

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 stand-alone derived element

1. In MicroStrategy Developer, log in to a project.

2. From the File menu, point to New, and then select Derived Element. The Select Attribute dialog box opens.

3. Browse to and select the attribute that you want to base your derived element on, and then click Open. The Derived Element Editor opens.

4. You can create Group, Filter, and Calculation derived elements to define your stand-alone derived element. With the exception of any steps to access or close the Derived Elements Editor, you can use the same processes and techniques described in the following topics to create derived elements for a stand-alone derived element:

   • Grouping attribute elements to create derived elements

   • Filtering attribute elements to create derived elements

   • Using calculations to create derived elements

5. Click Save and Close. The Save Derived Element As dialog box opens.

6. Type a name and click Save. The Derived Elements Editor closes and the derived element is saved as a stand-alone object.

You can now share your derived element in reports connected to Intelligent Cubes and Grid/Graphs in Report Services documents, as described in Sharing derived elements in reports and Grid/Graphs.

Related Topics

• Creating and sharing stand-alone derived elements

• Sharing derived elements in reports and Grid/Graphs

• Modifying stand-alone derived elements