You get below errors when you are trying to display large amount of data with analytical Apps:
- The query result is very large and may cause memory and performance issues during export. We recommend you filter your selection further before proceeding. If you continue with export without further filtering, any memory and performance issues that may result will be at your own risk.
- The query returned more results than could be displayed. To see all results, please filter your selection further. Optionally, you can use the Excel Export functionality to view all results.
- Too much data requested; Add filter or remove drilldown characteristic.
SAP S/4HANA Cloud
Reproducing the Issue
Display large amount of data using analytical Apps.
There is a limitation of 10,000 rows and 50 columns in analytical Apps to protect system environments and guarantee a good overall performance and memory consumption. Usually a user is not able to review all 10.000 lines, and if he wants to review data which is not shown, then it indicates that his filters are set up incorrectly and should be modified. Also the app should be responsive, you don't want to wait more than a minute for the output.
See the following SAP Note for more details
2447353 - Result set size restrictions for Design Studio / Lumira components e.g. Spreadsheet
2557541 - Configuration of amount of data to retrieve from server
- If the data is not too much and an OutOfMemory will not occur then you can Export the data to Excel. Export to Excel will try to export all data.
- The Fiori Apps usually have 2 Tiles. An accessible one and a non accessible one. The non-accessible App uses tool Design Studio. The accessible App uses another tool. The limitation only refers to the non-accessible App. You can use the "Accessible" version of the App.
- Limit the data using selection criteria or remove drill down characteristic.
Analytical Queries, Analytical Query, Cost Centers - Actuals, Cost Centers - Plan/Actual, profit, loss, market segment, profitability, BRAIN_DEV135, dump, Sales Orders - Actuals, 10000 rows, memory, performance, query result, very large, export , KBA , CO-OM-IS , Information System, iViews , CO-PA-IS , Information System , BI-RA-AD-EA , Embedded Analytics for S/4 , Problem