Lookup Builder

The Lookup Builder allows you to add variables that use lookup tables. A lookup table improves the speed of query execution by performing an often-used pattern of query processing with a single access to the database.

To add a variable that uses a lookup table:

Use the drop-down list to select the field to use as the key figure.
For example, you could use “customer number” as the key field in a lookup table that returns the customer numbers in the report
Enter a name to identify the variable.
Enter the variable in the Variable field. To add a variable, you can:
- Drag an operation onto a column in the left pane.
- Drag an operation or column into the Variable field.
- Double-click an operation or column to enter it into the Variable field.
- Type in the variable.
  To delete a variable from the Variable field, click Clear.
  The types of operations that you can use in your variables appear under the Operations pane on the right-hand side of the Variable Builder (for example, numeric functions, file functions, and operators). To view the available options for each type of operation, click the plus sign (+) next to the operation, or double-click the operation.
  Note that you can use the name of a calculated field in your variable. For example, you can create a calculated field, “TotalSalaryByRegion”
```
‘Total Salary is $’||TO_CHAR(#TotalSalaryByRegion) ||’.’
```
Click OK to close the Lookup Builder.
The variable will appear under the Variables tab.