Displaying a lookup list

The values of any list, variable list or custom hierarchy can be displayed in a look up list in the Report Wizard. This can be used to restrict the elements a user can select from a dimension. For example, you could have a template report for creating reports on products sold in Europe. To prevent users selecting products sold outside Europe in reports based on the template, you could create a list of products only sold in Europe and use it as a lookup in the Report Wizard.

To use a lookup, select a list in the Look Up column on the Report Parameters tab.

When you use a list as a lookup, users can select only from the lookup in the Report Wizard. It has the effect of fixing the lookup as the default value.