Symptom
You are using report Customer Demand Details (SCMCDU01_Q0001), however it takes several minutes to load a small number of lines.
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to Business Analytics work center.
- Select Design Reports view.
- Find report Customer Demand Details (SCMCDU01_Q0001).
- Open the report.
- Use the relevant filter.
- Click Apply.
- Notice that the system takes several minutes to load the data returned.
Cause
You need to remove or replace the default selection of Last 12 months for Requested Delivery Year/Month of the report.
This will ensure that the orders of only the requested period are fetched by the report and would be faster, as a lot of data will be called when Last 12 months is utilized.
Resolution
- Go to Business Analytics work center.
- Select Design Reports view.
- Find report Customer Demand Details (SCMCDU01_Q0001).
- Open the report.
- Use the relevant filter.
- Delete the variable value for Requested Delivery Year/Month or change it for other selection.
- Click Apply.
Keywords
report, performance, load , KBA , report , performance , load , AP-CR-CR , Customer Requirement , How To
Product
SAP Business ByDesign all versions