dashboard formula

34
Column Name Radio Network Load - Rel'99(DBH)-MByte Radio Network Load - HSDPA(DBH)-MByte Radio Network Load - HSUPA(DBH)-MByte RAB Setup Success Rate - Rel'99 (DBH) % of cells with RAB Setup Success Rate - Rel'99 >=98% (DBH) % of cells with RAB Setup Success Rate - HSDPA >=98% (DBH) % of cells with RAB Setup Success Rate - HSUPA >=98% (DBH) DCR-HSDPA (DBH) DCR-HSUPA (DBH) Total NBH Traffic (Erlangs)

Upload: prasoon-singh

Post on 30-Oct-2014

148 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: Dashboard Formula

Column NameRadio Network Load - Rel'99(DBH)-MByteRadio Network Load - HSDPA(DBH)-MByteRadio Network Load - HSUPA(DBH)-MByte

RAB Setup Success Rate - Rel'99 (DBH)% of cells with RAB Setup Success Rate - Rel'99 >=98% (DBH)% of cells with RAB Setup Success Rate - HSDPA >=98% (DBH)% of cells with RAB Setup Success Rate - HSUPA >=98% (DBH)

DCR-HSDPA (DBH)

DCR-HSUPA (DBH)

Total NBH Traffic (Erlangs)

Page 2: Dashboard Formula

NBH Voice Traffic(Erlang)

NBH Video Traffic(Erlang)

NBH Streaming(Conversational) Traffic(Erlang)-NBH

CE Utilised DL (NBH)

CE Utilised UL (NBH)

CSSR-VIDEO (NBH)

Page 3: Dashboard Formula

RAB Establishment Success rate(Voice,Video,Rel'99 & HSPA) (NBH)

RAB Setup Success Rate - Voice (NBH)

RAB Setup Success Rate - Video (NBH)

DCR-VIDEO (NBH)

SHO Factor-RT (NBH)

Page 4: Dashboard Formula

SHO Factor-NRT (NBH)

Total BBH Traffic (Erlangs)

BBH Voice Traffic(Erlang)

BBH Video Traffic(Erlang)

BBH Streaming(Conversational) Traffic(Erlang)

CE Utilised DL (BBH)

CE Utilised UL (BBH)

Page 5: Dashboard Formula

% cells with CSSR-VIDEO > 95% (BBH)

% cells with RAB Establishment Success rate(Voice,Video,Rel'99 & HSPA) >=98% (BBH)

% of cells with RAB Setup Success Rate - VOICE >=98% (BBH)

% of cells with RAB Setup Success Rate - VIDEO >=98% (BBH)

Page 6: Dashboard Formula

% of Cells with Service RRC Setup Success Rate >=98% (BBH)

% of cells with CS call blocking due to Call Admission Control <= 0.5% (BBH)

% of cells with PS call blocking due to Call Admission Control <= 0.5% (BBH)

Page 7: Dashboard Formula

DCR-Voice (BBH)

Page 8: Dashboard Formula

DCR-Rel'99 (BBH)

Page 9: Dashboard Formula

% cells with DCR-VIDEO <1.5% (BBH)

Total Whole Day (Erlangs)

Whole Day Voice Traffic(Erlang)

Page 10: Dashboard Formula

Whole Day Video Traffic(Erlang)

Whole Day Streaming(Conversational) Traffic(Erlang)

Radio Network Load - Rel'99(Whole Day)-MByte

Radio Network Load - HSDPA(Whole Day)-MByte

Radio Network Load - HSUPA(Whole Day)-MByte

Page 11: Dashboard Formula

CSSR-Voice

Page 12: Dashboard Formula

CSSR-Rel'99

Page 13: Dashboard Formula

CSSR-HSDPA

CSSR -HSUPA% cells with CSSR-Voice > 95%

Page 14: Dashboard Formula

SHOSRUL BLERDL BLER

3G-2G HOSR (RT)

Page 15: Dashboard Formula

3G-2G HOSR (NRT)

"UL throughput in KbpS"

DL throughput in KbpS

"UL throughput in KbpS"

DL throughput in KbpS% cells with CSSR-Rel'99 > 95%% cells with CSSR-HSDPA > 95% "% cells with CSSR-HSUPA > 95%" "% cells with DCR-Voice <1.5%"% cells with DCR-Rel'99 <1.5%% cells with DCR-HSDPA <2.0%% cells with DCR-HSUPA <2.0%% cells with SHOSR > 95%% of Cells having SHO FACTOR-RT < 40 % (BBH)

"% of Cells having SHO FACTOR-NRT < 40 % (BBH)"

Page 16: Dashboard Formula

% cells with UL BLER <2%% cells with DL BLER <2%

RAB Setup Success Rate - HSDPA (DBH)

RAB Setup Success Rate - HSUPA (DBH)

Page 17: Dashboard Formula

"Total RRC Attempt (NBH)"

"Service RRC Setup Success Rate (NBH)"

Page 18: Dashboard Formula

Formule sum((NRT_DCH_DL_DATA_VOL + NRT_DCH_UL_DATA_VOL + NRT_DCH_HSDPA_UL_DATA_VOL))/(1024*1024) Radio_NW_Load_Rel99_DBH_MByte,sum((RECEIVED_HS_MACD_BITS - DISCARDED_HS_MACD_BITS))/(8*1024) Radio_NW_Load_HSDPA_DBH_MByte, sum( (EDCH_DATA_SCELL_UL + EDCH_DATA_NSC_S_EDCH_UL + EDCH_DATA_NSC_NS_EDCH_UL)) / (1024) Radio_NW_Load_HSUPA_DBH_MByte,

sum((count_RAB_Setup_Success_Rate_Rel99_DBH)/ sum(TOTAL_COUNT_RAB_Setup_Success_Rate_Rel99_DBH))*100( sum((RAB_Setup_Suc_Rate_HSDPA_DBH)/ count(RAB_setup_suc_rate_HSDPA_DBH) >=98(value))*100) ( sum(RAB_Setup_suc_Rate_HSUPA_DBH)/count(RAB_setup_suc_rate_HSUPA_DBH)>=98(value))*100

(100* sum((RAB_ACC_COMP_PS_INTER+RAB_ACC_COMP_PS_BACKG)) / sum((RAB_STP_ATT_PS_INTER + RAB_STP_ATT_PS_BACKG)) RAB_Setup_Suc_Rate_Rel99_DBH,

(100-(100* (sum((REL_ALLO_NORM_HS_DSCH_INT + REL_ALLO_NORM_HS_DSCH_BGR)) / sum((REL_ALLO_NORM_HS_DSCH_INT + REL_ALLO_NORM_HS_DSCH_BGR + REL_ALLO_OTH_FAIL_HSDSCH_INT + REL_ALLO_OTH_FAIL_HSDSCH_BGR + REL_ALLO_RL_FAIL_HS_DSCH_INT + REL_ALLO_RL_FAIL_HS_DSCH_BGR))) DCR_HSDPA_DBH,

(100-(100* (sum((REL_EDCH_NORM_INT + REL_EDCH_NORM_BGR + REL_EDCH_HSDSCH_SCC_INT + REL_EDCH_HSDSCH_SCC_BGR)) / sum((REL_EDCH_NORM_INT + REL_EDCH_NORM_BGR + REL_EDCH_HSDSCH_SCC_INT + REL_EDCH_HSDSCH_SCC_BGR + REL_EDCH_RL_FAIL_INT + REL_EDCH_RL_FAIL_BGR + REL_EDCH_OTHER_FAIL_INT + REL_EDCH_OTHER_FAIL_BGR))))) DCR_HSUPA_DBH,

((sum((avg_rab_hld_tm_cs_CONV + avg_rab_hld_tm_cs_VOICE + avg_rab_hld_tm_cs_STREA)) / (100*60*60)) / (( sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT )) / sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3))) Total_NBH_Traffic_Erlangs,

Page 19: Dashboard Formula

(100*((sum(MAX_USED_CE_DL)- (72*(CELL_COUNT_NBH))) / (sum(MAX_AVAIL_CE) - (72*(CELL_COUNT_NBH)))))

(100*((sum(MAX_USED_CE_UL) - (72*(CELL_COUNT_NBH))) / (sum(MAX_AVAIL_CE) - (72*(CELL_COUNT_NBH)))))

((sum((avg_rab_hld_tm_cs_VOICE)) / (100*60*60)) / (( sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT ) )/ sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3))) NBH_Voice_Traffic_Erlang,

((sum((avg_rab_hld_tm_cs_CONV)) / (100*60*60)) / (( sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT )) / sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3))) NBH_Video_Traffic_Erlang,

(( sum((avg_rab_hld_tm_cs_STREA)) / (100*60*60)) / (( sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT))/ sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3))) NBH_Stre_Conver_Traf_Erl_NBH,

(100 * sum((MOC_CONV_CALL_ATTS - MOC_CONV_CALL_FAILS + MTC_CONV_CALL_ATTS - MTC_CONV_CALL_FAILS - RRC_ACC_REL_MO_CONV - RRC_ACC_REL_MT_CONV)) / sum((MOC_CONV_CALL_ATTS + MTC_CONV_CALL_ATTS - RRC_ATT_REP_MO_CONV - RRC_ATT_REP_MT_CONV - RRC_ACC_REL_MO_CONV - RRC_ACC_REL_MT_CONV))* sum((RAB_ACC_COMP_CS_CONV)) / sum((RAB_STP_ATT_CS_CONV)) CSSR_VIDEO_NBH

Page 20: Dashboard Formula

(100* (RAB_ACC_COMP_CS_VOICE) / (RAB_STP_ATT_CS_VOICE) RAB_Setup_Suc_Rate_Voice_NBH,

(100*(RAB_ACC_COMP_CS_CONV)/(RAB_STP_ATT_CS_CONV) RAB_Setup_Suc_Rate_Video_NBH

(100* (RAB_ACC_COMP_CS_VOICE) / (RAB_STP_ATT_CS_VOICE)+100*(RAB_ACC_COMP_CS_CONV) / (RAB_STP_ATT_CS_CONV)+ 100* (RAB_ACC_COMP_PS_INTER + RAB_ACC_COMP_PS_BACKG)/ (RAB_STP_ATT_PS_INTER + RAB_STP_ATT_PS_BACKG) RAB_Estab_Suc_rate_VoViReA_NBH,

(100* sum((RAB_ACT_FAIL_CS_CONV_IU + RAB_ACT_FAIL_CS_CONV_RADIO + RAB_ACT_FAIL_CS_CONV_BTS + RAB_ACT_FAIL_CS_CONV_RNC + RAB_ACT_FAIL_CS_CONV_IUR + RAB_ACT_FAIL_CS_CONV_UE + RAB_ACT_REL_CS_CONV_P_EMP + RAB_ACT_FAIL_CS_CONV_TRANS) ) / sum((RAB_ACT_COMP_CS_CONV + RAB_ACT_REL_CS_CONV_SRNC + RAB_ACT_REL_CS_CONV_HHO + RAB_ACT_REL_CS_CONV_ISHO + RAB_ACT_REL_CS_CONV_P_EMP + RAB_ACT_FAIL_CS_CONV_IU + RAB_ACT_FAIL_CS_CONV_RADIO + RAB_ACT_FAIL_CS_CONV_BTS + RAB_ACT_FAIL_CS_CONV_RNC + RAB_ACT_FAIL_CS_CONV_IUR + RAB_ACT_FAIL_CS_CONV_UE + RAB_ACT_FAIL_CS_CONV_TRANS)) DCR_VIDEO_NBH,

(100* ((sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT ) )/ sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3))) SHO_Factor_RT_NBH,

Page 21: Dashboard Formula

(100*((sum(MAX_USED_CE_DL) - (72*(CELL_COUNT_BBH))) / (sum(MAX_AVAIL_CE) - (72*(CELL_COUNT_BBH)))))

(100*((sum(MAX_USED_CE_UL) - (72*(CELL_COUNT_BBH))) / sum(MAX_AVAIL_CE) - (72*(CELL_COUNT_BBH)))))

(100* ((sum((ONE_CELL_IN_ACT_SET_FOR_NRT + TWO_CELLS_IN_ACT_SET_FOR_NRT + THREE_CELLS_IN_ACT_SET_NRT) )/ sum(((ONE_CELL_IN_ACT_SET_FOR_NRT) + ((TWO_CELLS_IN_ACT_SET_FOR_NRT)/2) + ((THREE_CELLS_IN_ACT_SET_NRT)/3))) SHO_Factor_NRT_NBH,

(sum((avg_rab_hld_tm_cs_CONV + avg_rab_hld_tm_cs_VOICE + avg_rab_hld_tm_cs_STREA)) / (100*60*60)) / ((sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT )) / sum((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3)) Total_BBH_Traffic_Erlangs,

((avg_rab_hld_tm_cs_VOICE) / (100*60*60)) / (sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT )) / sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3)))) BBH_Voice_Traffic_Erlang,

((avg_rab_hld_tm_cs_CONV) / (100*60*60)) / ( sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT ))/ sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3)) )) BBH_Video_Traffic_Erlang,

((avg_rab_hld_tm_cs_STREA) / (100*60*60)) / (( sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT ) )/ sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3))) BBH_Str_Conv_Traffic_Erlang,

Page 22: Dashboard Formula

( count(CSSR_VIDEO_NBH)>95/count(CSSR_VIDEO_NBH))*100

CSSR_VIDEO_NBH =(100 * sum((MOC_CONV_CALL_ATTS - MOC_CONV_CALL_FAILS + MTC_CONV_CALL_ATTS - MTC_CONV_CALL_FAILS - RRC_ACC_REL_MO_CONV - RRC_ACC_REL_MT_CONV)) / sum((MOC_CONV_CALL_ATTS + MTC_CONV_CALL_ATTS - RRC_ATT_REP_MO_CONV - RRC_ATT_REP_MT_CONV - RRC_ACC_REL_MO_CONV - RRC_ACC_REL_MT_CONV)) * sum((RAB_ACC_COMP_CS_CONV)) / sum((RAB_STP_ATT_CS_CONV))

(count(RAB_Estab_Suc_rate_VoViReA_NBH)>98(value)/count(RAB_Estab_Suc_rate_VoViReA_NBH))*100

RAB_Estab_Suc_rate_VoViReA_NBH = (100* (RAB_ACC_COMP_CS_VOICE) / (RAB_STP_ATT_CS_VOICE)+100*(RAB_ACC_COMP_CS_CONV) /(RAB_STP_ATT_CS_CONV)+ 100* (RAB_ACC_COMP_PS_INTER + RAB_ACC_COMP_PS_BACKG)/ (RAB_STP_ATT_PS_INTER + RAB_STP_ATT_PS_BACKG)

(count(RAB_Setup_Suc_Rate_Voice_NBH) >98(value)/count(RAB_Setup_Suc_Rate_Voice_NBH) )*100

RAB_Setup_Suc_Rate_Voice_NBH = (100* (RAB_ACC_COMP_CS_VOICE) / (case when (RAB_STP_ATT_CS_VOICE)

(count(RAB_Setup_Suc_Rate_Video_NBH) >98/count(RAB_Setup_Suc_Rate_Video_NBH))*100

RAB_Setup_Suc_Rate_Video_NBH = (100*sum((RAB_ACC_COMP_CS_CONV))/sum((RAB_STP_ATT_CS_CONV)) )

Page 23: Dashboard Formula

(sum(Serv_RRC_Setup_Suc_Rate_NBH)/count(Serv_RRC_Setup_Suc_Rate_NBH) >=98)*100 Serv_RRC_Setup_Suc_Rate_NBH = (100-100* sum((RRC_CONN_ACT_REL_P_EMP +RRC_CONN_ACT_FAIL_IU +RRC_CONN_ACT_FAIL_RADIO +RRC_CONN_ACT_FAIL_BTS +RRC_CONN_ACT_FAIL_IUR +RRC_CONN_ACT_FAIL_RNC +RRC_CONN_ACT_FAIL_UE +RRC_CONN_ACT_FAIL_TRANS +RRC_CONN_ACT_FAIL_CIPH)) / sum((RRC_CONN_ACT_COMP +RRC_CONN_ACT_REL_SRNC +RRC_CONN_ACT_REL_GANHO +RRC_CONN_ACT_REL_HHO +RRC_CONN_ACT_REL_INTRA_HHO +RRC_CONN_ACT_REL_ISHO +RRC_CONN_ACT_REL_P_EMP +RRC_CONN_ACT_FAIL_IU +RRC_CONN_ACT_FAIL_RADIO +RRC_CONN_ACT_FAIL_BTS +RRC_CONN_ACT_FAIL_IUR +RRC_CONN_ACT_FAIL_RNC +RRC_CONN_ACT_FAIL_UE +RRC_CONN_ACT_FAIL_TRANS +RRC_CONN_ACT_FAIL_CIPH))

(100 * sum((RAB_STP_FAIL_CS_VOICE_AC + RAB_STP_FAIL_CS_CONV_AC + RAB_STP_FAIL_CS_STREA_AC + RAB_STP_FAIL_PS_STREA_AC)) /sum((RAB_STP_ATT_CS_VOICE + RAB_STP_ATT_CS_CONV + RAB_STP_ATT_CS_STREA + RAB_STP_ATT_PS_STREA)) cells_with_CS_Call_Admis_BBH,

(100*sum((PS_SETUP_FAIL_AC_INT + PS_SETUP_FAIL_AC_BGR))/sum((PS_ATT_HSDSCH_EDCH_INT+PS_ATT_HSDSCH_EDCH_BGR+PS_ATT_HSDSCH_DCH_INT+PS_ATT_HSDSCH_DCH_BGR+PS_ATT_DCH_DCH_INT +PS_ATT_DCH_DCH_BGR)) Call_Admission_Control_PS_BBH,

Page 24: Dashboard Formula

(100* (sum((RAB_ACT_REL_CS_VOICE_P_EMP + RAB_ACT_FAIL_CS_VOICE_IU + RAB_ACT_FAIL_CS_VOICE_RADIO + RAB_ACT_FAIL_CS_VOICE_BTS + RAB_ACT_FAIL_CS_VOICE_IUR + RAB_ACT_FAIL_CS_VOICE_RNC + RAB_ACT_FAIL_CS_VOICE_UE + RAB_ACT_FAIL_CS_VOICE_TRANS) )/ sum((RAB_ACT_COMP_CS_VOICE + RAB_ACT_REL_CS_VOICE_SRNC + RAB_ACT_REL_CS_VOICE_P_EMP + RAB_ACT_REL_CS_VOICE_HHO + RAB_ACT_REL_CS_VOICE_ISHO + RAB_ACT_REL_CS_VOICE_GANHO + RAB_ACT_FAIL_CS_VOICE_IU + RAB_ACT_FAIL_CS_VOICE_RADIO + RAB_ACT_FAIL_CS_VOICE_BTS + RAB_ACT_FAIL_CS_VOICE_IUR + RAB_ACT_FAIL_CS_VOICE_RNC + RAB_ACT_FAIL_CS_VOICE_UE + RAB_ACT_FAIL_CS_VOICE_TRANS)) DCR_Voice_BBH,

Page 25: Dashboard Formula

RAB_ACT_FAIL_PS_INTER_IU + RAB_ACT_FAIL_PS_INTER_RADIO + RAB_ACT_FAIL_PS_INTER_BTS + RAB_ACT_FAIL_PS_INTER_IUR + RAB_ACT_FAIL_PS_INTER_RNC + RAB_ACT_FAIL_PS_BACKG_IU + RAB_ACT_FAIL_PS_BACKG_RADIO + RAB_ACT_FAIL_PS_BACKG_BTS + RAB_ACT_FAIL_PS_BACKG_IUR + RAB_ACT_FAIL_PS_BACKG_RNC + RAB_ACT_FAIL_PS_BACKG_UE + RAB_ACT_FAIL_PS_INTER_UE - RAB_ACT_FAIL_PS_BACKG_PCH - RAB_ACT_FAIL_PS_INT_PCH)) / sum((RAB_ACT_COMP_PS_INTER + RAB_ACT_COMP_PS_BACKG + RAB_ACT_REL_PS_INTER_SRNC + RAB_ACT_REL_PS_INTER_HHO + RAB_ACT_REL_PS_INTER_ISHO + RAB_ACT_REL_PS_BACKG_SRNC + RAB_ACT_REL_PS_BACKG_HHO + RAB_ACT_REL_PS_BGR_ISHO + RAB_ACT_FAIL_PS_INTER_IU + RAB_ACT_FAIL_PS_INTER_RADIO + RAB_ACT_FAIL_PS_INTER_BTS + RAB_ACT_FAIL_PS_INTER_IUR + RAB_ACT_FAIL_PS_INTER_RNC + RAB_ACT_FAIL_PS_BACKG_IU + RAB_ACT_FAIL_PS_BACKG_RADIO + RAB_ACT_FAIL_PS_BACKG_BTS + RAB_ACT_FAIL_PS_BACKG_IUR + RAB_ACT_FAIL_PS_BACKG_RNC + RAB_ACT_FAIL_PS_BACKG_UE + RAB_ACT_FAIL_PS_INTER_UE + RAB_ACT_FAIL_PS_INTER_TRANS + RAB_ACT_FAIL_PS_BACKG_TRANS)) DCR_ReL99_BBH,

Page 26: Dashboard Formula

(count(DCR_VIDEO_NBH)<1.5(value)/count(DCR_VIDEO_NBH))*100

DCR_VIDEO_NBH =(100* sum((RAB_ACT_FAIL_CS_CONV_IU + RAB_ACT_FAIL_CS_CONV_RADIO + RAB_ACT_FAIL_CS_CONV_BTS + RAB_ACT_FAIL_CS_CONV_RNC + RAB_ACT_FAIL_CS_CONV_IUR + RAB_ACT_FAIL_CS_CONV_UE + RAB_ACT_REL_CS_CONV_P_EMP + RAB_ACT_FAIL_CS_CONV_TRANS)) / sum((RAB_ACT_COMP_CS_CONV + RAB_ACT_REL_CS_CONV_SRNC + RAB_ACT_REL_CS_CONV_HHO + RAB_ACT_REL_CS_CONV_ISHO + RAB_ACT_REL_CS_CONV_P_EMP + RAB_ACT_FAIL_CS_CONV_IU + RAB_ACT_FAIL_CS_CONV_RADIO + RAB_ACT_FAIL_CS_CONV_BTS + RAB_ACT_FAIL_CS_CONV_RNC + RAB_ACT_FAIL_CS_CONV_IUR + RAB_ACT_FAIL_CS_CONV_UE + RAB_ACT_FAIL_CS_CONV_TRANS) )

((sum((avg_rab_hld_tm_cs_CONV + avg_rab_hld_tm_cs_VOICE + avg_rab_hld_tm_cs_STREA)) / (100*60*60)) / (( sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT ))/ sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3))) Total_Whole_Day_Erlangs,

((sum((avg_rab_hld_tm_cs_VOICE)) / (100*60*60)) / (( sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT )) / sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3))) Whole_Day_Voice_Traffic_Erlang,

Page 27: Dashboard Formula

sum((NRT_DCH_DL_DATA_VOL + NRT_DCH_UL_DATA_VOL + NRT_DCH_HSDPA_UL_DATA_VOL))/(1024*1024) Rdo_Nw_Lod_Rel99_Whol_Day,

sum((RECEIVED_HS_MACD_BITS - DISCARDED_HS_MACD_BITS))/(8*1024) HSDPA_Whole_Day_MByte,

sum((EDCH_DATA_SCELL_UL + EDCH_DATA_NSC_S_EDCH_UL + EDCH_DATA_NSC_NS_EDCH_UL)) / (1024) "HSUPA_Whole_Day_MByte",

((sum((avg_rab_hld_tm_cs_CONV)) / (100*60*60)) / (( sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT) )/ sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3))) Whole_Day_Video_Traffic_Erlang,

(((avg_rab_hld_tm_cs_STREA) / (100*60*60)) / (( sum((ONE_CELL_IN_ACT_SET_FOR_RT + TWO_CELLS_IN_ACT_SET_FOR_RT + THREE_CELLS_IN_ACT_SET_RT ))/ sum(((ONE_CELL_IN_ACT_SET_FOR_RT ) + ((TWO_CELLS_IN_ACT_SET_FOR_RT )/2) + ((THREE_CELLS_IN_ACT_SET_RT )/3))) Whole_Day_Str_Conver_Traf_Erl,

Page 28: Dashboard Formula

(100* ((sum((MOC_CONV_CALL_ATTS - MOC_CONV_CALL_FAILS + MTC_CONV_CALL_ATTS - MTC_CONV_CALL_FAILS + EMERGENCY_CALL_ATTS - EMERGENCY_CALL_FAILS - RRC_ACC_REL_EMERGENCY - RRC_ACC_REL_MO_CONV - RRC_ACC_REL_MT_CONV)) / sum((MOC_CONV_CALL_ATTS + MTC_CONV_CALL_ATTS + EMERGENCY_CALL_ATTS - RRC_ATT_REP_MO_CONV - RRC_ATT_REP_MT_CONV - RRC_ATT_REP_EMERGENCY - RRC_ACC_REL_EMERGENCY - RRC_ACC_REL_MO_CONV - RRC_ACC_REL_MT_CONV - RRC_CONN_STP_REJ_EMERG_CALL) )* (sum((RAB_ACC_COMP_CS_VOICE)) / sum((RAB_STP_ATT_CS_VOICE)) CSSR_Voice,

Page 29: Dashboard Formula

MOC_BACKG_CALL_ATTS - MOC_BACKG_CALL_FAILS + MTC_INTER_CALL_ATTS - MTC_INTER_CALL_FAILS + MTC_BACKG_CALL_ATTS - MTC_BACKG_CALL_FAILS + MOC_HIGH_PRIOR_SIGN_ATTS - MOC_HIGH_PRIOR_SIGN_FAILS + MTC_HIGH_PRIOR_SIGN_ATTS - MTC_HIGH_PRIOR_SIGN_FAILS - RRC_ACC_REL_INTERACTIVE - RRC_ACC_REL_MO_BACKGROUND - RRC_ACC_REL_MO_HIGH_PR_SIGN - RRC_ACC_REL_MO_INTERACTIVE - RRC_ACC_REL_MT_BACKGROUND - RRC_ACC_REL_MT_HIGH_PR_SIGN) )/ sum((MOC_INTER_CALL_ATTS + MOC_BACKG_CALL_ATTS + MOC_HIGH_PRIOR_SIGN_ATTS + MTC_INTER_CALL_ATTS + MTC_BACKG_CALL_ATTS + MTC_HIGH_PRIOR_SIGN_ATTS - RRC_ATT_REP_INTERACTIVE - RRC_ATT_REP_MO_INTERACTIVE - RRC_ATT_REP_MO_HIGH_PR_SIGN - RRC_ATT_REP_MO_BACKGROUND - RRC_ATT_REP_MT_BACKGROUND - RRC_ATT_REP_MT_HIGH_PR_SIGN - RRC_ACC_REL_INTERACTIVE - RRC_ACC_REL_MO_BACKGROUND - RRC_ACC_REL_MO_HIGH_PR_SIGN - RRC_ACC_REL_MO_INTERACTIVE - RRC_ACC_REL_MT_BACKGROUND - RRC_ACC_REL_MT_HIGH_PR_SIGN) )* (sum((RAB_ACC_COMP_PS_INTER+RAB_ACC_COMP_PS_BACKG)) /sum((RAB_STP_ATT_PS_INTER+RAB_STP_ATT_PS_BACKG)) "CSSR_Rel99",

Page 30: Dashboard Formula

(count(CSSR_VOICE) >95/count(CSSR_VOICE))*100

(100* sum((HS_E_REQ_HS_E_ALLO_STRE + HS_E_REQ_HS_E_ALLO_INT + HS_E_REQ_HS_E_ALLO_BGR + HS_E_REQ_HS_D_ALLO_STRE + HS_E_REQ_HS_D_ALLO_INT + HS_E_REQ_HS_D_ALLO_BGR + HS_D_REQ_HS_D_ALLO_STRE + HS_D_REQ_HS_D_ALLO_INT + HS_D_REQ_HS_D_ALLO_BGR) )/ sum(((PS_ATT_HSDSCH_EDCH_STRE + PS_ATT_HSDSCH_EDCH_INT + PS_ATT_HSDSCH_EDCH_BGR + PS_ATT_HSDSCH_DCH_STRE + PS_ATT_HSDSCH_DCH_INT + PS_ATT_HSDSCH_DCH_BGR - HS_D_REQ_D_D_ALLO_STR_CELL - HS_D_REQ_D_D_ALLO_BGR_CELL - HS_D_REQ_D_D_ALLO_INT_CELL - HS_E_REQ_D_D_ALLO_STR_CELL - HS_E_REQ_D_D_ALLO_BGR_CELL - HS_E_REQ_D_D_ALLO_INT_CELL)) ) CSSR_HSDPA,

(100* sum((HS_E_REQ_HS_E_ALLO_STRE + HS_E_REQ_HS_E_ALLO_INT + HS_E_REQ_HS_E_ALLO_BGR)) / sum((PS_ATT_HSDSCH_EDCH_STRE + PS_ATT_HSDSCH_EDCH_INT + PS_ATT_HSDSCH_EDCH_BGR - HS_E_REQ_HS_D_ALLO_STR_CELL - HS_E_REQ_HS_D_ALLO_BGR_CELL - HS_E_REQ_HS_D_ALLO_INT_CELL - HS_E_REQ_D_D_ALLO_STR_CELL - HS_E_REQ_D_D_ALLO_BGR_CELL - HS_E_REQ_D_D_ALLO_INT_CELL)) CSSR_HSUPA,

Page 31: Dashboard Formula

(100* ((UL_CRC_NOKS_R) /(UL_CRC_NOKS_R+ UL_CRC_OKS_R) UL_BLER, 100*(UEQ_AVE_BLER) DL_BLER,

(100* sum((SUCC_UPDATES_ON_SHO_FOR_RT) ) / sum((CELL_ADD_REQ_ON_SHO_FOR_RT + CELL_REPL_REQ_ON_SHO_FOR_RT + CELL_DEL_REQ_ON_SHO_FOR_RT)) SHOSR,

(100* sum((CON_DRPS_IS_HHO_UL_DCH_Q_NRT + CON_DRPS_IS_HHO_TRX_PWR_NRT + CON_DRPS_IS_HHO_DL_DPCH_NRT + CON_DRPS_IS_HHO_RSCP_NRT + CON_DRPS_IS_HHO_ECNO_NRT + CON_DRPS_IS_HHO_IM_IMS_NRT + CONDR_IS_HHO_LB_CAPA_DL_NRT + CONDR_IS_HHO_LB_CAPA_UL_NRT + CONDR_IS_HHO_LB_PRX_TOT_NRT + CONDR_IS_HHO_LB_PTX_TOT_NRT + CONDR_IS_HHO_LB_RES_LIM_NRT + CONDR_IS_HHO_LB_RSVR_SC_NRT + CONDR_IS_HHO_SB_NRT )) / sum((IS_HHO_ATT_UL_DCH_Q_NRT + IS_HHO_ATT_UE_TRX_PWR_NRT + IS_HHO_ATT_DL_DPCH_PWR_NRT + IS_HHO_ATT_CPICH_RSCP_NRT + IS_HHO_ATT_CPICH_ECNO_NRT + IS_HHO_ATT_IM_IMS_NRT + IS_HHO_ATT_LB_CAPA_DL_NRT + IS_HHO_ATT_LB_CAPA_UL_NRT + IS_HHO_ATT_LB_PRX_TOT_NRT + IS_HHO_ATT_LB_PTX_TOT_NRT + IS_HHO_ATT_LB_RES_LIM_NRT + IS_HHO_ATT_LB_RSVR_SC_NRT + IS_HHO_ATT_SB_NRT + ATT_ISHO_CELL_SHUTDOWN_NRT + ATT_ISHO_CELL_BLOCK_NRT)) "3G_2G_HOSR_NRT",

Page 32: Dashboard Formula

(((NRT_DCH_DL_DATA_VOL + RT_PS_DCH_DL_DATA_VOL)*8) / (1000*PERIOD_DURATION_RVOL*60)) DL_throughput_in_KbpS,

(((NRT_DCH_DL_DATA_VOL + RT_PS_DCH_DL_DATA_VOL)*8) / (1000*PERIOD_DURATION_RVOL*60)) DL_throughput_in_KbpS,((count(CSSR_Rel99) >95(value) /count(CSSR_Rel99) )*100) ((count(CSSR_HSDPA)>95(value)/count(CSSR_HSDPA))*100)((count(CSSR_HSUPA) >95(value)/count(CSSR_HSUPA) )*100) ((count(DCR_Voice_BBH) <1.5(value)/count(DCR_Voice_BBH))*100) ((count(DCR_ReL99_BBH) <1.5(value) /count(DCR_ReL99_BBH))*100)( count(DCR_HSDPA_DBH) <2.0(value)/count(DCR_HSDPA_DBH) )*100(count(DCR_HSUPA_DBH) <2.0(value)/count(DCR_HSUPA_DBH) )*100 (count(SHOSR) >95 (value)/count(SHOSR))*100(count(Cel_hav_SHO_FAC_RT_BBH) <40(value)/count(Cel_hav_SHO_FAC_RT_BBH) )*100

(count(Cel_hav_SHO_FAC_NRT_BBH) <40(value)/count(Cel_hav_SHO_FAC_NRT_BBH) )*100

(100* sum((CON_DRPS_IS_HHO_UL_DCH_Q_NRT + CON_DRPS_IS_HHO_TRX_PWR_NRT + CON_DRPS_IS_HHO_DL_DPCH_NRT + CON_DRPS_IS_HHO_RSCP_NRT + CON_DRPS_IS_HHO_ECNO_NRT + CON_DRPS_IS_HHO_IM_IMS_NRT + CONDR_IS_HHO_LB_CAPA_DL_NRT + CONDR_IS_HHO_LB_CAPA_UL_NRT + CONDR_IS_HHO_LB_PRX_TOT_NRT + CONDR_IS_HHO_LB_PTX_TOT_NRT + CONDR_IS_HHO_LB_RES_LIM_NRT + CONDR_IS_HHO_LB_RSVR_SC_NRT + CONDR_IS_HHO_SB_NRT )) / sum((IS_HHO_ATT_UL_DCH_Q_NRT + IS_HHO_ATT_UE_TRX_PWR_NRT + IS_HHO_ATT_DL_DPCH_PWR_NRT + IS_HHO_ATT_CPICH_RSCP_NRT + IS_HHO_ATT_CPICH_ECNO_NRT + IS_HHO_ATT_IM_IMS_NRT + IS_HHO_ATT_LB_CAPA_DL_NRT + IS_HHO_ATT_LB_CAPA_UL_NRT + IS_HHO_ATT_LB_PRX_TOT_NRT + IS_HHO_ATT_LB_PTX_TOT_NRT + IS_HHO_ATT_LB_RES_LIM_NRT + IS_HHO_ATT_LB_RSVR_SC_NRT + IS_HHO_ATT_SB_NRT + ATT_ISHO_CELL_SHUTDOWN_NRT + ATT_ISHO_CELL_BLOCK_NRT)) "3G_2G_HOSR_NRT",

(((NRT_DCH_UL_DATA_VOL + NRT_DCH_HSDPA_UL_DATA_VOL + RT_PS_DCH_UL_DATA_VOL)*8) / (1000*PERIOD_DURATION_RVOL*60)) UL_throughput_in_KbpS,

(((NRT_DCH_UL_DATA_VOL + NRT_DCH_HSDPA_UL_DATA_VOL + RT_PS_DCH_UL_DATA_VOL)*8) / (1000*PERIOD_DURATION_RVOL*60)) UL_throughput_in_KbpS,

Page 33: Dashboard Formula

(count(UL_BLER) <2(value)/count(UL_BLER))*100(count(DL_BLER) < 2(value)/count(DL_BLER))*100100-100*sum((PS_REL_RL_FAIL_HS_E_STRE +PS_REL_RL_FAIL_HS_E_INT +PS_REL_RL_FAIL_HS_E_BGR +PS_REL_RL_FAIL_HS_D_STRE +PS_REL_RL_FAIL_HS_D_INT +PS_REL_RL_FAIL_HS_D_BGR +PS_REL_OTH_FAIL_HS_E_STRE +PS_REL_OTH_FAIL_HS_E_INT +PS_REL_OTH_FAIL_HS_E_BGR +PS_REL_OTH_FAIL_HS_D_STRE +PS_REL_OTH_FAIL_HS_D_INT +PS_REL_OTH_FAIL_HS_D_BGR)) / sum((PS_REL_RL_FAIL_HS_E_STRE +PS_REL_RL_FAIL_HS_E_INT +PS_REL_RL_FAIL_HS_E_BGR +PS_REL_RL_FAIL_HS_D_STRE +PS_REL_RL_FAIL_HS_D_INT +PS_REL_RL_FAIL_HS_D_BGR +PS_REL_OTH_FAIL_HS_E_STRE +PS_REL_OTH_FAIL_HS_E_INT +PS_REL_OTH_FAIL_HS_E_BGR +PS_REL_OTH_FAIL_HS_D_STRE +PS_REL_OTH_FAIL_HS_D_INT +PS_REL_OTH_FAIL_HS_D_BGR +PS_REL_NORM_HS_E_STRE +PS_REL_NORM_HS_E_INT +PS_REL_NORM_HS_E_BGR +PS_REL_NORM_HS_D_STRE +PS_REL_NORM_HS_D_INT +PS_REL_NORM_HS_D_BGR +PS_SWI_HS_E_TO_D_D_STRE +PS_SWI_HS_E_TO_D_D_INT +PS_SWI_HS_E_TO_D_D_BGR +PS_SWI_HS_D_TO_D_D_STRE +PS_SWI_HS_D_TO_D_D_INT +PS_SWI_HS_D_TO_D_D_BGR)) RAB_Setup_Suc_Rate_HSDPA_DBH,

100-100* sum((PS_REL_RL_FAIL_HS_E_STRE +PS_REL_RL_FAIL_HS_E_INT +PS_REL_RL_FAIL_HS_E_BGR +PS_REL_OTH_FAIL_HS_E_STRE +PS_REL_OTH_FAIL_HS_E_INT +PS_REL_OTH_FAIL_HS_E_BGR)) / sum((PS_REL_RL_FAIL_HS_E_STRE +PS_REL_RL_FAIL_HS_E_INT +PS_REL_RL_FAIL_HS_E_BGR +PS_REL_OTH_FAIL_HS_E_STRE +PS_REL_OTH_FAIL_HS_E_INT +PS_REL_OTH_FAIL_HS_E_BGR +PS_REL_NORM_HS_E_STRE +PS_REL_NORM_HS_E_INT +PS_REL_NORM_HS_E_BGR +PS_SWI_HS_E_TO_D_D_STRE +PS_SWI_HS_E_TO_D_D_INT +PS_SWI_HS_E_TO_D_D_BGR)) RAB_Setup_suc_Rate_HSUPA_DBH,

Page 34: Dashboard Formula

rrc_conn_stp_att

(100-100* sum((RRC_CONN_ACT_REL_P_EMP +RRC_CONN_ACT_FAIL_IU +RRC_CONN_ACT_FAIL_RADIO +RRC_CONN_ACT_FAIL_BTS +RRC_CONN_ACT_FAIL_IUR +RRC_CONN_ACT_FAIL_RNC +RRC_CONN_ACT_FAIL_UE +RRC_CONN_ACT_FAIL_TRANS +RRC_CONN_ACT_FAIL_CIPH)) / sum((RRC_CONN_ACT_COMP +RRC_CONN_ACT_REL_SRNC +RRC_CONN_ACT_REL_GANHO +RRC_CONN_ACT_REL_HHO +RRC_CONN_ACT_REL_INTRA_HHO +RRC_CONN_ACT_REL_ISHO +RRC_CONN_ACT_REL_P_EMP +RRC_CONN_ACT_FAIL_IU +RRC_CONN_ACT_FAIL_RADIO +RRC_CONN_ACT_FAIL_BTS +RRC_CONN_ACT_FAIL_IUR +RRC_CONN_ACT_FAIL_RNC +RRC_CONN_ACT_FAIL_UE +RRC_CONN_ACT_FAIL_TRANS +RRC_CONN_ACT_FAIL_CIPH))) Serv_RRC_Setup_Suc_Rate_NBH