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.
SAP Business ByDesign
Reproducing the Issue
Go to Business Analytics > Design Reports
- Find and open report XYZ
- Run the report
- No results are displayed
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.
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.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , SRD-SCM-ANA , Analytics Content , How To