A report misses data when compared to the Object Work List in the work center view.
For example, the report Customer Project Overview (PROCPIU02_Q0001) does not show all the Projects displayed in Project Management work center - Projects view when both the report and the view are filtered by: In Planning, Started or Released.
SAP Business ByDesign, all versions.
Reproducing the Issue
Go to Business Analytics work center.
- Go to Design Reports view.
Show All Reports.
Find the report PROCPIU02_Q0001.
Open the report by clicking on its name.
Filter by Project Status 1, 2, 3.
The list of Projects displayed is different from the one obtained in the Project Management work center - Projects view when filtering by In Planning, Started, Released.
The report uses Key Figures for which the Zero Suppression is activated in the Key Figure Settings. The documents with zero value in the Key Figures are not displayed because of this setting.
In the Report PROCPIU02_Q0001, the Projects that not displayed have zero value for the Key Figures Net Value - Ordered and Net Value - Invoiced.
You can check the Zero Suppression settings for Key Figures in the report with these steps (in HTML5):
Open the report.
- Go to View.
- Click on More [...] next to Key Figure and select Key Figure Settings.
- Go to the General tab.
In the section Zero Suppression, Apply Suppresion to Rows is set by default as Suppress When All Values Equal Zero.
You can change this setting to: `Do Not Suppress` to see all the documents with zero value for the Key Figures.
Report, Key Figure, Project, OWL, Data, Missing, Zero, Value, Suppression , KBA , customer project overview , zero suppression , suppress when all values equal zero , apply suppresion to rows , data missing , project , do not suppress , key figure , AP-PRO-ANA , Analytics , Problem