Select element action

Opens the Select Element dialog. The dialog contains a server list from which you can select an element.

You can define a Select element action on each slice dimension in a report. You can then use the Action Result object to pass the selected elements to a variable.

In the Inputs field of the Define Action dialog box, select the Global list input value to get the element. In the Select Global List dialog box, select the wanted global list or specify a cell reference or formula for the target object. The formula must return unique name of the global list.

To pre-select an element, specify the element in the value of the Select element input.

Use the Display format input to specify the format in which to display the elements. For example, Caption, or Unique Name. To display combinations of formats, such as unique name and caption, select <Special Format String>. For Select Element actions, special format strings must be specified as string functions. For example, specify ="(U)C" to display unique name and caption, ="C(A)" to display caption and attribute, or ="A1+A2" to display attributes 1 and 2.

By default, you can select only individual elements in the Select Element dialog box. To enable a multiselection, specify True or False as the value for the Enable multiselection input. You can also specify a formula for the parameter to control the multiselection dynamically. If multiselection is enabled, then you can use Ctrl + click or Shift + click to select multiple elements. If multiple elements are selected, the selection is stored in the variable as a multiselect XML. If you select a single element, its unique name is stored in the variable.

Use the Element limit input to limit the number of elements to display in the Select Element dialog box. Specify a number, or a formula that returns the required number. Or, select No limit.

By default, the title of the Select Element dialog box is Select Element. Use the Dialog title input to specify a different title. You can use the name of the list that is displayed, a user-defined string, or a formula.

Parameters of the action are applied after the element is passed to the variable. The Select Element action supports the Action Result object. Actions.Result.Text contains the result of the current action. Click Add parameter and select the variable to which to pass the selected element. Select Actions.Result.Text as the value of the parameter.

Note: The select element action supports the optional Refresh input.