Previous	Next		Contents	Index	Navigation		Library

For example, suppose Global decides to start awarding credit by determining whether the address of the ship-to customer on invoices is in the salesperson's assigned territory. To define a condition to determine whether the compensation transaction should be classified as Territory 2, Global specifies an attribute called ZIP_CODE in the condition and associates with this attribute a hierarchy called Territory. In the same condition, Global names Territory 2 as the ancestor value.

Thus, as shown in Figure 3 - 13, the complete condition specifies that, if the value of the ZIP_CODE column in the compensation transaction rolls up to a value called Territory 2, the compensation transaction should be classified as Territory 2 revenue.

For instructions on defining a hierarchy, see Defining a Hierarchy.