1. Administrator's Guide
  2. Logic Accounts
  3. Creating Complex Logic Accounts
  4. Complex Logic Example 1: CashTx

Complex Logic Example 1: CashTx

Table 4-5 Complex Logic Example 1: CashTx

Dimension Criteria Type Criteria Value Group By Group Level
Account Like 11* Cash 0
Entity Like Tx Texas 0
ICP Between 00,99 ICP 0
UDI In 00,01,02 UD1 0

The first row specifies that any accounts that begin with "11" are included in the calculated result for "Calc Item: CashTx".

The second row further qualifies the results by specifying that the source record must also have the entity like "TX."

The third line reduces the results to only those source records that have an ICP value between 00 and 09.

The last line reduces the results to only those source records that have a Custom 1 (UD1) of either: 00, 01 or 02. Imported lines that do not meet the listed criteria are excluded from the calculated results.

In the following table, only one new logic item is derived from multiple source records. Using the preceding graphic example as the logic criteria, and the first grid that follows as the source line items, you can see how Oracle Hyperion Financial Data Quality Management, Enterprise Edition derives the value of a single logic item. Note the Group By field. Each Group By field includes a hard-coded value. Therefore, for every line that passes the specified criteria, the original imported member is replaced with the member listed in the Group By field.