3681271 - Date selector does not display the expected range of values in SAP Analytics Cloud (SAC)

• Date selector range missing dates in SAP Analytics Cloud.
• The dropdown for the page filter only shows few years, while the expected behavior is to display more year values.
• An error occurs after adjusting the date range filter: "The processing in the backend was stopped because of a too high data volume involved in the intermediate calculations."

SAP Analytics Cloud 2025.21.5

1. In SAP Analytics Cloud, open a story containing a filter on a date.
2. Select the date filter, and observe that the drop-down shows only few year values, instead of a larger number of values.

• The date range filter was not adjusted properly, resulting in the incorrect display of years in the date selector.
• The HANA backend processing limits were exceeded due to a large data volume when the date range was extended.

• To resolve the issue perform one of the following:
  
  
  • Adjust the Result Set Limit in HANA; or
  • Apply more restrictive filters in SAC
    
    
    
• Adjust the Result Set Limit in HANA
  • The HANA database enforces a default Result Set Limit parameter. When a data request exceeds this threshold, the backend stops processing the query, resulting in the observed error.
  • To modify the Result Set Limit in the backend, see the SAP Knowledge Base Article:
    2770570 - Error message "The select returned more records than the limit in MaxResultRecords" / MDS Cube resultset & cell size limit 

• Apply more restrictive filters in SAC
  • Limit tables to fewer than 100,000 cells by applying filters or reducing the number of dimensions and measures.
  • Narrow the filters to reduce the overall data volume and prevent the error from being triggered.
  • For example, set the date range to a more restrictive period (e.g., Jan 2025 – May 2025) to reduce the number of records returned.

SAC, Maxresultset, missing values , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem