SAP Knowledge Base Article - Public

3209606 - Performance of report Customer Demand Details

Symptom

The report "Customer Demand Details" is low to load, for example when opening the value help for "Sourced from".

Environment

SAP Business byDesign

Reproducing the Issue

  1. Go to the work center Business Analytics and the view Design Reports.
  2. Open Customer Demand Details.
  3. In the selection, open the value help for "Sourced From".

It loads for several minutes before anything is shown.

Cause

We have implemented some code changes to improve the performance of the report. However, the performance in the Value help cannot be changed completely due to the following reasons:

The root cause is due to the high number of data in the system. During the call of the value help, the system traverses through all of these records and stores them temporarily. Since the records are high, it takes times for this activity.

However note that after selecting the value help, the report execution is faster, since the system does not need to derive the orders again (unless the selections are changed).

So you could for example run the report first with the default selections and then select the Values from the Value help. This will make the value help much faster.

Resolution

Unfortunately, due to the distinct design of the underlying data source SCMCDU01, this behavior in the value help cannot be addressed with a short term change.

You can register this on the Influence Portal to be taken up in a future release.

Keywords

Customer demand details, report, performance, too slow, reporting, SCMCDU01_Q0001 , KBA , AP-CR-ANA , Analytics , Product Enhancement

Product

SAP Business ByDesign 2022