process_kpi/gsm_kpi_requirements.md

Required Input

• BH report
• Daily Report
• Dump file (2G dump)
• Number of last day for the analysis
• Number of days for blocking
• Sddch blocking threshold
• TCH blocking threshold
• Availability threshold
• TCH abis fails threshold

Analyse

DUMP

• Check that mandatory sheet exists in the dump
• Parse 2G databases
• Get number of TRX,TCH,SDCCH,amrSegLoadDepTchRateLower,amrSegLoadDepTchRateUpper from databases
• Add "GPRS" colomn equal to (dedicatedGPRScapacity * number_tch_per_cell)/100
• Get "Coef HF rate" by mapping "amrSegLoadDepTchRateLower" to 2G analysis_utility "hf_rate_coef" dict
• "TCH Actual HR%" equal to "number of TCH" multiplyed by "Coef HF rate"
• Get "Offered Traffic" by mapping approximate "TCH Actual HR%" to 2G analysis_utility "erlangB" dict

BH DATA

• Pivot KPI in BH report
• Calculate Average and Max of Traffic
• Average of TCH blocking
• Average of SDCCH blocking
• Count number of Days with TCH blocking exceeded TCH blocking threshold
• Count number of Days with SDCCH blocking exceeded Sddch blocking threshold
• Count number of Days with Availability below Availability threshold
• "TCH UTILIZATION (@Max Traffic)" equal to "Max_Trafic" divided by "offered Traffic"
• Add "ErlabngB_value" =MAX TRAFFIC/(1-(MAX TCH call blocking/200))
• Get "Target FR CHs" by mapping "ERLANG value" to 2G analysis_utility "erlangB" dict
• "Target HR CHs" equal to "Target FR CHs" * 2
• Get "Signal" and "GPRS" value from databases
• Target TCHs equal to Target HR CHs + Signal + GPRS + SDCCH
• "Target TRXs" equal to roundup(Target TCHs/8)
• "# of required TRXs" equal to difference between "Target TRXs" and "number of TRX"

Daily DATA

• Pivot KPI in Daily Report
• Count number of Days with Availability below Availability threshold
• Count number of Days with abis fails exceeded TCH abis fails threshold