Symptom
You cannot find the option to exclude multiple filter values with paste functionality in Analysis for Office (AO).
Environment
- SAP BusinessObjects Analysis 2.0, edition for Microsoft Office
- SAP BusinessObjects Analysis 2.1, edition for Microsoft Office
- SAP BusinessObjects Analysis 2.2, edition for Microsoft Office
- SAP BusinessObjects Analysis 2.4, edition for Microsoft Office (until SP 2)
Cause
As of AO version 2.4 SP 2, this functionality is not implemented.
Resolution
There is no resolution or workaround for this, at least until AO version 2.4 SP 2. This functionality *might* be delivered in future releases.
We encourage you to suggest this functionality on our idea place according to the SAP note below:
1879237 - Enhancement Request for Analysis, edition for MS.
Keywords
KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , Problem
Product
SAP BusinessObjects Analysis 2.0, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.1, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.2, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.4, edition for Microsoft Office