SAP Knowledge Base Article - Public

2708008 - Excel Add-In Limits the Number of Rows in Inserted Reports

Symptom

You inserted a report into SAP Excel Add-In and noticed a message in the last row saying "Result set has been cut off; hiding NNNNN rows".

Environment

SAP Cloud for Customer

SAP Business ByDesign

Reproducing the Issue

  1. Open MS Excel
  2. Go to SAP HYBRIS / BUSINESS BY DESIGN tab
  3. Log into the tenant myNNNNNN
  4. Click on Insert Report
  5. Select and add the report XYZ
  6. Note that not all report rows are being displayed, and there is a message at the bottom informing: "Result set has been cut off; hiding NNNNN rows".

Cause

Excel SAP Add-In limits the total rows by default in order to improve the performance of inserted reports.

Resolution

In order to display more values, you can make use of the "Dynamic Paging" function, through the following steps:

  1. After you inserted the report as per steps above, click on "Show/Hide" button
  2. Click on Dynamic Paging
  3. In Dynamic Paging box, set the maximum limit of rows to be displayed (e.g. 300000)
  4. Refresh the report
  5. The report will now display the total rows as per maximum limit defined above

* Note that allowing too much rows to be displayed via Dynamic Paging may result in performance loss, so it is expected your report may take several minutes to load up.

Keywords

Excel Reports; Rows Cut Off; Limited Rows; Excel Add-in; Missing Rows , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP BUSINESS BYDESIGN 1902 ; SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Cloud for Customer 1808 ; SAP Cloud for Customer 1811 ; SAP HYBRIS C4C ADDINS 1902