SAP Knowledge Base Article - Public

2813939 - Planned Work shows Doubled value in Project Report

Symptom

You have maintained X hours (X represents number of hours) as planned work in project.

But the Planned work field shows doubled value (2X) in Report: Team Member Work Analysis.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics work center
  2. Select view Design Reports
  3. Search for report: Team Member Work Analysis
  4. Filter with respective project
  5. The Planned Work shows doubled value

Cause

The key figure "Planned Work" gets its data both from the project as well as from the baseline. X h(h refers to Unit Of Measurement) in the project and X h in the baseline are summed up to 2X h.

If you add an additional characteristic, e.g. "Baseline Task", which gets its data only from the baseline, you will see the result is split up into two rows.

There is the key figure "Baseline Work (h)" available, which shows only the work of the baseline.

Resolution

Currently there is no such key figure available for planned work only from the project. But the underlying data source PROPRJU04 (Projects, Baselines: Tasks and Staffing) will be enhanced with future release so that you can build custom report based on this enhanced data source.

If you need a key figure already now, which shows only the planned work of the project, you can create a custom report in the Business Analytics Work Center based on the data source PROPRJU04 and create a new restricted key figure with a fixed restriction on "Source of Data" to the value "Project Task Service".

Keywords

Planned Work, Project Report, Baseline Task , KBA , project report, planned hours , baseline , AP-PRO-ANA , Analytics , How To

Product

SAP Business ByDesign 1902 ; SAP Business ByDesign 1905