3395691 - Error message "The data can't be displayed because too many records are returned"

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."
------------------------------------------

Below error appears in the browser developer tools HTTP archive (HAR) file trace:
"The selection returned more records than the limit in MaxResultRecords: : actual/query/default = <Number of selected Records>/1000000/1000000"

SAP Analytics Cloud, add-in for Microsoft Office

As described in chapter Data Connections to SAP Analytics Cloud:

"The data sources are added as tables to the workbook. The add-in uses the SAP HANA Multi-Dimensional Services (MDS) default of 1 000 000 result records. Note that though this is close to the visible number of data cells in Excel in many situations, it is a different number that can not precisely be mapped to the expected number of data cells in your table. For more information, you can see SAP Note 2770570."

In SAP Analytics Cloud, add-in for Microsoft Office, one data cell will be structured as one record(Row/Column)in the database(MDS) result set. Therefore, the limitation is controlled by parameter result_set_size_max_default, the value is 1.000.000 which means 1.000.000 data cells for SAP Analytics Cloud, add-in for Microsoft Office. And, the parameter cannot be changed the underlying HANA databases belong to SAP Analytics Cloud(KBA 2729600), SAP Datasphere(KBA 3575377).
In summary, the limitation of 1.000.000 data cells cannot be altered. Therefore, to prevent encountering an error message, it is essential to decrease the amount of data in the table results. This can be achieved by applying filters, including mandatory variables, and narrowing down the selection of columns and rows, among other strategies.

The SAP Analytics Cloud add-in for Microsoft Office is entirely based on web browser technology, including Excel Online, Excel on Windows Desktop, and Excel on Mac Desktop. Web browsers like Edge, Chrome or Safari and their corresponding Excel desktop embedded runtime components (such as WebView2 for Windows and WebKit2 for Mac) come with a 4GB memory limit. The limit is usually hit at around 500 000 to 1 mio cells. If the add-in crashes/restarts on big tables, it may be due to memory limitation. You can monitor the memory consumption of the WebView2/WebKit2 process in the respective task managers or use the development tools.

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 , 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

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