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."
------------------------------------------
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
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.
SAP Knowledge Base Article - Preview