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.- 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.