Error API-1057 on Cost Plan Details when adding certain Per Period Metrics with active Compare & Grouping By a field

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

In Cost Plan Detail View, with an active Compare and Group By, certain Per Period metrics will throw an error API-1057  when adding them as a column to the view

STEPS TO REPRODUCE:

1. Connect to Clarity MUX – Open a financially enabled project with at least 2 cost plans and details on them
2. Group By any field, i.e. Resource or Cost Type
3. Open Columns menu and check all the Per-Period Metrics in by selecting the checkbox
4. Note the view reloads and you are able to see them added
5. Take out all the Per-Period Metrics
6. Now add another plan in the Compare To field
7. Once loaded, open Columns menu and check all the Per-Period Metrics in with the checkbox again

Expected Results: The columns to be added successfully when Compare is used with Group by

Actual Results: Metrics are added. Error 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''.

DevTools shows HTTP 400 Bad request

 

Note: if you add the columns one by one, some of the metrics do not throw an error. These columns seem to always cause the error:

• Actual Revenue
• Cost
• Forecast
• Revenue

Environment

Clarity 16.2.3, 16.3.0, 16.3.1

Cause

DE167763

Resolution

• Fixed in Clarity 16.3.2

Workaround:

Add all the columns you need to the view first, before adding a comparison. Once you added them, you can also save the view for use with Compares

Or

Do not Group By