You are trying to pull weekly ETC hours for the next full year in Advanced Reporting, but we are getting data only until 8/15/2020. How would you get data to show for the remaining of that year as well?
You are also trying to pull timesheet data previous to 7/29/2018. How would you get data to show for those previous periods?
Release : All Releases
Component : CLARITY DATA WAREHOUSE
The weekly time periods that you see in the reports/views in Advanced Reporting depend on the weekly slices found under Administration - Time Slices. This would include any time slice with a Slice Period of Weekly and the Data Warehouse option checked.
In the above example, to get weekly periods past the week of 8/20/2020, there are two options, either:
Note: When changing the From Date on a weekly time slice, it needs to fall on the same day of the week that is set as the First Day of Work Week under Administration - Project Management - Settings.
To get the additional timesheet data to be available for past dates, similar steps would need to be done on the DAILYRESOURCETIMECURVE slice:
Reference also: Jaspersoft / reports known issues with Clarity