SAP Knowledge Base Article - Public

3119812 - Export to Excel in Design Studio Embedded report hangs or takes a long time.

Symptom

The export to Excel functionality brings up the warning message notifying that with the amount of data currently selected memory and/or performance issues can arise

The data will then be exported – depending on the amount of data, it will take longer to be exported. Excel requires quite some time to fill and format since we need to retrieve all data cells from the Backend and push them into the Excel file with formatting.

Environment

Design Studio Embedded Analytics

Reproducing the Issue

  1. Launch Design Studio application.
  2. Try to export the content to Excel.
  3. The browser hangs or the export takes a very long time to finish.

Cause

Due to the amount of data, additional calls to the backend are required to export all the data since memory in browser is restricted - so the data is retrieved package-wise.

Therefore, refer to note: 2846990 - Information regarding Excel Export

Resolution

Embedded Design Studio is a Tool for analyzing Data. As such it does not support mass data.
The function "Export to Excel" is therefore not designed for the export of mass data and should not be used for this.

For more details, refer to '2557541 - Configuration of amount of data to retrieve from server'. 

The following as well is a good read about best practices concerning Fiori:

2881803 - FAQ: S/4HANA Fiori Best Practices - Collective Note

Keywords

Embedded Analytics, Design Studio, S4HANA Cloud, Performance, Export, Excel, Large amount of data, large Queries, Set safety belt for result set size
, KBA , BI-RA-AD-EA , Embedded Analytics for S/4 , Problem

Product

SAP S/4HANA Cloud 1911 ; SAP S/4HANA Cloud 2002 ; SAP S/4HANA Cloud 2102 ; SAP S/4HANA Cloud 2105 ; SAP S/4HANA Cloud 2108