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
- Logon SAC tenant.
- Open a story.
- 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:
- 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.
- Turn on "View Time Optimization" in the Story Details.
##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