Create a return value for the lookup table by dragging a field into the Return Value edit box. The name of the field will be returned for each corresponding key.
To display all of the values in the database for a field, select the desired field and click Show Values.
If you need several fields returned for each lookup, you can combine more than one column into an expression. You do this by concatenating the columns. The following is an example for ORACLE. See your database manual for the correct syntax for your database.
‘name || ‘’-‘’ || country || ‘’-‘’ || population’
See LOAD-LOOKUP in Volume 2 of the Hyperion SQR Production Reporting Developer's Guide for more information.