Clarity: Earned Value History portlet is hard coded to use EV_MONTHLY from PRJ_EV_HISTORY.PERIOD_INTERVAL and is not editable out of the box.

Document ID : KB000053270
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

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:PERIOD_DATE@, 
       @SELECT:METRIC:USER_DEF:IMPLIED:H.ITD_ACWP:ACWP@, 
       @SELECT:METRIC:USER_DEF:IMPLIED:H.ITD_BCWP:BCWP@, 
       @SELECT:METRIC:USER_DEF:IMPLIED:H.ITD_BCWS:BCWS@, 
       @SELECT:METRIC:USER_DEF:IMPLIED:TRUNC(SYSDATE):TIME_NOW@ 
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 
HAVING @HAVING_FILTER@ 

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:

  1. 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.

Or:

  • 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.

Solution

WORKAROUND:
None, the query is not editable by the end user.

STATUS/RESOLUTION:
Resolved in PMO Accelerator 1.3, Clarity 12.0 and higher.

Keywords: CLARITYKB, CLRT-27333, PMO-163, clarity8open, clarity12resolved, pmo13resolved.