Home > Working with Planning Projects > Building an Application > Building Application Models > Building A Cube Model > Measure Settings > Defining Calculations for Measures
Defining Calculations for Measures
Last Updated 5/28/2012 4:22 PM
Some measures are what we would define as input measures, that is they are populated either by data being input, or being imported from an external source, or by data from another model using the linkage features.
However for some measures we want to derive the contents of the measure from a calculation. The calculation may involve simply adding a series of other Measures, or by applying more complex arithmetic or possibly using one of MaxiPlan's built in functions (see Measure Logic Functions for more detail). Adding a calculation to any Measure is easy to do.
For example for our Expenses example, we need to define the calculation for 'Office Costs'.
To do this, we select the 'Office Costs' measure from our list of measures and then select the  calculation icon to set the calculations for that measure.
Selecting the calculation icon causes the pop-up window to appear where we can specify the calculation.
Since we are doing a simple summation, we can select the measures we want to sum, and then drag them into the calculation window.
TIP: You can use 'CTRL left click mouse' to select multiple members or you can select the first in a range and then press 'SHIFT left click mouse' to select the complete range.
Next click the  button to apply the calculation to the measure.
NOTE: If no operators or functions appear in a list of measures, Cascade will assume you intend to do a summation and will insert the ' ' symbol for you.
Next we can perform the same process for the 'Total Expenses' calculation.
A measure calculation can also be defined using the operators listed in the Operators panel on the calculation pop-up. The arithmetic operators available include +,-,*,/,( ,) and ^
Simply select and then drag the desired operator down to the Calculation panel, positioning where you want the operator.
You can if you wish type the expression you require directly into the calculation window at the bottom of the popup. However be careful to ensure that you spell measure names correctly or your calculation will fail. You should also ensure that any measure names containing a space or special character are boiunded by single primes. This is not necessary when you drag from the measure list as Cascade will add the primes for you.
Measure calculations can also utilise the functions listed in the functions panel (see Measure Logic Functions for more detail).
See also
| 
Page URL: