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 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.
• Bind a workbook parameter to an AI Agent filter to pass the workbook filter context to AI-generated responses in the Assistant. See Why Use Workbook Filter Context for AI Agents.

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.