We do not use Modern User Experience (UX) and would like to remove the SQL Curves data, as it's slowing down job performance. How can we do that?
Release : 15.9.1+
Component : CLARITY TIME SLICING
Please run the SQL Curves removal queries below:
update niku.prassignment
set odf_nk_prestcurve =null,
odf_nk_practcurve =null,
odf_nk_etccost_curve =null,
odf_nk_actcost_curve =null
commit
update prteam
set odf_nk_alloccost_curve =null,
odf_nk_hardallccost_curve =null,
odf_nk_odf_pralloccurve =null,
odf_nk_odf_hard_curve =null
commit
update fin_cost_plan_details
set odf_nk_billing_cost =null,
odf_nk_billing_revenue =null,
odf_nk_cost =null,
odf_nk_revenue =null,
odf_nk_units =null,
odf_nk_cost_variance =null,
odf_nk_revenue_actual =null,
odf_nk_units_variance =null,
odf_nk_cost_actual=null,
odf_nk_units_actual=null,
odf_nk_revenue_variance =null
commit
The queries may run for a long time before completing on large dataset.
Note: This will remove all the SQL Curves data in Modern UX: i.e. Staffing, Assignments, Financial data in the TSV. Classic UI is not affected. To be run with caution as it removes slice data.