Level selection from a Select Element action

You might prefer to use a Select Element action instead of a combo box. Your choice may be simply aesthetic but there are also practical reasons why you might prefer one to the other.

See Combo Boxes vs Select Element Action.

When a user clicks a cell containing a select element action, the Select Element dialog opens. It displays a list from which the user can select an element. The list displayed must be a global list.

We want users to be able to select from a list of product levels. The levels are the children of the Product hierarchy.

Open Accessories in the Repository Explorer and expand Custom Hierarchies.
Right-click Olap Metadata and select New > Custom List. Name the list Level.
In Structure Selection, select the Product hierarchy in the Children of list.
The list displays the levels of the Product hierarchy.
Create report variables called SelectionHelper and Level.
Right-click cell B15 and select Define Action.
Select Select Element as the action type.
Select Level as the global list.
Select SelectionHelper as the action result.
Double-click <New Parameter>.
Select Level as the parameter name.
Create this formula in the Value field:
ROA("","","Olap Meta Data","Name",ReportVariables.SelectionHelper.text).
Select the hyperblock in B17. In Structure Selection, delete the existing structure selection (Level: All Products).
In Structure Selection, right-click the Level report variable and select Select as Level.
Specify a label in B15, for example, Select Level.
When you click the label in B15, the Select Element dialog is displayed. When you select a level, the report displays the products at the selected level.