A portlet based on the project object's status report is not performing well due to an Aggregated calculated attribute (ACA).
Steps To Reproduce:
1. On the Project object, create an attribute called "Overall Health Status" with the following properties
Filter: max( cop_prj_statusrpt.last_updated_date,"EQUALS",cop_prj_statusrpt.last_updated_date )
2. Create a portlet based on the project object.
ID, Name, Overall Health Status
3. Filter on the portlet on the numeric value based on the color (Overall Health Status):
90 : RED
50 : YELLOW
0 : GREEN
Expected: The portlet returns results within 10 seconds.
Actual: The portlet takes 2 to 4 minutes to return a couple of records matching.
The number of projects and its status reports has to be evaluated and the above filter condition will take time.
Release : 15.8.1
Component : CA PPM STUDIO
Since the ACA can introduce a performance issue based on a large number of projects and its status reports, consider the filter condition being used.
If it performs poorly, consider designing a process workflow to optimize the performance.