Edit Measures Definition

The Edit Measures Definition tab lets you define a measure.

These are the options:

Options Description
Save Save any changes.
Cancel Close the tab. You are prompted if there are unsaved changes.
Define Type of Measure Choose:

Specific Values. Select this option for numeric values.

Yes/No. Select this option for yes/no values. For example, a measure for a quarter of "Quarterly Review Completed" is either Yes or No which represents 100% or 0% value. Next quarter the value for that quarter is used and the previous quarter does not influence the value.

For a specific value type of measure, you can specify the number format to use in displaying the actual and target values. Select None to display the number as a general numeric value. Other options include:

  • Integer
  • Decimal
  • Percent
  • Currency

When the plan was created, the specific format setting was established for the plan, for example, number of decimal places.

For both types, you can specify the direction, Increasing, Absolute, or Decreasing.

For example, for expenses, lower is better so select Decreasing.

For sales, select Increasing because higher is better.

In situations where it is the magnitude of the deviation that is important, select Absolute. For example, inventory where too high or too low are both bad.

Select Unit Consolidation Method

Specify how the actual and target values are to be aggregated from children to a parent.

Select Sum to sum all values over all associated units.

Select Average to sum all values and then divide by the number of associated units to give an average.

Select None and data can be entered at both leaf node and consolidated organizational units. No summing occurs over the organizational structure. You must define a measure source if you select this option.

Define Time Setting Select the Measured values accumulate over time check box if periods are to be considered accumulated values. This affects how the performance calculations are done for Specific Values.

If the Measure values accumulate over time check box is selected, then the unit consolidation method also is used to determine the actual or target value for the year from the four quarter values, or for a quarter from the supporting monthly values.

For most measurements, you will want to compare the consolidation of the values from the current interval and previous intervals when looking at YTD or Total Year performance calculations.

This option does not apply to Yes/No values.

If you defined measures on a non-leaf unit and you change the unit consolidation method from None to Sum or Average, you are prompted to remove the measures definitions for the unit. If you click No, the measure definitions remain but the data values are calculated from the descendants and override the data values for that unit.

If you change the unit consolidation method from Sum to None, the non-leaf data is deleted.