Should making changes on a resource's calendar change the capacity shown on "Capacity vs. Demand by Resource" report

[navzjoshi00]

There is a resource for which the RM has marked the next 3 months as "No Work Day". However, when the "Capacity vs. Demand by Resource" is run, the capacity still shows as 1. Is this as designed or should making changes on the resource's calendar change the capacity shown on "Capacity vs. Demand by Resource" report ?

 

NJ

[Deactivated User]

My thinking is that capacity is availability coming from the calendars and it should.

The report apparently does not read the availability blob, but slices presumably the system slices.

You could track how far the availability set in calendar goes and put a trace to see where from the report takes the data or look at the source code if you have it.

[navzjoshi00]

The time periods that display in the report and all of the amounts being converted to FTE depend on the report calendar table. This table is populated by running the Update Business Objects Report Tables job with the update reporting calendar option checked. This job populates calendar periods and calculates FTE amounts based on the availability of the resource with Resource ID of 'admin' and the time slice with the name MONTHLYRESOURCEAVAILCURVE (Administration/Data Administration-Time Slices). This time slice must be configured to cover the periods displayed in this report or the report will not calculate FTE data for those periods.

The above is what is written on this thread -

Capacity vs Demand Report Issue

https://communities.ca.com/message/241730222#241730222

 

NJ

[navzjoshi00]

The RM had not marked the days as non-work day on resource's calendar, and hence they were unable to see that correctly on the report.

 

Here's another question - the RM wants the capacity to be 0.6 .... Is there a way we can set the non-work days on calendar that the calculation comes to 0.6 ? Might be a dumb question, but just want to check if there is any calculation / a way it can be achieved ?

 

NJ

[navzjoshi00]

Ok, this is what we did -

From Mar-2015 - May-2015, marked all Tuesdays and Fridays as Non-Workday

Expected:- The capacity would be 0.6

Actual:- Capacity showing 0.59, 0.64, 0.57

 

Question - Shouldn't the "Capacity vs. Demand by Resource" report show 0.6 for all the 3 months ? Is there something that I'm missing ?

 

NJ

[Roberto Barra]

Hi,

 

The values are correct.

 

You must consider the number of tuesdays, fridays, saturdays, mondays and the total number of days in each month.

 

For may, you have 10 weekend days, 9 tuesdays / fridays, and 31 days in the month. So: (31 - (10+9)) / (31 - 10) >> 12/21 >> 0,57

 

Regards,

Roberto Barra

[navzjoshi00]

Brilliant !

 

Thanks Roerto, you're a GEM

 

NJ

[Legacy User]

Thanks NJ for updating your own thread with the solution you found! This will help more users in searching for answers on similar issues.

[navzjoshi00]

A big thanks to Roberto for providing the calculation

 

Quick question though - The requirement is to have 0.60 across all the part time resources, but then, when you start calculating with the above formula, for, lets say a resource working for only 3 days a week, don't think you would be able to achieve .60 perfectly ????

 

NJ

[Anon Anon]

Set up a "shift" (part of the calendar) that is 0.6 of a working day, assign people to that shift full time - job done?

 

(the compromise with that solution is that when you are looking at monthly information there may be oddities ; eg worker works MON/TUE/WED and the new month is on the THU - loading will be off there).

 

The only real, full solution is to exactly model the working days for every single resource - which is possible, just a admin-intensive.

[navzjoshi00]

Hey Dave, thanks for this - "Set up a "shift" (part of the calendar) that is 0.6 of a working day, assign people to that shift full time - job done?"

 

I was thinking about that too and had advised the customer of the same, but the customer does not want to go that way (subtly calling the tool inflexible )

 

NJ

[navzjoshi00]

Also, can you throw some light on this ?

 

"The only real, full solution is to exactly model the working days for every single resource - which is possible, just a admin-intensive."

 

NJ

[Legacy User]

and please mark your own answer as correct