SAP Knowledge Base Article - Preview

3395691 - Error message "The data can't be displayed because too many records are returned" in SAP Analytics Cloud, add-in for Microsoft Office

Symptom

The following error message is displayed in SAP Analytics Cloud, add-in for Microsoft Office:
------------------------------------------ 
"The data can't be displayed because too many records are returned. Please try to reduce the amount of data by collapsing hierarchies, removing dimensions or filtering of any kind."
------------------------------------------
Error message.png

The following error appears in the browser developer tools HTTP archive (HAR) file trace (the steps of capturing the HAR file for SAC Add-in can be found in KBA 3085993 --> "1. Logs & Traces" -> "Windows Excel (Desktop App)"):

  • "The selection returned more records than the limit in MaxResultRecords: : actual/query/default = <Number of selected Records>/1000000/1000000"


Read more...

Environment

SAP Analytics Cloud, add-in for Microsoft Office

Product

SAP Analytics Cloud, add-in for Microsoft Office all versions

Keywords

SAC addin for Excel, SAC add-in for Excel, SAC addin for Microsoft Office, limit, limitation, result set limit, resultset, freezing, warning, performance, maximum size, he Cube that exceeds the limits contains the following dimensions , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , HAN-DB-ENG-MDS , SAP HANA Multidimensional Services MDS / InA , DS-MD-AM , Analytic Model , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.