SAP Knowledge Base Article - Public

3362612 - Message in Filter by Member dialog "Dimension contains too many members to display. Select members for filtering"

Symptom

The message “The dimension contains too many members to display. Select members for filtering" appears in Filter by Member dialog.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SAP Analysis for Office

Reproducing the Issue

  1. Select a Characteristic in AO Design Panel
  2. Right click > Filter by Member
  3. Confirm the message in filter dialog pop-up: “The dimension contains too many members to display. Select members for filtering.”

Cause

The value of the Analysis for Office setting FetchMemberLimit is lower than the number of available members for filtering.

E.g.

The value is 1.

And there are 2 members available for filtering, then the message will appear.

Resolution

  1. Open Analysis for Office > File > Analysis > Customize Analysis > Technical Configuration
  2. Change the value of FetchMemberLimit to a number greater than the number of members available. E.g: 1000 (default)
  3. Close AO and reopen it (for the setting to take effect)
  4. Open the affected query
  5. Select a Characteristic in AO Design Panel
  6. Right click > Filter by Member
  7. All members available for filtering are displayed in the dialog

See Also

Admin Guide - FetchMemberLimit 

User Guide - FetchMemberLimit

2083067 - How to maintain settings for Analysis Office 2.x 

3326654 - Analysis Office configuration setting not taking effect

2482784 - Best Practices in Analysis for Office

Keywords

do not display, don't display, not possible to filter, appear, afo, a4o , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions