SAP Knowledge Base Article - Public

3076113 - How to exclude members using "Paste from Clipboard" functionality in AO

Symptom

You are looking for more information about how to exclude members using "Paste from Clipboard" functionality in Analysis Office.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Resolution

In order to exclude members using Paste from Clipboard functionality, an exclamation must be entered in front of the values.
Example for excluding a list of members: !1; !2; !3 (exlude the members 1, 2, 3).

Refer to chapter "To filter data by member" in User Guide.

See Also

2875396 - Exclude member by Paste from Clipboard not working for compounded characteristics

Keywords

exclude, excluding, removing, exclamation, !=,  range, pasting, clipboard, filter, filtering , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions