Reset SQL Curves in MUX for few records
search cancel

Reset SQL Curves in MUX for few records


Article ID: 278684


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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?


  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
  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)