SAP Knowledge Base Article - Public

2626721 - Data Missing in Report Compared to Work Center View

Symptom

Report PROCPIU02_Q0001 misses data when compared to the Object Work List in the work center view.

For example, the standard 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.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports view.
  3. Show All Reports.
  4. Find the report PROCPIU02_Q0001.
  5. Open the report.
  6. Filter by Project Status 1, 2, 3.
  7. Select Apply.
The projects displayed in report PROCPIU02_Q0001 differ from the projects shown in Project Management work center > Projects View when filtering by In Planning, Started, and Released statuses.

Cause

  • The report uses Key Figures for which Zero Suppression is enabled in the Key Figure settings.
  • In the report PROCPIU02_Q0001, the projects that are not displayed have a value of 0 for the Key Figures Net Value - Ordered and Net Value - Invoiced.
  • As a result, documents with a zero value for these Key Figures are automatically excluded from the report output.

Resolution

Steps to check the Zero Suppression settings for Key Figures in the report with these steps:

  1. Open the report PROCPIU02_Q0001.
  2. Go to View.
  3. Click More [...] next to Key Figure and select Key Figure Settings.
  4. Go to the General tab.

In the section Zero Suppression, Apply Suppression to Rows is set by default as Suppress When All Values Equal Zero.

Change this setting to: `Do Not Suppress` to see all the documents with zero value for the Key Figures.

See Also

KBA 2650050 - Values Are Not Showing In The Report

Keywords

PROCPIU02_Q0001; Report; Key Figure; Zero, Value; Suppression, Projects missing in report; Zero Suppression; Do Not Suppress , KBA , AP-PRO-ANA , Analytics , AP-PRO-PRJ , Project , Problem

Product

SAP Business ByDesign all versions