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.

This tutorial provides a use case explaining how to bind a parameter to a request variable for a workbook:

Tutorial icon Tutorial

If the parameter a request variable is bound to 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.

  1. On your home page, hover over a workbook, click Actions, then select Open.
  2. To bind a parameter to a request variable for the workbook:
    1. In the Data Panel, click Parameters.
    2. In the Parameters Pane, click Menu Menu icon and select Request Variable Binding.
  3. To bind a parameter to a request variable for a visualization:
    1. Select the visualization, then click Properties.
    2. Click Advanced Advanced properties icon, then click Bind Request Variable Bind Request Variable.
  4. In the Request Variable field, enter the name of the request variable exactly as it's defined in the semantic model.
  5. In the Parameter field, select the parameter from the drop-down list.
    Description of request_variable_binding.png follows
    Description of the illustration request_variable_binding.png

  6. Click OK.