SAP Knowledge Base Article - Public

2729600 - The data cannot be displayed ... error when refreshing a story with many widgets and/or data in SAP Analytics Cloud (SAC)

Symptom

The following error occurs in SAP Analytics Cloud (SAC) when opening, refreshing or drilling down on dimension in a story with many widgets and/or a large amount of data:

  • The data cannot be displayed because the query returned too many records. Please try filtering your data.
  • The data cannot be displayed: the query process was stopped before it finished because it returned too many records. Please try filtering ... 

This error also appears in the browser developer tools HTTP archive (HAR) file trace:

  • The selection returned more records than the limit in MaxResultRecords : The selection returned more records than the limit in MaxResultRecords : Number of data records exceeded
  • The Cube that exceeds the limits contains the following dimensions : Rows:...
  • The selection returned more records than the limit in MaxResultRecords : actual/query/default = .../1000000/1000000

Environment

  • SAP Analytics Cloud (Enterprise)

Resolution

  • Tables and charts in SAC are used to analyze data, it is not for data exploration purposes.
  • Data exploration purposes are suggested to be done by a database client tool or using the Data Analyzer. See New data exploration experience in SAP Analytics Cloud.
  • It is recommended to limit records in the table to less than 100,000 cells. This can be performed with adding filters and/or reducing the number of dimensions in the table or chart to return fewer records. In practice, larger tables do not perform well, it may also result in browser performance issue.
    • In case of live HANA connections, the limit of records can be adjusted as per the below SAP Note. Higher resource consumption on backend side must be considered. As this decision is dependent on the available resources in the backend side, this change should be considered by SAP HANA administrators and outside of SAC's responsibility. 
      2770570 - Error message "The select returned more records than the limit in MaxResultRecords" / MDS Cube resultset & cell size limit.
    • This limit cannot be changed on the underlying HANA databases belong to SAC. In case this problem occurs for widgets consuming imort data models, only filtering and/or reducing number of measures and dimensions can resolve the problem
  • Server and memory usage is not only related to the number of cells in the table, the columns (fields), the elements used in table, the design of the table is also related. As a result, there is no exact limitation of cells in the table or from the data connection.
  • It is also recommended to use the optimized view mode. See Optimize Your Story's Performance.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

data maximum restriction, limitation, large amount of data, crosstab, data view, SAC story, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, , KBA , live connection data cannot be displayed , drill limitation settings not working as , settings not working as expected for tab , table , table widgets , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-XUS , User assistance, performance statistics , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0