SAP Knowledge Base Article - Public

3110505 - Selecting all members exceeds the 4000 member display limit

Symptom

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."

Environment

  • 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.

Cause

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

Resolution

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

Keywords

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

Product

SAP Analytics Cloud 1.0