1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Visualize Data
  3. Create and Use Parameters
  4. Use Parameters in Workbooks
  5. Bind a Parameter to a Request Variable

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.

For example, this 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:

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.
  1. On the Home page, hover over a workbook, click Actions, and then select Open.
  2. In the Data Panel, click Parameters.
  3. In the Parameters Pane, click Menu and select Request Variable Binding.
    Description of request_variable_binding.png follows
    Description of the illustration request_variable_binding.png

  4. In the Request Variable field, enter the name of the request variable exactly as it is defined in the semantic model.
  5. In the Parameter field, select the parameter from the drop-down list.
    You can also type the name of a parameter that does not exist yet and then create it after you finish this binding procedure. See Create a Parameter.
  6. Click OK.