1. User’s Guide for Oracle Analytics Desktop
  2. Filter Data
  3. Use the Workbook Filter Bar
  4. Use a Parameter in the Filter Bar

Use a Parameter in the Filter Bar

Adding a parameter to the filter bar allows you to set the parameter value for the whole workbook or an individual canvas.

This tutorial provides a use case explaining how to use a parameter in the filter bar:

Tutorial icon Tutorial

Note:

Adding a parameter as a workbook (pinned) or canvas (unpinned) filter in the filter bar functions as a column selector, it doesn't filter the data.
Using a parameter in the filter bar doesn't provide the same features as a standard filter. For example, it doesn't provide the exclude, nulls, or limit values functionalities.
You can also create and bind a parameter to a workbook filter, see Create and Bind a Parameter to a Workbook Filter.
  1. On the Home page, hover over a workbook, click Actions, then select Open.
  2. In the Data panel, click Parameters.
  3. Drag and drop a parameter to the filter bar.
    Parameter added to filter bar

  4. Click Save.