I am using the Avail_Hours column in dwh table "DWH_RES_PERIOD_FACTS" for calculating the Resource availability for a period for a report. When I compared the data with the resource availability in Clarity the value is not matching. The Load data warehouse job ran properly. Can anyone let me know how the Avail_Hours column in DWH_RES_PERIOD_FACTS is getting populated and what calculation is using for the resource availability.
Anyone have idea about how Avail_Hours column is populating in DWH_RES_PERIOD_FACTS?
What you comparing the values to, is this a specific portlet in Clarity? Please specify it as some places may not be using the same data.
The AVAIL_HOURS in DWH DWH_RES_PERIOD_FACTS will be taking data from source view in PPM DWH_X_RES_AVAIL_PER_FACTS_V. This PPM view is getting the data from the Availability Time slices.
Please ensure that your Time Slices are configured as per the requirements in DWH.
Once you configured them, if you did any changes, please run Time slicing job to completion, then run Load Data Warehouse - Full Load and see if you see the correct values.
Hope this helps -Nika