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
-
Go to Business Analytics work center
- Select view Design Reports
- Search for report: Team Member Work Analysis
- Filter with respective project
- 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