SAP Knowledge Base Article - Public

3110505 - Selecting all members exceeds the 4000 member display limit


Following error is shown when selecting a cost center in report:

"Selecting all members exceeds the 4000 member display limit. The selection has been automatically refined to the first 4000 members."


  • SAP Analytics Cloud

Reproducing the Issue

  1. Logon SAC tenant.
  2. Open a story.
  3. When trying to select a filter, the following error could be seen:

            This filter is at maximum capacity: 4000 selected members.

            Filters can only select up to 4000 values. You may still overwrite currently selected values with the values entered above.


The filter based on calculated dimension has a maximum limit of 4000 items and this is by design.


There are two workarounds:

  1. Do not use calculated dimension in the story layer, but instead define the dimension in the database model layer.   This way to SAC, the dimension is a normal dimension and thus the maximum 4000 item limit should not apply.
  2. Turn on "View Time Optimization" in the Story Details.  

See Also

##2809280 - Unable to search members within a page filter with more than 4000 unique members in SAP Analytics Cloud (SAC) & SAP Digital Boardroom


Filter, sac, story, 4k, 4000, limit , KBA , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , Problem


SAP Analytics Cloud 1.0