Bind a Parameter to a Request Variable
Bind a parameter to a request variable when you want to temporarily set the request variable to the parameter's value.
You can bind a parameter to a request variable for the entire workbook or for an individual visualization.
For example, binding a parameter to a request variable for the entire workbook is useful if you want a user to be able to select a currency type in a workbook so they can display the data in the visualizations in a specific currency. The request variable is set to the parameter's value only for the duration of a specific query in the workbook.
If a parameter that's bound to a request variable accepts multiple initial values, the request variable is set to the first value and the remaining values are ignored. You can bind only one parameter to a request variable.
You need to know the request variable name to bind a parameter to it. Your semantic model developer can provide the request variable name.
To create a parameter, see Create a Parameter.
- On your home page, hover over a workbook, click Actions, and select Open.
- To bind a parameter to a request variable for the workbook:
- In the Data Panel, click Parameters.
- In the Parameters Pane, click Menu
and select Request Variable Binding.
- To bind a parameter to a request variable for a visualization:
- Select the visualization, then click Properties.
- Click Advanced
, then click Bind Request Variable
.
- In the Request Variable field, enter the name of the request variable exactly as it's defined in the semantic model.
- In the Parameter field, select the parameter from the drop-down list.
- Click OK.
