dashboard-117547-web-dashboard-create-dashboards-on-the-web-data-analysis-dashboard-parameters-create-a-dashboard-parameter.md
This topic explains how to use the Parameters page where you can add a dashboard parameter and specify its settings in the UI.
To create a dashboard parameter, follow the steps below.
Invoke the dashboard menu and select Parameters.
In the Parameter List , click the Add button. The parameter’s settings form appears as follows:
Specify the parameter’s settings.
Specifies the parameter name.
When you create and modify parameter names, follow the rules below:
The corresponding property: Parameter.name
Specifies the parameter description displayed in the Parameter column of the Dashboard Parameters dialog:
The corresponding property: Parameter.description
Specifies whether the parameter is visible in the Dashboard Parameters dialog.
The corresponding property: Parameter.parameterVisible
Specifies whether a null value can be passed as a parameter value.
The corresponding property: Parameter.allowNull
Specifies whether multi-selection is enabled for the current parameter.
The following limitations apply to parameters with multi-selection enabled:
The corresponding property: Parameter.allowMultiselect
Specifies whether all parameter values should be selected in the initial state of the dashboard.
Note that this option is in effect when the Allow Multiselect setting is enabled.
The corresponding property: Parameter.selectAllValues
Specifies the parameter type. Select the parameter type from the drop-down list in the Type field.
The following types are available:
The corresponding property: Parameter.type
Specifies the default parameter value.
The corresponding properties: Parameter.defaultValue / Parameter.defaultValues
Specifies the parameter’s look-up editor settings.
The corresponding property: Parameter.lookUpSourceType
The following Look-up Settings are available in the Web Dashboard:
No Look-UpA user specifies the parameter value in the Dashboard Parameters dialog.Static List
A user selects a parameter value from a static list. To add predefined parameter values, use the plus button.
The corresponding property: Parameter.staticListLookUpSettings
Dynamic List
A user selects a parameter value defined in a data source.
The corresponding property: Parameter.dynamicListLookUpSettings
Tip
You can also create cascading parameters in the Web Dashboard. For more information, refer to the following topic: Cascading Parameters.
You can specify a data source as a source for dashboard parameter values. To provide access to data source values, specify the following options:
| UI Settings | Description | API |
|---|---|---|
| Data Source | Specifies the data source for the dashboard parameter. | dataSource |
| Data Member | Specifies the name of the data member with the parameter values for SQL and Entity Framework data sources. | dataMember |
| Value Member | Specifies the name of the data field for the parameter values. | valueMemberName |
| Display Member (optional) | Specifies the name of the data field displayed in the Dashboard Parameters dialog as a value description. | displayMemberName |
| Sort By (optional) | Specifies the data member used to sort parameter values. | sortByMember |
| Sort Order (optional) | Specifies the sort order. | sortOrder |
Note
You cannot use an OLAP data source as the data source for a dashboard parameter.
You can display a parameters window at startup and prompt a user to input parameter values before a dashboard loads and aggregates data. Dashboard items display the following message to guide users: “Waiting for Parameter Values…”.
The Web Dashboard control loads data only after the user submits all visible parameters. This operation mode prevents unnecessary data requests and ensures the dashboard fetches only data the user actually needs.
To activate this mode, open the dashboard menu, switch to the Parameters page, and select the following checkbox: Request Parameter Values before Data Loading. The setting value is saved in the dashboard XML definition.
The corresponding property: Dashboard.requestParameters
If a user changes this option at runtime, they need to initiate a data reload. The dashboard displays a Dashboard Parameters pop-up before it fetches data.
See Also