您好,欢迎来到九壹网。
搜索
您的当前位置:首页PMS公式定义

PMS公式定义

来源:九壹网
KPI名称告警类别下行RLC流量MCS1比例CELL下行RLC流量MCS6比例CELL下行RLC流量MCS8比例CELL下行RLC流量MCS9比例CELL下行RLC数据重传率_CSx上行RLC数据重传率_CSXCELLCELL下行RLC数据重传率_MCSXCELL上行RLC层平均吞吐量CELLprp_load_minber_bin0ber_bin3ber_bin7cpu_usage_maxin_intra_nc_suc_rateohoa_downqual_ratiomsc_ho_suc_rategprs32k_ul_not_avlms_class_7_reqch_dl_tx_pwrl_meanDPROCCARRIERCARRIERCARRIERgprocnbrnbrbsscellcellcarrierdownlink_ber_bin3carrierTotal_LostAvailable_Sdcch_MeanTCH_Erlang下行TBF失败率上行RLC层cs1上行RLC层cs2ul_data_fluxmat_pegsm_dcs1799ber_mean1fer_mean2chan_req_ms_fail0chan_req_ms_fail1frmrI_frames_txCall_Duration_per_call_perfratio_of_ohoa_downqual_to_all_ho_causesin_intra_nc_atmptchannel_reqs_rejms_class_2_reqavail_pdtch_meanAccess_per_RachcellsystembssCELLSYSTEMSYSTEMSYSTEMcellcarriercarriercarriercarrieromlrslcellcellnbrcellcellcellcelldownlink_ber_bin0carrierRACH成功接入比例MTL_U_RXbssmtluplink_ber_bin6carrierber_bin1drop_call_rate_plmn_newho_req_msc_okDL_PDTCH_Q_LENGTH_MAXI_frames_rxsabm_txPage_req_from_mscchan_req_cause_atmptintra_cell_ho_retDrop_Call_RateCARRIERsystemcellCELLrslrslcellcellcellsystemDrop_Call_Rate_withoutsystem_intracellmtp_msu_txmtlmtp_sif_sio_rxmtlohoa_adj_chn_intf_rationbrair_dl_blks_q3_cs1air_dl_blks_q3_cs2ms_class_9_reqms_class_11_reqcellcellcellcelldownlink_ber_bin5carrieruplink_ber_bin2carrierRSL_U_TXrsl下行TBF成功建立总数SYSTEM上行edgeTBF平均持续时长SYSTEM的分母drop_call_rate_bss_newbssAvailable_Tch_Mean小区内TBF下行成功建立总数下行RLC层cs1上行RLC层cs3下行RLC层cs3mtu_pgsm_egsminv_est_cause_rachrf_losses_sdma_complete_to_mscmat_dcs2000_onlymat_pgsm_dcs1799busy_tch_maxbusy_tch_meanfrmrSDCCH_Block_RateI_frames_txsabm_txinvalid_frames_rxinvalid_frames_rxsystemCELLSYSTEMSYSTEMSYSTEMcellcellcellcellcellcellcellcellcblcellomlomlxblrslAccess_Per_PCHcellSDCCH_Mean_Holding_Tcellimein_intra_bss_ho_clrcellPages_Per_Secondgprs32k_ch_switchgprs32k_dl_not_avlcs12_on_32k_changprs_acc_per_agchcellcellcellcellcelltotal_intra_cell_ho_lospath_balance_maxinvalid_frames_rxcellcarrieromlsabm_txcblTCH_Mean_Holding_TimbsseSDCCH_Block_RatebssAvailable_Tch_MeanTCH_Erlangchan_req_fail_rollcm_serv_req_smsn2_expirySDCCH_ErlangSDCCH_Mean_Holding_TimeMean_Time_Between_DropsAvailable_Sdcch_Meanbsscellcellcellxblbssbssbssbssbusy_sdcch_maxcellLocation_Updates_PerCacellllmtp_congestionmtlmtp_rxair_ul_data_blkschannel_reqs_recdrop_probabilityroc_mincustcom_drop_callRSL_U_RXHO_Failure_Recovered_RateCALL_S_POST_C_TCHHO_Lost_Per_Call_Ratein_intra_bss_eq_failHandover_Failure_Rateia_pgsm_ho_failmtlcellcellsystemcarriercellrslsystemcellbsscellcellcellia_invalid_freq_hocellho_fail_no_resource_intrcella_cellrf_losses_tch0carrierber_mean3Intf_on_idle_mean4path_balance_meann2_expiryI_frames_rxfrmrI_frames_txRSL_Utilization_RXn2_expirycarriercarriercarrieromlcblxblxblrslrslPage_responseHO_Lost_Per_Call_RateHO_Failure_Recovered_RatecellcellcellRation_of_SMS_to_Callscellin_intra_bss_ho_losprp_pd_dem_mean下行TBF失败率下行EDGE流量cellDPROCSYSTEMBSS上行数据流量BSSavg_simul_dl_tbfs_meanCELL下行RLC流量MCS4比例CELL无线接入性CELL下行数据流量BSSintra_cell_ho_reqin_inter_bss_eq_failDrop_Call_Rateout_ho_cause_atmpt下行edgeTBF平均持续时长的分子TCH_Mean_Holding_TimeCustomer_SDCCH_Block_RateTotal_Callsmtu_pgsm_onlyma_cmd_to_msalloc_tch_Failber_mean2I_frames_txTotal_CallsAvailable_Sdcch_MeancellcellbsscellSYSTEMsystemsystemsystemcellcellcellcarriercblbsscellOk_acc_procHO_Lostsdcch_congestionalloc_sdcchcm_serv_req_callout_inter_bss_ho_atmTCH拥塞次数_不含切换TCH平均占用时长半速率信道掉话次数ber_bin6ohoa_congestion_ratioair_dl_blks_q3_cs4ho_success_ratepch_page_q_discrdo_intra_bs_ho_losSDCCH占用时长in_inter_bss_ho_succellcellcellcellcellcellBSSCARRIERCELLCARRIERnbrcellsystembsssystemcellcellohoa_powerbdgtcellmean_time_between_hacellndoversegprs_avail_pdtch_meanCELLul_data_fluxmtp_re_txBSSmtlohoa_powerbdgt_rationbrohoa_band_reasign_ratinbroms_class_1_10_reqcellms_class_10_reqdrop_probabilitydl_busy_pdtch_meandl_data_fluxbusy_tch_hr_meanHO_Failure_Recovered_Ratemtu_dcs2000_onlyGPRS_AVAIL_PDTCH_MAX上行RLC层cs4小区上行EGPRS数据总量KBytecellbsscellcellSYSTEMbsscellCELLSYSTEMCELLHandover_Success_RatecellHandover_Loss_Ratemat_pgsm_egsmidl_tch_bnd3_meancellcellcellfer_mean0fer_mean_avechan_req_ms_fail4Intf_on_idle_mean1ohoa_congestionout_intra_bss_ho_atmMTL_Utilization_RXgbl_flow_ctrl_sentRatio_OHOA_PBGTIntra_cell_HO_LOSTair_ul_blks_q3_cs1air_ul_blks_q3_cs2air_dl_blks_q3_cs3ms_class_4_reqroc_maxcarriercarriercarriercarriercellcellmtlcellcellsystemcellcellcellcellcarrierdownlink_ber_bin2carrierCustomer_TCH_Block_Rsystemate下行话音质量0_2级CARRIERdrop_call_rate_newcellCall_Setup_Success_RatsystemeCELL_FLUSH_REQSCELLIntf_on_idle_mean7Intf_on_idle_avesabm_txfrmrAvailable_Tch_Meanalloc_sdcch_failcarriercarrierxblrslcellcellLocation_Update_Factorcellratio_of_ohoa_bandhandcellover_to_all_ho_causesout_inter_bss_rq_msccongestion_msumsu_discardedohoa_upqual_ratioms_class_3_reqms_class_11_20_reqcellmtlmtlnbrcellcelluplink_ber_bin0carrieruplink_ber_bin4carrieruplink_ber_bin5carrierHO_Lost_Per_Call_RateHO_Lost_Per_Attempt_RateTotal_Lost无线原因导致的下行TBF异常释放的比例GPRS上行RLC层流量ia_dcs1800_ho_atmptpgsm_to_pgsm_ho_failure_Ratepgsm_to_dcs1799_ho_failure_Ratealloc_tchber_mean_avechan_req_ms_fail3systemsystemsystemCELLCELLcellcellcellcellcarriercarrierchan_req_ms_fail5carrierDrop_Call_Rate_withoutbss_intracellohoa_upinterfcellSD拥塞次数ohoa_distance_ratioBSSnbrTch_Assign_Fail_RatecellSDCCH_Access_Failure_cellRatems_class_12_reqcellpage_responsedrop_probabilitydl_data_fluxTCH_ErlangSDCCH_Access_FailureSDCCH_RF_Lost_Rateconn_req_to_mscma_req_from_mscsystemcellSYSTEMsystembssbsscellcellho_fail_no_resource_intrcella_bssrf_losses_tch4carrierrf_losses_tch_totalfer_mean4TCH_Mean_Holding_TimeTCH_RF_LostHO_Lost_Per_Attempt_Rateintra_cell_ho_sucDrop_Call_RateNumber_of_Handovers_Per_CallIMSI_Detach_PerCallRatio_of_IMSI_Detaches_to_CallsTCH_ACCESS_FAILcpu_usage_mincarriercarriercellcellcellcellcellcellcellcellBSSDPROC小区EGDE下行RLC吞吐量CELLber_bin5pages_per_secondms_class_1_reqms_class_5_reqHOpercallCARRIERbsscellcellcellMTL_U_TXmtl下行edgeTBF平均持续时长SYSTEM的分母SDCCH_Block_RatesystemPDCH信道分配成功率下行RLC层cs4上下行分开统计CS3使用比例cipher_mode_failconn_refusedimsi_detachrf_loss_tch_rollcalls_queuedBSSSYSTEMCELLcellcellcellcellcellrf_losses_tch5rf_losses_tch6msc_no_assign_reqHO_Lostsms_init_on_sdcchintra_cell_ho_loscarriercarrierbssbsscellcellRanking_Formulabssassgn_redireccellRanking_Formulacellratio_of_ohoa_powerbdgcellt_to_all_ho_causes下行TBF建立成功率CELLma_cmd_to_ms_blkdma_fail_from_mssec_assign_sucia_egsm_ho_atmptmat_pgsm_onlymtu_pgsm_dcs1999mtu_pegsm_dcs1999offered_erlang_tchcellcellcellcellcellcellcellcellcong_stand_ho_atmcellho_fail_no_resource_intceller_bssfer_mean5carrierIntf_on_idle_mean0ohoa_distanceTotal_LostSDCCH_Mean_Holding_TimeTCH_RF_LostHO_Lost_Per_Attempt_RateCustomer_TCH_Block_Ratebad_ho_refnum_msmtu_pegsm_dcs1799rf_losses_tch7ber_mean7fer_mean7carriercellbsssystemsystembssbsscellcellcarriercarriercarrierratio_of_ohoa_upqual_tocell_all_ho_causesohoa_upqualcellohoa_uplevelohoa_downqualcm_reestablishlocation_updateout_intra_bss_ho_sucmtp_sif_sio_txsl_congestionohoa_downlevel_ratiocellcellcellcellcellmtlmtlnbrohoa_downinterf_rationbrohoa_bandhandover_ratinbroms_class_6_reqcellho_success_rateRACH成功捕获率TCH_RF_Lost_RatePDCH占用数bsscellsystemSYSTEM下行数据流量SYSTEM上行话音质量0_2级CARRIERHO_LostTCH_Block_Ratesystembssmsc_ho_succellDL_PDTCH_Q_LENGTH_CELLMEANI_frames_rxomlI_frames_rxTCH_Block_Ratecm_serv_req_emergxblcellcellRatio_of_Location_Updatcelles_to_Callsintra_cell_ho_atmcellRanking_FormulasystemDrop_Call_Rate_withoutcell_intracellCall_Duration_plan_perfcellohoa_downlevelohoa_downinterfcpu_usage_maxcellcellDPROCuplink_ber_bin1carrierin_intra_bss_ho_retpdu_discard_llcchan_req_ms_fail_tchf小区下行EGPRS数据总量KBytecellCELLCARRIERCELLGPRS下行RLC层流量ia_egsm_ho_failber_mean0busy_tch_hr_meanber_bin4air_dl_data_blksgprs_acc_per_rachgprs_ch_switchedHO_ATMCELLcellcarrierCELLCARRIERcellcellcellbssdownlink_ber_bin1carrierdownlink_ber_bin4carrierGPRS_AVAIL_PDTCH_MECELLAN质量切换次数cell上下行分开统计CS1使用比例mtu_pgsm_dcs1799sec_assign_atmptia_pgsm_ho_atmptia_dcs2000_ho_failfer_mean1chan_req_ms_fail2chan_req_ms_fail7chan_req_ms_fail_totalohoa_band_handoverCELLcellcellcellcellcarriercarriercarriercarriercell上行话音质量0_2级SYSTEMber_bin2out_ho_nc_cau_atmptbusy_tch_meanalloc_tch_carrCARRIERnbrcarriercarrierchannel_reqs_rej_rateul_busy_pdtch_meanTCH重分配率每线ERLbusy_tch_hr_meancellcellcellcellBSS上行数据流量SYSTEMSDCCH_Access_FailureSDCCH_Erlangin_inter_bss_ho_clrHandover_Attemptmat_pgsm_dcs1999systemsystemcellcellcell小区下行数据总量KByteCELLDL_BUSY_PDTCH_MAX下行RLC层cs2ia_dcs2000_ho_atmptia_invalid_freq_asgnmat_dcs1800_onlyidl_tch_bnd0_meanidl_tch_bnd2_meanrf_losses_tch1rf_losses_tch3ber_mean5Intf_on_idle_mean2out_intra_bss_ho_rettbf_sessions_mean下行TBF建立成功率上行TBF失败率sl_stop_congestioncpu_usage_meancpu_usage_minout_ho_nc_suc_rateohoa_uplevel_ratioair_ul_blks_q3_cs4ms_class_21_29_reqSMSperCALLo_inter_bs_ho_clrroc_meanCELLSYSTEMcellcellcellcellcellcarriercarriercarriercarriercellDPROCSYSTEMSYSTEMmtlgprocgprocnbrnbrcellcellbsssystemcarrierin_inter_bss_clr上下行分开统计CS4使用比例bssCELL下行edgeTBF平均持续时长CELL上行edgeTBF平均持续时长CELLho_req_msc_failcelldcs1800_to_dcs1799_hocell_failure_RateIntf_on_idle_mean5carrierinvalid_frames_rxn2_expiry质量切换比例Page_Success_RatecblcblcellcellPCH_page_q_discardcellCall_Setup_Success_RatcelleSDCCH_Erlangcell下行RLC重传比例busy_sdcch_mean下行PDTCH利用率test无线接通率上下行分开统计CS2使用比例idl_tch_bnd1_meanTCH_RF_LostSDCCH_Access_Failureohoa_band_re_assignsdcch_rf_loss次数avail_sdcch_max无线接入性dl_data_fluxohoa_upinterf_ratioair_ul_blks_q3_cs3ms_class_8_reqch_ul_tx_pwrl_meanSYSTEMcellCELLBSSSYSTEMCELLcellbsscellcellBSSCELLSYSTEMBSSnbrcellcellcarriero_inter_bs_ho_suc_ratesystemuplink_ber_bin3carrierSDCCH_RF_Lost_RateTCH_Block_Rate上行edgeTBF平均持续时长的分子Mean_Time_Between_DropsCall_Setup_Success_RateTCH_RF_Lost_Ratein_inter_bss_ms_nsmat_pegsm_dcs1999mtu_dcs1800_only上行RLC块重传比例下行RLC块重传比例systemsystemSYSTEMsystembssbsscellcellcellCELLCELLout_intra_bss_ho_reqcellout_intra_bss_ho_pri_blcellkout_inter_bss_ho_clrcellprp_load_maxcpu_usage_meanprp_pd_dem_maxPDCH信道分配成功率ia_dcs1800_ho_failcong_exist_ho_atmber_mean4ber_mean6fer_mean3fer_mean6RSL_Utilization_TXMTL_Utilization_TXDPROCDPROCDPROCSYSTEMcellcellcarriercarriercarriercarrierrslmtlTCH_RF_Lost_RatecellCustomer_SDCCH_Blockcell_RateTotal_CallscellOk_acc_proc_suc_rachcellout_intra_bss_ho_losprp_load_meantbf_sessions_maxavail_tch_maxul_data_fluxcellDPROCDPROCCELLcelldownlink_ber_bin6carrierdownlink_ber_bin7carrierdcs1799_to_pgsm_ho_facellilure_RateMean_Time_Between_Drcellops小区上行数据量KByteCELLPDCH信道分配成功率tch_congestionrf_losses_tch2chan_req_ms_fail6Intf_on_idle_mean6path_balance_minCELLcellcarriercarriercarriercarrieruplink_ber_bin7carrierCustomer_SDCCH_Block_RateSDCCH_RF_Lost_RateCustomer_TCH_Block_Rate半速率信道数SMSs_PerCallratio_of_intra_cell_HO_to_all_HOsratio_of_intra_bss_HO_to_all_HOsratio_of_inter_bss_HO_to_all_HOsratio_of_intra_cell_HO_lost_to_HO_attemptsratio_of_intra_bss_HO_lost_to_HO_attemptsratio_of_inter_bss_HO_lost_to_HO_attemptsratio_of_intra_cell_HO_failure_to_HO_attemptsratio_of_intra_bss_HO_failure_to_HO_attemptsratio_of_inter_bss_HO_failure_to_HO_attemptsout_inter_bss_ho_sucin_intra_bss_ho_sucgprs_cell_cong_rateDL_BLER_GPRSbsscellcellCELLcellcellcellcellcellcellcellcellcellcellcellcellCELLCELLchan_req_ms_fail_sdcchCARRIERsdcch_access_failCARRIER[chan_req_ms_fail_sdccCELLh_roll][chan_req_ms_fail_tchh]CELL[chan_req_ms_fail_tchf]CELLcs1234_on_k_chan上行TBF建立成功率CELLSYSTEMDL_BLER_EGPRSCELLchan_req_ms_fail_tchhCARRIER小区EDGE上行吞吐量CELL小区可用和占用PDTCH信道CELL差egprs_k_channels_swiCELLtched上行TBF建立成功率CELL上行TBF失败率CELL上行信道请求成功率CELL上行EDGE吞吐量SYSTEM下行EDGE吞吐量SYSTEM下行RLC层EDGE流量SYSTEM上行EDGE流量SYSTEMGPRS拥塞率上行RLC重传比例SYSTEMSYSTEM上行信道请求成功率SYSTEM上行EDGE流量BSSGPRS拥塞率HOpercallBSSSYSTEM下行话音质量0_2级SYSTEM上行话音质量0级SYSTEM下行话音质量0级SYSTEM上行话音质量考核级SYSTEM下行话音质量考核级SYSTEM下行RLC流量MCS2比例CELL下行RLC流量MCS3比例CELL下行RLC流量MCS5比例CELL下行RLC流量MCS7比例CELL下行同时TBF数CELL上行RLC数据重传率_MCSXCELL无线接入性BSS下行RLC层平均吞吐量CELLIntf_on_idle_mean3cm_serv_req_suppohoa_adj_chan_intfout_inter_bss_ho_retcarriercellcellcell告警公式isnull(100*((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22)/((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148),0)isnull(100*((dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74)/((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148),0)isnull(100*((dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136)/((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148),0)isnull(100*((dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148)/((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148),0)isnull(100*(dlrlcretxblks_cs1+dlrlcretxblks_cs2+dlrlcretxblks_cs3+dlrlcretxblks_cs4)/(dlrlcretxblks_cs1+dlrlcretxblks_cs2+dlrlcretxblks_cs3+dlrlcretxblks_cs4+dlrlcaknewbks_cs1+dlrlcaknewbks_cs2+dlrlcakneisnull(100*(ulrlc_retxbks_cs1+ulrlc_retxbks_cs2+ulrlc_retxbks_cs3+ulrlc_retxbks_cs4)/(ulrlc_retxbks_cs1+ulrlc_retxbks_cs2+ulrlc_retxbks_cs3+ulrlc_retxbks_cs4+ulrlcaknewbks_cs1+ulrlcaknewbks_cs2+ulrlisnull(100*(dlrlcretxblks_mcs1+dlrlcretxblks_mcs2+dlrlcretxblks_mcs3+dlrlcretxblks_mcs4+dlrlcretxblks_mcs5+dlrlcretxblks_mcs6+dlrlcretxblks_mcs7+dlrlcretxblks_mcs8+dlrlcretxblks_mcs9)/(dlrlcretxblks_mcs1+dlrlcretxblks_mcs2+dlrlcretxblks_mcs3+dlrlcretxblks_mcs4+dlrlcretxblks_mcs5+dlrlcretxblks_mcs6+dlrlcretxblks_mcs7+dlrlcretxblks_mcs8+dlrlcretxblks_mcs9+dlrlcaknewbks_mcs1+dlrlcaknewbks_mcs2+dlrlcaknewbks_mcs3+dlrlcaknewbks_mcs4+dlrlcaknewbks_mcs5+dlrlcaknewbks_mcs6+dlrlcaknewbisnull(( ULRLCAKNEWBKS_CS1 * 22+ULRLCAKNEWBKS_CS2 * 32+ULRLCAKNEWBKS_CS3 *38+ULRLCAKNEWBKS_CS4 * 52+ULRLCAKNEWBKS_MCS1 * 22 + ULRLCAKNEWBKS_MCS2* 28 +ULRLCAKNEWBKS_MCS3 * 37 + ULRLCAKNEWBKS_MCS4 * 44 + ULRLCAKNEWBKS_MCS5 * 56 +ULRLCAKNEWBKS_MCS6* 74 +ULRLCAKNEWBKS_MCS7 * 112 + ULRLCAKNEWBKS_MCS8* 136 +ULRLCAKNEWBKS_MCS9 *148)*8/1000/ (ULRLCAKNEWBKS_CS1+ULRLCAKNEWBKS_CS2+ULRLCAKNEWBKS_CS3 +ULRLCAKNEWBKS_CS4+ ULRLCAKNEWBKS_MCS1 +ULRLCAKNEWBKS_MCS2+ULRLCAKNEWBKS_MCS3+ULRLCAKNEWBKS_MCS4+ULRLCAKNEWBKS_MCS5+ ULRLCAKNEWBKS_MCS6+ ULRLCAKNEWBKS_MCS7 + ULRLCAKNEWBKS_MCS8+ULRLCAKNEWBKS_MCS9+ULRLC_RETXBKS_CS1 + ULRLC_RETXBKS_CS2 + ULRLC_RETXBKS_CS3 +ULRLC_RETXBKS_CS4 + ULRLC_RETXBKS_MCS1 + ULRLC_RETXBKS_MCS2 + ULRLC_RETXBKS_MCS3 +ULRLC_RETXBKS_MCS4 + ULRLC_RETXBKS_MCS5 + ULRLC_RETXBKS_MCS6+ ULRLC_RETXBKS_MCS7+ ULRLC_RETXBKS_MCS8 + ULRLC_RETXBKS_MCS9) *50,0)isnull(prp_load_min,0)isnull(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7,0)isnull(ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+ber_bin3_ts7,0)isnull(ber_bin7_ts0+ber_bin7_ts1+ber_bin7_ts2+ber_bin7_ts3+ber_bin7_ts4+ber_bin7_ts5+ber_bin7_ts6+ber_bin7_ts7,0)isnull(cpu_usage_max,0)isnull(in_intra_nc_suc/in_intra_nc_atmpt,0)isnull(ohoa_downqual/out_ho_nc_cau_atm,0)isnull(sum(o_inter_bs_ho_atm)/sum(o_inter_bs_rq_msc)*100,0)isnull(gprs32k_ul_not_avl,0)isnull(ms_class_7_req,0)isnull(ch_dl_tx_pwrl_mean,0)isnull((ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+ber_bin3_ts7)/(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+bisnull(call_s_post_c_tch,0)isnull(sum(avail_sdcch_mean),0)isnull(sum(busy_tch_mean),0)isnull((air_dl_tbf_fl_et)*100/(tbf_dl_asgn_pacch+imm_assgn_cse_6+imm_assgn_cse_8),0)isnull(sum(ulrfbk8psk1ts_cs1 + ulrfbk8psk2ts_cs1 + ulrfbkgmsk1ts_cs1 + ulrfbkgmsk2ts_cs1),0)isnull(sum(ulrfbk8psk1ts_cs2 + ulrfbk8psk2ts_cs2 + ulrfbkgmsk1ts_cs2 + ulrfbkgmsk2ts_cs2),0)isnull(sum(23*(ulrlcaknewbks_cs1+ulrlcnanewbks_cs1)+33*(ulrlcaknewbks_cs2+ulrlcnanewbks_cs2)+39*(ulrlcaknewbks_cs3+ulrlcnanewbks_cs3)+53*(ulrlcaknewbks_cs4+ulrlcnanewbks_cs4))/10000,0)isnull(mat_pegsm_dcs1800 ,0)isnull(ber_mean1,0)isnull(fer_mean2,0)isnull(chan_req_ms_fail0,0)isnull(chan_req_ms_fail1,0)isnull(frmr,0)isnull(I_frames_tx,0)isnull(busy_tch_mean/total_calls*100 ,0)isnull(ohoa_downqual/out_ho_caus_atmpt*100,0)isnull(in_intra_nc_atmpt,0)isnull(channel_reqs_rej,0)isnull(ms_class_2_req,0)isnull(avail_pdtch_mean,0)isnull(access_per_rach,0)isnull((ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7)/(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+bisnull(sum(ok_acc_proc_suc_r)/sum(access_per_rach),0)isnull((mtp_msu_rx*6+mtp_sif_sio_rx)*8/mtp_link_ins*1000/000*100,0)isnull((u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7)/(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7+u_ber_bin7_ts0+u_ber_bin7_ts1+u_ber_bin7_ts2+u_ber_bin7_ts3+u_ber_bin7_ts4+u_ber_bin7_ts5+u_ber_bin7_ts6+u_ber_bin7_ts7),0)isnull(ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7,0)isnull(sum(call_s_post_c_tch)*100/sum(total_calls),0)isnull(ho_req_msc_ok ,0)isnull(dl_pdtch_q_len_mx,0)isnull(I_frames_rx,0)isnull(sabm_tx,0)isnull(page_req_from_msc ,0)isnull(chan_req_caus_atm,0)isnull(intra_cell_ho_ret ,0)isnull((sum(rf_loss_tch_roll)+sum(intra_cell_ho_los)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/(sum(total_calls)+sum(isnull(assgn_redirect,0)))*100,0)isnull((sum(rf_loss_tch_roll)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/(sum(total_calls)+sum(isnull(assgn_redirect,0)))*100,0)isnull(mtp_msu_tx,0)isnull(mtp_sif_sio_rx,0)isnull(ohoa_adj_chn_intf/out_ho_nc_cau_atm,0)isnull(air_dl_blks_q3_cs1,0)isnull(air_dl_blks_q3_cs2,0)isnull(ms_class_9_req,0)isnull(ms_class_11_req,0)isnull((ber_bin5_ts0+ber_bin5_ts1+ber_bin5_ts2+ber_bin5_ts3+ber_bin5_ts4+ber_bin5_ts5+ber_bin5_ts6+ber_bin5_ts7)/(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+bisnull((u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7)/(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7+u_ber_bin7_ts0+u_ber_bin7_ts1+u_ber_bin7_ts2+u_ber_bin7_ts3+u_ber_bin7_ts4+u_ber_bin7_ts5+u_ber_bin7_ts6+u_ber_bin7_ts7),0)isnull(i_frames_tx/3600/95*100,0)isnull(sum(dl_pdtch_seizure),0)isnull(sum(ul_pdtch_seizure - air_ul_tbf_fl_dt - air_ul_tbf_fl_t),0)isnull(sum(call_s_post_c_tch)/(sum(total_calls)+sum(i_inter_bs_ho_suc))*100,0)isnull(sum(avail_tch_mean),0)isnull(dl_pdtch_seizure,0)isnull(sum(dl_rf_bks_1ts_cs1 + dl_rf_bks_2ts_cs1 + dl_rf_bks_3ts_cs1 + dl_rf_bks_4ts_cs1),0)isnull(sum(ulrfbk8psk1ts_cs3 + ulrfbk8psk2ts_cs3 + ulrfbkgmsk1ts_cs3 + ulrfbkgmsk2ts_cs3),0)isnull(sum(dl_rf_bks_1ts_cs3 + dl_rf_bks_2ts_cs3 + dl_rf_bks_3ts_cs3 + dl_rf_bks_4ts_cs3),0)isnull(mtu_pgsm_egsm ,0)isnull(inv_est_cause_rach ,0)isnull(rf_losses_sd ,0)isnull(ma_complet_to_msc ,0)isnull(mat_dcs2000_only ,0)isnull(mat_pgsm_dcs1800 ,0)isnull(busy_tch_max ,0)isnull(busy_tch_mean ,0)isnull(frmr,0)isnull(alloc_sdcch_fail/(alloc_sdcch+alloc_sdcch_fail)*100,0)isnull(i_frames_tx,0)isnull(sabm_tx,0)isnull(invalid_frames_rx,0)isnull(invalid_frames_rx,0)isnull(access_per_pch,0)isnull(busy_sdcch_mean/alloc_sdcch*3600 ,0)isnull(i_intra_bs_ho_clr ,0)isnull(page_req_from_msc/3600 ,0)isnull(gprs32k_ch_switch,0)isnull(gprs32k_dl_not_avl,0)isnull(cs12_on_32k_chan,0)isnull(gprs_acc_per_agch,0)isnull(intra_cell_ho_los,0)isnull(path_balance_max,0)isnull(invalid_frames_rx,0)isnull(sabm_tx,0)isnull(sum(busy_tch_mean)/sum(alloc_tch)*3600,0)isnull(sum(alloc_sdcch_fail)/(sum(alloc_sdcch)+sum(alloc_sdcch_fail))*100,0)isnull(sum(avail_tch_mean),0)isnull(busy_tch_mean,0)isnull(chan_req_fail_rol ,0)isnull(cm_serv_req_sms ,0)isnull(n2_expiry,0)isnull(sum(busy_sdcch_mean),0)isnull(sum(busy_sdcch_mean)/sum(alloc_sdcch)*3600,0)isnull(sum(busy_tch_mean)/(sum(rf_loss_tch_roll)+sum(intra_cell_ho_los)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_los))*3600,0)isnull(sum(avail_sdcch_mean),0)isnull(busy_sdcch_max ,0)isnull(location_update/total_calls ,0)isnull(mtp_congestion,0)isnull(mtp_msu_rx,0)isnull(air_ul_data_blks,0)isnull(channel_reqs_rec,0)isnull((sum(rf_loss_tch_roll)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/sum(busy_tch_mean)/60*100,0)isnull(roc_min,0)isnull((o_intra_bs_ho_los+o_inter_bs_ho_clr+rf_loss_tch_roll)/(total_calls)*100,0)isnull(i_frames_rx/3600/95*100,0)isnull((sum(o_intra_bs_ho_ret)+sum(o_inter_bs_ho_ret))/(sum(o_intra_bs_ho_atm)+sum(o_inter_bs_ho_atm))*100,0)isnull(call_s_post_c_tch,0)isnull((sum(intra_cell_ho_los)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/(sum(total_calls)+sum(i_inter_bs_ho_suc))*100,0)isnull(i_intra_bs_eq_fa ,0)isnull((o_inter_bs_ho_ret+o_intra_bs_ho_ret+intra_cell_ho_ret)/(o_inter_bs_ho_atm+o_intra_bs_ho_atm+intra_cell_ho_f_f+intra_cell_ho_f_h+intra_cell_ho_h_f+intra_cell_ho_h_h)*100,0)isnull(ia_pgsm_ho_fail ,0)isnull(ia_invld_frq_ho ,0)isnull(intra_cell,0)isnull(rf_losses_tch0,0)isnull(ber_mean3,0)isnull(intf_on_idle_mean4,0)isnull(path_balance_mean,0)isnull(n2_expiry,0)isnull(i_frames_rx,0)isnull(frmr,0)isnull(i_frames_tx,0)isnull(i_frames_rx/(3600*95),0)isnull(n2_expiry,0)isnull(page_response ,0)isnull((intra_cell_ho_los+o_intra_bs_ho_los+o_inter_bs_ho_clr)/(total_calls+i_inter_bs_ho_suc+i_intra_bs_ho_suc)*100 ,0)isnull((o_intra_bs_ho_ret +o_inter_bs_ho_ret)/(o_intra_bs_ho_atm +o_inter_bs_ho_atm)*100,0)isnull((sms_init_on_sdcch+sms_init_on_tch)/(cm_serv_req_call+cm_serv_req_sms+cm_serv_req_emerg+page_response-sms_init_on_sdcch),0)isnull(i_intra_bs_ho_los ,0)isnull(prp_pd_dem_mean,0)isnull(sum(air_dl_tbf_fl_et)*100/sum(tbf_dl_asgn_pacch+imm_assgn_cse_6+imm_assgn_cse_8),0)isnull(sum(((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlisnull((sum((ulrlcaknewbks_mcs1+ulrlcnanewbks_mcs1))*22+sum((ulrlcaknewbks_mcs2+ulrlcnanewbks_mcs2))*28+sum((ulrlcaknewbks_mcs3+ulrlcnanewbks_mcs3))*37+sum((ulrlcaknewbks_mcs4+ulrlcnanewbks_mcs4))*44+sum((ulrlcaknewbks_mcs5+ulrlcnanewbks_mcs5))*56+sum((ulrlcaknewbks_mcs6+ulrlcnanewbks_mcs6))*74+sum((ulrlcaknewbks_mcs7+ulrlcnanewbks_mcs7))*112+sum((ulrlcaknewbks_mcs8+ulrlcnanewbks_mcs8))*136+sum((ulrlcaknewbks_mcs9+ulrlcnanewbks_mcs9))*148)*100/1024+(sum((ulrlcaknewbks_cs1+ulrlcnanewbks_cs1))*20+sum((ulrlcaknewbks_cs2+ulrlcnanewbks_cs2))*30+sum((ulrlcaknewbks_cs3+ulrlcnanewbks_cs3))*36+sum((ulrlcaknewbks_cs4+ulrlcnanewbks_cs4))isnull(avgsimdltbfs_mean,0)isnull(100*((dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44)/((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148),0)100*(total_calls/ma_req_from_msc)*(alloc_sdcch/(alloc_sdcch+alloc_sdcch_fail))isnull((sum((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1))*22+sum((dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2))*28+sum((dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3))*37+sum((dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4))*44+sum((dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5))*56+sum((dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6))*74+sum((dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7))*112+sum((dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8))*136+sum((dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148))*100/1024+(sum((dlrlcaknewbks_cs1+dlrlcnanewbks_cs1))*20+sum((dlrlcaknewbks_cs2+dlrlcnanewbks_cs2))*30+sum((dlrlcaknewbks_cs3+dlrlcnanewbks_cs3))*36+sum((dlrlcaknewbks_cs4+dlrlcnanewbks_cs4)*isnull(intra_cell_ho_req ,0)isnull(i_inter_bs_eq_fa ,0)isnull((sum(rf_loss_tch_roll)+sum(intra_cell_ho_los)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/(sum(total_calls)+sum(isnull(assgn_redirect,0))+sum(i_inter_bs_ho_suc))*100 ,0)isnull(out_ho_caus_atmpt,0)isnull(sum(dl_tbf_time_1_ts + dl_tbf_time_2_ts +dl_tbf_time_3_ts + dl_tbf_time_4_ts),0)isnull(sum(busy_tch_mean)/sum(alloc_tch)*3600,0)isnull(sum(alloc_sdcch_fail)/(sum(alloc_sdcch)+sum(alloc_sdcch_fail))*100,0)isnull(sum(total_calls),0)isnull(mtu_pgsm_only ,0)isnull(ma_cmd_to_ms ,0)isnull(alloc_tch_fail ,0)isnull(ber_mean2,0)isnull(i_frames_tx,0)isnull(sum(total_calls),0)isnull(avail_sdcch_mean ,0)isnull(ok_acc_proc ,0)isnull(intra_cell_ho_los+o_intra_bs_ho_los+o_inter_bs_ho_clr ,0)isnull(sdcch_congestion ,0)isnull(alloc_sdcch ,0)isnull(cm_serv_req_call ,0)isnull(o_inter_bs_ho_atm ,0)isnull(sum(ma_cmd_to_ms_blkd),0)isnull(busy_tch_mean*3600/alloc_tch_carr,0)isnull(rf_los_tch_hr_amr,0)isnull(ber_bin6_ts0+ber_bin6_ts1+ber_bin6_ts2+ber_bin6_ts3+ber_bin6_ts4+ber_bin6_ts5+ber_bin6_ts6+ber_bin6_ts7,0)isnull(ohoa_congestion/out_ho_nc_cau_atm,0)isnull(air_dl_blks_q3_cs4,0)isnull(sum(intra_cell_ho_suc+o_intra_bs_ho_suc+o_inter_bs_ho_suc)/sum(intra_cell_ho_f_f+intra_cell_ho_f_h+intra_cell_ho_h_f+intra_cell_ho_h_h+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100,0)isnull(max(pch_page_q_discrd),0)isnull(sum(o_intra_bs_ho_los),0)isnull(busy_sdcch_mean*3600/alloc_sdcch,0)isnull(i_inter_bs_ho_suc ,0)isnull(ohoa_powerbdgt ,0)isnull(busy_tch_mean/(o_intra_bs_ho_suc+o_inter_bs_ho_suc)*3600,0)isnull(egprs_av_pdtch_mn,0)isnull(sum(23*(ulrlcaknewbks_cs1+ulrlcnanewbks_cs1)+33*(ulrlcaknewbks_cs2+ulrlcnanewbks_cs2)+39*(ulrlcaknewbks_cs3+ulrlcnanewbks_cs3)+53*(ulrlcaknewbks_cs4+ulrlcnanewbks_cs4))/10000,0)isnull(mtp_re_tx,0)isnull(ohoa_powerbdgt/out_ho_nc_cau_atm,0)isnull(ohoa_band_reasign/out_ho_nc_cau_atm,0)isnull(ms_class_1_10_req,0)isnull(ms_class_10_req,0)isnull((sum(rf_loss_tch_roll)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/sum(busy_tch_mean)/60*100,0)isnull(dl_busy_pdtch_mean,0)isnull((23*(dlrlcaknewbks_cs1+dlrlcnanewbks_cs1)+33*(dlrlcaknewbks_cs2+dlrlcnanewbks_cs2)+39*(dlrlcaknewbks_cs3+dlrlcnanewbks_cs3)+53*(dlrlcaknewbks_cs4+dlrlcnanewbks_cs4))/10000,0)isnull(sum(bsy_tch_h_amr_mean),0)isnull((sum(o_intra_bs_ho_ret)+sum(o_inter_bs_ho_ret))/(sum(o_intra_bs_ho_atm)+sum(o_inter_bs_ho_atm))*100,0)isnull(mtu_dcs2000_only ,0)isnull(gprs_av_pdtch_max,0)isnull(sum(ulrfbk8psk1ts_cs4 + ulrfbk8psk2ts_cs4 + ulrfbkgmsk1ts_cs4 + ulrfbkgmsk2ts_cs4),0)isnull(((ulrlcaknewbks_mcs1+ulrlcnanewbks_mcs1)*22+(ulrlcaknewbks_mcs2+ulrlcnanewbks_mcs2)*28+(ulrlcaknewbks_mcs3+ulrlcnanewbks_mcs3)*37+(ulrlcaknewbks_mcs4+ulrlcnanewbks_mcs4)*44+(ulrlcaknewbks_mcs5+ulrlcnanewbks_mcs5)*56+(ulrlcaknewbks_mcs6+ulrlcnanewbks_mcs6)*74+(ulrlcaknewbks_mcs7+ulrlcnanewbks_mcs7)*112+(ulrlcaknewbks_mcs8+ulrlcnanewbks_mcs8)*136+(ulrlcaknisnull((intra_cell_ho_suc+o_intra_bs_ho_suc+o_inter_bs_ho_suc)/(intra_cell_ho_f_f+intra_cell_ho_f_h+intra_cell_ho_h_f+intra_cell_ho_h_h+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100,0)isnull((intra_cell_ho_los+o_intra_bs_ho_los+o_inter_bs_ho_clr)/(o_inter_bs_ho_atm+o_intra_bs_ho_atm+intra_cell_ho_f_f+intra_cell_ho_f_h+intra_cell_ho_h_f+intra_cell_ho_h_h)*100,0)isnull(mat_pgsm_egsm ,0)isnull(idl_tch_bnd3_mean ,0)isnull(fer_mean0,0)isnull((fer_mean0+fer_mean1+fer_mean2+fer_mean3+fer_mean4+fer_mean5+fer_mean6+fer_mean7)/8,0)isnull(chan_req_ms_fail4,0)isnull(intf_on_idle_mean1,0)isnull(ohoa_congestion ,0)isnull(o_intra_bs_ho_atm ,0)100*(mtp_msu_rx*6+mtp_sif_sio_rx)/(mtp_link_ins*8)isnull(gbl_flow_ctrl_sent,0)isnull(ohoa_powerbdgt*100/out_ho_caus_atmpt,0)isnull(sum(intra_cell_ho_los),0)isnull(air_ul_blks_q3_cs1,0)isnull(air_ul_blks_q3_cs2,0)isnull(air_dl_blks_q3_cs3,0)isnull(ms_class_4_req,0)isnull(roc_max,0)isnull((ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7)/(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+bisnull(sum(ma_cmd_to_ms_blkd)/sum(ma_req_from_msc)*100,0)100*isnull((ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7)/(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+isnull(call_s_post_c_tch*100/(total_calls+i_inter_bs_ho_suc+i_intra_bs_ho_suc),0)isnull(100*sum(total_calls + assgn_redirect)/ sum(cm_serv_req_call + cm_serv_req_sms +cm_serv_req_emerg + cm_reestablish + page_response + loc_flw_req_nrm + loc_flw_req_sms -isnull(cell_flush_reqs,0)isnull(intf_on_idle_mean7,0)isnull((intf_on_idle_mean0+intf_on_idle_mean1+intf_on_idle_mean2+intf_on_idle_mean3+intf_on_idle_mean4+intf_on_idle_mean5+intf_on_idle_mean6+intf_on_idle_mean7)/8,0)isnull(sabm_tx,0)isnull(frmr,0)isnull(avail_tch_mean ,0)isnull(alloc_sdcch_fail ,0)isnull(location_update/total_calls+0.5*imsi_detach/total_calls ,0)isnull(ohoa_bandhandover/out_ho_caus_atmpt*100 ,0)isnull(o_inter_bs_rq_msc ,0)isnull(sl_congestion,0)isnull(msu_discarded,0)isnull(ohoa_upqual/out_ho_nc_cau_atm,0)isnull(ms_class_3_req,0)isnull(ms_class_11_20_req,0)isnull((u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7)/(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7+u_ber_bin7_ts0+u_ber_bin7_ts1+u_ber_bin7_ts2+u_ber_bin7_ts3+u_ber_bin7_ts4+u_ber_bin7_ts5+u_ber_bin7_ts6+u_ber_bin7_ts7),0)isnull((u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7)/(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7+u_ber_bin7_ts0+u_ber_bin7_ts1+u_ber_bin7_ts2+u_ber_bin7_ts3+u_ber_bin7_ts4+u_ber_bin7_ts5+u_ber_bin7_ts6+u_ber_bin7_ts7),0)isnull((u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7)/(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7+u_ber_bin7_ts0+u_ber_bin7_ts1+u_ber_bin7_ts2+u_ber_bin7_ts3+u_ber_bin7_ts4+u_ber_bin7_ts5+u_ber_bin7_ts6+u_ber_bin7_ts7),0)isnull((sum(intra_cell_ho_los)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/sum(total_calls)*100,0)isnull((sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/(sum(o_intra_bs_ho_atm)+sum(o_inter_bs_ho_atm))*100,0)isnull(sum(call_s_post_c_tch),0)isnull(pdu_dscrdllc_tbf /air_dl_tbf_fl_tot*100,0)isnull(((ulrfbk8psk1ts_cs1 + ulrfbk8psk2ts_cs1 + ulrfbkgmsk1ts_cs1 + ulrfbkgmsk2ts_cs1)*22+(ulrfbk8psk1ts_cs2 + ulrfbk8psk2ts_cs2 + ulrfbkgmsk1ts_cs2 + ulrfbkgmsk2ts_cs2)*33+(ulrfbk8psk1ts_cs3 + ulrfbk8psk2ts_cs3 + ulrfbkgmsk1ts_cs3 + ulrfbkgmsk2ts_cs3)*39+(ulrfbk8psk1ts_cs4 + ulrfbk8psk2ts_cs4 + ulrfbkgmsk1ts_cs4 + ulrfbkgmsk2ts_cs4)*53)*0.1,0)isnull(ia_dcs1800_atm ,0)isnull(ia_pgsm_ho_fail/ia_pgsm_ho_atm,0)isnull(ia_dcs1800_fail/ia_dcs1800_atm,0)isnull(alloc_tch ,0)isnull((ber_mean0+ber_mean1+ber_mean2+ber_mean3+ber_mean4+ber_mean5+ber_mean6+ber_mean7)/8,0)isnull(chan_req_ms_fail3,0)isnull(chan_req_ms_fail5,0)isnull((sum(rf_loss_tch_roll)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/(sum(total_calls)+sum(isnull(assgn_redirect,0))+sum(i_inter_bs_ho_suc))*100,0)isnull(ohoa_upinterf ,0)isnull(sum(alloc_sdcch_fail),0)isnull(ohoa_distance/out_ho_nc_cau_atm,0)isnull(ma_fail_from_ms*100/total_calls,0)isnull(chan_req_fail_rol*100/alloc_sdcch,0)isnull(ms_class_12_req,0)isnull(sum(page_response),0)isnull((rf_loss_tch_roll+o_intra_bs_ho_los+o_inter_bs_ho_clr)/busy_tch_mean/60*100,0)isnull(sum(23*(dlrlcaknewbks_cs1+dlrlcnanewbks_cs1)+33*(dlrlcaknewbks_cs2+dlrlcnanewbks_cs2)+39*(dlrlcaknewbks_cs3+dlrlcnanewbks_cs3)+53*(dlrlcaknewbks_cs4+dlrlcnanewbks_cs4))/10000,0)isnull(sum(busy_tch_mean),0)isnull(sum(chan_req_fail_rol)/(sum(ok_acc_proc_suc_r)-sum(inv_est_cause_rach)-sum(chan_req_ms_blk))*100,0)isnull(sum(rf_losses_sd)/sum(ok_acc_proc)*100,0)isnull(conn_req_to_msc ,0)isnull(ma_req_from_msc ,0)isnull(intra_bss,0)isnull(rf_losses_tch4,0)isnull(rf_losses_tch0+rf_losses_tch1+rf_losses_tch2+rf_losses_tch3+rf_losses_tch4+rf_losses_tch5+rf_losses_tch6+rf_losses_tch7,0)isnull(fer_mean4,0)isnull(busy_tch_mean/alloc_tch*3600 ,0)isnull(rf_loss_tch_roll ,0)isnull((o_intra_bs_ho_los +o_inter_bs_ho_clr)/(o_intra_bs_ho_atm +o_inter_bs_ho_atm)*100,0)isnull(intra_cell_ho_suc ,0)isnull((rf_loss_tch_roll+intra_cell_ho_los+o_intra_bs_ho_los+o_inter_bs_ho_clr)/(total_calls+isnull(assgn_redirect,0)+i_inter_bs_ho_suc+i_intra_bs_ho_suc)*100,0)isnull((o_inter_bs_ho_atm+o_intra_bs_ho_atm+intra_cell_ho_atm)/(total_calls+isnull(assgn_redirect,0)) ,0)isnull(imsi_detach/total_calls,0)isnull(imsi_detach/(cm_serv_req_call+cm_serv_req_sms+cm_serv_req_emerg+page_response-sms_init_on_sdcch) ,0)isnull(sum(ma_fail_from_ms)*100/sum(total_calls),0)isnull(cpu_usage_min,0)isnull((((DLRLCAKNEWBKS_MCS1+DLRLCRETXBLKS_MCS1) * 22 + (DLRLCAKNEWBKS_MCS2+DLRLCRETXBLKS_MCS2)* 28+ (DLRLCAKNEWBKS_MCS3+ DLRLCRETXBLKS_MCS3) * 37 +(DLRLCAKNEWBKS_MCS4+ DLRLCRETXBLKS_MCS4) * 44 + (DLRLCAKNEWBKS_MCS5+DLRLCRETXBLKS_MCS5 ) * 56 + (DLRLCAKNEWBKS_MCS6+ DLRLCRETXBLKS_MCS6 )* 74 +(DLRLCAKNEWBKS_MCS7+ DLRLCRETXBLKS_MCS7) * 112 + (DLRLCAKNEWBKS_MCS8+DLRLCRETXBLKS_MCS8 )* 136 + (DLRLCAKNEWBKS_MCS9+ DLRLCRETXBLKS_MCS9) * 148)*8/1000/(DLRLCAKNEWBKS_MCS1 +DLRLCAKNEWBKS_MCS2+DLRLCAKNEWBKS_MCS3+DLRLCAKNEWBKS_MCS4+DLRLCAKNEWBKS_MCS5+ DLRLCAKNEWBKS_MCS6+ DLRLCAKNEWBKS_MCS7 + DLRLCAKNEWBKS_MCS8+DLRLCAKNEWBKS_MCS9+DLRLCNACKBLKS_MCS1 + DLRLCNACKBLKS_MCS2 + DLRLCNACKBLKS_MCS3+ DLRLCNACKBLKS_MCS4 + DLRLCNACKBLKS_MCS5 + DLRLCNACKBLKS_MCS6+DLRLCNACKBLKS_MCS7 + DLRLCNACKBLKS_MCS8+ DLRLCNACKBLKS_MCS9++DLRLCRETXBLKS_MCS1isnull(ber_bin5_ts0+ber_bin5_ts1+ber_bin5_ts2+ber_bin5_ts3+ber_bin5_ts4+ber_bin5_ts5+ber_bin5_ts6+ber_bin5_ts7,0)isnull(max(page_req_from_msc)/3600,0)isnull(ms_class_1_req,0)isnull(ms_class_5_req,0)isnull((o_inter_bs_ho_atm+o_intra_bs_ho_atm+intra_cell_ho_f_f+intra_cell_ho_h_h)/total_calls,0)isnull((mtp_msu_tx*6+mtp_sif_sio_tx)*8/(mtp_link_ins/1000)/000*100,0)isnull(sum(dl_pdtch_seizure - air_dl_tbf_fl_dt - air_dl_tbf_fl_dr - air_dl_tbf_fl_t),0)isnull(sum(alloc_sdcch_fail)/(sum(alloc_sdcch)+sum(alloc_sdcch_fail))*100,0)isnull(sum(ch_reqs_succ)*100/sum(channel_reqs_rec),0)isnull(sum(dl_rf_bks_1ts_cs4 + dl_rf_bks_2ts_cs4 + dl_rf_bks_3ts_cs4 + dl_rf_bks_4ts_cs4),0)isnull((dl_rf_bks_1ts_cs3+dl_rf_bks_2ts_cs3+dl_rf_bks_3ts_cs3+dl_rf_bks_4ts_cs3)*100/(dl_rf_bks_1ts_cs1+dl_rf_bks_2ts_cs1+dl_rf_bks_3ts_cs1+dl_rf_bks_4ts_cs1+dl_rf_bks_1ts_cs2+dl_rf_bks_2ts_cs2+dl_rf_bks_3ts_cs2+dl_rf_bks_4ts_cs2+dl_rf_bks_1ts_cs3+dl_rf_bks_2ts_cs3+dl_rf_bks_3ts_cs3+dl_rf_bks_4ts_cs3+dl_rf_bks_1ts_cs4+dl_rf_bks_2ts_cs4+dl_rf_bks_3ts_cs4+dl_rf_bks_4ts_cs4),0)isnull(cipher_mode_fail ,0)isnull(conn_refused ,0)isnull(imsi_detach ,0)isnull(rf_loss_tch_roll ,0)isnull(calls_queued ,0)isnull(rf_losses_tch5,0)isnull(rf_losses_tch6,0)isnull(((sum(cm_serv_req_call)+sum(cm_serv_req_sms)+sum(cm_serv_req_emerg)+sum(page_response)+sum(cm_reestablish)+sum(imsi_detach)-sum(sms_init_on_sdcch)-sum(conn_refused)-sum(ma_req_from_msc))/(sum(cm_serv_req_call)+sum(cm_serv_req_sms)+sum(cm_serv_req_emerg)+sum(page_response)+sum(cm_reestablish)+sum(imsi_detach)-sum(sms_init_on_sdcch)-isnull(sum(intra_cell_ho_los)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr),0)isnull(sms_init_on_sdcch ,0)isnull(intra_cell_ho_los ,0)isnull((100-(sum(total_calls)+sum(isnull(assgn_redirect,0)))/(sum(cm_serv_req_call)+sum(cm_serv_req_emerg)+sum(cm_serv_req_sms)+sum(cm_reestablish)+sum(page_response)-sum(sms_init_on_sdcch))*100*(1-(sum(rf_loss_tch_roll)+sum(intra_cell_ho_los)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/(sum(total_calls)+sum(isnull(assgn_redirect,0)))*100/100))*sum(total_calls)/(sum(total_calls)+sum(isnull(assgn_redirect,0)))/(sum(cm_serv_req_call)+sum(cm_serv_req_emerg)+sum(cm_serv_req_sms)+sum(isnull(assgn_redirect,0)isnull((100-(total_calls+isnull(assgn_redirect,0))/(cm_serv_req_call+cm_serv_req_emerg+cm_serv_req_sms+cm_reestablish+page_response-sms_init_on_sdcch)*100*(1-(rf_loss_tch_roll+intra_cell_ho_los+o_intra_bs_ho_los+o_inter_bs_ho_clr)/(total_calls+isnull(assgn_redirect,0))*100/100))*total_calls/(total_calls+isnull(assgn_redirect,0))/(cm_serv_req_call+cm_serv_req_emerg+cm_serv_req_sms+cm_reestablish+page_response-sms_init_on_sdcch)*100,0)isnull(ohoa_powerbdgt/out_ho_caus_atmpt*100 ,0)isnull((dl_pdtch_seizure*100)/(tbf_dl_asgn_pacch+imm_assgn_cse_6+imm_assgn_cse_8),0)isnull(ma_cmd_to_ms_blkd,0)isnull(ma_fail_from_ms ,0)isnull(sec_assign_suc,0)isnull(ia_egsm_ho_atm ,0)isnull(mat_pgsm_only ,0)isnull(mtu_pgsm_dcs2000 ,0)isnull(mtu_pegsm_dcs2000 ,0)isnull(busy_tch_mean,0)isnull(cong_stand_ho_atm ,0)isnull(inter_bss,0)isnull(fer_mean5,0)isnull(intf_on_idle_mean0,0)isnull(ohoa_distance ,0)isnull(sum(call_s_post_c_tch),0)isnull(sum(busy_sdcch_mean)/sum(alloc_sdcch)*3600,0)isnull(sum(rf_loss_tch_roll),0)isnull((sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/(sum(o_intra_bs_ho_atm)+sum(o_inter_bs_ho_atm))*100,0)isnull(sum(ma_cmd_to_ms_blkd)/sum(ma_req_from_msc)*100,0)isnull(bad_ho_refnum_ms,0)isnull(mtu_pegsm_dcs1800,0)isnull(rf_losses_tch7,0)isnull(ber_mean7,0)isnull(fer_mean7,0)isnull(ohoa_upqual/out_ho_caus_atmpt*100,0)isnull(ohoa_upqual ,0)isnull(ohoa_uplevel ,0)isnull(ohoa_downqual ,0)isnull(cm_reestablish ,0)isnull(location_update ,0)isnull(o_intra_bs_ho_suc ,0)isnull(mtp_sif_sio_tx,0)isnull(sl_congestion,0)isnull(ohoa_downlevel/out_ho_nc_cau_atm,0)isnull(ohoa_downinterf/out_ho_nc_cau_atm,0)isnull(ohoa_bandhandover/out_ho_nc_cau_atm,0)isnull(ms_class_6_req,0)isnull(sum(intra_cell_ho_suc+o_intra_bs_ho_suc+o_inter_bs_ho_suc)/sum(intra_cell_ho_f_f+intra_cell_ho_f_h+intra_cell_ho_h_f+intra_cell_ho_h_h+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100,0)isnull(ok_acc_proc_suc_r/access_per_rach,0)isnull(sum(rf_loss_tch_roll)/sum(total_calls)*100,0)isnull(sum(dl_busy_pdtch_mean),0)isnull((sum((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1))*22+sum((dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2))*28+sum((dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3))*37+sum((dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4))*44+sum((dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5))*56+sum((dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6))*74+sum((dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7))*112+sum((dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8))*136+sum((dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148))*100/1024+(sum((dlrlcaknewbks_cs1+dlrlcnanewbks_cs1))*20+sum((dlrlcaknewbks_cs2+dlrlcnanewbks_cs2))*30+sum((dlrlcaknewbks_cs3+dlrlcnanewbks_cs3))*36+sum((dlrlcaknewbks_cs4+dlrlcnanewbks_cs4)*100*isnull((u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7)/(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+isnull(sum(intra_cell_ho_los)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr),0)isnull(sum(alloc_tch_fail)/(sum(alloc_tch)+sum(alloc_tch_fail))*100,0)isnull((o_inter_bs_ho_atm /o_inter_bs_rq_msc) *100,0)isnull(dl_pdtch_q_len_mn,0)isnull(i_frames_rx,0)isnull(i_frames_rx,0)isnull(alloc_tch_fail/(alloc_tch+alloc_tch_fail)*100 ,0)isnull(cm_serv_req_emerg ,0)isnull(location_update/(cm_serv_req_call+cm_serv_req_sms+cm_serv_req_emerg+page_response-sms_init_on_sdcch) ,0)isnull(intra_cell_ho_atm ,0)isnull((100-(sum(total_calls)+sum(isnull(assgn_redirect,0)))/(sum(cm_serv_req_call)+sum(cm_serv_req_emerg)+sum(cm_serv_req_sms)+sum(cm_reestablish)+sum(page_response)-sum(sms_init_on_sdcch))*100*(1-(sum(rf_loss_tch_roll)+sum(intra_cell_ho_los)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_clr))/(sum(total_calls)+sum(isnull(assgn_redirect,0)))*100/100))*sum(total_calls)/(sum(total_calls)+sum(isnull(assgn_redirect,0)))/(sum(cm_serv_req_call)+sum(cm_serv_req_emerg)+sum(cm_serv_req_sms)+sum(isnull((rf_loss_tch_roll+o_intra_bs_ho_los+o_inter_bs_ho_clr)/(total_calls+isnull(assgn_redirect,0)+i_inter_bs_ho_suc+i_intra_bs_ho_suc)*100,0)isnull(busy_tch_mean/(total_calls+isnull(assgn_redirect,0))*3600 ,0)isnull(ohoa_downlevel ,0)isnull(ohoa_downinterf ,0)isnull(cpu_usage_max,0)isnull((u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7)/(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7+u_ber_bin7_ts0+u_ber_bin7_ts1+u_ber_bin7_ts2+u_ber_bin7_ts3+u_ber_bin7_ts4+u_ber_bin7_ts5+u_ber_bin7_ts6+u_ber_bin7_ts7),0)isnull(i_intra_bs_ho_ret ,0)isnull(pdu_discard_llc,0)isnull(chanreq_fail_tchf0+chanreq_fail_tchf1+chanreq_fail_tchf2+chanreq_fail_tchf3+chanreq_fail_tchf4+chanreq_fail_tchf5+chanreq_fail_tchf6+chanreq_fail_tchf7,0)isnull(((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknisnull(((dl_rf_bks_1ts_cs1 + dl_rf_bks_2ts_cs1 + dl_rf_bks_3ts_cs1 + dl_rf_bks_4ts_cs1)*22+(dl_rf_bks_1ts_cs2+ dl_rf_bks_2ts_cs2 + dl_rf_bks_3ts_cs2 + dl_rf_bks_4ts_cs2)*33+(dl_rf_bks_1ts_cs3 + dl_rf_bks_2ts_cs3 + dl_rf_bks_3ts_cs3 + dl_rf_bks_4ts_cs3)*39+(dl_rf_bks_1ts_cs4 + dl_rf_bks_2ts_cs4+ dl_rf_bks_3ts_cs4+dl_rf_bks_4ts_cs4)*53)*0.1,0)isnull(ia_egsm_ho_fail ,0)isnull(ber_mean0,0)isnull(bsy_tch_h_amr_mean,0)isnull(ber_bin4_ts0+ber_bin4_ts1+ber_bin4_ts2+ber_bin4_ts3+ber_bin4_ts4+ber_bin4_ts5+ber_bin4_ts6+ber_bin4_ts7,0)isnull(air_dl_data_blks,0)isnull(gprs_acc_per_rach,0)isnull(gprs_ch_switched,0)isnull(sum(o_inter_bs_ho_atm+o_intra_bs_ho_atm+intra_cell_ho_f_f),0)isnull((ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7)/(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+bisnull((ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+ber_bin3_ts7)/(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+bisnull(gprs_av_pdtch_mn,0)isnull((ohoa_upqual+ohoa_downqual+intra_cell_ho_f_f+intra_cell_ho_h_h),0)isnull((dl_rf_bks_1ts_cs1+dl_rf_bks_2ts_cs1+dl_rf_bks_3ts_cs1+dl_rf_bks_4ts_cs1)*100/(dl_rf_bks_1ts_cs1+dl_rf_bks_2ts_cs1+dl_rf_bks_3ts_cs1+dl_rf_bks_4ts_cs1+dl_rf_bks_1ts_cs2+dl_rf_bks_2ts_cs2+dl_rf_bks_3ts_cs2+dl_rf_bks_4ts_cs2+dl_rf_bks_1ts_cs3+dl_rf_bks_2ts_cs3+dl_rf_bks_3ts_cs3+dl_rf_bks_4ts_cs3+dl_rf_bks_1ts_cs4+dl_rf_bks_2ts_cs4+dl_rf_bks_3ts_cs4+dl_rf_bks_4ts_cs4),0)isnull(mtu_pgsm_dcs1800 ,0)isnull(sec_assign_atmpt,0)isnull(ia_pgsm_ho_atm,0)isnull(ia_dcs2000_fail ,0)isnull(fer_mean1,0)isnull(chan_req_ms_fail2,0)isnull(chan_req_ms_fail7,0)isnull(chan_req_ms_fail0+chan_req_ms_fail1+chan_req_ms_fail2+chan_req_ms_fail3+chan_req_ms_fail4+chan_req_ms_fail5+chan_req_ms_fail6+chan_req_ms_fail7,0)isnull(ohoa_bandhandover ,0)100*isnull(sum(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7)/sum(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+isnull(ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7,0)isnull(out_ho_nc_cau_atm,0)isnull(busy_tch_mean,0)isnull(alloc_tch_carr,0)isnull(channel_reqs_rej/(isnull(channel_reqs_rec,0)+1)*100,0)isnull(ul_busy_pdtch_mean,0)isnull(sec_assign_atmpt/total_calls,0)isnull(busy_tch_mean/avail_tch_max,0)isnull(sum(bsy_tch_h_amr_mean),0)isnull((sum((ulrlcaknewbks_mcs1+ulrlcnanewbks_mcs1))*22+sum((ulrlcaknewbks_mcs2+ulrlcnanewbks_mcs2))*28+sum((ulrlcaknewbks_mcs3+ulrlcnanewbks_mcs3))*37+sum((ulrlcaknewbks_mcs4+ulrlcnanewbks_mcs4))*44+sum((ulrlcaknewbks_mcs5+ulrlcnanewbks_mcs5))*56+sum((ulrlcaknewbks_mcs6+ulrlcnanewbks_mcs6))*74+sum((ulrlcaknewbks_mcs7+ulrlcnanewbks_mcs7))*112+sum((ulrlcaknewbks_mcs8+ulrlcnanewbks_mcs8))*136+sum((ulrlcaknewbks_mcs9+ulrlcnanewbks_mcs9))*148)*100/1024+(sum((ulrlcaknewbks_cs1+ulrlcnanewbks_cs1))*20+sum((ulrlcaknewbks_cs2+ulrlcnanewbks_cs2))*30+sum((ulrlcaknewbks_cs3+ulrlcnanewbks_cs3))*36+sum((ulrlcaknewbks_cs4+ulrlcnanewbks_cs4))isnull(sum(chan_req_fail_rol)/(sum(ok_acc_proc_suc_r)-sum(inv_est_cause_rach)-sum(chan_req_ms_blk))*100,0)isnull(sum(busy_sdcch_mean),0)isnull(i_inter_bs_ho_clr ,0)isnull(o_inter_bs_ho_atm+o_intra_bs_ho_atm+intra_cell_ho_f_f+intra_cell_ho_f_h+intra_cell_ho_h_f+intra_cell_ho_h_h,0)isnull(mat_pgsm_dcs2000 ,0)isnull(((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148)*100/1024+((dlrlcaknewbks_cs1+dlrlcnanewbks_cs1)*20+(dlrlcaknewbks_cs2+dlrlcnanewbks_cs2)*30+(dlrlcaknewbks_cs3+dlrlcnanewbks_cs3)*36+(dlrlcaknewbks_isnull(dl_busy_pdtch_max,0)isnull(sum(dl_rf_bks_1ts_cs2 + dl_rf_bks_2ts_cs2 + dl_rf_bks_3ts_cs2 + dl_rf_bks_4ts_cs2),0)isnull(ia_dcs2000_atm ,0)isnull(ia_invld_frq_as ,0)isnull(mat_dcs1800_only ,0)isnull(idl_tch_bnd0_mean ,0)isnull(idl_tch_bnd2_mean ,0)isnull(rf_losses_tch1,0)isnull(rf_losses_tch3,0)isnull(ber_mean5,0)isnull(intf_on_idle_mean2,0)isnull(o_intra_bs_ho_ret ,0)isnull(tbf_sessions_mean,0)isnull(sum(dl_pdtch_seizure)*100/sum(tbf_dl_asgn_pacch+imm_assgn_cse_6+imm_assgn_cse_8),0)isnull(sum(air_ul_tbf_fl_dt+air_ul_tbf_fl_t)*100/sum(ch_reqs_succ_p_c+ch_reqs_succ_p_p+ch_reqs_succ_p_r+ch_reqs_succ_pkts+ch_reqs_succ_e_c+ch_reqs_succ_cp_a+chanreqsucce1ccc+chanreqsucce1pccc+chanreqsuccepuaprr+chanreqsucceptr+chanreqsuccepuapda),0)isnull(sl_stop_congest,0)isnull(cpu_usage_mean,0)isnull(cpu_usage_min,0)isnull(out_ho_nc_suc/out_ho_nc_cau_atm,0)isnull(ohoa_uplevel/out_ho_nc_cau_atm,0)isnull(air_ul_blks_q3_cs4,0)isnull(ms_class_21_29_req,0)isnull(sum(isnull(sms_no_bcast_msg,0)+sms_init_on_tch+sms_init_on_sdcch)/sum(total_calls),0)isnull(sum(o_inter_bs_ho_clr),0)isnull(roc_mean,0)isnull(sum(i_inter_bs_ho_clr),0)isnull((dl_rf_bks_1ts_cs4+dl_rf_bks_2ts_cs4+dl_rf_bks_3ts_cs4+dl_rf_bks_4ts_cs4)*100/(dl_rf_bks_1ts_cs1+dl_rf_bks_2ts_cs1+dl_rf_bks_3ts_cs1+dl_rf_bks_4ts_cs1+dl_rf_bks_1ts_cs2+dl_rf_bks_2ts_cs2+dl_rf_bks_3ts_cs2+dl_rf_bks_4ts_cs2+dl_rf_bks_1ts_cs3+dl_rf_bks_2ts_cs3+dl_rf_bks_3ts_cs3+dl_rf_bks_4ts_cs3+dl_rf_bks_1ts_cs4+dl_rf_bks_2ts_cs4+dl_rf_bks_3ts_cs4+dl_rf_bks_4ts_cs4),0)isnull((dl_tbf_time_1_ts + dl_tbf_time_2_ts +dl_tbf_time_3_ts + dl_tbf_time_4_ts)*0.02 /(dl_pdtch_seizure - air_dl_tbf_fl_dt - air_dl_tbf_fl_dr - air_dl_tbf_fl_t),0)isnull((ul_tbf_tm_8psk_1ts + ul_tbf_tm_8psk_2ts + ul_tbf_tm_gmsk_1ts + ul_tbf_tm_gmsk_2ts)*0.02/ (ul_pdtch_seizure - air_ul_tbf_fl_dt - air_ul_tbf_fl_t),0)isnull(ho_req_msc_fail ,0)isnull(ia_dcs2000_fail/ia_dcs2000_atm,0)isnull(intf_on_idle_mean5,0)isnull(invalid_frames_rx,0)isnull(n2_expiry,0)isnull((ohoa_downqual+ohoa_upqual+intra_cell_ho_f_f+intra_cell_ho_h_h)/(o_inter_bs_ho_atm+o_intra_bs_ho_atm+intra_cell_ho_f_f+intra_cell_ho_h_h),0)isnull(page_response/page_req_from_msc*100,0)isnull(pch_page_q_discrd,0)isnull(100*(total_calls + assgn_redirect)/ (cm_serv_req_call + cm_serv_req_sms +cm_serv_req_emerg + cm_reestablish + page_response + loc_flw_req_nrm + loc_flw_req_sms -isnull(busy_sdcch_mean ,0)isnull(sum(dl_rlc_retx_blks)*100/sum(dl_rlc_ack_new_bks+dl_rlc_retx_blks),0)isnull(busy_sdcch_mean ,0)isnull(dl_busy_pdtch_mean*100/(gprs_av_pdtch_mn +egprs_av_pdtch_mn),0)isnull(sum(tch_congestion),0)isnull(100*(1-sum(ma_cmd_to_ms_blkd)/sum(ma_req_from_msc))*(1-sum(alloc_sdcch_fail)/(sum(alloc_sdcch)+sum(alloc_sdcch_fail))),0)isnull((dl_rf_bks_1ts_cs2+dl_rf_bks_2ts_cs2+dl_rf_bks_3ts_cs2+dl_rf_bks_4ts_cs2)*100/(dl_rf_bks_1ts_cs1+dl_rf_bks_2ts_cs1+dl_rf_bks_3ts_cs1+dl_rf_bks_4ts_cs1+dl_rf_bks_1ts_cs2+dl_rf_bks_2ts_cs2+dl_rf_bks_3ts_cs2+dl_rf_bks_4ts_cs2+dl_rf_bks_1ts_cs3+dl_rf_bks_2ts_cs3+dl_rf_bks_3ts_cs3+dl_rf_bks_4ts_cs3+dl_rf_bks_1ts_cs4+dl_rf_bks_2ts_cs4+dl_rf_bks_3ts_cs4+dl_rf_bks_4ts_cs4),0)isnull(idl_tch_bnd1_mean ,0)isnull(sum(rf_loss_tch_roll),0)isnull(chan_req_fail_rol/(ok_acc_proc_suc_r-inv_est_cause_rach-chan_req_ms_blk)*100,0)isnull(ohoa_band_reasign,0)isnull(sum(rf_losses_sd),0)isnull(avail_sdcch_max,0)100*(sum(total_calls)/sum(ma_req_from_msc))*(sum(alloc_sdcch)/(sum(alloc_sdcch)+sum(alloc_sdcch_fail)))isnull(sum(23*(dlrlcaknewbks_cs1+dlrlcnanewbks_cs1)+33*(dlrlcaknewbks_cs2+dlrlcnanewbks_cs2)+39*(dlrlcaknewbks_cs3+dlrlcnanewbks_cs3)+53*(dlrlcaknewbks_cs4+dlrlcnanewbks_cs4))/10000,0)isnull(ohoa_upinterf/out_ho_nc_cau_atm,0)isnull(air_ul_blks_q3_cs3,0)isnull(ms_class_8_req,0)isnull(ch_ul_tx_pwrl_mean,0)isnull(sum(o_inter_bs_ho_suc)/sum(o_inter_bs_ho_atm)*100,0)isnull((u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7)/(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7+u_ber_bin7_ts0+u_ber_bin7_ts1+u_ber_bin7_ts2+u_ber_bin7_ts3+u_ber_bin7_ts4+u_ber_bin7_ts5+u_ber_bin7_ts6+u_ber_bin7_ts7),0)isnull(sum(rf_losses_sd)/sum(ok_acc_proc)*100,0)isnull(sum(alloc_tch_fail)/(sum(alloc_tch)+sum(alloc_tch_fail))*100,0)isnull(sum(ul_tbf_tm_8psk_1ts + ul_tbf_tm_8psk_2ts + ul_tbf_tm_gmsk_1ts + ul_tbf_tm_gmsk_2ts),0)isnull(sum(busy_tch_mean)/(sum(rf_loss_tch_roll)+sum(intra_cell_ho_los)+sum(o_intra_bs_ho_los)+sum(o_inter_bs_ho_los))*3600,0)isnull(100*sum(total_calls + assgn_redirect)/ sum(cm_serv_req_call + cm_serv_req_sms +cm_serv_req_emerg + cm_reestablish + page_response + loc_flw_req_nrm + loc_flw_req_sms -isnull(sum(rf_loss_tch_roll)/(sum(total_calls)+sum(i_inter_bs_ho_suc))*100,0)isnull(i_inter_bs_ms_ns ,0)isnull(mat_pegsm_dcs2000 ,0)isnull(mtu_dcs1800_only ,0)isnull(ul_rlc_retx_blks*100/(ul_rlc_ack_new_bks+ul_rlc_retx_blks),0)isnull(dl_rlc_retx_blks*100/(dl_rlc_ack_new_bks+dl_rlc_retx_blks),0)isnull(o_intra_bs_ho_req ,0)isnull(o_intra_bs_ho_pri ,0)isnull(o_inter_bs_ho_clr ,0)isnull(prp_load_max,0)isnull(cpu_usage_mean,0)isnull(prp_pd_dem_max,0)isnull(sum(ch_reqs_succ)*100/sum(channel_reqs_rec),0)isnull(ia_dcs1800_fail ,0)isnull(cong_exist_ho_atm ,0)isnull(ber_mean4,0)isnull(ber_mean6,0)isnull(fer_mean3,0)isnull(fer_mean6,0)isnull(i_frames_tx/(3600*95),0)100*(mtp_msu_tx*6+mtp_sif_sio_tx)/(mtp_link_ins*8)isnull(rf_loss_tch_roll/(total_calls+i_inter_bs_ho_suc+i_intra_bs_ho_suc)*100 ,0)isnull(alloc_sdcch_fail/(alloc_sdcch+alloc_sdcch_fail)*100 ,0)isnull(total_calls ,0)isnull(ok_acc_proc_suc_r ,0)isnull(o_intra_bs_ho_los ,0)isnull(prp_load_mean,0)isnull(tbf_sessions_max,0)isnull(avail_tch_max,0)isnull((23*(ulrlcaknewbks_cs1+ulrlcnanewbks_cs1)+33*(ulrlcaknewbks_cs2+ulrlcnanewbks_cs2)+39*(ulrlcaknewbks_cs3+ulrlcnanewbks_cs3)+53*(ulrlcaknewbks_cs4+ulrlcnanewbks_cs4))/10000,0)isnull((ber_bin6_ts0+ber_bin6_ts1+ber_bin6_ts2+ber_bin6_ts3+ber_bin6_ts4+ber_bin6_ts5+ber_bin6_ts6+ber_bin6_ts7)/(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+bisnull((ber_bin7_ts0+ber_bin7_ts1+ber_bin7_ts2+ber_bin7_ts3+ber_bin7_ts4+ber_bin7_ts5+ber_bin7_ts6+ber_bin7_ts7)/(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+bisnull(ia_egsm_ho_fail/ia_egsm_ho_atm,0)isnull(busy_tch_mean/(rf_loss_tch_roll+intra_cell_ho_los+o_intra_bs_ho_los+o_inter_bs_ho_los)*3600,0)isnull(((ulrlcaknewbks_mcs1+ulrlcnanewbks_mcs1)*22+(ulrlcaknewbks_mcs2+ulrlcnanewbks_mcs2)*28+(ulrlcaknewbks_mcs3+ulrlcnanewbks_mcs3)*37+(ulrlcaknewbks_mcs4+ulrlcnanewbks_mcs4)*44+(ulrlcaknewbks_mcs5+ulrlcnanewbks_mcs5)*56+(ulrlcaknewbks_mcs6+ulrlcnanewbks_mcs6)*74+(ulrlcaknewbks_mcs7+ulrlcnanewbks_mcs7)*112+(ulrlcaknewbks_mcs8+ulrlcnanewbks_mcs8)*136+(ulrlcaknewbks_mcs9+ulrlcnanewbks_mcs9)*148)*100/1024+((ulrlcaknewbks_cs1+ulrlcnanewbks_cs1)*20+(ulrlcaknewbks_cs2+ulrlcnanewbks_cs2)*30+(ulrlcaknewbks_cs3+ulrlcnanewbks_cs3)*36+(ulrlcaknewbks_isnull(ch_reqs_succ*100/channel_reqs_rec,0)isnull(tch_congestion ,0)isnull(rf_losses_tch2,0)isnull(chan_req_ms_fail6,0)isnull(intf_on_idle_mean6,0)isnull(path_balance_min,0)isnull((u_ber_bin7_ts0+u_ber_bin7_ts1+u_ber_bin7_ts2+u_ber_bin7_ts3+u_ber_bin7_ts4+u_ber_bin7_ts5+u_ber_bin7_ts6+u_ber_bin7_ts7)/(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7+u_ber_bin7_ts0+u_ber_bin7_ts1+u_ber_bin7_ts2+u_ber_bin7_ts3+u_ber_bin7_ts4+u_ber_bin7_ts5+u_ber_bin7_ts6+u_ber_bin7_ts7),0)isnull(sum(alloc_sdcch_fail)/(sum(alloc_sdcch)+sum(alloc_sdcch_fail))*100,0)isnull(rf_losses_sd/ok_acc_proc*100,0)isnull(ma_cmd_to_ms_blkd/ma_req_from_msc*100 ,0)av_tch_hr_amr_max/2isnull((isnull(sms_no_bcast_msg,0)+sms_init_on_tch+sms_init_on_sdcch)/total_calls,0)isnull(intra_cell_ho_atm/(intra_cell_ho_atm+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100 ,0)isnull(o_intra_bs_ho_atm/(intra_cell_ho_atm+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100,0)isnull(o_inter_bs_ho_atm/(intra_cell_ho_atm+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100,0)isnull(intra_cell_ho_los/(intra_cell_ho_atm+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100 ,0)isnull(o_intra_bs_ho_los/(intra_cell_ho_atm+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100 ,0)isnull(o_inter_bs_ho_clr/(intra_cell_ho_atm+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100,0)isnull(intra_cell_ho_ret/(intra_cell_ho_atm+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100 ,0)isnull(o_intra_bs_ho_ret/(intra_cell_ho_atm+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100,0)isnull(o_inter_bs_ho_ret/(intra_cell_ho_atm+o_intra_bs_ho_atm+o_inter_bs_ho_atm)*100,0)isnull(o_inter_bs_ho_suc ,0)isnull(i_intra_bs_ho_suc ,0)isnull(100*(gprs_cellcong_55+gprs_cellcong_60+gprs_cellcong_65+gprs_cellcong_70+gprs_cellcong_75+gprs_cellcong_80+gprs_cellcong_85+gprs_cellcong_90+gprs_cellcong_95+gprs_cellcong_100)/gprsisnull((dlrlcnackblks_cs1+dlrlcnackblks_cs2+dlrlcnackblks_cs3+dlrlcnackblks_cs4)*100/(dlrlcnackblks_cs1+dlrlcnackblks_cs2+dlrlcnackblks_cs3+dlrlcnackblks_cs4+dlrlcaknewbks_cs1+dlrlcaknewbks_cs2+dlrlcisnull(chanreq_fail_sdch0+chanreq_fail_sdch1+chanreq_fail_sdch2+chanreq_fail_sdch3+chanreq_fail_sdch4+chanreq_fail_sdch5+chanreq_fail_sdch6+chanreq_fail_sdch7,0)isnull(100*(chanreq_fail_sdch0+chanreq_fail_sdch1+chanreq_fail_sdch2+chanreq_fail_sdch3+chanreq_fail_sdch4+chanreq_fail_sdch5+chanreq_fail_sdch6+chanreq_fail_sdch7)/alloc_sdcch_carr,0)isnull(sum(chanreq_fail_sdch0+chanreq_fail_sdch1+chanreq_fail_sdch2+chanreq_fail_sdch3+chanreq_fail_sdch4+chanreq_fail_sdch5+chanreq_fail_sdch6+chanreq_fail_sdch7),0)isnull(sum(chanreq_fail_tchh0+chanreq_fail_tchh1+chanreq_fail_tchh2+chanreq_fail_tchh3+chanreq_fail_tchh4+chanreq_fail_tchh5+chanreq_fail_tchh6+chanreq_fail_tchh7),0)isnull(sum(chanreq_fail_tchf0+chanreq_fail_tchf1+chanreq_fail_tchf2+chanreq_fail_tchf3+chanreq_fail_tchf4+chanreq_fail_tchf5+chanreq_fail_tchf6+chanreq_fail_tchf7),0)isnull(cs1234_on_k_chan,0)isnull(sum(UL_PDTCH_SEIZURE )* 100 /sum(chnlrqrecegprs1pc+chnlrqrecegprs1ppc+chnlrqrecegprspkrq+chnlrqrecegprscrpd+chan_reqs_rec_p_c+chan_reqs_rec_p_p+chan_reqs_rec_p_r+chan_reqs_rec_cp_a+chan_reqs_rec_e_c),0)isnull((dlrlcnackblks_mcs1+dlrlcnackblks_mcs2+dlrlcnackblks_mcs3+dlrlcnackblks_mcs4+dlrlcnackblks_mcs5+dlrlcnackblks_mcs6+dlrlcnackblks_mcs7+dlrlcnackblks_mcs8+dlrlcnackblks_mcs9)*100/(dlrlcnackblks_mcs1+dlrlcnackblks_mcs2+dlrlcnackblks_mcs3+dlrlcnackblks_mcs4+dlrlcnackblks_mcs5+dlrlcnackblks_mcs6+dlrlcnackblks_mcs7+dlrlcnackblks_mcs8+dlrlcnackblks_mcs9+dlrlcaknewbks_mcs1+dlrlcaknewbks_mcs2+dlrlcaknewbks_mcs3+dlrlcaknewbks_mcs4+dlrlcaknewbks_mcs5+dlrlcaknewbks_mcs6+isnull(chanreq_fail_tchh0+chanreq_fail_tchh1+chanreq_fail_tchh2+chanreq_fail_tchh3+chanreq_fail_tchh4+chanreq_fail_tchh5+chanreq_fail_tchh6+chanreq_fail_tchh7,0)isnull(( ULRLCAKNEWBKS_MCS1 * 22 + ULRLCAKNEWBKS_MCS2* 28 + ULRLCAKNEWBKS_MCS3 * 37 +ULRLCAKNEWBKS_MCS4 * 44 + ULRLCAKNEWBKS_MCS5 * 56 + ULRLCAKNEWBKS_MCS6* 74+ULRLCAKNEWBKS_MCS7 * 112 + ULRLCAKNEWBKS_MCS8* 136 + ULRLCAKNEWBKS_MCS9*148)*8/1000/ ( ULRLCAKNEWBKS_MCS1 +ULRLCAKNEWBKS_MCS2+ULRLCAKNEWBKS_MCS3+ULRLCAKNEWBKS_MCS4+ULRLCAKNEWBKS_MCS5+ ULRLCAKNEWBKS_MCS6+ ULRLCAKNEWBKS_MCS7 + ULRLCAKNEWBKS_MCS8+ULRLCAKNEWBKS_MCS9+ ULRLC_RETXBKS_MCS1 + ULRLC_RETXBKS_MCS2 + ULRLC_RETXBKS_MCS3+ ULRLC_RETXBKS_MCS4 + ULRLC_RETXBKS_MCS5 + ULRLC_RETXBKS_MCS6+isnull(gprs_av_pdtch_mn,0)+isnull(egprs_av_pdtch_mn,0)-isnull(dl_busy_pdtch_mean,0)isnull(egprs_k_chns_swh,0)isnull(UL_PDTCH_SEIZURE * 100 /(chnlrqrecegprs1pc+chnlrqrecegprs1ppc+chnlrqrecegprspkrq+chnlrqrecegprscrpd+chan_reqs_rec_p_c+chan_reqs_rec_p_p+chan_reqs_rec_p_r+chan_reqs_rec_cp_a+chan_reqs_rec_e_c),0)isnull((air_ul_tbf_fl_dt+air_ul_tbf_fl_t)*100/(ch_reqs_succ_p_c+ch_reqs_succ_p_p+ch_reqs_succ_p_r+ch_reqs_succ_pkts+ch_reqs_succ_e_c+ch_reqs_succ_cp_a+chanreqsucce1ccc+chanreqsucce1pccc+chanreqsuccepuaprr+chanreqsucceptr+chanreqsuccepuapda),0)isnull((ch_reqs_succ_p_c+ch_reqs_succ_p_p+ch_reqs_succ_p_r+ch_reqs_succ_pkts+ch_reqs_succ_e_c+ch_reqs_succ_cp_a+chanreqsucce1ccc+chanreqsucce1pccc+chanreqsuccepuaprr+chanreqsucceptr+chanreqsuccepuapda)*100/(chnlrqrecegprs1pc+chnlrqrecegprs1ppc+chnlrqrecegprspkrq+chnlrqrecegprscrpd+chan_reqs_rec_p_c+chan_reqs_rec_p_p+chan_reqs_rec_p_r+chan_reqs_rec_cp_a+chan_reqs_rec_e_c),0)isnull(sum(( ULRLCAKNEWBKS_MCS1 * 22 + ULRLCAKNEWBKS_MCS2* 28 + ULRLCAKNEWBKS_MCS3 *37 + ULRLCAKNEWBKS_MCS4 * 44 + ULRLCAKNEWBKS_MCS5 * 56 + ULRLCAKNEWBKS_MCS6* 74+ULRLCAKNEWBKS_MCS7 * 112 + ULRLCAKNEWBKS_MCS8* 136 + ULRLCAKNEWBKS_MCS9*148)*8/1000/ ( ULRLCAKNEWBKS_MCS1 +ULRLCAKNEWBKS_MCS2+ULRLCAKNEWBKS_MCS3+ULRLCAKNEWBKS_MCS4+ULRLCAKNEWBKS_MCS5+ ULRLCAKNEWBKS_MCS6+ ULRLCAKNEWBKS_MCS7 + ULRLCAKNEWBKS_MCS8+ULRLCAKNEWBKS_MCS9+ ULRLC_RETXBKS_MCS1 + ULRLC_RETXBKS_MCS2 + ULRLC_RETXBKS_MCS3+ ULRLC_RETXBKS_MCS4 + ULRLC_RETXBKS_MCS5 + ULRLC_RETXBKS_MCS6+isnull(sum((((DLRLCAKNEWBKS_MCS1+DLRLCRETXBLKS_MCS1) * 22 + (DLRLCAKNEWBKS_MCS2+DLRLCRETXBLKS_MCS2)* 28+ (DLRLCAKNEWBKS_MCS3+ DLRLCRETXBLKS_MCS3) * 37 +(DLRLCAKNEWBKS_MCS4+ DLRLCRETXBLKS_MCS4) * 44 + (DLRLCAKNEWBKS_MCS5+DLRLCRETXBLKS_MCS5 ) * 56 + (DLRLCAKNEWBKS_MCS6+ DLRLCRETXBLKS_MCS6 )* 74 +(DLRLCAKNEWBKS_MCS7+ DLRLCRETXBLKS_MCS7) * 112 + (DLRLCAKNEWBKS_MCS8+DLRLCRETXBLKS_MCS8 )* 136 + (DLRLCAKNEWBKS_MCS9+ DLRLCRETXBLKS_MCS9) * 148)*8/1000/(DLRLCAKNEWBKS_MCS1 +DLRLCAKNEWBKS_MCS2+DLRLCAKNEWBKS_MCS3+DLRLCAKNEWBKS_MCS4+DLRLCAKNEWBKS_MCS5+ DLRLCAKNEWBKS_MCS6+ DLRLCAKNEWBKS_MCS7 + DLRLCAKNEWBKS_MCS8+DLRLCAKNEWBKS_MCS9+DLRLCNACKBLKS_MCS1 + DLRLCNACKBLKS_MCS2 + DLRLCNACKBLKS_MCS3+ DLRLCNACKBLKS_MCS4 + DLRLCNACKBLKS_MCS5 + DLRLCNACKBLKS_MCS6+DLRLCNACKBLKS_MCS7 + DLRLCNACKBLKS_MCS8+ DLRLCNACKBLKS_MCS9++DLRLCRETXBLKS_MCS1isnull(sum(((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlisnull(sum(((ulrlcaknewbks_mcs1+ulrlcnanewbks_mcs1)*22+(ulrlcaknewbks_mcs2+ulrlcnanewbks_mcs2)*28+(ulrlcaknewbks_mcs3+ulrlcnanewbks_mcs3)*37+(ulrlcaknewbks_mcs4+ulrlcnanewbks_mcs4)*44+(ulrlcaknewbks_mcs5+ulrlcnanewbks_mcs5)*56+(ulrlcaknewbks_mcs6+ulrlcnanewbks_mcs6)*74+(ulrlcaknewbks_mcs7+ulrlcnanewbks_mcs7)*112+(ulrlcaknewbks_mcs8+ulrlcnanewbks_mcs8)*136+(ulrlisnull(100*sum(gprs_cellcong_55+gprs_cellcong_60+gprs_cellcong_65+gprs_cellcong_70+gprs_cellcong_75+gprs_cellcong_80+gprs_cellcong_85+gprs_cellcong_90+gprs_cellcong_95+gprs_cellcong_100)/sisnull(sum(ul_rlc_retx_blks*100/(ul_rlc_ack_new_bks+ul_rlc_retx_blks)),0)isnull(sum(ch_reqs_succ_p_c+ch_reqs_succ_p_p+ch_reqs_succ_p_r+ch_reqs_succ_pkts+ch_reqs_succ_e_c+ch_reqs_succ_cp_a+chanreqsucce1ccc+chanreqsucce1pccc+chanreqsuccepuaprr+chanreqsucceptr+chanreqsuccepuapda)*100/sum(chnlrqrecegprs1pc+chnlrqrecegprs1ppc+chnlrqrecegprspkrq+chnlrqrecegprscrpd+chan_reqs_rec_p_c+chan_reqs_rec_p_p+chan_reqs_rec_p_r+chan_reqs_rec_cp_a+chan_reqs_rec_e_c),0)isnull(sum(((ulrlcaknewbks_mcs1+ulrlcnanewbks_mcs1)*22+(ulrlcaknewbks_mcs2+ulrlcnanewbks_mcs2)*28+(ulrlcaknewbks_mcs3+ulrlcnanewbks_mcs3)*37+(ulrlcaknewbks_mcs4+ulrlcnanewbks_mcs4)*44+(ulrlcaknewbks_mcs5+ulrlcnanewbks_mcs5)*56+(ulrlcaknewbks_mcs6+ulrlcnanewbks_mcs6)*74+(ulrlcaknewbks_mcs7+ulrlcnanewbks_mcs7)*112+(ulrlcaknewbks_mcs8+ulrlcnanewbks_mcs8)*136+(ulrlisnull(100*sum(gprs_cellcong_55+gprs_cellcong_60+gprs_cellcong_65+gprs_cellcong_70+gprs_cellcong_75+gprs_cellcong_80+gprs_cellcong_85+gprs_cellcong_90+gprs_cellcong_95+gprs_cellcong_100)/sisnull(sum(o_inter_bs_ho_atm+o_intra_bs_ho_atm+intra_cell_ho_f_f+intra_cell_ho_h_h)/sum(total_calls),0)100*isnull(sum(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7)/sum(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+100*isnull(sum(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7)/sum(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7+u_ber_bin7_ts0+u_ber_bin7_ts1+u_ber_bin7_ts2+u_ber_bin7_ts3+u_ber_bin7_ts4+u_ber_bin7_ts5+u_ber_bin7_ts6+u_ber_bin7_ts7),0)100*isnull(sum(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7)/sum(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+ber_bin3_ts7+100*isnull(sum(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+u_ber_bin2_ts0+u_ber_bin2_ts1+u_ber_bin2_ts2+u_ber_bin2_ts3+u_ber_bin2_ts4+u_ber_bin2_ts5+u_ber_bin2_ts6+u_ber_bin2_ts7+u_ber_bin3_ts0+u_ber_bin3_ts1+u_ber_bin3_ts2+u_ber_bin3_ts3+u_ber_bin3_ts4+u_ber_bin3_ts5+u_ber_bin3_ts6+u_ber_bin3_ts7+(u_ber_bin4_ts0+u_ber_bin4_ts1+u_ber_bin4_ts2+u_ber_bin4_ts3+u_ber_bin4_ts4+u_ber_bin4_ts5+u_ber_bin4_ts6+u_ber_bin4_ts7+u_ber_bin5_ts0+u_ber_bin5_ts1+u_ber_bin5_ts2+u_ber_bin5_ts3+u_ber_bin5_ts4+u_ber_bin5_ts5+u_ber_bin5_ts6+u_ber_bin5_ts7+u_ber_bin6_ts0+u_ber_bin6_ts1+u_ber_bin6_ts2+u_ber_bin6_ts3+u_ber_bin6_ts4+u_ber_bin6_ts5+u_ber_bin6_ts6+u_ber_bin6_ts7)*0.7)/sum(u_ber_bin0_ts0+u_ber_bin0_ts1+u_ber_bin0_ts2+u_ber_bin0_ts3+u_ber_bin0_ts4+u_ber_bin0_ts5+u_ber_bin0_ts6+u_ber_bin0_ts7+u_ber_bin1_ts0+u_ber_bin1_ts1+u_ber_bin1_ts2+u_ber_bin1_ts3+u_ber_bin1_ts4+u_ber_bin1_ts5+u_ber_bin1_ts6+u_ber_bin1_ts7+100*isnull(sum(ber_bin0_ts0+ber_bin0_ts1+ber_bin0_ts2+ber_bin0_ts3+ber_bin0_ts4+ber_bin0_ts5+ber_bin0_ts6+ber_bin0_ts7+ber_bin1_ts0+ber_bin1_ts1+ber_bin1_ts2+ber_bin1_ts3+ber_bin1_ts4+ber_bin1_ts5+ber_bin1_ts6+ber_bin1_ts7+ber_bin2_ts0+ber_bin2_ts1+ber_bin2_ts2+ber_bin2_ts3+ber_bin2_ts4+ber_bin2_ts5+ber_bin2_ts6+ber_bin2_ts7+ber_bin3_ts0+ber_bin3_ts1+ber_bin3_ts2+ber_bin3_ts3+ber_bin3_ts4+ber_bin3_ts5+ber_bin3_ts6+ber_bin3_ts7+(ber_bin4_ts0+ber_bin4_ts1+ber_bin4_ts2+ber_bin4_ts3+ber_bin4_ts4+ber_bin4_ts5+ber_bin4_ts6+ber_bin4_ts7+ber_bin5_ts0+ber_bin5_ts1+ber_bin5_ts2+ber_bin5_ts3+ber_bin5_ts4+ber_bin5_ts5+ber_bin5_ts6+ber_bin5_ts7+ber_bin6_ts0+ber_bin6_ts1+ber_bin6_ts2+ber_bin6_ts3+ber_bin6_ts4+ber_bin6_ts5+ber_bin6_ts6+bisnull(100*((dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28)/((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148),0)isnull(100*((dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37)/((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148),0)isnull(100*((dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56)/((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148),0)isnull(100*((dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112)/((dlrlcaknewbks_mcs1+dlrlcnanewbks_mcs1)*22+(dlrlcaknewbks_mcs2+dlrlcnanewbks_mcs2)*28+(dlrlcaknewbks_mcs3+dlrlcnanewbks_mcs3)*37+(dlrlcaknewbks_mcs4+dlrlcnanewbks_mcs4)*44+(dlrlcaknewbks_mcs5+dlrlcnanewbks_mcs5)*56+(dlrlcaknewbks_mcs6+dlrlcnanewbks_mcs6)*74+(dlrlcaknewbks_mcs7+dlrlcnanewbks_mcs7)*112+(dlrlcaknewbks_mcs8+dlrlcnanewbks_mcs8)*136+(dlrlcaknewbks_mcs9+dlrlcnanewbks_mcs9)*148),0)isnull(((DL_TBF_TIME_1_TS+ DL_TBF_TIME_2_TS+ DL_TBF_TIME_3_TS+ DL_TBF_TIME_4_TS )*0.02)/(DL_BUSY_PDTCH_MEAN*3600),0)isnull(100*(ulrlc_retxbks_mcs1+ulrlc_retxbks_mcs2+ulrlc_retxbks_mcs3+ulrlc_retxbks_mcs4+ulrlc_retxbks_mcs5+ulrlc_retxbks_mcs6+ulrlc_retxbks_mcs7+ulrlc_retxbks_mcs8+ulrlc_retxbks_mcs9)/(ulrlc_retxbks_mcs1+ulrlc_retxbks_mcs2+ulrlc_retxbks_mcs3+ulrlc_retxbks_mcs4+ulrlc_retxbks_mcs5+ulrlc_retxbks_mcs6+ulrlc_retxbks_mcs7+ulrlc_retxbks_mcs8+ulrlc_retxbks_mcs9+ulrlcaknewbks_mcs1+ulrlcaknewbks_mcs2+ulrlcaknewbks_mcs3+ulrlcaknewbks_mcs4+ulrlcaknewbks_mcs5+ulrlcaknewbks_mcs6100*(sum(total_calls)/sum(ma_req_from_msc))*(sum(alloc_sdcch)/(sum(alloc_sdcch)+sum(alloc_sdcch_fail)))isnull((((DLRLCAKNEWBKS_CS1+DLRLCRETXBLKS_CS1) *22+(DLRLCAKNEWBKS_CS2+DLRLCRETXBLKS_CS2) *32+(DLRLCAKNEWBKS_CS3+DLRLCRETXBLKS_CS3) *38+(DLRLCAKNEWBKS_CS4+DLRLCRETXBLKS_CS4) *52+(DLRLCAKNEWBKS_MCS1+DLRLCRETXBLKS_MCS1) * 22 + (DLRLCAKNEWBKS_MCS2+DLRLCRETXBLKS_MCS2)* 28+ (DLRLCAKNEWBKS_MCS3+ DLRLCRETXBLKS_MCS3) * 37 +(DLRLCAKNEWBKS_MCS4+ DLRLCRETXBLKS_MCS4) * 44 + (DLRLCAKNEWBKS_MCS5+DLRLCRETXBLKS_MCS5 ) * 56 + (DLRLCAKNEWBKS_MCS6+ DLRLCRETXBLKS_MCS6 )* 74 +(DLRLCAKNEWBKS_MCS7+ DLRLCRETXBLKS_MCS7) * 112 + (DLRLCAKNEWBKS_MCS8+DLRLCRETXBLKS_MCS8 )* 136 + (DLRLCAKNEWBKS_MCS9+ DLRLCRETXBLKS_MCS9) * 148)*8/1000/(DLRLCAKNEWBKS_CS1+DLRLCAKNEWBKS_CS2+DLRLCAKNEWBKS_CS3+DLRLCAKNEWBKS_CS4+DLRLCAKNEWBKS_MCS1 +DLRLCAKNEWBKS_MCS2+DLRLCAKNEWBKS_MCS3+DLRLCAKNEWBKS_MCS4+DLRLCAKNEWBKS_MCS5isnull(intf_on_idle_mean3,0)isnull(cm_serv_req_supp ,0)isnull(ohoa_adj_chn_intf ,0)isnull(o_inter_bs_ho_ret ,0)

因篇幅问题不能全部显示,请点此查看更多更全内容

Copyright © 2019- 91gzw.com 版权所有 湘ICP备2023023988号-2

违法及侵权请联系:TEL:199 18 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务