Who else is bumping up against the Design Studio limitation of 10,000 rows? When will Design Studio applications in S/4HANA Cloud be able to handle more than this?

[former_member95896]

Hello,

My company continues to run into issues with Design Studio applications for Finance and Accounting (Trial Balance, P&L Actual, P&L Actual/Plan, Custom Analytical Queries, etc.) where our data set exceeds 10,000 rows of data and is cut off by the application. We have hundreds of cost centers and profit centers (1-2 for each of our stores as retail/fast casual restaurant company) and when we want to do analysis or extracts by cost center and GL account in a single report we consistently bump up against this limitation.

There is a workaround in some cases, but it is unrealistic to expect a standard user to apply this everytime:

1. Open any other Design Studio app
2. Set the filters and press ok
3. Manipulate the url by adding following

?XDATALIMIT_COLS=-1&XDATALIMIT_ROWS=-1

The place where you should add this manipulation is here (example is the P&L Actual app):

https://my300420.s4hana.ondemand.com/ui#CompanyCode-analyzeActualsPC?XDATALIMIT_COLS=-1&XDATALIMIT_R... 

Is anyone else encountering this issue?

When will SAP expand Design Studio past this limitation?

Thanks!

Ryan Muller

Sr. Business Systems Analyst

MOD Pizza

[former_member95896 · Accepted solution]

Good news on this one: SAP is now allowing excel exports of more than 10,000 line items with design studio apps as of a release or two ago!

[former_member94298]

Interesting update - and good to hear that SAP are being responsive in the face of this sort of 'real world' problem that only manifests itself once a system has been live for some time.

[former_member95896]

We faced it faster than most because of our structure (300+ GL accounts x 200+ stores at really any line item or date detail pushed us past it), but agree that it is good that we're being heard.