ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Missing Time report missing data when DAILYRESOURCEAVAIL does not cover the entire period(s)

book

Article ID: 130054

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The Missing Time Report does not work as expected / 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.
As referenced at Missing Time

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: All
Component: Clarity Jaspersoft

Resolution

Set the DAILYRESOURCEAVAIL slice back to cover at least the entire time period of your report. In the example mentioned above, the 16 hours are getting calculated because this slice is set to start on a Thursday instead of the first day of the week. Since in this example an availability time slice only exists 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.

Additional Information

Reference also: Jaspersoft / reports known issues with Clarity