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 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. 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.

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 on More [...] next to Key Figure and select Key Figure Settings.
  4. 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.

Keywords

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

Product

SAP Business ByDesign all versions