Symptom
You are reporting on top of data source Supply Planning Product Exceptions [SCMEXCV01] and see that no data is retrieved in report results, even without any filters in the report.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to Business Analytics > Design Reports
- Find and open report XYZ
- Run the report
- No results are displayed
Cause
Due to a standard display limit of 5000 Exceptions, data source Supply Planning Product Exceptions [SCMEXCV01] will not retrieve data unless some filtering to be applied in the fields Material ID and Supply Planning Area ID in order to retrieve data. This is designed to prevent performance issues in the system.
Resolution
Add the fields Material ID and Supply Planning Area ID into report selection, and then apply some filters on these fields via value help. Once it is done the report should then retrieve data.
Keywords
Material ID, Supply Planning Area ID, Report Selection, Data Source Supply Planning Product Exceptions, SCMEXCV01, Apply Filters, Data Source, No Data, Exceptions. , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , SRD-SCM-ANA , Analytics Content , How To