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
- Launch Design Studio application.
- Try to export the content to Excel.
- 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