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

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"

SAP Analytics Cloud, add-in for Microsoft Office

As described in chapter System Sizing and Limits:

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

  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.

  After adding a table, you can switch to the high-volume mode in the table's context menu. In this mode, you can use tables with up to ten million cells. It creates a performance-optimized table for large data sets and includes only essential analysis features."

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 in the normal mode for SAP Analytics Cloud, add-in for Microsoft Office. In order to support larger datasets, SAC add-in overrides this value in high-volume mode with the absolute maximum of 10 million cells (result_set_size_max_limit). The other value for cell size (cell_size_max_default, only needed for internal server calculations) is not changed and remains as 10.000.000.

And, the parameter cannot be changed in the underlying HANA databases belonging to SAP Analytics Cloud(KBA 2729600), SAP Datasphere(KBA 3575377).

In summary, the limitation of 1.000.000 frontend data cells in the normal mode (10.000.000 frontend data cells in the high-volume mode) and 10.000.000 intermediate data sets cannot be altered.

After adding a table, you can switch to the high-volume mode as per Standard and high-volume mode. Please refer to the same link for features that are not or only partially supported in the high-performance mode.

If you still experience the error after switching to the high-volume mode, 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.

• SAP Note 3428522  -The data cannot be displayed: the query process was stopped before it finished because it returned too many records. Please try filtering your data.
• Blog SAP Analytics Cloud, add-in for Microsoft Excel - New high-volume mode

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

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