1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Integration Tasks
  3. Check Rules
  4. Creating Check Rules
  5. Using the Rule Logic Editor to Create Check Rules
  6. Adding a Rule Logic Statement as Free Form Text

Adding a Rule Logic Statement as Free Form Text

Use the Rule Logic Add/Edit as Text tab to add the rule to test manually as free-form text. This feature enables you to instruct the system on how to display the actual value from the check rule logic. It always provides you with a way to cut and paste text rather than entering text line by line. If you do not specify a display summary, then the report shows a "0" value.

When the Display area is active, all interactions take place in the Display area. For example, pasting a tree copies all tree members to the Display area. When the Rule area is active, all interactions take place in the Condition area. Changes made on the Lookup tab are reflected on the Rule tab in related editors.

Image shows Add / Edit as Text tab

To add a rule logic statement:

  1. On the Rule Logic Editor, select the Rule Logic Add/Edit as Text tab.
  2. In Rule, enter the rule.

    Do not use a semicolon (;) in check rules. The semicolon is a reserved as the separator between the rule value and the display value.

    When using the equal sign for evaluating amounts, use double equal signs (==) instead of the single equal sign (=). For example, use a – b == 0, and not a - b=0.

  3. Click OK.