Passing Parameter Values

In this topic, it describes how to pass the created dashboard parameter to the dashboard. For instance, you can include a dashboard parameter to a WHERE clause of the SQL query or you can filter a dashboard dynamically according to the required parameter value(s).

The created dashboard parameter can be used in the following scenarios:

SQL Queries

The Web Dashboard provides the capability to bind a dashboard parameter and the existing SQL query/stored procedure parameter. This can be useful when you need to filter the SQL query dynamically by including the parameter value in the WHERE clause.

wdd-configure-query-param-page2

To bind a dashboard parameter to an SQL query/stored procedure parameter in the Dashboard Data Source Wizard, do the following:

  • Select the existing query/stored procedure parameter or create a new query parameter using the Add button.
  • Set the Expression as a parameter value and click the ellipsis button to invoke the Expression Editor for this parameter.
  • In the Expression Editor add the required dashboard parameter from the Parameters column.

Filtering

You can filter the specified query of the SQL Data Source, the entire Excel Data Source/Object Data Source or apply filtering to a specific dashboard item according to the current parameter value(s) using the Filter Editor.

In the Filter Editor, you can compare a field value with different objects such as static values, values of another field or parameter values. To switch between values, click a down arrow glyph in the operand value placeholder to expand the list of available objects. Select the Parameter object to compare a field value with a parameter value.

wdd-filter-editor-change-object

Then, click the operand value to invoke the list of available parameters and select the existing parameter or create a new one.

wdd-parameters-filtering

Conditional Formatting

You can apply conditional formatting to a specific dashboard item according to the current parameter value when creating the Expression format condition. Use this capability to format dashboard item elements dynamically, depending on the current parameter value.

wdd-parameters-conditional-formatting

To switch between values, click the down arrow glyph in the operand value placeholder to expand the list of available objects and select the Parameter object to create a format rule with a parameter.

Calculated Fields

You can use parameters when constructing expressions for calculated fields. This allows you to evaluate values of the calculated field dynamically depending on the current parameter value.

wdd-parameters-calculated-field

To include a parameter in the expression, double-click the required parameter in the Fields pane.

Window Calculations

You can use parameters when customizing expressions for window calculations. This allows you to apply a calculation dynamically, depending on the current parameter value.

wdd-parameters-window-calculations

To create the calculation with a parameter, select the Custom calculation and click Edit. In the invoked Expression Editor double-click the required parameter.

See Also