View with Group By significantly slower in Staffing workspace with Per Period Metrics

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

View with Group By significantly slower in Staffing workspace with Per Period Metrics enabled, returns in many minutes vs few seconds without Group By or without Per Period Metrics

 

STEPS TO REPRODUCE:

1. On a large dataset, with admin user
2. Connect to Modern UX - Staffing workspace
3. Create few views that return at least 50k or records, 100 per page

Basic View - contains only OOTB basic fields such as Resource name, Project Name etc.

Basic View with Group By on Resource Name

4. Now add Per Period Metrics - Allocation , 12 months, with Grand Totals, test the timings

View with Per Period Metrics Allocation

View with Per Period Metrics Allocation and Group by Resource Name

5. Now add Per Period Metrics - Remaining Availability, 12 months, with Grand Totals, test the timings

View with Per Period Metrics Allocation and Remaining Availability

View with Per Period Metrics Allocation and Remaining Availability and Group by Resource

 

Expected Results: Group by should not cause a very significant slowdown in performance

Actual Results: The Group By views return in multiple minutes vs few sec without the Group By

Environment

Release : 16.0.1, 16.0.1.1, 16.0.2

Resolution

This is DE64536, targeted for 16.0.2.1 and 16.0.3