Defining a simple rule

You can create a simple calculation rule, which is applicable to all the measures defined in the selected module.

To create a simple calculation rule:

  1. Select Configuration > Common > Measures > Calculation Rules.
  2. Click the New and select Simple Rule.
  3. Specify this information:
    Measure
    Specify the measure code on which the calculation is based.
    System
    If this check box is selected, the calculation rule is a system defined rule.
    Calculation Sequence
    Specify an integer value that indicates the order of calculation for rules in this module, with 1 being first and followed by the subsequent calculations. This value must be unique to each module. The calculation sequence is used to ensure that calculation dependencies from other measures are correctly established prior to being used.
    Tags
    The tag linked to a calculation rule. Select from a list of pre-defined tags displayed in the Tags window. You can link one or more tags to a calculation rule. This option is used to group common elements, which can be linked to entities such as measures or worksheets.
    Module
    Specify the module in which the calculation rule is available. You can use multiple calculation rules for a module.
    Calculation Scope

    Specifies the level of the dimension hierarchies at which the calculation is performed before being aggregated or prorated to other levels, if applicable. Specify one of these values:

    • All Elements: The calculation is performed at all levels of the dimension hierarchy.
    • All Base Elements: The calculation is performed at the base (lowest) levels of the dimension hierarchy and aggregated to other levels.
    • All Consolidated Elements: Base data is aggregated to consolidated levels of the dimension hierarchy where the calculation is performed.
  4. On the Simple Rule pane, specify this information:
    Left Measure
    Specify the first measure used in this calculation.
    Operator
    Specify the type of calculation to be performed.
    Right Measure
    Specify the second measure that is used in this calculation.
  5. Click Submit.