Clarity

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  Should making changes on a resource's calendar change the capacity shown on "Capacity vs. Demand by Resource" report

    Posted 03-24-2015 06:51 AM

    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



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

    Posted 03-24-2015 07:05 AM

    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.



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

    Posted 03-24-2015 07:45 AM

    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



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

    Posted 03-25-2015 05:55 AM

    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



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

    Posted 03-26-2015 04:38 AM

    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



  • 6.  Re: Should making changes on a resource's calendar change the capacity shown on "Capacity vs. Demand by Resource" report
    Best Answer

    Posted 03-26-2015 07:45 PM

    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



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

    Posted 03-27-2015 03:38 AM

    Brilliant !

     

    Thanks Roerto, you're a GEM

     

    NJ



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

    Posted 03-26-2015 11:47 PM

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



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

    Posted 03-27-2015 06:18 AM

    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



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

    Posted 03-27-2015 06:37 AM

    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.



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

    Posted 03-27-2015 07:49 AM

    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



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

    Posted 03-27-2015 07:51 AM

    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



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

    Posted 03-26-2015 11:48 PM

    and please mark your own answer as correct