Symptom
All tasks available in a project are not appearing in this report.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business analytics work center
- Go to Design Reports
- Search for reportRevenue by Team Member
- Filter with respective project ID
- In rows add Project, Project task and Team member
- and execute you will see that few taks are missing
However if you go to Report ID: PROPRJU05_Q0001 and do same filtering and rows and columns mentioned above, you will see all project tasks are not appearing.
Cause
The purpose of both reports are different:
Report PROPRJU05_Q0001 Project Time Recordings is project based.
Report PROCPIU03_Q0001 Revenue by Team Member is expense based.
In general all Project tasks are shown for which expenses exist,but above reports or respective data source has a restriction that they would excludes expenses that are assigned to sales orders with item type: fixed price, cause we do not calculate a revenue for these expenses.
Resolution
In case all project tasks are needed we recommend you to create your own report .i.e you can create join data source using one data source PROCPIU03 - Revenue Contribution and other data source where the desired data exist.
Keywords
Project tasks missing in report,Revenue by team member report not pulling all tasks,fixed price tasks not appearing , KBA , AP-PRO-PRJ , Project , Problem