Included aged information within DWH_TME_SHEET table on Data Warehouse

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

We need historical timesheet data in DWH and the job is only populating 2 years worth of data by default. How to increase this range?

Environment

Release : 15.9.3,16.0

Resolution

The Number of rows that are included in DWH_TME_SHEET and DWH_TME_ENTRY are dependant on Time slice Request DAILYRESOURCETIMECURVE with slice id 55555.

By Default the above time slice is set for 730 periods which is around 2 years worth of timesheet data. In case you want data from a historical data then we need to update the slice start date and number of periods to reflect the desired range. 

Once the change is done and time slices are caught up, run the Datawarehouse Full Load to populate the data.  

Note :- Increasing/changing the slice range will cause this specific time slice to be re-sliced and the Time slice job will take longer to complete. Time slice job and DWH job will take significantly longer as there is more data to process.