【资料名称】：NSN CELL BSC SQL

【资料作者】：--

【资料日期】：--

【资料语言】：中文

【资料格式】：DOC

【资料目录和简介】：

---------------------小区级小时级指标 ----------------

select 地市,START_TIME,BSC_NAME,a.cell_id,a.BCF,bcf_type,SEG_ID,SEG_NAME
,round(tch_traffic,2) TCH话务量
,round(decode(avail_ftch_nbr,0,0,tch_traffic/avail_ftch_nbr),2) 每线话务量
,tch_drop_call"2071掉话次数"
,tch_call_req_nhoTCH请求次数
,tch_seize_nhoTCH占用次数
,f_tch_ass_nhoTCH失败次数
,att_tch_ovrfl_nhoTCH溢出次数
,att_tch_ovrfl"TCH溢出次数(含切)"
,round(decode(tch_call_req_nho,0,0,100*att_tch_ovrfl_nho/tch_call_req_nho),2) TCH拥塞率
,round(decode(tch_seize,0,0,100*tch_drop_call/tch_seize),2)"TCH掉话率(含切)"
,round(decode(tch_seize_nho,0,0,100*tch_drop_call/tch_seize_nho),2) "TCH掉话率(不含切)"
,drop_call_sdcchSD掉话次数
,T3101T3101超时
,round(decode((sdcch_seiz-SDCCH_ACT_FAIL_CALL),0,0,100*drop_call_sdcch/(sdcch_seiz-SDCCH_ACT_FAIL_CALL)),2) SD掉话率
,att_sdcch_seizSD请求次数
,sdcch_seizSD占用次数
,sdcch_failSD失败次数
,SDCCH_UNSUCC_IMM_ASSIGN_ATTSD溢出次数
,round(decode(att_sdcch_seiz,0,0,100*SDCCH_UNSUCC_IMM_ASSIGN_ATT/att_sdcch_seiz),2) SD拥塞率
,LU_ATT位置更新请求
,LU_FAIL位置更新失败
,round(decode(att_sdcch_seiz*tch_call_req_nho,0,0,100*tch_seize_nho*sdcch_seiz/(att_sdcch_seiz*tch_call_req_nho)),2) 无线接入性
,round(decode(ho_req,0,0,100*s_ho/ho_re