CA Clarity Missing Time report not working as expected.

book

Article ID: 130054

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Missing Time Report does not work correctly if there is no resource availability.

For example, the week on the report should display a total of 40 Available hours per resource, but instead it is only showing 16 hours. 

Cause

Since the report looks at the daily resource availability it cannot produce correct results if those time slices are not available.
This is documented in each product guide 

- Advanced Reporting with Jaspersoft
  - PMO Accelerator Advanced Reporting Content
     - Missing Time 


https://docops.ca.com/ca-ppm/15-6/en/advanced-reporting-with-jaspersoft/pmo-accelerator-advanced-reporting-content/time-management-reports/missing-time

Specifically: 

The resource available hours are calculated based on the time slice with the name DAILYRESOURCEAVAILCURVE (Administration/Data Administration-Time Slices). This time slice is not a Data Warehouse request, therefore, it must be configured to cover the dates that are displayed in this report or the report does not display data for those dates.

Environment

Release:
Component: ODJSP

Resolution

Set the DAILYRESOURCEAVAIL slice back to cover at least the entire time period of your report. In the example mentioned here, the 16 hours are getting calculated becuase this slice is set to Start on a Thursday instead of the first day of the week. Since for this week, an availability time slice only exist for Thursday and Friday, this is where the 16 hours are coming from. 

Note that the DAILYRESOURCEAVAIL slice rolls over monthly so make sure you set it back far enough to cover the monthly rollover.