FC Criticality Testing and review

Test FC Bar, get detail, Adherence metrics

1- include SubVersion IS NULL condition

2- select * from dbo.Forecast_Change_Analysis — day by day change

select * from rpt.Forecast_Change_Dashboard – where RC required

select * from Process_Adherence_Metrics_FC – to Fullfil SIT FC Change process

3- material,couytry,fromdate,todate

material,Country,FCImpact,bucket,%Change

select alertso,alertsh from web.sr_alerts_forecast

where alertso > 1

group by alertso,alertsh

4- for FC impact,

[

    '-', --> 0

    'New SO criticality', --> 1

    'Increased SO criticality (1 week+)', --> 2

    'Increased SO criticality (< 1 week)',--> 3

    'New SR criticality', --> 4

    'Increased SR criticality (1 week+)', --> 5

    'Increased SR criticality (< 1 week)',  --> 6

    'New SH criticality', --> 7

    'Increased SH criticality (4 week+)',  --> 8

    'Increased SH criticality (< 4 week)', --> 9

    ''

 ]