1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Visualize Data
  3. Create and Use Parameters
  4. Bind Parameters to Filters
  5. Create and Bind a Parameter to Exclude Filter Values

Create and Bind a Parameter to Exclude Filter Values

Set a filter to exclude data values and then use the Bind to Parameter option to create and bind an excludes parameter to the filter. After you create the parameter, you can bind it to other filters in the workbook to pass excluded data values between filters.

This tutorial provides a use case explaining how to use a parameter to exclude filter values that you pass to another canvas.

Tutorial icon Tutorial

This tutorial provides a use case explaining how to apply an exclusion list filter to all canvases in a workbook.

Tutorial icon Tutorial

You can create and bind a parameter to exclude data values in:
  • Workbook filters
  • List, list box, range, and inline list dashboard filter types
The excludes parameter you create uses the Integer data type and contains Boolean values, and is added to the workbook's Parameters tab. The excludes parameter shares the filtered column's name, for example, if you bind an excludes parameter to a City column filter, the binding creates a parameter named Excludes City.
You can also select an existing excludes parameter to bind to a filter. An existing excludes parameter must use the Integer data type and contain Boolean values.
Before you create and bind an excludes parameter, you must set the filter's values and bind a parameter to the filter. This is to ensure that the exclusion list is passed to the parameter.
  1. On the Home page, select the workbook with the filter you want to create and bind an excludes parameter to, click Actions, and then select Open.
  2. Locate and click the filter that you want to bind the excludes parameter to.
  3. For a workbook or list or range dashboard filter:
    1. In Selections, confirm that the filter values are set to the values you want to exclude and that the Bind to Parameter icon (x) is green, indicating that a parameter is bound to the filter.
    2. Click Exclude, click Bind to Parameter (x), and then click Create Parameter to create and bind the excludes parameter to the filter.
  4. For a list box or inline list dashboard filter:
    1. Click Properties and click Filter Controls.
    2. Go to the Parameter Binding (Selection) field and confirm that a parameter name is displayed, indicated that a parameter is bound to the filter.
    3. Go to the Exclude Selection field and set it to On.
    4. Locate the Parameter Binding (Excludes Mode) field and click None. Click Create Parameter to create and bind the excludes parameter to the filter.
  5. Click Save.