Advanced Reporting Timesheet Detail Report displays incorrect totals. When there are Other Work items as well as several tasks listed on the timesheet, the totals appear to include the Other Work and only the last line of the task group.
Steps to Reproduce:
- In Clarity PPM Classic UI, create a timesheet
- Add several Task lines and enter hours in various days and task lines
- Add Other Work Item and enter hours on this line as well.
- Approve and Post Timesheet
- Run Load DW (full load)
- Run Timesheet Detail Report. Select the specific OBS information for the resource and select the correct timesheet period.
Expected Result: Total hours match the timesheet and the detailed hours on the report.
Actual Result: Report shows incorrect hours. Appears to be the Other Work hours and only the last line of the task group. Hours are incorrect.