SAP Knowledge Base Article - Public

2626721 - Data Missing in Report Compared to Work Center View

Symptom

A report 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, all versions.

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 by clicking on its name.
  6. Filter by Project Status 1, 2, 3.
  7. Apply.

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.

Cause

The report uses Key Figures for which the Zero Suppression is activated in the Key Figure Settings. Hence, the documents with zero value in the Key Figures are not displayed because of this setting.

In the Report PROCPIU02_Q0001, the projects that are not displayed have zero value for the Key Figures Net Value - Ordered and Net Value - Invoiced.

Resolution

You can check the Zero Suppression settings for Key Figures in the report with these steps (in HTML5):

  1. Open the report.
  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.

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

See Also

2650050 - Values Are Not Showing In The Report

Keywords

Report, Key Figure, Project, OWL, Data, Missing, Zero, Value, Suppression, projects missing in report , KBA , project , key figure , zero suppression , suppress when all values equal zero , data missing , customer project overview , do not suppress , apply suppresion to rows , project missing in report , AP-PRO-ANA , Analytics , AP-PRO-PRJ , Project , Problem

Product

SAP Business ByDesign all versions