SAP Knowledge Base Article - Public

2441559 - Filter Dialog: "Number of members exceeds the maximum number defined in user settings"

Symptom

When filtering a dimension by value in Filter Dialog, message "Number of members exceeds the maximum number defined in user settings" is displayed.

KBA1.PNG

Environment

SAP Analysis for Microsoft Office

Cause

There are more values to be displayed than the maximum value set in Analysis for Office.

Resolution

In AO, go to Settings and try increasing the "Maximum Number of Members Displayed in Filter Dialog" value.
PS.: The value should be extended according to the total number of existing values for the object.
PS2.: Take care as a large numbers can cause performance and/or memory issues.


KBA2.PNG

Keywords

KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions