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
- Select a Characteristic in AO Design Panel
- Right click > Filter by Member
- 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
- Open Analysis for Office > File > Analysis > Customize Analysis > Technical Configuration
- Change the value of FetchMemberLimit to a number greater than the number of members available. E.g: 1000 (default)
- Close AO and reopen it (for the setting to take effect)
- Open the affected query
- Select a Characteristic in AO Design Panel
- Right click > Filter by Member
- All members available for filtering are displayed in the dialog
See Also
Admin Guide - FetchMemberLimit
2083067 - How to maintain settings for Analysis Office 2.x
3326654 - Analysis Office configuration setting not taking effect
Keywords
do not display, don't display, not possible to filter, appear, afo, a4o , KBA , BI-RA-AO-XLA , Excel Addin , Problem