The out of the box Earned Value History portlet pulls its data via the Earned Value History query
SELECT @SELECT:DIM:USER_DEF:IMPLIED:PERIOD_DATE:H.PERIOD_END_DATE:[email protected], @SELECT:METRIC:USER_DEF:IMPLIED:H.ITD_ACWP:[email protected], @SELECT:METRIC:USER_DEF:IMPLIED:H.ITD_BCWP:[email protected], @SELECT:METRIC:USER_DEF:IMPLIED:H.ITD_BCWS:[email protected], @SELECT:METRIC:USER_DEF:IMPLIED:TRUNC(SYSDATE):[email protected] FROM PRJ_EV_HISTORY H WHERE @[email protected] and H.OBJECT_TYPE='PROJECT' AND H.PERIOD_INTERVAL='EV_MONTHLY' AND [email protected]:param:xml:integer:/data/id/@[email protected] GROUP BY H.PERIOD_NUMBER,H.ITD_ACWP,H.ITD_BCWP,H.ITD_BCWS,H.PERIOD_END_DATE HAVING @[email protected]
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:
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.