3.6 Lookup Tables

Lookup Tables are user-defined database tables created to hold user data for matching instrument-level measures or attributes and returning a corresponding value. The user data is matched conditionally with columns from a Profitability Management Cloud Service instrument table, and a user-specified return value is stored in the return columns of the Lookup table.

A Lookup table is a data administration component used in conjunction with Allocation Lookup Table Driver rules. It is rendered operational when referenced inside an Allocation rule of the Lookup Driver Table type.

Summary and Detail Screens

To open the Summary page, select Data Management Tools, and then select Lookup Tables.

A summary screen is displayed showing a set of Lookup Table rules. Using search criteria, you can control the set of rules displayed. When you Add, Edit, or View a rule, a detail screen is displayed.

Figure 3-27 Lookup Tables — Summary page