The out of the box Earned Value History portlet pulls its data via the Earned Value History query
FROM PRJ_EV_HISTORY H
WHERE @FILTER@ and H.OBJECT_TYPE='PROJECT' AND H.PERIOD_INTERVAL='EV_MONTHLY' AND H.PROJECT_ID=@where:param:xml:integer:/data/id/@value@
GROUP BY H.PERIOD_NUMBER,H.ITD_ACWP,H.ITD_BCWP,H.ITD_BCWS,H.PERIOD_END_DATE
which has the H.PERIOD_INTERVAL hardcoded to EV_MONTHLY.
In 8.1.1 and higher it should be pulling data from the PRJ_EV_HISTORY based on the project's Earned Value Reporting Period, if any.
In pre 8.1 it needs to be editable so that users that set the Interval for the Create Earned Value Snapshot job to Weekly can use this portlet rather than have to custom code their own.
Steps to Reproduce:
- Either attempt to display the portlet on a pre 8.1.1 box after running the Create Earned Value Snapshot job with Interval as weekly.
- Upgrade a system with EV_WEEKLY data only in the PRJ_EV_HISTORY table and attempt to display the portlet.
Expected Results: To see data based on the PRJ_EV_HISTORY Contents for this project.
Actual Results: You do not see any results.
None, the query is not editable by the end user.
Resolved in PMO Accelerator 1.3, Clarity 12.0 and higher.
Keywords: CLARITYKB, CLRT-27333, PMO-163, clarity8open, clarity12resolved, pmo13resolved.