Steps to Reproduce
Expected Result: While saving the project or idea instances should be fast
Actual Result: The performance of Idea or Project instance is too slow
Release : All Supported Releases
Component : CA PPM INTEGRATIONS & INSTALLATIONS
The instance of strategy attribute is created under Project/Idea Instance and when you create the aggregated attribute under Investment its going to be one to many mapping causing the query to generate the Cartesian product and hence slowing down the performance while saving any of project or idea instance
Create an aggregate attribute Under Project and Idea Object so that instance created under Strategy object under Project and Idea is mapped as 1:1 relationship and performance should be better.