Calculated measures can add a wealth of information-rich data to a cube. The data set is calculated on the fly, so no data is stored. You can add as many calculated measures as you like without increasing the size of the database. Use this tab to define your calculations.
Name
A simple name.
You cannot change the name after creating the calculated measure.
ID
The fully qualified name.
This information appears on the property sheet after the calculated measure has been created; it does not appear on the initial dialog box.
Short Label
A short descriptive name for display where space is limited, usually in mixed case.
Long Label
A long descriptive name for display, usually in mixed case.
Description
Additional descriptive text, which can include mixed case and spaces.
Choose a Calculation Type
Choose one of these basic calculation types:
| Calculation | Description |
|---|---|
| Addition | Adds the values of one measure to the values of another measure. |
| Cumulative Average | Calculates a running average across a particular dimension beginning at a particular member and moving either forward or backward. |
| Cumulative Maximum | Returns the maximum value across a particular dimension beginning at a particular member and moving either forward or backward. |
| Cumulative Minimum | Returns the minimum value across a particular dimension beginning at a particular member and moving either forward or backward. |
| Cumulative Total | Calculates a running total across a particular dimension beginning at a particular member and moving either forward or backward. |
| Difference From Future Period | Calculates the difference between the current value of a measure and the value of that measure from a later time period. |
| Difference From Parallel Period | Calculates the difference between the value of the current member and the value of another member at the same level. |
| Difference From Period to Date Period Ago | Calculates the difference between the value of the current member and the aggregated values from a specified number of time periods before a particular prior period. |
| Difference From Prior Period | Calculates the difference between the current value of a measure and the value from a prior period. |
| Division (Ratio) | Divides the values of one measure by the values of another measure. |
| Free Form | Calculates the expression entered in the Expression box. |
| Future Period | Returns the values of a measure from a later time period. |
| Index | Calculates the percentage difference between the values of a measure and a particular value or selection of values that serve as an index. |
| Moving Average | Calculates an average for a measure over a rolling number of dimension members. |
| Moving Maximum | Returns the maximum value for a measure over a rolling number of dimension members. |
| Moving Minimum | Returns the minimum value for a measure over a rolling number of dimension members. |
| Moving Total | Calculates a total across a particular dimension over a rolling number of dimension members. |
| Multiplication | Multiplies the values of one measure by the values of another measure. |
| Parallel Period | Returns the value of a member at the same level as the current member. The selected member is related to the current member based on the sort order of one of the dimension's attributes. |
| Percent Difference | Calculates the percent difference between the values of two measures. |
| Percent Difference From Future Period | Calculates the percentage difference between the current value of a measure and the value of that measure from a later time period. |
| Percent Difference From Parallel Period | Calculates the percent difference between the value of the current member and the value of another member at the same level. |
| Percent Difference From Period to Date Period Ago | Calculates the percentage difference between the value of the current member and the aggregated values from a specified number of time periods before a particular prior period. |
| Percent Difference From Prior Period | Calculates the percentage difference between the current value of a measure and the value from a prior period. |
| Period to Date | Calculates the aggregated values of a measure from a specified number of earlier time periods to the current member. |
| Period to Date Period Ago | Calculates the aggregated values of a measure from a specified number of earlier time periods to a particular prior period. |
| Prior Period | Returns the values of a measure from an earlier time period. |
| Rank | Orders the members of a dimension based on their values in the selected measure. |
| Share | Calculates the proportion of an aggregate value that was contributed by each member of a particular dimension hierarchy. |
| Subtraction | Subtracts the values of one measure from the values of another measure. |
Calculation
Defines the calculation using the format of a sentence. Click the underlined text for a menu of choices for the measure or dimension to use in the calculation. Click the ellipses (...) to display a dialog box that you can use to select a portion of the data for the calculation.
The Index calculation displays the selection of dimension members:
Multiply the Result by 100
Select this box to multiply the results by 100. Otherwise, the results are decimal values between 0 and 1. (Not available for some calculations.)
Expression
Displays the expression created by the current settings.
Creating Calculated Measures
OLAP Expression Syntax: Analytic Functions
Copyright © 2003, 2007, Oracle. All rights reserved.