Ways to Use Parameters with Filters

In Oracle Analytics, you can use parameters and filters together to dynamically manipulate the data in your workbook.

Use parameters and filters together in the following ways:

Bind a parameter to a filter to pass a selected filter value to the parameter everywhere it's used in the workbook. See Bind Parameters to Filters.
Add a parameter to the workbook filter bar to set the parameter value for the workbook or canvas. See Use a Parameter in the Filter Bar.
Add a parameter to a dashboard filter visualization as a filter control. See Use a Parameter as a Dashboard Filter Control.

If you use a parameter as a filter, keep in mind that parameters have a limit of 10,000 available values that can be cached and also a limit of 1,000 initial values.

You can also use a parameter and a filter together to conditionally show or hide visualizations on a canvas based on a user's selections. See Use a Parameter to Conditionally Show or Hide a Visualization.