Home > Working with Planning Projects > Building an Application > Building Application Models > Building A Cube Model > Measure Settings > Setting Measure Attributes

Setting Measure Attributes

CURRENCY:     This defines whether or not the measure uses currency. If a measure is selected as a currency measure and a currency dimension has been defined, then the currency feature will be enabled. For measures that are not monetary (e.g. volumes, quantities, percentages etc), the currency should be set to 'No'. ). If you are not using currency, it is still advisable to leave the currency set to 'Yes' (this will have no impact unless currency has been enabled), as it will make it easier to add currency conversion at a later date if you want to. Currency 'Yes' is the default setting for the measure.

CURRENCY OVERRIDE: In certain circumstances, you may wish to override the default currency, and specify a fixed currency for a measure. This is useful when you have for example, a foreign currency bank account. The drop down list of currencies next to the currency attribute allows the currency for a specific measure to be fixed.
CALCULATION: The calculation attribute enables a calculation to be defined for this measure. Selecting the calculation icon  will open a pop-up window where you can define the necessary calculation(s) for the measure. For more information on defining calculations, see the section in this manual 'Defining Calculations for Measures'.

LAYOUT: The layout attribute enables certain formatting options for the measures defined in the model.
To set the layout attributes for a particular measure, first select the desired measure and then select the icon to display the layout properties in a pop-up menu. From here you can change the indent for the measure name, cell underline, font attributes, decimal places, 'display as percentage' option and the 'red when negative' option. For more information on the Measure Layout, see the section in this manual 'Measure Formatting'.

PERIOD CUMULATION OPTIONS: By default, all cumulations for the period set will be a simple aggregation as defined in the Period Set definition. However, you may override this for a measure. For example, the Full Year figure for a bank balance measure would not be the aggregation for all defined periods, but rather the last period. Similarly, the aggregation for a price should not be the aggregation of the prices but an average or a weighted average.

The available options for cumulation are:

• None (default) - no override.
• First Period - uses the first period defined in the aggregation.
• Last Period - uses the last period defined in the aggregation.
• Avg - creates an average of all the periods defined in the aggregation.
• Weighted Avg. - creates an average weighted by the values in the selected measure.

In our example, all our measures exist at the lowest level (input node) of any consolidation as well as at the consolidated level. Also, we have no requirement to calculate at the consolidation level.

Cascade Planning has the ability to create new variables at the consolidated level as well as specify variables that only exist at the input level. We can also specify calculations for measures at the consolidated level.

These features, can be accessed by selecting the CONSOLIDATION LOGIC option. See Specifying Consolidation Logic for more detail. 

Defining the Measures List

Measure Formatting

Defining Calculations for Measures

Other Functions for Measures Editor

Cross Referencing Measures

Measure Logic Functions