2400924 - Data Limits When Executing and Downloading Reports - SAP Business ByDesign

System either crashes or returns an XML error message while executing a report.

SAP Business ByDesign

One example of report could be:

1. Go to General Ledger work center.
2. Go to Lists view.
3. Open G/L Account - Line Items report.
4. Fill in the selection parameters.
5. Click Go.

Error message: "See XML error message in property XmlMessage"

A system crash might also be thrown when exporting data to Excel via Download button.

Taking as example the G/L Account - Line Items:

• This report shows all line items on G/L accounts and even includes the journal entry line items for each journal entry of a given G/L Account; hence this report can easily lead into a time-out.
• Whether or not the report runs through can also depend on what other system activities are performed at this time, which background jobs are running, local internet connection etc. For this reason, the data set size may vary.
• Consider that both the analytics framework in the application as well as the Excel add-in are subject to time outs when handling an over-dimensioned number of records, which imposes some limits to data extraction.
• This is not only a matter of number of rows but also number of columns in the report. In the current example, if characteristic Journal Entry Item is removed, the number of records may be considerably reduced.

In such cases, selection parameters need to be adapted to retrieve a suitable number of records and download.

For example, define an accounting period and define a posting date range within this accounting period

Further selection parameters can be included in the report as follows:

1. Click Add Fields button.
2. Expand the dimensions and include in the report the required fields to refine your selection.

In case there's performance issue in custom reports, refer to KBA 2366796 - Best Practices for Modeling Data Sources and Reports - Performance.

Performance. Report. Analytics Report. , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To