Calculated measures execute functions and operations on the base measures stored in a cube. The calculated data is not stored; the data is generated in response to individual queries. Calculated measures are similar to relational views.
To see the names of measures qualified by the cube name, change the configuration setting.
To create a calculated measure:
Expand the folder for the cube that contains the base measures that will be used in the calculation.
Right-click Calculated Measures, then choose Create Calculated Measure from the pop-up menu.
The Calculated Measure property pages are displayed.
Enter the name and description.
Select a calculation type.
Modify the template that describes the calculation. Click on the linked text to see a menu of choices.
To perform the calculation on only a portion of a measure:
Click the ellipses (...) next to a measure for the calculation.
The Qualify Measure dialog box is displayed.
Note: This choice is not available for all calculations.
Click Create.
When you are done, the name of the new calculated measure appears as an item in the Calculated Measures folder.
Copyright © 2003, 2007, Oracle. All rights reserved.