Otherwork time entries in MUX Reporting data providers

Products

• Clarity FedRAMP
• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Other work time entries not displayed in Data Providers where the Investment object is added

STEPS TO REPRODUCE

1. Get a user who is Open for Time Entry and track mode is PPM, let say ResourceA
2. Create a Classic Other Work instance and add ResourceA to the team
3. Create a project or investment, add ResourceA to the team and assign him to a task
4. Open a timesheet for ResourceA and add both tasks to the timesheet
5. Enter data and post the timesheet
6. Run the Load DWH job
7. Go to MUX > Reporting > Data Providers
8. Create a Data Provider called 2 joins
   • Add objects: Task, Time Entry, Timesheet
   • Add Joins:
     • Inner - Timesheet - Timesheet Key - Equals - Time Entry - Timesheet Key
     • Inner - Time Entry - Task - Equals - Task - Task Key
9. Go to the Preview tab
10. Add filter: Resource(Timesheet) = ResourceA
11. Add Task name and actuals columns to the grid
12. You can see the time entries of the timesheet posted
13. Go to MUX > Reporting > Data Providers
14. Create a Data Provider called 3 joins
    • Add objects: Task, Time Entry, Timesheet, Investment
    • Add Joins:
      • Inner - Timesheet - Timesheet Key - Equals - Time Entry - Timesheet Key
      • Inner - Time Entry - Task - Equals - Task - Task Key
      • Left - Task - Investment Key - Equals - Investment - Investment Key
15. Go to the Preview tab
16. Add filter: Resource(Timesheet) = ResourceA
17. Add Task name and actuals columns to the grid

Expected Results: The timesheet entries from the Project and Other Work entries are displayed

Actual Results: Time belonging to the Project is displayed, but Other Work time is missing

Environment

Clarity 16.4.X

Cause

This is caused by DE210778

Resolution

This is fixed in Clarity 16.5.0