Symptom
When filtering a dimension by value in Filter Dialog, message "Number of members exceeds the maximum number defined in user settings" is displayed.
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.
Keywords
KBA , BI-RA-AO-XLA , Excel Addin , Problem
Product
SAP Analysis for Microsoft Office all versions