Using the Derived Elements Editor

While the quick groups features described in Quickly creating groups, calculations, and sorts enable you to quickly create derived elements using right-click menu options while reviewing report results, the Derived Elements Editor provides the full set of derived elements functionality when creating derived elements.

For example, if you use right-click menu options to create a quick calculation on a report connected to an Intelligent Cube, the expression can only include one type of function or operand such as +, /, and Average. However, in the Derived Elements Editor, you can create expressions with a valid combination of different functions.

Using the Derived Elements Editor, you can create derived elements using the techniques described in the topics listed below:

• Grouping attribute elements to create derived elements

• Filtering attribute elements to create derived elements

• Using calculations to create derived elements

Along with creating the derived elements as listed above, you can modify derived elements in the following ways using the Derived Elements Editor:

• Applying derived elements to subtotals

• Displaying derived elements or their attribute elements

• Displaying derived elements and their attribute elements simultaneously

• Formatting derived elements

• Creating and sharing stand-alone derived elements

Related Topics

• Accessing the Derived Elements Editor

• Derived Element Editor: Definition tab

• Derived Element Editor: Property tab

• Derived Elements Editor: Toolbar options

• About Derived Elements

• Types of Derived Elements