Create and Bind a Parameter to a Double Column Type Filter
You can select the double column filter's data values and then use the Create Parameter option to create and bind a parameter to the filter. The parameter you create uses the selected values and corresponding column as its properties, and is added to the workbook's Parameters tab.
This tutorial provides a use case explaining how to bind a double
column list filter to a parameter:
For more information about how to use parameter binding in a
workbook's filters, see About Binding Parameters to Filters.
Double columns are available only in datasets created from local
subject areas. In a double column, one column represents the data descriptor value and
is displayed to the end user. The second column represents an identifier of the data
descriptor and isn't displayed to the end user.
When you create a parameter for a double column, the
Alias field in the parameter's property is turned on by
default. An alias is required for a double column parameter, so you can't switch the
Alias field to off.
When you create a parameter from a filter, the parameter uses the filtered column's
name.
- On the Home page, select the workbook where you want to create a double column type filter and add and bind a parameter to, click Actions, and then select Open.
- Create or locate and click the double column type filter where you want to create and bind the parameter. The filter displays the double column's display values and not its ID values.
- Click Bind to Parameter (x) and then click Create Parameter to create and bind the parameter to the filter.
- Optional: Go to the workbook's Data Panel, click Parameters, right-click the parameter you created from the filter, and select Edit Parameter to reviews and update the parameter's properties.
- Click OK.