Complex Logic Example 2: CashTx

Table 4-27 Complex Logic Example 2

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

The first row in the preceding table specifies accounts that begin with "11" are to be 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 000 and 100.

The last line reduces the results to only those source records that have a Custom 1 (UD1) of either: "00", "01". or "02". Any imported line that does not meet all listed criteria is excluded from the calculated results.

In the following tables, two logic items are derived from the source records because of the values entered in the Group By and Group Level fields. Two of the Group By fields have hard-coded values listed and two have an asterisk. Therefore, for every line that passes the specified criteria, the original imported members for the Account and Entity dimensions are replaced with the member listed in the Group By field. The other dimensions return all, or part of the original members based on the Group Level entered.