SAP Knowledge Base Article - Public

2467077 - No Exclude multiple filter values option with paste function in AO

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