On the Weekly Detail or Booking Status Portlets in CA Project & Portfolio Management (PPM), the query takes huge amount of time to return results. The performance degrades as the data volume increases.
This happens when the user has instance or OBS Level access to a larger number of resources.
Steps to Reproduce:
Expected Result: To display results in a reasonable time regardless of the security access granted to the user.
Actual Result: It takes a long time to display results or never returns results. Performance degrades as the number of instances increases granted to the user access.
The intention of the design and use of these portlets is for a Resource Manager having access to a limited number of resources in the system for managing the planning aspect of investment work. It is not intended for use as a reporting tool, please use a reporting tool or the data warehouse.
As referenced in the Resource Management section of the Getting Started with Classic CA PPM documentation, configuring a user with Instance or OBS Unit access for a larger number of resources may impact the performance of these portlets. There are a few configuration changes that can be implemented that will help to improve the performance for these portlets. You can implement some or all configuration ideas.