SAP Knowledge Base Article - Public

2259509 - How to deselect multiple values in prompts dialog box in Analysis Office

Symptom

  • Many values are selected in prompts dialog box while using analysis office
  • You need to deselect those values from the prompts in a easy-way, instead of deselecting them one-by-one.

1.png

 

Environment

  • SAP BusinessObjects Analysis 1.4, edition for Microsoft Office

  • 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

Reproducing the Issue

  1. Start Analysis Office

  2. Select a data source or open a workbook

  3. Deselect values in prompts

Resolution

The following workaround can be used:

1. press "Add", select "Add Lines using Filter By Member".

2.png

2. "Filter By Member" screen pops up.

3.png

3. select "Select All", click on "OK" button.

4.png

4. all the values are deselected.

5.png

Keywords

Filter Value Help, Filter Dialog, remove filter values, mass values, delete , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , How To

Product

SAP BusinessObjects Analysis 1.4, edition for Microsoft Office ; 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