SAP Knowledge Base Article - Public

2896436 - Cost Center reports memory and performance issues

Symptom

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.

Environment

SAP S/4HANA Cloud

Reproducing the Issue

Display large amount of data using analytical Apps.

Cause

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

Resolution

  1. 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.
  2. 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.
  3. Limit the data using selection criteria or remove drill down characteristic.

Keywords

Analytical Queries, Analytical Query, Cost Centers - Actuals, Cost Centers - Plan/Actual, profit, loss, market segment, profitability, BRAIN_DEV135, dump , KBA , CO-OM-IS , Information System, iViews , BI-RA-AD-EA , Embedded Analytics for S/4 , CO-PA-IS , Information System , Problem

Product

SAP S/4HANA Cloud all versions