Rule Logic

The Rule Logic column is used to create multidimensional lookups and check rule expressions. Rule Logic columns are processed for reports only in #ModeRule or #ModeList mode. After a rule logic is processed for a rule in the check report, Oracle Hyperion Financial Data Quality Management, Enterprise Edition flags the rule as passing or failing.

Check Rule Condition Expressions

Check rule expressions are used primarily to validate target-system account balances when performing multidimensional lookups. The expressions return a True or False result.

For example, the following returns true (OK) if Cash (a target account) has a positive balance, and false (Error) when it does not:

|,,,YTD,<Entity Currency>,,Cash,[ICP None],[None],[None],[None],[None],,,,,,,,,,,,,,,,|>0

In this example, the check rule expression returns true (OK) when the value of Cash (a target account) plus $1000 is greater or equals the value of AccruedTax (another target account), and false (Error) when it does not:

|,,,YTD,<Entity Currency>,,Cash,[ICP None],[None],[None],[None],[None],,,,,,,,,,,,,,,,|+1000>=|,,,YTD,<Entity Currency>,,AccruedTax,[ICP None],[None],[None],[None],[None],,,,,,,,,,,,,,,,|