Pasting Values into Page Filters
Instead of scrolling through a long filter list for specific values, you can paste the values from a list.
When you have a page filter that has a large number of values, it can take a long time to find the specific values to display in your filter. If you have the list of values saved somewhere else, you can paste them in and update your filter.
Pasting values only works for flat data, not hierarchical data.
Pasting values is available for Live HANA and acquired data models. The feature is also available for SAP BW, with some limitations. For SAP BW live data sources, see Pasting Values into Page Filters (Specifics for SAP BW).
Only exact matches will be found, that is, exact spelling (not case-sensitive) or complete IDs. For example, if you are trying to find “AB3D7” and you paste in “AB3”, you will see a message stating that “AB3” could not be found.
The values you paste must match the displayed format: if you display ID and Description, you can paste in either ID or Description (but not both values for any one member). If you display the member IDs, you can only paste in ID values, and when displaying member descriptions, you can only paste in description values.
Pasting values for date dimensions (time, day, or date) is not available when your display is set to ID and Description.
Set up a text file with the values that you want to paste, one value per line. You can include both IDs and descriptions, but not on the same line.
-
Select a story or page filter.
-
In the filter menu, select Paste Filter Values.
-
Paste your list of values into the dialog box.
-
Choose whether to Append the new values (keeping any members that were already selected), or Overwrite the list (which will clear selected members and then select those from the list).
The filter is updated as is the chart or table that uses that filter.
A message will display the first few values that couldn't be found, but if there are a lot of values, it won't display all of the them.