• 1.  Question on role capacity segments in Portfolio XOG

    Posted 04-07-2015 02:06 PM

    I am looking to build a process that will XOG in the current available capacity for roles into a portfolio plan to show up on the Targets page.  Basically I will do a SQL query to determine what the remaining available # of FTEs is per role factoring out all approved projects resources associated to the roles are booked to.


    I XOGed out a test portfolio to see how the structure is set up and I am trying to understand how it is getting the values for the segments.  See example:


    These numbers are really large and also don't fit neatly into even monthly segments as they appear on the Targets page.  I'd like to know what these values are based on as I've tried many different mathematical equations trying to look at the totals and never seem to get close.


    <Role code="ANALYST_BUSINESS" target="0.0">


                                    <Segment finish="2015-01-02T00:00:00" start="2015-01-02T00:00:00" sum="53327.01075162037"/>

                                    <Segment finish="2015-01-08T00:00:00" start="2015-01-05T00:00:00" sum="227825.67211692382"/>

                                    <Segment finish="2015-01-09T00:00:00" start="2015-01-09T00:00:00" sum="56437.93127528658"/>

                                    <Segment finish="2015-01-12T00:00:00" start="2015-01-12T00:00:00" sum="56437.93127528658"/>

                                    <Segment finish="2015-01-15T00:00:00" start="2015-01-13T00:00:00" sum="170869.25408769285"/>

                                    <Segment finish="2015-01-16T00:00:00" start="2015-01-16T00:00:00" sum="54882.471013453476"/>

                                    <Segment finish="2015-01-19T00:00:00" start="2015-01-19T00:00:00" sum="1036.9735078887359"/>

                                    <Segment finish="2015-01-20T00:00:00" start="2015-01-20T00:00:00" sum="56437.93127528658"/>

                                    <Segment finish="2015-01-22T00:00:00" start="2015-01-21T00:00:00" sum="113912.83605846191"/>

                                    <Segment finish="2015-01-23T00:00:00" start="2015-01-23T00:00:00" sum="56437.93127528658"/>

                                    <Segment finish="2015-01-26T00:00:00" start="2015-01-26T00:00:00" sum="56956.418029230954"/>

                                    <Segment finish="2015-01-27T00:00:00" start="2015-01-27T00:00:00" sum="57474.90478317532"/>

                                    <Segment finish="2015-01-28T00:00:00" start="2015-01-28T00:00:00" sum="56956.418029230954"/>

                                    <Segment finish="2015-01-29T00:00:00" start="2015-01-29T00:00:00" sum="57474.90478317532"/>

                                    <Segment finish="2015-01-30T00:00:00" start="2015-01-30T00:00:00" sum="56956.418029230954"/>

                                    <Segment finish="2015-02-02T00:00:00" start="2015-02-02T00:00:00" sum="57474.90478317532"/>

                                    <Segment finish="2015-02-04T00:00:00" start="2015-02-03T00:00:00" sum="113912.83605846191"/>

                                    <Segment finish="2015-02-06T00:00:00" start="2015-02-05T00:00:00" sum="112875.86255057316"/>

                                    <Segment finish="2015-02-11T00:00:00" start="2015-02-09T00:00:00" sum="172424.71434952595"/>

                                    <Segment finish="2015-02-13T00:00:00" start="2015-02-12T00:00:00" sum="113912.83605846191"/>

                                    <Segment finish="2015-02-16T00:00:00" start="2015-02-16T00:00:00" sum="1036.9735078887359"/>

                                    <Segment finish="2015-02-17T00:00:00" start="2015-02-17T00:00:00" sum="56437.93127528658"/>

                                    <Segment finish="2015-02-18T00:00:00" start="2015-02-18T00:00:00" sum="56956.418029230954"/>

                                    <Segment finish="2015-02-20T00:00:00" start="2015-02-19T00:00:00" sum="114949.80956635064"/>

                                    <Segment finish="2015-02-23T00:00:00" start="2015-02-23T00:00:00" sum="57474.90478317532"/>


  • 2.  Re: Question on role capacity segments in Portfolio XOG

    Broadcom Employee
    Posted 04-08-2015 04:02 AM

    Seconds? I.e. divide by 3600 to get Hours?


    Can you give an example of the value you expect? E.g. what capacity do you expect for Business Analyst for Jan?

  • 3.  Re: Question on role capacity segments in Portfolio XOG

    Posted 04-08-2015 08:12 AM

    I’m expecting 111 BA’s for Jan.


    That seems crazy that it would be down to seconds.

  • 4.  Re: Question on role capacity segments in Portfolio XOG

    Broadcom Employee
    Posted 04-08-2015 03:59 PM

    2 questions:


    - What do you expect the 'remaining capacity' to be for Jan

    - What are your default 'hrs per day'

  • 5.  Re: Question on role capacity segments in Portfolio XOG

    Posted 04-08-2015 04:06 PM

    I haven’t worked on what I expect remaining capacity to be yet.


    I’m just trying to figure out first where the XOG is getting those numbers from so I can understand how to code the remaining capacity.


    When I look at the Targets page on the Portfolio right now and hit the Populate Capacity button for the roles, the Business Analyst role shows values between 109 – 112 per month.


    I’m also trying to understand why the XOG shows what seems to be random segments of 2-4 days.


    As for default hours per day it’s 8.