Calculation/Logic in Resource Availability report?

Dhiren Aghera · ‎04-01-2020

I am exploring the Resource Management module in my personal instance for providing a solution to my organisation. I am struggling to understand the Resource availability report within Resource management. I have two dummy resource created with the same properties, however, when I run the Resource availability report it shows different weekly hours. Can someone please help me understand what I am missing to understand here and how are the hours calculated.

Screenshot 1 - Project Manager 1 USI

Screenshot 2 - Project Manager 2 USI

abhinaykumar · ‎04-13-2020

Hi @Dhiren Aghera

Have you checked user_has_schedule table entries for these 2users?

If there are no entries in above table then OOTB 'Resource Management Schedule' will be applied for every user(8hours per day). This will be derived from 'com.snc.resource_management.default_schedule' property.

Ideally when aggregates are generated for new user then considering this schedule(40hours per week will be generated).

So, In your instance there is a change in schedule for Project Manager 1 USI before generating aggregates Or change in hours in default schedule.

Find default schedule and figure out the scheduled hours per day by checking schedule entries in 'cmn_schedule' table of that record.

Then click on 'Update Resource Capacity' link available in user record in Resource Manager View for both users. It will update the aggregates and makes in sync with schedule.

If my answer was able to solve your query please mark it as Helpful & Correct.

Thanks,

abhinay kumar nandagiri.

View solution in original post

abhinaykumar · ‎04-15-2020

Hi @Dhiren Aghera

We can view only availability of child groups(users of selected particular group)

In resource reports we don't have a way to select parent group and look at availability of all users in child group.

But there is another module 'Reports - New'(below resource reports), there we have platform reports.

You can select 'Resource - Group Member Allocation Details - Monthly (Hrs)' or 'Resource - Group Member Allocation Details - Weekly (Hrs)' and in filter criteria apply all the child groups that you want to look availability data.

I hope it will suffice your requirement.

Thanks,

Abhinay kumar nandagiri.

Dhiren Aghera · ‎04-15-2020

Absolutely. Will be good to have this included in the Resource reports as well.