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.

book

Article ID: 53270

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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:[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:

  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.

Environment

Release: ESPCLA99000-12.1-Clarity-Extended Support Plus
Component: