4.7.3 Creating Derived Measures
In addition to selecting existing model attributes as measures for the hierarchical overlay, you can create new “derived measures,” which are measures computed from existing attributes.
To create a derived measure:

1. Click the 'Create derived measure' button above the 'Dimensions' tree in the Hierarchy tab. This opens the 'Add Expression' dialog box.

2. Enter a name for the new measure and click 'OK'. This opens the Script Editor.
3. In the Script Editor, enter an expression to define the new measure. The expression should use the appropriate SQL syntax for the underlying database. (There are no aggregation functions available for measure definition because aggregation is specified in the 'Properties' panel of the Hierarchy tab.)

4. Click the 'Save and Close' button. The new derived measure will appear alongside the existing measures.
| << 4.7.2 Editing Dimension and Measure Properties | © 1996-2013 InetSoft Technology Corporation (v11.4) | 4.7.4 Example: OLAP Overlay >> |