{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":174,"n_cols":8,"rows_kept":174,"cut":false,"hidden":false,"merged":[]}
["序号","colname","变量名","类型","中文名","解释","备注","汇聚算法"]
[1,"provice",{"$f":"\"a_\"&LOWER(B2)","v":"a_provice"},"varchar","省份",null,null,"provice,"]
[2,"sdate",{"$f":"\"a_\"&LOWER(B3)","v":"a_sdate"},"timestamp","分析时间","文本格式为：2022-04-12 15:00:00",null,"date_trunc('h',sdate),"]
[3,"eci","a_eci","varchar",",\"对象编号\"","格式：127.2244608.6",null,"eci,"]
[4,"cellname","a_cellname","varchar",",\"对象名称\"",null,null,"cellname,"]
[5,"freq","a_freq","varchar",",\"频段\"",null,null,"freq,"]
[6,"bandwidth","a_bandwidth","varchar",",\"带宽\"",null,null,"bandwidth,"]
[7,"vendor","a_vendor","varchar",",\"厂商名称\"",null,null,"vendor,"]
[8,"rrc_req","a_rrc_req","numeric",",\"RRC建立请求次数(次)\"",null,null,"sum(rrc_req),"]
[9,"rrc_suc","a_rrc_suc","numeric",",\"RRC建立成功次数(次)\"",null,null,"sum(rrc_suc),"]
[10,"rrc_congest","a_rrc_congest","numeric",",\"RRC连接建立拥塞次数(次)\"",null,null,"sum(rrc_congest),"]
[11,"rrc_suc_ratio","a_rrc_suc_ratio","numeric",",\"RRC建立成功率(%)\"",null,null,"case when sum(rrc_req)=0 then 0 else sum(rrc_suc)/sum(rrc_req) end,"]
[12,"ng_suc_ratio","a_ng_suc_ratio","numeric",",\"NG接口信令连接建立成功率\"",null,null,"case when sum(ng_req)=0 then 0 else sum(ng_suc)/sum(ng_req) end,"]
[13,"ng_suc","a_ng_suc","numeric",",\"NG接口信令连接建立成功次数\"",null,null,"sum(ng_suc),"]
[14,"ng_req","a_ng_req","numeric",",\"NG接口信令连接建立请求次数\"",null,null,"sum(ng_req),"]
[15,"radio_suc_ratio","a_radio_suc_ratio","numeric",",\"无线接入成功率\"","RRC连接建立成功率、NG接口信令连接成功率与初始QoS Flow建立成功率的乘积。",null,"(case when sum(rrc_req)=0 or sum(rrc_req) is null then avg(rrc_suc_ratio) else sum(rrc_suc)/sum(rrc_req) end)*(case when sum(ng_req)=0 or sum(ng_req) is null then avg(ng_suc_ratio) else sum(ng_suc)/sum(ng_req) end)*(case when sum(qosflow_init_req)=0 then avg(qosflow_init_suc_ratio) when sum(qosflow_init_req) is null then avg(qosflow_init_suc_ratio)  else sum(qosflow_init_suc)/sum(qosflow_init_req) end),"]
[16,"ng_suc_ratio_2","a_ng_suc_ratio_2","numeric",",\"NG接口信令连接建立成功率\"",null,null,"case when sum(ng_req_2)=0 then 0 else sum(ng_suc_2)/sum(ng_req_2) end,"]
[17,"ng_suc_2","a_ng_suc_2","numeric",",\"NG接口信令连接建立成功次数\"",null,null,"sum(ng_suc_2),"]
[18,"ng_req_2","a_ng_req_2","numeric",",\"NG接口信令连接建立请求次数\"",null,null,"sum(ng_req_2),"]
[19,"qosflow_suc_ratio","a_qosflow_suc_ratio","numeric",",\"QoSFlow建立成功率\"",null,null,"case when sum(qosflow_req)=0 then 0 else sum(qosflow_suc)/sum(qosflow_req) end,"]
[20,"qosflow_req","a_qosflow_req","numeric",",\"QoSFlow建立请求数\"",null,null,"sum(qosflow_req),"]
[21,"qosflow_suc","a_qosflow_suc","numeric",",\"QoSFlow建立成功数\"",null,null,"sum(qosflow_suc),"]
[22,"ue_context_rel_total","a_ue_context_rel_total","numeric",",\"UE上下文释放总次数\"",null,null,"sum(ue_context_rel_total),"]
[23,"ue_context_rel_abnormal","a_ue_context_rel_abnormal","numeric",",\"UE上下文异常释放次数\"",null,null,"sum(ue_context_rel_abnormal),"]
[24,"ue_context_drop_ratio","a_ue_context_drop_ratio","numeric",",\"UE上下文掉线率\"",null,null,"case when sum(ue_context_rel_total)=0 then 0 else sum(ue_context_rel_abnormal)/sum(ue_context_rel_total) end,"]
[25,"ul_tra_mb","a_ul_tra_mb","numeric",",\"空口上行流量\"",null,null,"sum(ul_tra_mb),"]
[26,"dl_tra_mb","a_dl_tra_mb","numeric",",\"空口下行流量\"",null,null,"sum(dl_tra_mb),"]
[27,"total_tra_mb","a_total_tra_mb","numeric",",\"空口总业务量(MByte)\"",null,null,"sum(total_tra_mb),"]
[28,"ul_speed_mbps","a_ul_speed_mbps","numeric",",\"用户上行平均吞吐率\"",null,null,"avg(ul_speed_mbps),"]
[29,"dl_speed_mbps","a_dl_speed_mbps","numeric",",\"用户下行平均吞吐率\"",null,null,"avg(dl_speed_mbps),"]
[30,"drop_duration","a_drop_duration","numeric",",\"小区退服时长\"",null,null,"sum(drop_duration),"]
[31,"cell_available_ratio","a_cell_available_ratio","numeric",",\"小区可用率\"",null,null,"avg(cell_available_ratio),"]
[32,"save_duration_zaipin","a_save_duration_zaipin","numeric",",\"节能态时长-载频关断\"",null,null,"sum(save_duration_zaipin),"]
[33,"save_duration_fuhao","a_save_duration_fuhao","numeric",",\"节能态时长-符号关断\"",null,null,"sum(save_duration_fuhao),"]
[34,"save_duration_tongdao","a_save_duration_tongdao","numeric",",\"节能态时长-通道关断\"",null,null,"sum(save_duration_tongdao),"]
[35,"txpower","a_txpower","numeric",",\"小区平均实际发射功率\"",null,null,"avg(txpower),"]
[36,"max_txpower","a_max_txpower","numeric",",\"小区最大实际发射功率\"",null,null,"avg(max_txpower),"]
[37,"cqi_table1_c","a_cqi_table1_c","numeric",",\"CQITable1表UE上报的CQI次数\"",null,null,"sum(cqi_table1_c),"]
[38,"cqi_table2_c","a_cqi_table2_c","numeric",",\"CQITable2表UE上报的CQI次数\"",null,null,"sum(cqi_table2_c),"]
[39,"cqi_table1_ge10","a_cqi_table1_ge10","numeric",",\"4-bitCQITable表下UE上报的CQI大于等于10的次数\"",null,null,"sum(cqi_table1_ge10),"]
[40,"cqi_table2_ge7","a_cqi_table2_ge7","numeric",",\"4-bitCQITable2表下UE上报的CQI大于等于7的次数\"",null,null,"sum(cqi_table2_ge7),"]
[41,"cqi_high_ratio","a_cqi_high_ratio","numeric",",\"CQI优良率\"",null,null,"case when sum(cqi_table1_c)+sum(cqi_table2_c)=0 then avg(cqi_high_ratio) when sum(cqi_table1_c)+sum(cqi_table2_c) is null then avg(cqi_high_ratio) else (sum(cqi_table1_ge10)+sum(cqi_table2_ge7))/( sum(cqi_table1_c)+sum(cqi_table2_c)) end,"]
[42,"ul_noise","a_ul_noise","numeric",",\"小区上行每PRB平均干扰电平\"",null,null,"avg(ul_noise),"]
[43,"ul_pdcp_package_total","a_ul_pdcp_package_total","numeric",",\"上行PDCP层用户面包总数\"",null,null,"sum(ul_pdcp_package_total),"]
[44,"ul_pdcp_package_drop","a_ul_pdcp_package_drop","numeric",",\"上行PDCP层用户面丢包数\"",null,null,"sum(ul_pdcp_package_drop),"]
[45,"ul_pdcp_package_drop_ratio","a_ul_pdcp_package_drop_ratio","numeric",",\"上行PDCP层用户面丢包率\"",null,null,"case when sum(ul_pdcp_package_total)=0 then 0 else sum(ul_pdcp_package_drop)/sum(ul_pdcp_package_total) end,"]
[46,"dl_pdcp_package_total","a_dl_pdcp_package_total","numeric",",\"下行PDCP层用户面包总数\"",null,null,"sum(dl_pdcp_package_total),"]
[47,"dl_pdcp_package_discard","a_dl_pdcp_package_discard","numeric",",\"下行PDCP层用户面弃包数\"",null,null,"sum(dl_pdcp_package_discard),"]
[48,"dl_pdcp_package_discard_ratio","a_dl_pdcp_package_discard_ratio","numeric",",\"下行PDCP层用户面弃包率\"",null,null,"case when sum(dl_pdcp_package_total)=0 then 0 else sum(dl_pdcp_package_discard)/sum(dl_pdcp_package_total) end,"]
[49,"dl_radio_resource_utilization","a_dl_radio_resource_utilization","numeric",",\"小区下行无线资源利用率\"",null,null,"avg(dl_radio_resource_utilization),"]
[50,"ul_radio_resource_utilization","a_ul_radio_resource_utilization","numeric",",\"小区上行无线资源利用率\"",null,null,"avg(ul_radio_resource_utilization),"]
[51,"dl_rlc_user_panle_trans_duration","a_dl_rlc_user_panle_trans_duration","numeric",",\"下行RLC层用户面数据发送总时长（不含最后一个slot）\"",null,null,"sum(dl_rlc_user_panle_trans_duration),"]
[52,"ul_prb_used","a_ul_prb_used","numeric",",\"小区上行PRB占用总数\"",null,null,"sum(ul_prb_used),"]
[53,"ul_prb_available","a_ul_prb_available","numeric",",\"小区上行PRB可用总数\"",null,null,"sum(ul_prb_available),"]
[54,"ul_prb_utilization","a_ul_prb_utilization","numeric",",\"小区上行PRB平均占用率\"",null,null,"case when sum(ul_prb_available)=0 then 0 else sum(ul_prb_used)/sum(ul_prb_available) end,"]
[55,"dl_prb_used","a_dl_prb_used","numeric",",\"小区下行PRB占用总数\"",null,null,"sum(dl_prb_used),"]
[56,"dl_prb_available","a_dl_prb_available","numeric",",\"小区下行PRB可用总数\"",null,null,"sum(dl_prb_available),"]
[57,"dl_prb_utilization","a_dl_prb_utilization","numeric",",\"小区下行PRB平均占用率\"",null,null,"case when sum(dl_prb_available)=0 then 0 else sum(dl_prb_used)/sum(dl_prb_available) end,"]
[58,"ul_pdcp_user_panle_tra","a_ul_pdcp_user_panle_tra","numeric",",\"上行PDCP层用户面流量\"",null,null,"sum(ul_pdcp_user_panle_tra),"]
[59,"dl_pdcp_user_panle_tra","a_dl_pdcp_user_panle_tra","numeric",",\"下行PDCP层用户面流量\"",null,null,"sum(dl_pdcp_user_panle_tra),"]
[60,"ul_rl_user_panle_tra","a_ul_rl_user_panle_tra","numeric",",\"上行RLC层用户面流量\"",null,null,"sum(ul_rl_user_panle_tra),"]
[61,"dl_rl_user_panle_tra","a_dl_rl_user_panle_tra","numeric",",\"下行RLC层用户面流量\"",null,null,"sum(dl_rl_user_panle_tra),"]
[62,"rrc_max","a_rrc_max","numeric",",\"RRC连接最大用户数\"",null,null,"max(rrc_max),"]
[63,"ul_pusch_prb_utilization","a_ul_pusch_prb_utilization","numeric",",\"上行PUSCH信道PRB平均利用率\"",null,null,"avg(ul_pusch_prb_utilization),"]
[64,"dl_pdsch_prb_utilization","a_dl_pdsch_prb_utilization","numeric",",\"下行PDSCH信道PRB平均利用率\"",null,null,"avg(dl_pdsch_prb_utilization),"]
[65,"rrc_avg","a_rrc_avg","numeric",",\"用户数均值\"",null,null,"avg(rrc_avg),"]
[66,"user_max",{"$f":"\"a_\"&LOWER(B67)","v":"a_user_max"},"numeric",",\"最大用户数\"",null,null,"max(user_max),"]
[67,"qosflow_init_req","a_qosflow_init_req","numeric","初始QoS Flow建立请求数",null,"2022-6-13新增","sum(qosflow_init_req),"]
[68,"qosflow_init_suc","a_qosflow_init_suc","numeric","初始QoS Flow建立成功数",null,"2022-6-13新增","sum(qosflow_init_suc),"]
[69,"qosflow_init_suc_ratio","a_qosflow_init_suc_ratio","numeric","初始QoS Flow建立成功率",null,"2022-6-13新增","case when sum(qosflow_init_req)=0 or sum(qosflow_init_req) is null then avg(qosflow_init_suc_ratio) else sum(qosflow_init_suc)/sum(qosflow_init_req) end,"]
[70,"total_duration","a_total_duration","numeric","小区统计时长(s)",null,"2022-6-13新增","sum(total_duration),"]
[71,"NbrRbUl","a_nbrrbul","numeric","上行占用PRB个数的总和","∑上行信道占用i层PRB数*i，小区上行无线资源利用率的分子","2022-6-13新增","sum(NbrRbUl),"]
[72,"ConfigLayerUl","a_configlayerul","numeric","小区上行配置层数",null,"2022-6-13新增","sum(ConfigLayerUl),"]
[73,"NbrRbDl","a_nbrrbdl","numeric","上行占用PRB个数的总和","∑上行信道占用i层PRB数*i，小区下行无线资源利用率的分子","2022-6-13新增","sum(NbrRbDl),"]
[74,"ConfigLayerDl","a_configlayerdl","numeric","小区下行配置层数",null,"2022-6-13新增","sum(ConfigLayerDl),"]
[75,"pusch_prb_used","a_pusch_prb_used","numeric","上行PUSCH PRB占用总数",null,"2022-6-13新增","sum(pusch_prb_used),"]
[76,"pdsch_prb_used","a_pdsch_prb_used","numeric","下行PDSCH PRB占用总数",null,"2022-6-13新增","sum(pdsch_prb_used),"]
[77,"GENBID",null,"numeric","基站ID","基站ID","2022-7-4新增","GENBID,"]
[78,"CI",null,"numeric","CI","CI","2022-7-4新增","CI,"]
[79,"GNB_WIRELESS_DROP_RATIO",null,"numeric","5G无线掉线率(%)","(CONTEXT_AttRelgNB-CONTEXT_AttRelgNB_Normal)/(CONTEXT_SuccInitalSetup+CONTEXT_NbrLeft+HO_SuccExecInc+RRC_SuccConnReestab_NonSrccell)","2022-7-4新增","case when sum(CONTEXT_SuccInitalSetup+CONTEXT_NbrLeft+HO_SuccExecInc+RRC_SuccConnReestab_NonSrccell)=0 then 0 else sum(CONTEXT_AttRelgNB-CONTEXT_AttRelgNB_Normal)/sum(CONTEXT_SuccInitalSetup+CONTEXT_NbrLeft+HO_SuccExecInc+RRC_SuccConnReestab_NonSrccell) end,"]
[80,"GNB_SW_SUCC_RATIO",null,"numeric","5G切换成功率(%)","(HO_SuccOutInterCuNG+HO_SuccOutInterCuXn+HO_SuccOutIntraCUInterDU+HO_SuccOutIntraDU)/(HO_AttOutInterCuNG+HO_AttOutInterCuXn+HO_AttOutIntraCUInterDU+HO_AttOutCUIntraDU)","2022-7-4新增","case when sum(HO_AttOutInterCuNG+HO_AttOutInterCuXn+HO_AttOutIntraCUInterDU+HO_AttOutCUIntraDU)=0 then 0 else sum(HO_SuccOutInterCuNG+HO_SuccOutInterCuXn+HO_SuccOutIntraCUInterDU+HO_SuccOutIntraDU)/sum(HO_AttOutInterCuNG+HO_AttOutInterCuXn+HO_AttOutIntraCUInterDU+HO_AttOutCUIntraDU) end,"]
[81,"KPI_PDCCHCCEOCCUPANCYRATE",null,"numeric","PDCCH信道CCE占用率","RRU_PdcchCceUtil/RRU_PdcchCceAvail*100","2022-7-4新增","case when sum(RRU_PdcchCceAvail)=0 then 0 else sum(RRU_PdcchCceUtil)/sum(RRU_PdcchCceAvail) end,"]
[82,"KPI_FLOWDROPRATE_CELLLEVEL",null,"numeric","Flow掉线率（小区级）","(Flow_NbrReqRelGnb -Flow_NbrReqRelGnb_Normal +Flow_HoAdmitFail) / ( Flow_NbrLeft +Flow_NbrSuccEstab +Flow_NbrHoInc ) *100%","2022-7-4新增","case when sum( Flow_NbrLeft +qosflow_suc +Flow_NbrHoInc )=0 then 0 else sum(Flow_NbrReqRelGnb -Flow_NbrReqRelGnb_Normal +Flow_HoAdmitFail) / sum( Flow_NbrLeft +qosflow_suc+Flow_NbrHoInc) end,"]
[83,"KPI_RRCCONNREESTABRATE",null,"numeric","RRC连接重建比率\n","RRC_AttConnReestab/（RRC_AttConnReestab+RRC_AttConnEstab）*100%","2022-7-4新增","case when sum(RRC_AttConnReestab+rrc_req)=0 then 0 else sum(RRC_AttConnReestab)/sum(RRC_AttConnReestab+rrc_req) end,"]
[84,"KPI_HOSUCCOUTINTERGNBRATE_NG",null,"numeric","gNB间NG切换成功率\n","HO_SuccOutInterCuNG/HO_AttOutInterCuNG*100%","2022-7-4新增","case when sum(HO_AttOutInterCuNG)=0 then 0 else sum(HO_SuccOutInterCuNG)/sum(HO_AttOutInterCuNG) end,"]
[85,"KPI_HOSUCCOUTINTERGNBRATE_XN",null,"numeric","gNB间Xn切换成功率\n","HO_SuccOutInterCuXn/HO_AttOutInterCuXn*100%","2022-7-4新增","case when sum(HO_AttOutInterCuXn)=0 then 0 else sum(HO_SuccOutInterCuXn)/sum(HO_AttOutInterCuXn) end,"]
[86,"KPI_HOSUCCOUTINTERGNBRATE",null,"numeric","gNB间切换成功率","(HO_SuccOutInterCuNG+HO_SuccOutInterCuXn)/(HO_AttOutInterCuNG+HO_AttOutInterCuXn ) *100%","2022-7-4新增","case when sum(HO_AttOutInterCuNG+HO_AttOutInterCuXn )=0 then 0 else sum(HO_SuccOutInterCuNG+HO_SuccOutInterCuXn)/sum(HO_AttOutInterCuNG+HO_AttOutInterCuXn ) end,"]
[87,"KPI_HOSUCCOUTINTRAGNBRATE",null,"numeric","gNB内切换成功率","(HO_SuccOutIntraCUInterDU+HO_SuccOutIntraDU）/（HO_AttOutIntraCUInterDU+HO_AttOutCUIntraDU）*100%","2022-7-4新增","case when sum(HO_AttOutIntraCUInterDU+HO_AttOutCUIntraDU)=0 then 0 else sum(HO_SuccOutIntraCUInterDU+HO_SuccOutIntraDU)/sum(HO_AttOutIntraCUInterDU+HO_AttOutCUIntraDU) end,"]
[88,"KPI_HOSUCCOUTRATE_INTRAFREQ",null,"numeric","同频切换执行成功率\r","HO_SuccOutIntraFreq\n/HO_AttOutExecIntraFreq*100%","2022-7-4新增","case when sum(HO_AttOutExecIntraFreq)=0 then 0 else sum(HO_SuccOutIntraFreq)/sum(HO_AttOutExecIntraFreq) end,"]
[89,"KPI_HOSUCCOUTRATE_INTERFREQ",null,"numeric","异频切换执行成功率\r","HO_SuccOutInterFreq/HO_AttOutExecInterFreq*100%","2022-7-4新增","case when sum(HO_AttOutExecInterFreq)=0 then 0 else sum(HO_SuccOutInterFreq)/sum(HO_AttOutExecInterFreq) end,"]
[90,"KPI_RLCNBRPKTLOSSRATEDL",null,"numeric","小区RLC层下行丢包率","RLC_NbrPktLossDl/RLC_NbrPktDl*100%","2022-7-4新增","case when sum(RLC_NbrPktDl)=0 then 0 else sum(RLC_NbrPktLossDl)/sum(RLC_NbrPktDl) end,"]
[91,"KPI_MACBLERUL",null,"numeric","MAC层上行误块率","MAC_NbrResErrTbUl/MAC_NbrInitTbUl*100%","2022-7-4新增","case when sum(MAC_NbrInitTbUl)=0 then 0 else  sum(MAC_NbrResErrTbUl)/sum(MAC_NbrInitTbUl) end,"]
[92,"KPI_MACBLERDL",null,"numeric","MAC层下行误块率","MAC_NbrResErrTbDl/MAC_NbrInitTbDl*100%","2022-7-4新增","case when sum(MAC_NbrInitTbDl)=0 then 0 else sum(MAC_NbrResErrTbDl)/sum(MAC_NbrInitTbDl) end,"]
[93,"KPI_HARQRETRANSRATEUL",null,"numeric","上行HARQ重传比率","（MAC_NbrTbUl-MAC_NbrInitTbUl）/MAC_NbrTbUl*100%","2022-7-4新增","case when sum(MAC_NbrTbUl)=0 then 0 else sum(MAC_NbrTbUl-MAC_NbrInitTbUl)/sum(MAC_NbrTbUl) end,"]
[94,"KPI_HARQRETRANSRATEDL",null,"numeric","下行HARQ重传比率","（MAC_NbrTbDl-MAC_NbrInitTbDl）/MAC_NbrTbDl*100%","2022-7-4新增","case when sum(MAC_NbrTbDl)=0 then 0 else sum(MAC_NbrTbDl-MAC_NbrInitTbDl)/sum(MAC_NbrTbDl) end,"]
[95,"KPI_RANK2PERCENTDL",null,"numeric","下行双流占比","（MAC_NbrTbDl_Rank2/MAC_NbrTbDl）*100%","2022-7-4新增","case when sum(MAC_NbrTbDl)=0 then 0 else sum(MAC_NbrTbDl_Rank2)/sum(MAC_NbrTbDl) end,"]
[96,"KPI_RANK3PERCENTDL",null,"numeric","下行3流占比","（MAC_NbrTbDl_Rank3/MAC_NbrTbDl）*100%","2022-7-4新增","case when  sum(MAC_NbrTbDl)=0 then 0 else sum(MAC_NbrTbDl_Rank3)/sum(MAC_NbrTbDl) end,"]
[97,"KPI_RANK4PERCENTDL",null,"numeric","下行4流占比","（MAC_NbrTbDl_Rank4/MAC_NbrTbDl）*100%","2022-7-4新增","case when sum(MAC_NbrTbDl)=0 then 0 else sum(MAC_NbrTbDl_Rank4)/sum(MAC_NbrTbDl) end,"]
[98,"KPI_QPSKPERCENTUL",null,"numeric","上行QPSK编码比例","MAC_NbrInitTbUl_Qpsk/MAC_NbrInitTbUl*100%","2022-7-4新增","case when sum(MAC_NbrInitTbUl)=0 then 0 else sum(MAC_NbrInitTbUl_Qpsk)/sum(MAC_NbrInitTbUl) end,"]
[99,"KPI_16QAMPERCENTUL",null,"numeric","上行16QAM编码比例","MAC_NbrInitTbUl_16Qam/MAC_NbrInitTbUl*100%","2022-7-4新增","case when sum(MAC_NbrInitTbUl)=0 then 0 else sum(MAC_NbrInitTbUl_16Qam)/sum(MAC_NbrInitTbUl) end,"]
[100,"KPI_64QAMPERCENTUL",null,"numeric","上行64QAM编码比例","MAC_NbrInitTbUl_64Qam/MAC_NbrInitTbUl*100%","2022-7-4新增","case when sum(MAC_NbrInitTbUl)=0 then 0 else sum(MAC_NbrInitTbUl_64Qam)/sum(MAC_NbrInitTbUl) end,"]
[101,"KPI_256QAMPERCENTUL",null,"numeric","上行256QAM编码比例","MAC_NbrInitTbUl_256Qam/MAC_NbrInitTbUl*100%","2022-7-4新增","case when sum(MAC_NbrInitTbUl)=0 then 0 else sum(MAC_NbrInitTbUl_256Qam)/sum(MAC_NbrInitTbUl) end,"]
[102,"KPI_QPSKPERCENTDL",null,"numeric","下行QPSK编码比例","MAC_NbrInitTbDl_Qpsk/MAC_NbrInitTbDl*100%","2022-7-4新增","case when sum(MAC_NbrInitTbDl)=0 then 0 else sum(MAC_NbrInitTbDl_Qpsk)/sum(MAC_NbrInitTbDl) end,"]
[103,"KPI_16QAMPERCENTDL",null,"numeric","下行16QAM编码比例","MAC_NbrInitTbDl_16Qam/MAC_NbrInitTbDl*100%","2022-7-4新增","case when sum(MAC_NbrInitTbDl)=0 then 0 else sum(MAC_NbrInitTbDl_16Qam)/sum(MAC_NbrInitTbDl) end,"]
[104,"KPI_64QAMPERCENTDL",null,"numeric","下行64QAM编码比例","MAC_NbrInitTbDl_64Qam/MAC_NbrInitTbDl*100%","2022-7-4新增","case when sum(MAC_NbrInitTbDl)=0 then 0 else sum(MAC_NbrInitTbDl_64Qam)/sum(MAC_NbrInitTbDl) end,"]
[105,"KPI_256QAMPERCENTDL",null,"numeric","下行256QAM编码比例","MAC_NbrInitTbDl_256Qam/MAC_NbrInitTbDl*100%","2022-7-4新增","case when sum(MAC_NbrInitTbDl)=0 then 0 else sum(MAC_NbrInitTbDl_256Qam)/sum(MAC_NbrInitTbDl) end,"]
[106,"KPI_AVGTHROUPERPRBUL",null,"numeric","上行每PRB平均吞吐量","MAC_CpOctUl*8/RRU_DtchPrbAssnUl","2022-7-4新增","case when sum(RRU_DtchPrbAssnUl)=0 then 0 else sum(MAC_CpOctUl*8)/sum(RRU_DtchPrbAssnUl) end,"]
[107,"KPI_AVGTHROUPERPRBDL",null,"numeric","下行每PRB平均吞吐量","MAC_CpOctDl*8/RRU_DtchPrbAssnDl","2022-7-4新增","case when sum(RRU_DtchPrbAssnDl)=0 then 0 else sum(MAC_CpOctDl*8)/sum(RRU_DtchPrbAssnDl) end,"]
[108,"KPI_AverageLayersUl",null,"numeric","上行MIMO平均配对层数","sum(MAC_NbrRbUlMassiveMimoSM_2*2 ___MAC_NbrRbUlMassiveMimoSM_n*n)/sum(MAC_NbrRbUlMassiveMimoSM_2___MAC_NbrRbUlMassiveMimoSM_n)","2022-7-4新增",{"$f":"\"avg(\"&B109&\"),\"","v":"avg(KPI_AverageLayersUl),"}]
[109,"KPI_AverageLayersDl",null,"numeric","下行MIMO平均配对层数","sum(MAC_NbrRbDlMassiveMimoSM_2*2 ___MAC_NbrRbDlMassiveMimoSM_n*n)/sum(MAC_NbrRbDlMassiveMimoSM_2 ___MAC_NbrRbDlMassiveMimoSM_n)","2022-7-4新增",{"$f":"\"avg(\"&B110&\"),\"","v":"avg(KPI_AverageLayersDl),"}]
[110,"KPI_MUPairPrbRateUl",null,"numeric","上行MIMO配对PRB占比","sum(MAC_NbrRbUlMassiveMimoSM_2+___+MAC_NbrRbUlMassiveMimoSM_n)/sum(MAC_NbrRbUlMassiveMimoSM_1___MAC_NbrRbUlMassiveMimoSM_n)*100%","2022-7-4新增","avg(KPI_MUPairPrbRateUl),"]
[111,"KPI_MUPairPrbRateDl",null,"numeric","下行MIMO配对PRB占比","sum(MAC_NbrRbDlMassiveMimoSM_2+___+MAC_NbrRbDlMassiveMimoSM_n)/sum(MAC_NbrRbDlMassiveMimoSM_1+___+MAC_NbrRbDlMassiveMimoSM_n)*100%","2022-7-4新增","avg(KPI_MUPairPrbRateDl),"]
[112,"CONTEXT_AttInitalSetup",null,"numeric","初始上下文建立请求次数","CONTEXT_AttInitalSetup","2022-7-4新增","sum(CONTEXT_AttInitalSetup),"]
[113,"CONTEXT_SuccInitalSetup",null,"numeric","初始上下文建立成功次数","CONTEXT_SuccInitalSetup","2022-7-4新增","sum(CONTEXT_SuccInitalSetup),"]
[114,"CONTEXT_FailInitalSetup",null,"numeric","初始上下文建立失败次数","CONTEXT_FailInitalSetup","2022-7-4新增","sum(CONTEXT_FailInitalSetup),"]
[115,"CONTEXT_AttRelgNB",null,"numeric","gNB请求释放上下文数","CONTEXT_AttRelgNB","2022-7-4新增","sum(CONTEXT_AttRelgNB),"]
[116,"CONTEXT_AttRelgNB_Normal",null,"numeric","正常的gNB请求释放上下文数","CONTEXT_AttRelgNB_Normal","2022-7-4新增","sum(CONTEXT_AttRelgNB_Normal),"]
[117,"CONTEXT_NbrLeft",null,"numeric","遗留上下文个数","CONTEXT_NbrLeft","2022-7-4新增","sum(CONTEXT_NbrLeft),"]
[118,"HO_SuccExecInc",null,"numeric","切换入成功次数","HO_SuccExecInc","2022-7-4新增","sum(HO_SuccExecInc),"]
[119,"RRC_SuccConnReestab_NonSrccell",null,"numeric","RRC连接重建成功次数(非源侧小区)","RRC_SuccConnReestab_NonSrccell","2022-7-4新增","sum(RRC_SuccConnReestab_NonSrccell),"]
[120,"HO_SuccOutInterCuNG",null,"numeric","gNB间NG切换出成功次数","HO_SuccOutInterCuNG","2022-7-4新增","sum(HO_SuccOutInterCuNG),"]
[121,"HO_SuccOutInterCuXn",null,"numeric","gNB间Xn切换出成功次数","HO_SuccOutInterCuXn","2022-7-4新增","sum(HO_SuccOutInterCuXn),"]
[122,"HO_SuccOutIntraCUInterDU",null,"numeric","CU内DU间切换出执行成功次数","HO_SuccOutIntraCUInterDU","2022-7-4新增","sum(HO_SuccOutIntraCUInterDU),"]
[123,"HO_SuccOutIntraDU",null,"numeric","CU内DU内切换出成功次数","HO_SuccOutIntraDU","2022-7-4新增","sum(HO_SuccOutIntraDU),"]
[124,"HO_AttOutInterCuNG",null,"numeric","gNB间NG切换出准备请求次数","HO_AttOutInterCuNG","2022-7-4新增","sum(HO_AttOutInterCuNG),"]
[125,"HO_AttOutInterCuXn",null,"numeric","gNB间Xn切换出准备请求次数","HO_AttOutInterCuXn","2022-7-4新增","sum(HO_AttOutInterCuXn),"]
[126,"HO_AttOutIntraCUInterDU",null,"numeric","CU内DU间切换出执行请求次数","HO_AttOutIntraCUInterDU","2022-7-4新增","sum(HO_AttOutIntraCUInterDU),"]
[127,"HO_AttOutCUIntraDU",null,"numeric","CU内DU内切换出执行请求次数","HO_AttOutCUIntraDU","2022-7-4新增","sum(HO_AttOutCUIntraDU),"]
[128,"RRU_PuschPrbAssn",null,"numeric","上行PUSCH PRB占用数","RRU_PuschPrbAssn","2022-7-4新增","sum(RRU_PuschPrbAssn),"]
[129,"RRU_PuschPrbTot",null,"numeric","上行PUSCH PRB可用数","RRU_PuschPrbTot","2022-7-4新增","sum(RRU_PuschPrbTot),"]
[130,"RRU_PdschPrbAssn",null,"numeric","下行PDSCH PRB占用数","RRU_PdschPrbAssn","2022-7-4新增","sum(RRU_PdschPrbAssn),"]
[131,"RRU_PdcchCceUtil",null,"numeric","PDCCH信道CCE占用个数","RRU_PdcchCceUtil","2022-7-4新增","sum(RRU_PdcchCceUtil),"]
[132,"RRU_PdcchCceAvail",null,"numeric","PDCCH信道CCE可用个数","RRU_PdcchCceAvail","2022-7-4新增","sum(RRU_PdcchCceAvail),"]
[133,"Flow_NbrReqRelGnb",null,"numeric","gNB请求释放的Flow数","Flow_NbrReqRelGnb","2022-7-4新增","sum(Flow_NbrReqRelGnb),"]
[134,"Flow_NbrReqRelGnb_Normal",null,"numeric","正常的gNB请求释放的Flow数","Flow_NbrReqRelGnb_Normal","2022-7-4新增","sum(Flow_NbrReqRelGnb_Normal),"]
[135,"Flow_HoAdmitFail",null,"numeric","切出接纳失败的Flow数","Flow_HoAdmitFail","2022-7-4新增","sum(Flow_HoAdmitFail),"]
[136,"Flow_NbrLeft",null,"numeric","遗留Flow个数","Flow_NbrLeft","2022-7-4新增","sum(Flow_NbrLeft),"]
[137,"Flow_NbrHoInc",null,"numeric","切换入Flow数","Flow_NbrHoInc","2022-7-4新增","sum(Flow_NbrHoInc),"]
[138,"RRC_AttConnReestab",null,"numeric","RRC连接重建请求次数","RRC_AttConnReestab","2022-7-4新增","sum(RRC_AttConnReestab),"]
[139,"HO_SuccOutIntraFreq",null,"numeric","同频切换出成功次数","HO_SuccOutIntraFreq","2022-7-4新增","sum(HO_SuccOutIntraFreq),"]
[140,"HO_AttOutExecIntraFreq",null,"numeric","同频切换出执行请求次数","HO_AttOutExecIntraFreq","2022-7-4新增","sum(HO_AttOutExecIntraFreq),"]
[141,"HO_SuccOutInterFreq",null,"numeric","异频切换出成功次数","HO_SuccOutInterFreq","2022-7-4新增","sum(HO_SuccOutInterFreq),"]
[142,"HO_AttOutExecInterFreq",null,"numeric","异频切换出执行请求次数","HO_AttOutExecInterFreq","2022-7-4新增","sum(HO_AttOutExecInterFreq),"]
[143,"RLC_NbrPktLossDl",null,"numeric","小区下行RLC SDU丢包数","RLC_NbrPktLossDl","2022-7-4新增","sum(RLC_NbrPktLossDl),"]
[144,"RLC_NbrPktDl",null,"numeric","小区下行RLC SDU发送包数","RLC_NbrPktDl","2022-7-4新增","sum(RLC_NbrPktDl),"]
[145,"MAC_NbrResErrTbUl",null,"numeric","上行残留错误TB数","MAC_NbrResErrTbUl","2022-7-4新增","sum(MAC_NbrResErrTbUl),"]
[146,"MAC_NbrInitTbUl",null,"numeric","上行传输初始TB数","MAC_NbrInitTbUl","2022-7-4新增","sum(MAC_NbrInitTbUl),"]
[147,"MAC_NbrTbUl",null,"numeric","上行传输TB数","MAC_NbrTbUl","2022-7-4新增","sum(MAC_NbrTbUl),"]
[148,"MAC_NbrResErrTbDl",null,"numeric","下行残留错误TB数","MAC_NbrResErrTbDl","2022-7-4新增","sum(MAC_NbrResErrTbDl),"]
[149,"MAC_NbrTbDl",null,"numeric","下行传输TB数","MAC_NbrTbDl","2022-7-4新增","sum(MAC_NbrTbDl),"]
[150,"MAC_NbrInitTbDl",null,"numeric","下行传输初始TB数","MAC_NbrInitTbDl","2022-7-4新增","sum(MAC_NbrInitTbDl),"]
[151,"MAC_NbrTbDl_Rank2",null,"numeric","双流下行传输TB数","MAC_NbrTbDl_Rank2","2022-7-4新增","sum(MAC_NbrTbDl_Rank2),"]
[152,"MAC_NbrTbDl_Rank3",null,"numeric","3流下行传输TB数","MAC_NbrTbDl_Rank3","2022-7-4新增","sum(MAC_NbrTbDl_Rank3),"]
[153,"MAC_NbrTbDl_Rank4",null,"numeric","4流下行传输TB数","MAC_NbrTbDl_Rank4","2022-7-4新增","sum(MAC_NbrTbDl_Rank4),"]
[154,"MAC_NbrInitTbUl_Qpsk",null,"numeric","QPSK模式上行传输初始TB数","MAC_NbrInitTbUl_Qpsk","2022-7-4新增","sum(MAC_NbrInitTbUl_Qpsk),"]
[155,"MAC_NbrInitTbUl_16Qam",null,"numeric","16QAM模式上行传输初始TB数","MAC_NbrInitTbUl_16Qam","2022-7-4新增","sum(MAC_NbrInitTbUl_16Qam),"]
[156,"MAC_NbrInitTbUl_64Qam",null,"numeric","64QAM模式上行传输初始TB数","MAC_NbrInitTbUl_64Qam","2022-7-4新增","sum(MAC_NbrInitTbUl_64Qam),"]
[157,"MAC_NbrInitTbUl_256Qam",null,"numeric","256QAM模式上行传输初始TB数","MAC_NbrInitTbUl_256Qam","2022-7-4新增","sum(MAC_NbrInitTbUl_256Qam),"]
[158,"MAC_NbrInitTbDl_Qpsk",null,"numeric","QPSK模式下行传输初始TB数","MAC_NbrInitTbDl_Qpsk","2022-7-4新增","sum(MAC_NbrInitTbDl_Qpsk),"]
[159,"MAC_NbrInitTbDl_16Qam",null,"numeric","16QAM模式下行传输初始TB数","MAC_NbrInitTbDl_16Qam","2022-7-4新增","sum(MAC_NbrInitTbDl_16Qam),"]
[160,"MAC_NbrInitTbDl_64Qam",null,"numeric","64QAM模式下行传输初始TB数","MAC_NbrInitTbDl_64Qam","2022-7-4新增","sum(MAC_NbrInitTbDl_64Qam),"]
[161,"MAC_NbrInitTbDl_256Qam",null,"numeric","256QAM模式下行传输初始TB数","MAC_NbrInitTbDl_256Qam","2022-7-4新增","sum(MAC_NbrInitTbDl_256Qam),"]
[162,"RRU_DtchPrbAssnUl",null,"numeric","上行业务信道占用PRB数","RRU_DtchPrbAssnUl","2022-7-4新增","sum(RRU_DtchPrbAssnUl),"]
[163,"RRU_DtchPrbAssnDl",null,"numeric","下行业务信道占用PRB数","RRU_DtchPrbAssnDl","2022-7-4新增","sum(RRU_DtchPrbAssnDl),"]
[164,"RRU_PdschPrbTot",null,"numeric","下行PDSCH PRB可用数","RRU_PdschPrbTot","2022-7-4新增","sum(RRU_PdschPrbTot),"]
[165,"MAC_CpOctUl",null,"numeric","小区MAC层传输成功的上行流量","MAC_CpOctUl","2022-7-4新增","sum(MAC_CpOctUl),"]
[166,"MAC_CpOctDl",null,"numeric","小区MAC层传输成功的下行流量","MAC_CpOctDl","2022-7-4新增","sum(MAC_CpOctDl),"]
[167,"PHY_ULMaxNL_PRB",null,"numeric","小区RB上行最大干扰电平","PHY_ULMaxNL_PRB","2022-7-4新增","sum(PHY_ULMaxNL_PRB),"]
[168,"RRC_RedirectToLTE",null,"numeric","RRC 重定向到LTE次数","RRC_RedirectToLTE","2022-7-4新增","sum(RRC_RedirectToLTE),"]
[169,"RRC_RedirectToLTE_EpsFB",null,"numeric","EPS fallback RRC 重定向到LTE次数","RRC_RedirectToLTE_EpsFB","2022-7-4新增","sum(RRC_RedirectToLTE_EpsFB),"]
[170,"RRC_SAnNsaConnUserMean",null,"numeric","小区平均用户数","RRC_SAnNsaConnUserMean","2022-7-4新增","avg(RRC_SAnNsaConnUserMean),"]
[171,"HoPrepAttOutEutran",null,"numeric","NR切换LTE请求次数（数据触发）","统计时间段内，源gNodeB向AMF发送HANDOVER REQUIRED消息且包含的Handover Type信元取值为5GStoEPS时（38.413），且由于数据原因触发切换时统计此指标。","2022-7-18新增","sum(HoPrepAttOutEutran),"]
[172,"HoExeSuccOutEutran",null,"numeric","NR切换LTE成功次数（数据触发）","统计时间段内，源gNB接收到AMF发送的UE CONTEXT RELEASE COMMAND消息且携带原因值为Successful Handover，指示系统间（GUTRAN->EUTRAN）切换执行成功时，且由于数据原因触发切换时统计此指标。","2022-7-18新增","sum(HoExeSuccOutEutran),"]
[173,"RwrEutranUeSucc",null,"numeric","5G重定向到4G的总次数（数据触发）","5G网络触发异系统重定向过程中，由于数据原因触发，当NR基站向UE发送“RRC Release”消息且重定向目标为4G系统时统计。","2022-7-18新增","sum(RwrEutranUeSucc),"]