Remaining Availability slow in Per Period Metrics

book

Article ID: 222323

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

Issue/Introduction

When we add Remaining Avaiability to Per Period Metrics we notice a major slowdown of the response time

STEPS TO REPRODUCE

  1. Connect to a very large dataset (Modern UX) with over 450k records in Staffing page
  2. Go to Staffing page
  3. Note it takes over 30-40 sec to get all records to return
  4. Make sure there is no grouping and filter
  5. Filter to return 1 year worth of data
  6. Now add a Per Period Metrics - 12 months - Grand Totals - Allocation
  7. Note the timing is 27 sec
  8. Now remove Allocation and add Remaining Availability instead
  9. Note the timing

Expected Results: The page to respond and return results within reasonable time, comparable to Allocation

Actual Results: Remaining Availability in Per Period Metrics takes at least 1min 20 sec which is 3 times more than Allocation
The same issue can be observed on Project - Staff page

Environment

Release : 15.9.3

Component : Clarity MUX UI Usability

Resolution

This is DE62279, fixed in 16.0