Clarity

 View Only
  • 1.  Is there a job that needs to be run to update the Estimate at Completion value?

    Posted Apr 13, 2016 12:17 PM

    We are looking at our Project Storyboard Report and find that the value in the Estimate at Completion is not correct.  Going back to the project, the correct number is within the Cost Plan, and that's where this number should pull from.  And it is baselined.  Is there a job that needs to be run to update the Project Storyboard Report?  Thank you!!



  • 2.  Re: Is there a job that needs to be run to update the Estimate at Completion value?

    Posted Apr 14, 2016 07:05 AM

    Have you tried running the "Update % Complete%" job ?

     

    NJ



  • 3.  Re: Is there a job that needs to be run to update the Estimate at Completion value?

    Posted Apr 14, 2016 02:59 PM

    I just ran it and it didn't update the value :-(



  • 4.  Re: Is there a job that needs to be run to update the Estimate at Completion value?

    Posted Apr 14, 2016 04:29 PM

    According to CA Clarity PPM Solution Pack r14.2 Product Guide Project Storyboard is a Crystal report and

     

    The earned value amounts are dependent upon running the Update Cost Totals or the Update Earned

    Value Totals jobs. The Update Cost Totals job is available in the Actions pull-down on the task list or

    baseline list. The Update Cost Totals job runs the following: Runtime extraction of rates (calculates

    rates based on the matrix but does not populate the data mart rate table), Update % Complete job,

    and Update Earned Value Totals job. If you want to update costs across several projects instead of

    updating costs for only one project, you should run the Update Earned Value Totals job from the

    Reports and Jobs menu. The Update Earned Value Totals job from the menu is the same as the

    Update Cost Totals job in the Actions pull-down, except it updates all the projects meeting the

    parameter criteria when run instead of updating only one project



  • 5.  Re: Is there a job that needs to be run to update the Estimate at Completion value?

    Broadcom Employee
    Posted Apr 14, 2016 04:24 PM

    Hi Kristine,

     

    Is this a BO or a Jaspersoft report?

     

    If BO, then please ensure the following jobs are run:
    Timeslicing
    Update BO Report tables
    Datamart Extraction

     

    If Jaspersoft, then the following jobs should be run to update the data:
    Timeslicing
    Update Report tables
    Load Data Warehouse
    Load Data Warehouse - Access Rights

     

    Please let me know how it goes. Thanks -Nika



  • 6.  Re: Is there a job that needs to be run to update the Estimate at Completion value?

    Posted Apr 15, 2016 12:51 PM

    Hi Nika -- It's a BO report.  And we do have all of these jobs scheduled to run regularly.  Thank you for your reply!



  • 7.  Re: Is there a job that needs to be run to update the Estimate at Completion value?

    Broadcom Employee
    Posted Apr 15, 2016 02:49 PM

    Hi Kristine,

     

    In this case please check what urmas said above : the jobs Update Cost Totals / Update Earned Value Totals jobs, this should work. Let us know how it went!

    Thanks -Nika



  • 8.  Re: Is there a job that needs to be run to update the Estimate at Completion value?

    Posted Apr 20, 2016 01:13 PM

    I investigated this a couple months ago with CA.  We had the same issue.  There is a lot involved in getting the EAC and the way CA calculates it is not the way we want it to, therefore we are having someone build a Storyboard report for our needs.   I also second what Urmas said plus here are the notes CA sent me about the EAC.  Hope it helps.

     

    For the EAC (Estimate at Completion) that is highlighted in that screen shot you provided in the Project Storyboard report, this is calculated as follows:

     

    Project ETC(COST) + Project ACWP

     

    The Estimate at Completion under Financial Performance in the Storyboard report should match the field 'EAC (T)' from the project. Is this not matching?

     

    To make sure it is matching and calculating correctly, I recommend adding the following fields to the project list page:

    * EAC (T)

    * ETC (Cost)

    * ACWP

    So, then EAC (T) should = ETC (Cost) + ACWP

     

    There is another EAC field called 'EAC' on the project list view. This field is calculated differently, and requires baselines, but this one isn't the one being pulled into the project storyboard report:

     

    EAC = ACWP + [(BAC – BCWP) / CPI] where CPI = BCWP / ACWP Baseline Required: Yes

     

     

    ACWP

    Displays the system-calculated value of Actual Cost of Work Performed (ACWP). This value is the total direct cost (based on posted actuals) that is incurred in performing work during a specified period. The cost calculation includes all actuals posted up until the as-of date or the system date (if no as-of date is provided). ACWP is calculated at the following levels:

    • Assignment
    • Detail-task

      ACWP = Sum of Actual Cost for all the assignments on the task

    • Summary-task

      ACWP = Sum of ACWP for all detail tasks in project

    • Project

     

    In short, ACWP is calculated by taking the actuals on the task * resource rate.

     

    EAC (T)

    Displays the system-calculated value of Estimate At Completion (EAC). This calculation is most often used when current variances are seen as typical of future variances.

      EAC (T) = ACWP + ETC

     

    ETC (Cost)

    Displays the system-calculated value of Estimate To Completion (ETC).

      ETC (Cost) = remaining labor cost + remaining non-labor cost

     

    How is the ETC(Cost) Calculated?

     

    ETC  x  the billing rate(from Rate Matrix). 

    • Can use the Team tab to calculate the ETC x the rate.

     

    From CA:

     

    Here's a link to the communities post I mentioned on our call: https://urldefense.proofpoint.com/v2/url?u=https-3A__communities.ca.com_message_98939930-2398939930&d=BQICaQ&c=6071WI5hme3qubAgsPInwSFFJUptGl1Ret_NIv4f0FM&r=Rgafss2eBPL3WxpuEQaP3DhgMmBoY9nK74o1rz8cVjA&m=4YGfAIzVqAe8LQ5kCWU7Lzcy42_OSdrXkLVZ2TXfu3Y&s=JOWQCn8UF2rL2AsZHqMpjfgm2uIO19JXtYJqls0AoB4&e=

     

    This one explains some of the earned value fields such as ETC Cost in a little more detail.

     

    ETC (Cost): Cost of Estimate to Complete

     

    ETC (Cost) = remaining labor cost (ETC * billing rate) + remaining non-labor cost

    Baseline Required: No