1. User's Guide
  2. Working with Management Ledger Profitability
  3. Working with Management Ledger Allocations
  4. Creating and Managing Management Ledger Allocations
  5. Defining and Managing Calculation Rules in Management Ledger Models
  6. Creating Management Ledger Custom Calculation Rules
  7. Custom Calculation Rule Formula Validation Requirements

Custom Calculation Rule Formula Validation Requirements

When you click Validate Formula, Oracle Hyperion Profitability and Cost Management checks for the following:

  • The Target tab of the custom calculation rule Rule Definition task area must have all dimensions selected except the one used for the formula Result.

  • The formula Result term must not contain a tuple. For example, the following is not allowed:

    </A11,B11/> = <A11>*3

  • Parent members are not allowed in the formula Result term. For example, the following is not allowed assuming that A1 is a parent member:

    </A1/> = <A11>*3

  • In the Target, single-member references can only be members from the Result dimension. Tuples must include a member from the Result dimension. For example, the following formulas are invalid and valid as noted:

    Invalid formula: </A11/> = <B11>*3

    Valid formulas: </A11/> = <A11,B11>*3; </A11/> = <A41,B11>*3; </A11/> = <A21>*3

  • Valid arithmetic operators are the following:

    +, -, *, /

Target and Result terms are separated by a valid equal sign (=). Only one = sign is allowed in a formula.

When a model has duplicate members across dimensions, partially or fully qualified names must be used (see Management Ledger Custom Calculation Rule Formula Syntax).

In the Result term, only a Target term dimension member is allowed.

In the Result term, there must be one Level 0 member of the Result dimension.

The Target formula must contain valid dimension members in a valid format, as outlined here and in the Oracle Essbase Technical Reference.