SAP Knowledge Base Article - Public

2651405 - How to enter values when using "Paste from Clipboard" and "Paste from File" functionalities

Symptom

You want to paste members from clipboard (1) or from a file (2) when filtering data by members of a dimension in Analysis for Office.

     PasteMembers.jpeg

Environment

SAP Analysis for Microsoft Office

Resolution

Besides "Individual Selection" and "Range Selection", you can enter members and their operators from a file or from clipboard. In this case, instead of selecting the operator in the "Range Selection" screen, for both Paste from File and Paste from Clipboard options, you need to enter the operator along with the values description.

Example #1:

You want to filter by member that are "Not Equal to" the two values "valABC" and "valDEF" in a file. The file should contain the below:

     !valABC

     !valDEF

Select the dimension, click Filter By Member, click "Paste from File" and insert the file path.

Example #2:

You can enter the members from the file mentioned above just by selecting the values and copying them to the clipboard. Then, select the dimension, click Filter By Member and then click "Paste from Clipboard".

Note: The usage of character "*" does not create a condition of "start with", "end with" or "contains". 
For example, including member "valAB*" will not filter all members starting with "valAB" when using the "Paste from Clipboard" or "Paste from File" functionalities.

See chapter "To filter data by member", item 5 in the User Guide.

Keywords

filter, member, dimension, filter by member, paste member, clipboard, paste from file , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions