3.13.1.2.3.1 Range Lookup

One of the options in defining a lookup table is to define a minimum column and a maximum column that you can employ in a “Range Lookup” against each row of selected instrument data. For example, you may wish to assign an Account Maintenance fee against certain checking account products as a function of balances ranges, such as one fee amount for accounts having balances between 0 and 1,000 and a different fee amount for balances between 1,000 and 5,000, and a third fee amount for accounts having balances greater than 5,000.

If the lookup table you chose in the “Source and Lookup Table” pane includes range lookup columns, a Range Lookup row (this is a row whose Lookup Type is Range Lookup) is automatically generated within the Source – Lookup Mapping pane. Within this automatically generated row, select the source column that you want to compare to the Range Lookup columns from your lookup table. In the example described above, you might want to compare the Average Net Book Balance for each account with the range values from your lookup table. Range Lookup supports all instrument-level measures, attributes, and dimension members (numbers, dates, or strings).

Note:

Range Lookups require that your lookup data not have overlapping ranges that would lead to ambiguous lookup values.