Missing time information from Adhoc Views
search cancel

Missing time information from Adhoc Views

book

Article ID: 367301

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

It is noticed that it is not possible to obtain all the missing time information by creating an Adhoc View in Advanced Reporting. Following possibilities have been explored:

  1. Adhoc View using the 'Time Management' domain, using missing time related attributes, which make use of the DWH_TME_MISSING_TIME_V view
  2. Adhoc View using the 'Time Management' domain, but using just the 'Timesheet Status', 'Time Reporting Period' and 'Resource Name' fields
  3. A custom domain on the PPM schema by using the PRTIMESHEET, PRTIMEPERIOD, SRM_RESOURCES tables

The main challenge has been identified to be those timesheets that are not even opened by end users, resulting in their data not being populated in the PRTIMESHEET table.

'Missing Time' out of the box report has been identified to be working as expected, providing even that data which cannot be obtained by a simple Adhoc View.

Resolution

  • Use the 'Missing Time' report to obtain missing time information
  • Customize the 'Missing Time' report as required