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!!
Have you tried running the "Update % Complete%" job ?
I just ran it and it didn't update the value :-(
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
Is this a BO or a Jaspersoft report?
If BO, then please ensure the following jobs are run:TimeslicingUpdate BO Report tables Datamart Extraction
If Jaspersoft, then the following jobs should be run to update the data:TimeslicingUpdate Report tablesLoad Data Warehouse Load Data Warehouse - Access Rights
Please let me know how it goes. Thanks -Nika
Hi Nika -- It's a BO report. And we do have all of these jobs scheduled to run regularly. Thank you for your reply!
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!
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)
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
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:
ACWP = Sum of Actual Cost for all the assignments on the task
ACWP = Sum of ACWP for all detail tasks in project
In short, ACWP is calculated by taking the actuals on the task * resource rate.
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
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).
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