Replacing a combo box with a lookup object

In some cases, lookup objects have advantages over combo boxes. Lookup obects are particularly useful with Select Element actions.

To replace a combo box with a lookup object for a select element action:

Create a variable.
Insert a lookup object.
See Defining a lookup object.
Click Perform action when icon is clicked in the Format dialog.
Double-click a lookup object to display the Format dialog.
Select Select element as the action type and Lookup click as the action mode.
In the Inputs section, specify this information:

Global list

Select the list to be displayed by the lookup object

Select element

Select the variable that you created in Step 1.

Display format

By default, element captions are displayed. Optionally, select a different format.

Enable multiselection

See Multiselect
In the Parameters section, select the variable that you created in Step 1 as the parameter name, and specify =Actions.Result.Text as its value and click OK.
In the Value field of the Format dialog, specify a formula to display the list that is displayed when you click the lookup
This example MEMBERGET formula displays the Product list of the Best Practices sample database.
=MEMBERGET("best practices olap", "analysis", "[product]",ReportVariables.selection.Text, "self")

See MEMBERGET.