Reset SQL Curves in MUX for few records

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

We noticed that a few numbers in Per Period Metrics in MUX Grids are not correct, we are seeing mismatches, how can we address this?

Resolution

1. Find out the record(s) that have the issue, and the SQL Curve affected (Use SQL Curves list and slice recalculation if needed)
2. Run the query to reset the SQL Curve to null, example for Actuals:
   update prteam set odf_nk_actuals_curve = null where prid = <5xxxxxx> ----replace with actual IDs affected
   commit
3. Run Time Slicing Sync job to completion (note - on some environments it may take a while after you reset for many records, test the timings on a lower environment first)