Pasting Values into Page Filters (Specifics for SAP BW)
When working with SAP BW live data sources, you can paste values into your story or page filter 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.
If you can't use the search dialog because of SAP BW restrictions, you won't be able to append or overwrite values. For a list of SAP BW search restrictions, see Searching in Filters and Input Controls (Specifics for SAP BW).
Pasting values only works for flat data, not hierarchical data.
The dialog to paste to is only available for multi-select filters, not single-select filters.
Your list of values should have no more than 1000 values.
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.
Prerequisite
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.
Procedure
-
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.
When you have compound dimensions with leaf nodes that can't be matched, you won't be shown the list of values that didn't match.