Allocations By Resource: Error adding TSV Total Columns
search cancel

Allocations By Resource: Error adding TSV Total Columns

book

Article ID: 259742

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

In the Staffing Workspace, 'Allocations by Resource' when you add any TSV Total column (other than the Allocation field) you get the API-1057 Toast message. Adding the fields on the 'Allocations by Investment' layout works as expected. 

Steps to Reproduce: 

  1. Go to the Staffing Workspace Allocations Timeline tab
  2. For the 'Allocations by Investment' layout add one of the TSV Total columns such as Hard Allocation or any other Total field (the column is added successfully) 
  3. Switch to the 'Allocations by Resource' layout 

Expected Results: The page loads successfully without a Toast message. 

Actual Results: The results do not load and you get a Toast message: API-1057 : An attribute needs to be groupable or aggregatable to be used in group by or aggregation respectively. Attributes used in 'groupBy' and 'aggr' must be present in fields. 'sort' and 'expand' cannot be used with 'groupBy'. 

Workaround: When using the 'Allocations by Resource' layout remove the Total columns or switch to another view that does not use these columns in the layout. 

   

Environment

Release 16.1.1 

Cause

DE68494 

Resolution

Due to the complexities of this issue, it has been determined it is not a candidate for a Patch request. 

Targeted Fix in Release 16.1.2 

Attachments