ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 237853

calendar_today

Updated On:

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

  1. 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

  1. 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