Copy and Paste Values into a List Filter

You can copy values from another application and paste them into a list filter in Oracle Analytics to quickly select multiple values at once.

The Paste Values option is available for list filters in all filter scopes and locations: workbook and canvas filters in the filter bar, dashboard filters, and visualization filters. It isn't available for double-column filters. Paste Values is also available when you use a parameter as a list filter in any filter scope and location.

For a filter or parameter that allows multiple selections, each paste adds up to the first 500 valid, unique values to the existing selections. Empty, invalid, and duplicate values don't count toward this limit. For a filter or parameter that allows only one selection, the first valid value is used.

Oracle Analytics converts pasted values to the filter column's data type and ignores individual values that can't be converted. Selected values use the filter's existing sort order, which can differ from the clipboard order.

The pasted selections follow the filter's existing apply and parameter-binding behavior. If the filter is bound to a parameter, the updated selection is passed through the existing binding.

Note:

To use Paste Values, open Oracle Analytics over HTTPS and allow clipboard access if your browser prompts you. Clipboard support and permission settings vary by browser.
Before you begin, prepare the clipboard text in either of these formats:
  • On one line, separate values with commas. Enclose a value that contains a comma in double quotation marks. For example: Kyoto,Lisbon,"Washington, D.C."
  • On multiple lines, put one value on each line.
  1. On your home page, hover over a workbook, click Actions, and select Open.
  2. Click the list filter to open the Filter dialog.
  3. Above the Selections column, click Paste Values Paste values icon.
    Alternatively, click inside the Selections column and press Ctrl+V on Windows, or Command+V on macOS.
  4. If prompted by your browser, allow clipboard access.
  5. Review the selected values.