2G Npi Kpi

Period start time BSC Name Segment Name SEGMENT TCH_AVAILABILITY
K001
12.23.2014 BSCN_FBT ALILAULUWATU 141 99.70
12.23.2014 BSCN_FBT ALILAULUWATU 142 99.70
Total TCH Traffic BH TCH Traffic BH SDCCH Traffic Average SDCCH traffic
K002 K003 K004 K005
20.45 0.85 4.00 0.10
72.96 3.04 49.00 0.70
EDGE Payload Total (Mbyte) DL EDGE Payload (Mbyte) UL EDGE Payload (Mbyte)
K006 K007 K008
85.32 73.27 12.06
603.54 479.85 123.69
GPRS Payload Total (Mbyte) DL GPRS Payload (Mbyte) UL GPRS Payload (Mbyte) CSSR
K009 K010 K011 K012
4.34 3.62 0.72 99.41
10.84 8.15 2.69 99.69
IM ASS_NUM IM ASS_DEN SDCCH ACC_NUMSDCCH ACC_DENTCH ASSIGN_NUMTCH ASSIGN_DEN
K082 K083 K084 K085 K086 K087
2,556.00 2,556.00 15.00 2,555.00 411.00 411.00
15,504.00 15,508.00 44.00 15,504.00 5,111.00 5,111.00
SDCCH Blocking SDCCH BLOCK_NUMSDCCH BLOCK_DENSDCCH congest time
K013 K014 K015 cngt_2
0.00 0 2,555 0.00
0.03 4 15,508 0.00
SDCCH Success Rate SDCCH Drop Rate SDSR_NUMSDSR_DEN SDSR_T3(%) SDSR_T3_NUM
K016 K018 K019 K020 K111 K113
99.26 0.74 2,536 2,555 96.79 2,473.00
99.57 0.41 15,441 15,508 98.38 15,257.00
SDSR_T3_DENSDCCH DROP_NUMTCH Blocking TCH BLOCK_NUMTCH BLOCK_DEN
K114 K021 K022 K023 K024
2,555.00 19 0.00 0 413
15,508.00 63 0.00 0 5,124
TCH_Congestion TCH Assignment Success CCSR CCSR_NUMCCSR_DENTCH Drop Rate
K025 K026 K088 K124 K125 K027
0.00 99.33 99.51 409.00 411.00 0.34
0.00 99.84 99.82 5,102.00 5,111.00 0.17
TCH DROP_NUMTCH DROP_DENDROP_AFTER_TCH_ASSIGN
DL_Quality UL_Quality
K028 K029 K030 K031 K032
2.00 584.00 2 99.16 99.20
9.00 5,438.00 9 99.32 99.46
UL_Interference Handover Success Rate HOSR_NUMHOSR_DEN
K033 K034 K035 K036
1 98.70 455 461
1 94.81 5,662 5,972
Downlink multislot allocation blocking TBF EST Success TBF EST_NUM TBF EST_DEN
K037 K103 K104 K105
0.00 99.98 8.00 32,255.00
0.00 99.99 34.00 274,430.00
TBF DL EST Success TBF DL EST_NUM TBF DL EST_DEN TBF UL EST Success
K038 K039 K040 K041
100.00 0 7,506 99.97
100.00 0 70,806 99.98
TBF UL EST_NUM TBF UL EST_DEN TBF Completion Rate TBF COMPLETION_NUM
K042 K043 K100 K101
8 24,749 99.15 27,156.00
34 203,624 99.27 227,266.00
TBF COMPLETION_DENDL EDGE Throughput (kbps) GPRS DL Throughput (kbps)
K102 K044 K045
27,388.00 70.14 19.21
228,929.00 61.33 18.39
DL EDGE Throughput_MCS1-6 (kbps) DL EDGE Throughput_MCS7-9 (kbps) AVE_AVAIL_TCH_TSL
K046 K047 K048
21.00 55.00 15
22.10 54.82 17
AVE_DUR_DL_TBFAVE_DUR_DL_TBF_SUM AVE_DUR_UL_TBF_DEN (C72004)
K049 K050 AVE_DUR_UL_TBF_DEN
5,126.00 1,878,943.00 22,225
49,846.00 15,413,886.00 178,007
AVE_DUR_UL_TBF_SUM (C72003)AVE_GPRS_CHANNELS_tslave_avail_tch_den (C2060)
AVE_DUR_UL_TBF_SUM nsn_tinem14 AVE_AVAIL_TCH_DEN
875,374 8 4,317
6,406,273 10 4,317
ave_avail_tch_sum (C2059) ave_busy_tch (C2027) ave_gprs_channels_den (C2062)
AVE_AVAIL_TCH_SUM AVE_BUSY_TCH AVE_GPRS_CHANNELS_DEN
64,548 3,651 4,317
71,399 13,107 4,317
ave_gprs_channels_sum (C2061) ave_non_avail_tch_timeslot (C2069)
AVE_GPRS_CHANNELS_SUM AVE_NON_AVAIL_TCH_TIMESLOT
34,444 299
44,809 351
non_avail_tch_denom (C2070) SDCCH_RADIO_FAILSDCCH_RF_OLD_HO SDCCH_ABIS_FAIL_CALL
NON_AVAIL_TCH_DENOM K051 K052 K053
4,317 0.59 0.00 2.54
4,317 0.28 0.00 1.27
SDCCH_ABIS_FAIL_OLDSDCCH_A_IF_FAIL_CALL SDCCH_A_IF_FAIL_OLD SDCCH_BTS_FAIL
K054 K055 K056 K057
0.00 0.08 0.00 0.00
0.00 0.04 0.00 0.00
SDCCH_BCSU_RESETSDCCH_LAPD_FAIL SDCCH_NETW_ACTSDCCH_USER_ACTSDCCH_SEIZ_ATT
K058 K059 K060 K061 K062
0.00 0.00 0.00 0.00 2,555.00
0.00 0.00 0.00 0.00 15,508.00
SDCCH_HO_SEIZSDCCH_BUSY_ATTT3101_EXPIRED TCH_REQUESTS_CALL_ATTEMPT (C1192)
K063 K064 K066 TCH_REQUESTS_CALL_ATTEMPT
0.00 0.00 63.00 413
0.00 4.00 184.00 5,124
TCH MOC (c3024) TCH MTC (c3023) DELETE PAGING COMMAND (c3038)
TCH_MOC TCH_MTC DELETE_PAGING_COMMAND
0 0 0
0 0 94
CELL_SDCCH_TCH (C4074) CELL_SDCCH_TCH_AT (C4077) CELL_TCH_TCH (C4073)
CELL_SDCCH_TCH CELL_SDCCH_TCH_AT CELL_TCH_TCH
0 0 135
0 0 642
CELL_TCH_TCH_AT (C4076) TCH_CALL_REQTCH NEW CALL ASSIGN (c57033)
CELL_TCH_TCH_AT TCH_CALL_REQTCH_NEW_CALL_ASSIGN
136 413 411
642 5,124 5,111
TCH_NORM_SEIZ (C1009) TCH RE EST ASSIGN (c57032) TCH_RADIO_FAIL TCH_RF_OLD_HO
TCH_NORM_SEIZ TCH_RE_EST_ASSIGN K076 K077
413 0 1.21 0.24
5,124 0 0.21 0.06
TCH_ABIS_FAIL_CALL TCH_ABIS_FAIL_OLD TCH_A_IF_FAIL_CALL TCH_TR_FAIL
K067 K068 K070 K078
0.24 0.00 0.00 0.00
0.06 0.00 0.00 0.00
TCH_A_IF_FAIL_OLD TCH_ACT_FAIL_CALL TCH_BCSU_RESETTCH_BTS_FAIL TCH_LAPD_FAIL
K071 K069 K072 K073 K074
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.02
TCH_NETW_ACTTCH_TR_FAIL_OLD TCH_USER_ACTHO Attempt BSC_I_SUCC_HO (C4010)
K075 K079 K080 K081 BSC_I_SUCC_HO
0.00 0.00 0.00 461 628
0.00 0.00 0.00 5,972 5,985
BSC_I_TCH_TCH (C4056) BSC_O_HO_CMD_ASSGN (C1196)BSC_O_SUCC_HO (C4014)
BSC_I_TCH_TCH BSC_O_HO_CMD_ASSGN BSC_O_SUCC_HO
628 460 454
5,985 5,969 5,659
BSC_O_TCH_TCH (C4064) MSC_CONTROLLED_IN_HO (C4101)MSC_I_SUCC_HO (C4000)
BSC_O_TCH_TCH MSC_CONTROLLED_IN_HO MSC_I_SUCC_HO
454 0 0
5,659 0 4
MSC_I_TCH_TCH (C4043) MSC_O_HO_CMD (C1195)MSC_O_SUCC_HO (C4004)
MSC_I_TCH_TCH MSC_O_HO_CMD MSC_O_SUCC_HO
0 1 1
4 3 3
MSC_O_TCH_TCH (C4049)NBR_OF_DL_TBF (C72005) NBR_OF_UL_TBF (C72000)
MSC_O_TCH_TCH NBR_OF_DL_TBF NBR_OF_UL_TBF
1 5,504 22,650
3 51,834 181,639
NO_RADIO_RES_AVAIL_FOR_DL_TBF (C72124)NO_RADIO_RES_AVAIL_FOR_UL_TBF (C72123)
NO_RADIO_RES_AVAIL_FOR_DL_TBF NO_RADIO_RES_AVAIL_FOR_UL_TBF
0 0
0 0
REQ_1_TSL_DL (C72039) REQ_1_TSL_UL (C72034) REQ_2_TSL_DL (C72040)
REQ_1_TSL_DL REQ_1_TSL_UL REQ_2_TSL_DL
4,739 23,587 102
43,510 194,929 1,128
REQ_2_TSL_UL (C72035) REQ_3_TSL_DL (C72041) REQ_3_TSL_UL (C72036)
REQ_2_TSL_UL REQ_3_TSL_DL REQ_3_TSL_UL
206 60 25
3,186 777 172
REQ_4_TSL_DL (C72042) REQ_4_TSL_UL (C72037) REQ_5_TSL_DL (C72129)
REQ_4_TSL_DL REQ_4_TSL_UL REQ_5_TSL_DL
2,335 931 270
19,090 5,337 6,301
REQ_6_TSL_DL (C72130) REQ_7_TSL_DL (C72131) REQ_8_TSL_DL (C72132)
REQ_6_TSL_DL REQ_7_TSL_DL REQ_8_TSL_DL
0 0 0
0 0 0
DL_EGPRS_TBF_REL_DUE_NO_RESP (C72095)
DL RLC BLOCKS IN ACK MODE (c79000)
DL_EGPRS_TBF_REL_DUE_NO_RESP DL_RLC_BLOCKS_IN_ACK_MODE
7 734,419
28 4,627,494
DL RLC BLOCKS IN UNACK MODE (c79001) DL_TBF_ESTABLISHMENT_FAILED (C72093)
DL_RLC_BLOCKS_IN_UNACK_MODE DL_TBF_ESTABLISHMENT_FAILED
257 0
12 0
DL_TBF_REL_DUE_CSW_TRAFFIC (C72055)
DL_TBF_REL_DUE_NO_RESP_MS (C72057)
DL_TBF_REL_DUE_CSW_TRAFFIC DL_TBF_REL_DUE_NO_RESP_MS
0 164
6 1,026
DL_TBF_REL_DUE_TO_FLUSH (C72059)DL_TBF_REL_DUE_TO_SUSPEND (C72061)
DL_TBF_REL_DUE_TO_FLUSH DL_TBF_REL_DUE_TO_SUSPEND
134 6
410 37
DL_TBF_RELEASES_DUE_DTM (C72202)
DTM_DURATION_SUM_FR (C105011)
DL_TBF_RELEASES_DUE_DTM DTM_DURATION_SUM_FR
9 53,133
13 35,016
DTM_DURATION_SUM_HR (C105012)UL_EGPRS_TBF_REL_DUE_NO_RESP (C72094)
DTM_DURATION_SUM_HR UL_EGPRS_TBF_REL_DUE_NO_RESP
0 226
0 2,244
UL RLC BLOCKS IN ACK MODE (c79002) UL RLC BLOCKS IN UNACK MODE (c79003)
UL_RLC_BLOCKS_IN_ACK_MODE UL_RLC_BLOCKS_IN_UNACK_MODE
231,753 393
1,522,906 11
UL_TBF_ESTABLISHMENT_FAILED (C72092)UL_TBF_REL_DUE_CSW_TRAFFIC (C72054)
UL_TBF_ESTABLISHMENT_FAILED UL_TBF_REL_DUE_CSW_TRAFFIC
8 0
34 7
UL_TBF_REL_DUE_NO_RESP_MS (C72056)
UL_TBF_REL_DUE_TO_FLUSH (C72058)
UL_TBF_REL_DUE_NO_RESP_MS UL_TBF_REL_DUE_TO_FLUSH
68 67
624 148
UL_TBF_REL_DUE_TO_SUSPEND (C72060)
UL_TBF_RELEASES_DUE_DTM (C72201)
UL_TBF_REL_DUE_TO_SUSPEND UL_TBF_RELEASES_DUE_DTM
3 6
11 6
res_av_denom4 (C2007) TCH Avail_NUM TCH Avail_DEN ALLOC DL_NUMALLOC DL_DEN
RES_AV_DENOM4 K115 K116 K117 K118
4,317 22.93 23.00 14,925.00 7,239.00
4,317 26.92 27.00 127,360.00 64,589.00
GPRS DL COM_NUMGPRS DL COM_DENEDGE DL COM_NUMEDGE DL COM_DENTCH Traffic NPI
K119 K120 K121 K122 K126
14,615.54 1,568.62 307,296.64 9,032.58 20.28
117,916.56 12,641.60 2,012,647.33 64,709.69 72.82
Report Title
NOP Report Release Version
RS Report Release Version
Report ID
Report Description
Start Time
End Time
Objects
Object Aggregation Level
Time Aggregation Level
Threshold
Sorting
Data Source
Advanced Filter
KPI ID
K001
K002
K003
K004
K005
K006
K007
K008
K009
K010
K011
K012
K082
K083
K084
K085
K086
K087
K013
K014
K015
cngt_2
K016
K018
K019
K020
K111
K113
K114
K021
K022
K023
K024
K025
K026
K088
2G_NPI_KPI
none
none
custom/customizedReports/mixed/reports/2G_NPI_KPI.xml
2G_NPI_KPI
12.23.2014 00:00:00
12.24.2014 00:00:00
Level: BCF; ALILAULUWATUMG (5000000366116)
PLMN/BSC/SEGMENT
day
none
none
pmrPool
none
KPI Alias KPI Title KPI FormulUnit

TCH_AVAILABILITY TCH_AVAIL100 *DECOD [%]
Total TCH Traffic Total TCH Tresavail.a [Erlangs]
BH TCH Traffic BH TCH TraDECODE(re[Erlangs]
BH SDCCH Traffic BH SDCCH(resavail.
T [Erlangs]
Average SDCCH traffic Average SDDECODE(res [Erlangs]
EDGE Payload Total (Mbyte) EDGE Paylo DECODE(([Mbit]
DL EDGE Payload (Mbyte) DL EDGE PDECODE(([Mbit]
UL EDGE Payload (Mbyte) UL EDGE PDECODE(([Mbit]
GPRS Payload Total (Mbyte) GPRS Paylo DECODE((1[Mbit]
DL GPRS Payload (Mbyte) DL GPRS PDECODE((1[Mbit]
UL GPRS Payload (Mbyte) UL GPRS PDECODE((1[Mbit]
CSSR CSSR 100*(DECO[%]
IM ASS_NUM IM ASS_N resacc.IM [%]
IM ASS_DEN IM ASS_D resacc.IM [%]
SDCCH ACC_NUM SDCCH A (traffic. [%]
SDCCH ACC_DEN SDCCH ACtraffic.S [%]
TCH ASSIGN_NUM TCH ASSI (service [%]
TCH ASSIGN_DEN TCH ASSI (service. [%]
SDCCH Blocking SDCCH Blo100*(DECO[%]
SDCCH BLOCK_NUM SDCCH B traffic.S [#]
SDCCH BLOCK_DEN SDCCH BLtraffic.S [#]
SDCCH congest time Congestionresavail.s [s]
SDCCH Success Rate SDCCH Suc 100*DECOD [%]
SDCCH Drop Rate SDCCH Dro100*DECOD [%]
SDSR_NUM SDSR_NU (traffic. [#]
SDSR_DEN SDSR_DE traffic.S [#]
SDSR_T3(%) SDSR_T3( 100*DECOD [%]
SDSR_T3_NUM SDSR_T3 (traffic. [%]
SDSR_T3_DEN SDSR_T3_traffic.S [%]
SDCCH DROP_NUM SDCCH D traffic.S [#]
TCH Blocking TCH Blocki100*(DECO[%]
TCH BLOCK_NUM TCH BLOC(traffic. [#]
TCH BLOCK_DEN TCH BLOC(traffic. [#]
TCH_Congestion TCH_Conge DECODE(100 [Seconds]
TCH Assignment Success TCH Assig (100- 100 [%]
CCSR CCSR 100*DECOD [%]
K124
K125
K027
K028
K029
K030
K031
K032
K033
K034
K035
K036
K037
K103
K104
K105
K038
K039
K040
K041
K042
K043
K100
K101
K102
K044
K045
K046
K047
K048
K049
K050
AVE_DUR_UL_TBF_DEN
AVE_DUR_UL_TBF_SUM
nsn_tinem14
AVE_AVAIL_TCH_DEN
AVE_AVAIL_TCH_SUM
AVE_BUSY_TCH
AVE_GPRS_CHANNELS_DEN
AVE_GPRS_CHANNELS_SUM
AVE_NON_AVAIL_TCH_TIMESLOT
NON_AVAIL_TCH_DENOM
K051
K052
K053
K054
K055
K056
K057
K058
K059
K060
K061
K062
CCSR_NUM CCSR_NU service.T [%]
CCSR_DEN CCSR_DE service. [%]
TCH Drop Rate TCH Drop 100*DECOD [%]
TCH DROP_NUM TCH DRO traffic.D [%]
TCH DROP_DEN TCH DROPservice. [%]
DROP_AFTER_TCH_ASSIGN DROP_AFT(traffic. [#]
DL_Quality DL_Quality100*DECOD [%]
UL_Quality UL_Quality100*DECOD [%]
UL_Interference UL_Interfe DECODE((p[#]
Handover Success Rate Handover 100 *(DEC [%]
HOSR_NUM HOSR_NU ho.MSC_O[#]
HOSR_DEN HOSR_DE traffic.M [#]
Downlink multislot allocation blocking Downlink muDECODE(pcu[%]
TBF EST Success TBF EST S100 -(DECOD [%]
TBF EST_NUM TBF EST_ pcu.no_rad[%]
TBF EST_DEN TBF EST_ pcu.req_1_t[%]
TBF DL EST Success TBF DL ES100 -(DECOD [%]
TBF DL EST_NUM TBF DL E pcu.no_radi[#]
TBF DL EST_DEN TBF DL E pcu.req_1_t[#]
TBF UL EST Success TBF UL ES100 -(DECOD [%]
TBF UL EST_NUM TBF UL E pcu.no_radi[#]
TBF UL EST_DEN TBF UL E pcu.req_1_t[#]
TBF Completion Rate TBF Comple 100*DECODE[%]
TBF COMPLETION_NUM TBF COMPpcu.ave_du[%]
TBF COMPLETION_DEN TBF COMPpcu.ave_du[%]
DL EDGE Throughput (kbps) DL EDGE Th DECODE((p[kbit/s]
GPRS DL Throughput (kbps) GPRS DL Th DECODE((pcu
[kbit/s]
DL EDGE Throughput_MCS1-6 (kbps) DL EDGE T0.4*DECO [kbit/s]
DL EDGE Throughput_MCS7-9 (kbps) DL EDGE T0.4*DECOD[kbit/s]
AVE_AVAIL_TCH_TSL AVE_AVAI DECODE((re [#]
AVE_DUR_DL_TBF AVE_DUR_pcu.ave_du[%]
AVE_DUR_DL_TBF_SUM AVE_DUR_(pcu.ave_d[%]
AVE_DUR_UL_TBF_DEN (C72004) AVE_DUR_pcu.AVE_ [#]
AVE_DUR_UL_TBF_SUM (C72003) AVE_DUR_pcu.AVE_ [10 ms]
AVE_GPRS_CHANNELS_tsl AVE_GPRSDECODE((re [#]
ave_avail_tch_den (C2060) ave_avail_ resavail. [#]
ave_avail_tch_sum (C2059) ave_avail_ resavail. [#]
ave_busy_tch (C2027) ave_busy_ resavail. [#]
ave_gprs_channels_den (C2062) ave_gprs_ resavail.a [#]
ave_gprs_channels_sum (C2061) ave_gprs_ resavail.a [#]
ave_non_avail_tch_timeslot (C2069) ave_non_avresavail. [#]
non_avail_tch_denom (C2070) non_avail resavail. [#]
SDCCH_RADIO_FAIL SDCCH_RA100*DECODE [%]
SDCCH_RF_OLD_HO SDCCH_R 100*DECOD [%]
SDCCH_ABIS_FAIL_CALL SDCCH_AB100*DECODE [%]
SDCCH_ABIS_FAIL_OLD SDCCH_AB100*DECODE [%]
SDCCH_A_IF_FAIL_CALL SDCCH_A_100*DECODE [%]
SDCCH_A_IF_FAIL_OLD SDCCH_A_100*DECODE [%]
SDCCH_BTS_FAIL SDCCH_BT100*DECODE [%]
SDCCH_BCSU_RESET SDCCH_B 100*DECOD [%]
SDCCH_LAPD_FAIL SDCCH_LA100*DECODE [%]
SDCCH_NETW_ACT SDCCH_N 100*DECOD [%]
SDCCH_USER_ACT SDCCH_U 100*DECOD [%]
SDCCH_SEIZ_ATT SDCCH_SEtraffic.S [%]
K063
K064
K066
TCH_REQUESTS_CALL_ATTEMPT
TCH_MOC
TCH_MTC
DELETE_PAGING_COMMAND
CELL_SDCCH_TCH
CELL_SDCCH_TCH_AT
CELL_TCH_TCH
CELL_TCH_TCH_AT
TCH_CALL_REQ
TCH_NEW_CALL_ASSIGN
TCH_NORM_SEIZ
TCH_RE_EST_ASSIGN
K076
K077
K067
K068
K070
K078
K071
K069
K072
K073
K074
K075
K079
K080
K081
BSC_I_SUCC_HO
BSC_I_TCH_TCH
BSC_O_HO_CMD_ASSGN
BSC_O_SUCC_HO
BSC_O_TCH_TCH
MSC_CONTROLLED_IN_HO
MSC_I_SUCC_HO
MSC_I_TCH_TCH
MSC_O_HO_CMD
MSC_O_SUCC_HO
MSC_O_TCH_TCH
NBR_OF_DL_TBF
NBR_OF_UL_TBF
NO_RADIO_RES_AVAIL_FOR_DL_TBF
NO_RADIO_RES_AVAIL_FOR_UL_TBF
REQ_1_TSL_DL
REQ_1_TSL_UL
REQ_2_TSL_DL
REQ_2_TSL_UL
REQ_3_TSL_DL
REQ_3_TSL_UL
REQ_4_TSL_DL
REQ_4_TSL_UL
REQ_5_TSL_DL
SDCCH_HO_SEIZ SDCCH_HO 100*DECODE[%]
SDCCH_BUSY_ATT SDCCH_BUtraffic.S [%]
T3101_EXPIRED T3101_EX service.T [%]
TCH_REQUESTS_CALL_ATTEMPT (C1192) TCH_REQUtraffic. [#]
TCH MOC (c3024) TCH seizurresacc.T [#]
TCH MTC (c3023) Number of resacc.TC [#]
DELETE PAGING COMMAND (c3038) Number of resacc.D [#]
CELL_SDCCH_TCH (C4074) CELL_SDCho.CELL_ [#]
CELL_SDCCH_TCH_AT (C4077) CELL_SDCho.CELL_ [#]
CELL_TCH_TCH (C4073) CELL_TCHho.CELL_ [#]
CELL_TCH_TCH_AT (C4076) CELL_TCHho.CELL_ [#]
TCH_CALL_REQ TCH_CALLtraffic_e [No.]
TCH NEW CALL ASSIGN (c57033) TCH new caservice. [#]
TCH_NORM_SEIZ (C1009) TCH_NORM traffic.T [#]
TCH RE EST ASSIGN (c57032) TCH re-est service.T [#]
TCH_RADIO_FAIL TCH_RADI100*DECOD [%]
TCH_RF_OLD_HO TCH_RF_ 100*DECOD [%]
TCH_ABIS_FAIL_CALL TCH_ABIS 100*DECOD [%]
TCH_ABIS_FAIL_OLD TCH_ABIS 100*DECOD [%]
TCH_A_IF_FAIL_CALL TCH_A_IF 100*DECOD [%]
TCH_TR_FAIL TCH_TR_F100*DECOD [%]
TCH_A_IF_FAIL_OLD TCH_A_IF 100*DECOD [%]
TCH_ACT_FAIL_CALL TCH_ACT_100*DECOD [%]
TCH_BCSU_RESET TCH_BCS 100*DECOD [%]
TCH_BTS_FAIL TCH_BTS_100*DECOD [%]
TCH_LAPD_FAIL TCH_LAPD100*DECOD [%]
TCH_NETW_ACT TCH_NET 100*DECOD [%]
TCH_TR_FAIL_OLD TCH_TR_F100*DECOD [%]
TCH_USER_ACT TCH_USE 100*DECOD [%]
HO Attempt HO Attemp traffic.M [#]
BSC_I_SUCC_HO (C4010) BSC_I_SU ho.BSC_I [#]
BSC_I_TCH_TCH (C4056) BSC_I_TC ho.BSC_I [#]
BSC_O_HO_CMD_ASSGN (C1196) BSC_O_H traffic. [#]
BSC_O_SUCC_HO (C4014) BSC_O_S ho.BSC_O [#]
BSC_O_TCH_TCH (C4064) BSC_O_T ho.BSC_O [#]
MSC_CONTROLLED_IN_HO (C4101) MSC_CONho.MSC_C [#]
MSC_I_SUCC_HO (C4000) MSC_I_SUho.MSC_I [#]
MSC_I_TCH_TCH (C4043) MSC_I_TCho.MSC_I [#]
MSC_O_HO_CMD (C1195) MSC_O_H traffic.M [#]
MSC_O_SUCC_HO (C4004) MSC_O_S ho.MSC_O[#]
MSC_O_TCH_TCH (C4049) MSC_O_T ho.MSC_O[#]
NBR_OF_DL_TBF (C72005) NBR_OF_Dpcu.NBR_ [#]
NBR_OF_UL_TBF (C72000) NBR_OF_Upcu.NBR_ [#]
NO_RADIO_RES_AVAIL_FOR_DL_TBF (C72124) NO_RADIOpcu.NO_R [#]
NO_RADIO_RES_AVAIL_FOR_UL_TBF (C72123) NO_RADIOpcu.NO_R [#]
REQ_1_TSL_DL (C72039) REQ_1_TSpcu.REQ_ [#]
REQ_1_TSL_UL (C72034) REQ_1_TSpcu.REQ_ [#]
REQ_6_TSL_DL
REQ_7_TSL_DL
REQ_8_TSL_DL
DL_EGPRS_TBF_REL_DUE_NO_RESP
DL_RLC_BLOCKS_IN_ACK_MODE
DL_RLC_BLOCKS_IN_UNACK_MODE
DL_TBF_ESTABLISHMENT_FAILED
DL_TBF_REL_DUE_CSW_TRAFFIC
DL_TBF_REL_DUE_NO_RESP_MS
DL_TBF_REL_DUE_TO_FLUSH
DL_TBF_REL_DUE_TO_SUSPEND
DL_TBF_RELEASES_DUE_DTM
DTM_DURATION_SUM_FR
DTM_DURATION_SUM_HR
UL_EGPRS_TBF_REL_DUE_NO_RESP
UL_RLC_BLOCKS_IN_ACK_MODE
UL_RLC_BLOCKS_IN_UNACK_MODE
UL_TBF_ESTABLISHMENT_FAILED
UL_TBF_REL_DUE_CSW_TRAFFIC
UL_TBF_REL_DUE_NO_RESP_MS
UL_TBF_REL_DUE_TO_FLUSH
UL_TBF_REL_DUE_TO_SUSPEND
UL_TBF_RELEASES_DUE_DTM
RES_AV_DENOM4
K115
K116
K117
K118
K119
K120
K121
K122
K126
DL_EGPRS_TBF_REL_DUE_NO_RESP (C72095) DL_EGPRSpcu.DL_E [#]
DL RLC BLOCKS IN ACK MODE (c79000) Number of codingsc [#]
DL RLC BLOCKS IN UNACK MODE (c79001) Number of codingsc [#]
DL_TBF_ESTABLISHMENT_FAILED (C72093) DL_TBF_Epcu.DL_T [#]
DL_TBF_REL_DUE_CSW_TRAFFIC (C72055) DL_TBF_Rpcu.DL_T [#]
DL_TBF_REL_DUE_NO_RESP_MS (C72057) DL_TBF_Rpcu.DL_T [#]
DL_TBF_REL_DUE_TO_FLUSH (C72059) DL_TBF_Rpcu.DL_T [#]
DL_TBF_REL_DUE_TO_SUSPEND (C72061) DL_TBF_Rpcu.DL_T [#]
DL_TBF_RELEASES_DUE_DTM (C72202) DL_TBF_Rpcu.DL_T [#]
DTM_DURATION_SUM_FR (C105011) DTM_DURA psdtm.DT [10 msec]
DTM_DURATION_SUM_HR (C105012) DTM_DUR psdtm.DT [10 msec]
UL_EGPRS_TBF_REL_DUE_NO_RESP (C72094) UL_EGPRSpcu.UL_E [#]
UL RLC BLOCKS IN ACK MODE (c79002) Number of codingsc [#]
UL RLC BLOCKS IN UNACK MODE (c79003) Number of codingsc [#]
UL_TBF_ESTABLISHMENT_FAILED (C72092) UL_TBF_Epcu.UL_T [#]
UL_TBF_REL_DUE_CSW_TRAFFIC (C72054) UL_TBF_Rpcu.UL_T [#]
UL_TBF_REL_DUE_NO_RESP_MS (C72056) UL_TBF_Rpcu.UL_T [#]
UL_TBF_REL_DUE_TO_FLUSH (C72058) UL_TBF_Rpcu.UL_T [#]
UL_TBF_REL_DUE_TO_SUSPEND (C72060) UL_TBF_Rpcu.UL_T [#]
UL_TBF_RELEASES_DUE_DTM (C72201) UL_TBF_Rpcu.UL_T [#]
res_av_denom4 (C2007) res_av_de resavail. [#]
TCH Avail_NUM TCH Avail (DECODE(re [%]
TCH Avail_DEN TCH Avail (DECODE(re [%]
ALLOC DL_NUM ALLOC DL (pcu.alloc_ [Mbit]
ALLOC DL_DEN ALLOC DL (pcu.alloc_ [Mbit]
GPRS DL COM_NUM GPRS DL (DECODE(100 [Mbit]
GPRS DL COM_DEN GPRS DL (DECODE(50, [kbit/s]
EDGE DL COM_NUM EDGE DL 8*DECODE( [Mbit]
EDGE DL COM_DEN EDGE DL DECODE(5[kbit/s]
TCH Traffic NPI TCH Traffi DECODE(180[%]
Cache handler null
Evaluation method tmp tables(1)
Init duration 4.167
Sql generation 0.08
Execution duration 1.752
Load from cache none
Create tmp Tables 0.936
Drop tmp Tables 0.15
Load data db 0.0010
Load data and write to cache none
Start Time End Time Note Sql

2014-12-24 12:17:05.227 2014-12-24 12:17:05.260 creating tmp table: jf_rxstat_2470153731
select
trunc( p.period_start_time, 'dd' )
bsc.co_gid bsc_gid,
p.segment_id segment,
SUM(FREQ_UL_QUAL0) FREQ
SUM(FREQ_DL_QUAL0) FREQ
from
utp_common_objects plmn,
utp_common_objects bsc,
utp_common_objects bcf,
utp_common_objects bts,
utp_common_objects trx,
rbs_ps_rxstat_trx_day p
where
bcf.co_gid in ( '5000000366116
period_start_time >= to_date('20
period_start_time < to_date('201
plmn.co_gid = bsc.co_parent_g
p.bsc_gid = bsc.co_gid and
bsc.co_gid = bcf.co_parent_gid
bcf.co_gid = bts.co_parent_gid
_rxstat_2470153731
( p.period_start_time, 'dd' ) period_start_time,

co_gid bsc_gid,
gment_id segment,
(FREQ_UL_QUAL0) FREQ_UL_QUAL0,
(FREQ_DL_QUAL0) FREQ_DL_QUAL0,
(FREQ_DL_QUAL7) FREQ_DL_QUAL7
common_objects plmn,
common_objects bsc,
tp_common_objects bcf,
common_objects bts,
common_objects trx,
ps_rxstat_trx_day p
co_gid in ( '5000000366116' ) and

d_start_time >= to_date('2014/12/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss') and
d_start_time < to_date('2014/12/24 00:00:00', 'yyyy/mm/dd hh24:mi:ss') and
.co_gid = bsc.co_parent_gid and
c_gid = bsc.co_gid and
co_gid = bcf.co_parent_gid and
o_gid = bts.co_parent_gid and
bts.co_gid = trx.co_parent_gid a
p.bts_gid = bts.co_gid and
p.trx_gid = trx.co_gid and
bts.co_oc_id=4 and
bsc.co_oc_id=3 and
bcf.co_oc_id=27 and
plmn.co_oc_id=16 and
trx.co_oc_id=24
group by
trunc( p.period_start_time, 'dd' )
bsc.co_gid,
p.segment_id
2014-12-24 12:17:05.260 2014-12-24 12:17:05.355 creating tmp table: jf_power_ext_2477733887
select
trunc( p.period_start_time, 'dd' ) p
bsc.co_gid bsc_gid,
SUM(AVE_SUM_IDLE_CH_INTE
SUM(AVE_SUM_IDLE_TCH_PE
from
RBS_PS_POWER_bts_day p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
plmn.co_gid = bsc.co_parent_gid
bsc.co_gid = bcf.co_parent_gid a
bcf.co_gid = bts.co_parent_gid a
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
trunc( p.period_start_time, 'dd' ),
bsc.co_gid,
p.segment_id
2014-12-24 12:17:05.355 2014-12-24 12:17:05.391 creating tmp table: jf_resacc_2411313044
select
bsc.co_gid bsc_gid,
o_gid = trx.co_parent_gid and
_gid = bts.co_gid and
_gid = trx.co_gid and
o_oc_id=4 and
co_oc_id=3 and
o_oc_id=27 and
.co_oc_id=16 and
( p.period_start_time, 'dd' ),
_power_ext_2477733887
p.period_start_time, 'dd' ) period_start_time,

co_gid bsc_gid,
gment_id segment,
AVE_SUM_IDLE_CH_INTERF) AVE_SUM_IDLE_CH_INTERF,
(AVE_SUM_IDLE_TCH_PER_TRX) AVE_SUM_IDLE_TCH_PER_TRX
ommon_objects plmn,
ommon_objects bsc,
_common_objects bcf,
ommon_objects bts,
PS_POWER_bts_day p
o_gid in ( '5000000366116' ) and

_start_time >= to_date('2014/12/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss') and
_start_time < to_date('2014/12/24 00:00:00', 'yyyy/mm/dd hh24:mi:ss') and
o_oc_id=3 and
co_oc_id=16 and
co_gid = bsc.co_parent_gid and
_gid = bsc.co_gid and
o_gid = bcf.co_parent_gid and
_gid = bts.co_parent_gid and
gid = bts.co_gid and
_oc_id=4 and
p.period_start_time, 'dd' ),
_resacc_2411313044

co_gid bsc_gid,
gment_id segment,
SUM(DEL_IND_MSG_REC) DEL
SUM(DELETE_PAGING_COMM
SUM(IMM_ASSGN_REJ) IMM_
SUM(IMM_ASSGN_SENT) IMM
SUM(TCH_MOC) TCH_MOC,
SUM(TCH_MTC) TCH_MTC
from
RBS_PS_RESACC_bts_day p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
bsc.co_gid,
p.segment_id
2014-12-24 12:17:05.392 2014-12-24 12:17:05.423 creating tmp table: jf_ho_2442946551
select
bsc.co_gid bsc_gid,
SUM(bsc_i_sdcch_tch) BSC_I_S
SUM(bsc_i_succ_ho) BSC_I_SU
SUM(bsc_i_tch_tch) BSC_I_TC
SUM(bsc_i_unsucc_a_int_circ_
SUM(bsc_o_sdcch_tch) BSC_O
SUM(bsc_o_succ_ho) BSC_O_
SUM(bsc_o_tch_tch) BSC_O_T
SUM(cell_sdcch_tch) CELL_SD
SUM(cell_sdcch_tch_at) CELL_
SUM(cell_tch_tch) CELL_TCH_
SUM(cell_tch_tch_at) CELL_TC
SUM(ho_unsucc_a_int_circ_typ
SUM(msc_controlled_in_ho) MS
SUM(msc_i_sdcch_tch) MSC_I_
SUM(msc_i_succ_ho) MSC_I_S
DEL_IND_MSG_REC) DEL_IND_MSG_REC,
(DELETE_PAGING_COMMAND) DELETE_PAGING_COMMAND,
(IMM_ASSGN_REJ) IMM_ASSGN_REJ,
(IMM_ASSGN_SENT) IMM_ASSGN_SENT,
(TCH_MOC) TCH_MOC,
(TCH_MTC) TCH_MTC
ommon_objects plmn,
ommon_objects bsc,
ommon_objects bts,
PS_RESACC_bts_day p
o_gid in ( '5000000366116' ) and

o_oc_id=3 and
co_oc_id=16 and
_oc_id=4 and
_ho_2442946551

co_gid bsc_gid,
gment_id segment,
bsc_i_sdcch_tch) BSC_I_SDCCH_TCH,
(bsc_i_succ_ho) BSC_I_SUCC_HO,
(bsc_i_tch_tch) BSC_I_TCH_TCH,
(bsc_i_unsucc_a_int_circ_type) BSC_I_UNSUCC_A_INT_CIRC_TYPE,
(bsc_o_sdcch_tch) BSC_O_SDCCH_TCH,
(bsc_o_succ_ho) BSC_O_SUCC_HO,
(bsc_o_tch_tch) BSC_O_TCH_TCH,
(cell_sdcch_tch) CELL_SDCCH_TCH,
(cell_sdcch_tch_at) CELL_SDCCH_TCH_AT,
(cell_tch_tch) CELL_TCH_TCH,
(cell_tch_tch_at) CELL_TCH_TCH_AT,
(ho_unsucc_a_int_circ_type) HO_UNSUCC_A_INT_CIRC_TYPE,
(msc_controlled_in_ho) MSC_CONTROLLED_IN_HO,
(msc_i_sdcch_tch) MSC_I_SDCCH_TCH,
(msc_i_succ_ho) MSC_I_SUCC_HO,
SUM(msc_i_tch_tch) MSC_I_TC
SUM(msc_o_sdcch_tch) MSC_
SUM(msc_o_succ_ho) MSC_O
SUM(msc_o_tch_tch) MSC_O_
from
rbs_ps_ho_bts_day p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
bsc.co_gid,
p.segment_id
2014-12-24 12:17:05.425 2014-12-24 12:17:05.664 creating tmp table: jf_resavail_ext_2469946128
select
bsc.co_gid bsc_gid,
SUM(ave_busy_tch) AVE_BUSY_
SUM(res_av_denom14) RES_A
from
(
SELECT a.ave_idle_f_tch_3, a.
a.res_av_denom7, a.ave_idle
a.ave_idle_h_tch_1, a.res_av
a.res_av_denom10, a.ave_idl
a.ave_idle_h_tch_4, a.res_av
a.res_av_denom13, a.tch_con
(msc_i_tch_tch) MSC_I_TCH_TCH,
(msc_o_sdcch_tch) MSC_O_SDCCH_TCH,
(msc_o_succ_ho) MSC_O_SUCC_HO,
(msc_o_tch_tch) MSC_O_TCH_TCH
ommon_objects plmn,
ommon_objects bsc,
ommon_objects bts,
s_ho_bts_day p
o_gid in ( '5000000366116' ) and

o_oc_id=3 and
co_oc_id=16 and
_oc_id=4 and
_resavail_ext_2469946128

co_gid bsc_gid,
gment_id segment,
ave_busy_tch) AVE_BUSY_TCH,
(res_av_denom14) RES_AV_DENOM14
ommon_objects plmn,
ommon_objects bsc,
ommon_objects bts,
ECT a.ave_idle_f_tch_3, a.res_av_denom6, a.ave_idle_f_tch_4,

es_av_denom7, a.ave_idle_f_tch_5, a.res_av_denom8,
ve_idle_h_tch_1, a.res_av_denom9, a.ave_idle_h_tch_2,
es_av_denom10, a.ave_idle_h_tch_3, a.res_av_denom11,
ve_idle_h_tch_4, a.res_av_denom12, a.ave_idle_h_tch_5,
es_av_denom13, a.tch_cong_time, a.ave_busy_tch, a.res_av_denom14,
a.peak_busy_tch, a.ave_busy
a.sdcch_cong_time, a.ave_sd
a.ave_ftch_hold_tim, a.res_av
a.ave_non_avail_tch,
b.bts_gid,
a.ave_tch_avail_half, a.tch_fr_
a.tch_hr_radio_congestion_tim
a.ave_tch_busy_half, a.tch_pe
a.ave_tch_hold_time_hscsd, a
a.ave_tch_hold_time_hscsd_d
a.ave_busy_tch_hscsd_nume
a.peak_busy_hscsd, a.ave_hs
a.ave_hscsd_users_denom, a
a.ave_gprs_channels_sum, a
a.ave_permanent_gprs_ch_su
a.peak_permanent_gprs_ch, a
a.ave_add_gprs_ch_hold_tim
a.bsc_gid, a.bts_id, a.ave_non
a.ave_avail_full_tch, a.res_av
a.res_av_denom3, a.ave_idle
a.ave_idle_f_tch_2, a.res_av_
a.ave_non_avail_tch_timeslot
a.clear_request_by_bsc_on_t
a.ave_tch_tsl_locked_by_usr,
a.ave_sdcch_locked_by_usr,
a.ave_busy_tch_14k4_data_c
a.ave_tch_hold_14k4_data_c
a.time_in_forced_hr_mode, a.
a.time_in_forced_hr_amr_hr_
a.sdcch_alloc_for_voice_call,
a.sdcch_alloc_for_sms, a.ave
a.peak_busy_tch_timeslot, a.b
a.ave_non_avail_sdcch
FROM RBS_PS_RESAVAIL_bts
(SELECT bsc_gid, bts_gid, b
FROM rbs_ps_resavail_eb
WHERE period_start_time
TO_DATE ('2014/12
AND period_start_time <
TO_DATE ('2014/12
GROUP BY bsc_gid, bts_gid,
WHERE a.bts_id = b.bts_id AND
AND a.period_start_time >=
TO_DATE ('2014/12
AND a.period_start_time <
TO_DATE ('2014/12
)p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
eak_busy_tch, a.ave_busy_sdcch, a.res_av_denom15, a.peak_busy_sdcch,
dcch_cong_time, a.ave_sdcch_hold_tim, a.res_av_denom16,
ve_ftch_hold_tim, a.res_av_denom17, a.period_start_time,
ve_non_avail_tch,
ve_tch_avail_half, a.tch_fr_radio_congestion_time,
ch_hr_radio_congestion_time, a.ave_tch_busy_full,
ve_tch_busy_half, a.tch_peak_busy_full, a.tch_peak_busy_half,
ve_tch_hold_time_hscsd, a.ave_tch_hold_time_hscsd_numer,
ve_tch_hold_time_hscsd_denom, a.ave_busy_tch_hscsd,
ve_busy_tch_hscsd_numer, a.ave_busy_tch_hscsd_denom,
eak_busy_hscsd, a.ave_hscsd_users, a.ave_hscsd_users_numer,
ve_hscsd_users_denom, a.ave_avail_tch_sum, a.ave_avail_tch_den,
ve_gprs_channels_sum, a.ave_gprs_channels_den, a.peak_gprs_channels,
ve_permanent_gprs_ch_sum, a.ave_permanent_gprs_ch_den,
eak_permanent_gprs_ch, a.ave_add_gprs_ch_hold_time_sum,
ve_add_gprs_ch_hold_time_den, a.period_duration, a.int_id,
sc_gid, a.bts_id, a.ave_non_avail_tsl, a.res_av_denom1,
ve_avail_full_tch, a.res_av_denom2, a.ave_sdcch_sub,
es_av_denom3, a.ave_idle_f_tch_1, a.res_av_denom4,
ve_idle_f_tch_2, a.res_av_denom5, a.segment_id,
ve_non_avail_tch_timeslot, a.non_avail_tch_denom,
lear_request_by_bsc_on_tch, a.facch_call_setup_fail_paging,
ve_tch_tsl_locked_by_usr, a.res_av_denom30,
ve_sdcch_locked_by_usr, a.res_av_denom31,
ve_busy_tch_14k4_data_call, a.res_av_denom32,
ve_tch_hold_14k4_data_call, a.res_av_denom33,
me_in_forced_hr_mode, a.time_in_forced_amr_hr_mode,
me_in_forced_hr_amr_hr_mode, a.sdcch_traffic_for_voice_call,
dcch_alloc_for_voice_call, a.sdcch_traffic_for_sms,
dcch_alloc_for_sms, a.ave_busy_tch_timeslot,
eak_busy_tch_timeslot, a.bcch_downtime, a.bcch_uptime, b.trx_type,
ve_non_avail_sdcch
M RBS_PS_RESAVAIL_bts_day a,
ELECT bsc_gid, bts_gid, bts_id, trx_type, COUNT (*)
FROM rbs_ps_resavail_ebts_raw
WHERE period_start_time >=
TO_DATE ('2014/12/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
AND period_start_time <
ROUP BY bsc_gid, bts_gid, bts_id, trx_type) b
RE a.bts_id = b.bts_id AND a.bsc_gid = b.bsc_gid
a.period_start_time >=
a.period_start_time <
o_gid in ( '5000000366116' ) and

o_oc_id=3 and
co_oc_id=16 and
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
bsc.co_gid,
p.segment_id
2014-12-24 12:17:05.664 2014-12-24 12:17:05.681 creating tmp table: jf_service_2462624695
select
bsc.co_gid bsc_gid,
SUM(SERVED_FACCH_REQ) S
SUM(T3101_EXPIRED) T3101_
SUM(TCH_NEW_CALL_ASSIG
SUM(TCH_RE_EST_ASSIGN)
from
RBS_PS_SERVICE_bts_day p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
bsc.co_gid,
p.segment_id
2014-12-24 12:17:05.682 2014-12-24 12:17:05.719 creating tmp table: jf_pcu_2425552267
select
bsc.co_gid bsc_gid,
_oc_id=4 and
_service_2462624695

co_gid bsc_gid,
gment_id segment,
SERVED_FACCH_REQ) SERVED_FACCH_REQ,
(T3101_EXPIRED) T3101_EXPIRED,
(TCH_NEW_CALL_ASSIGN) TCH_NEW_CALL_ASSIGN,
(TCH_RE_EST_ASSIGN) TCH_RE_EST_ASSIGN
ommon_objects plmn,
ommon_objects bsc,
ommon_objects bts,
PS_SERVICE_bts_day p
o_gid in ( '5000000366116' ) and

o_oc_id=3 and
co_oc_id=16 and
_oc_id=4 and
_pcu_2425552267

co_gid bsc_gid,
gment_id segment,
SUM(alloc_1_tsl_dl) alloc_1_tsl_
SUM(alloc_2_tsl_dl) alloc_2_tsl
SUM(DECODE(ave_dur_dl_tbf_
SUM(ave_dur_dl_tbf_sum) ave_
SUM(DECODE(ave_dur_ul_tbf_
SUM(ave_dur_ul_tbf_sum) ave_
SUM(dl_egprs_tbf_rel_due_no_
SUM(dl_tbf_establishment_faile
SUM(dl_tbf_rel_due_csw_traffic
SUM(dl_tbf_rel_due_no_resp_m
SUM(dl_tbf_rel_due_to_flush) d
SUM(dl_tbf_rel_due_to_suspen
SUM(nbr_of_dl_tbf) nbr_of_dl_t
SUM(nbr_of_ul_tbf) nbr_of_ul_t
SUM(no_radio_res_ava_dl_tbf)
SUM(no_radio_res_ava_ul_tbf)
SUM(req_1_tsl_dl) req_1_tsl_dl
SUM(req_1_tsl_ul) req_1_tsl_ul
SUM(retra_rlc_data_blocks_dl_
SUM(retra_rlc_data_blocks_dl_
SUM(rlc_mac_cntrl_blocks_dl) r
SUM(ul_egprs_tbf_rel_due_no_
SUM(ul_tbf_establishment_faile
SUM(ul_tbf_rel_due_csw_traffic
SUM(ul_tbf_rel_due_no_resp_m
SUM(ul_tbf_rel_due_to_flush) u
SUM(ul_tbf_rel_due_to_suspen
SUM(no_radio_res_avail_for_ul
SUM(no_radio_res_avail_for_dl
SUM(rlc_data_blocks_ul_cs1) rl
SUM(rlc_data_blocks_ul_cs2) rl
SUM(rlc_data_blocks_dl_cs1) rl
SUM(rlc_data_blocks_dl_cs2) rl
SUM(UL_TBF_RELEASES_DU
SUM(DL_TBF_RELEASES_DU
SUM(REQ_9_TSL_DL) REQ_9
SUM(REQ_10_TSL_DL) REQ_
SUM(REQ_11_TSL_DL) REQ_1
alloc_1_tsl_dl) alloc_1_tsl_dl,
(alloc_2_tsl_dl) alloc_2_tsl_dl,
(DECODE(ave_dur_dl_tbf_den,-1,0,ave_dur_dl_tbf_den)) ave_dur_dl_tbf_den,
(ave_dur_dl_tbf_sum) ave_dur_dl_tbf_sum,
(DECODE(ave_dur_ul_tbf_den,-1,0,ave_dur_ul_tbf_den)) ave_dur_ul_tbf_den,
(ave_dur_ul_tbf_sum) ave_dur_ul_tbf_sum,
(dl_egprs_tbf_rel_due_no_resp) dl_egprs_tbf_rel_due_no_resp,
(dl_tbf_establishment_failed) dl_tbf_establishment_failed,
(dl_tbf_rel_due_csw_traffic) dl_tbf_rel_due_csw_traffic,
(dl_tbf_rel_due_no_resp_ms) dl_tbf_rel_due_no_resp_ms,
(dl_tbf_rel_due_to_flush) dl_tbf_rel_due_to_flush,
(dl_tbf_rel_due_to_suspend) dl_tbf_rel_due_to_suspend,
(nbr_of_dl_tbf) nbr_of_dl_tbf,
(nbr_of_ul_tbf) nbr_of_ul_tbf,
(no_radio_res_ava_dl_tbf) no_radio_res_ava_dl_tbf,
(no_radio_res_ava_ul_tbf) no_radio_res_ava_ul_tbf,
(req_1_tsl_dl) req_1_tsl_dl,
(req_1_tsl_ul) req_1_tsl_ul,
(retra_rlc_data_blocks_dl_cs1) retra_rlc_data_blocks_dl_cs1,
(retra_rlc_data_blocks_dl_cs2) retra_rlc_data_blocks_dl_cs2,
(rlc_mac_cntrl_blocks_dl) rlc_mac_cntrl_blocks_dl,
(ul_egprs_tbf_rel_due_no_resp) ul_egprs_tbf_rel_due_no_resp,
(ul_tbf_establishment_failed) ul_tbf_establishment_failed,
(ul_tbf_rel_due_csw_traffic) ul_tbf_rel_due_csw_traffic,
(ul_tbf_rel_due_no_resp_ms) ul_tbf_rel_due_no_resp_ms,
(ul_tbf_rel_due_to_flush) ul_tbf_rel_due_to_flush,
(ul_tbf_rel_due_to_suspend) ul_tbf_rel_due_to_suspend,
(no_radio_res_avail_for_ul_tbf) no_radio_res_avail_for_ul_tbf,
(no_radio_res_avail_for_dl_tbf) no_radio_res_avail_for_dl_tbf,
(rlc_data_blocks_ul_cs1) rlc_data_blocks_ul_cs1,
(rlc_data_blocks_ul_cs2) rlc_data_blocks_ul_cs2,
(rlc_data_blocks_dl_cs1) rlc_data_blocks_dl_cs1,
(rlc_data_blocks_dl_cs2) rlc_data_blocks_dl_cs2,
(UL_TBF_RELEASES_DUE_DTM) UL_TBF_RELEASES_DUE_DTM,
(DL_TBF_RELEASES_DUE_DTM) DL_TBF_RELEASES_DUE_DTM,
(REQ_9_TSL_DL) REQ_9_TSL_DL,
SUM(REQ_12_TSL_DL) REQ_
from
rbs_ps_pcu_bts_day p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
bsc.co_gid,
p.segment_id
2014-12-24 12:17:05.719 2014-12-24 12:17:05.983 creating tmp table: jf_traffic_ext_2441147716
select
bsc.co_gid bsc_gid,
SUM(tch_call_req) tch_call_req
from
rbs_ps_traffic_ebts_raw p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
(REQ_12_TSL_DL) REQ_12_TSL_DL
ommon_objects plmn,
ommon_objects bsc,
ommon_objects bts,
s_pcu_bts_day p
o_gid in ( '5000000366116' ) and

o_oc_id=3 and
co_oc_id=16 and
_oc_id=4 and
_traffic_ext_2441147716

co_gid bsc_gid,
gment_id segment,
tch_call_req) tch_call_req
ommon_objects plmn,
ommon_objects bsc,
ommon_objects bts,
s_traffic_ebts_raw p
o_gid in ( '5000000366116' ) and

o_oc_id=3 and
co_oc_id=16 and
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
bsc.co_gid,
p.segment_id
2014-12-24 12:17:05.984 2014-12-24 12:17:06.7 creating tmp table: jf_resavail_2424413904
select
bsc.co_gid bsc_gid,
SUM(period_duration) period_du
SUM(ave_busy_tch/res_av_den
AVG(ave_gprs_channels_den) a
SUM(ave_gprs_channels_sum)
AVG(non_avail_tch_denom) non
SUM(ave_busy_tch) ave_busy_
AVG(ave_avail_tch_den) ave_a
SUM(ave_avail_tch_sum) ave_a
SUM(ave_busy_sdcch) ave_bus
SUM(ave_non_avail_tch_timesl
MAX(peak_busy_sdcch) peak_b
AVG(res_av_denom15) res_av_
SUM(sdcch_cong_time) sdcch_
SUM(tch_cong_time) tch_cong_
AVG(res_av_denom4) res_av_d
from
rbs_ps_resavail_bts_day p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
bsc.co_gid,
_oc_id=4 and
_resavail_2424413904

co_gid bsc_gid,
gment_id segment,
period_duration) period_duration,
(ave_busy_tch/res_av_denom14) ave_busy_tch_den,
(ave_gprs_channels_den) ave_gprs_channels_den,
(ave_gprs_channels_sum) ave_gprs_channels_sum,
(non_avail_tch_denom) non_avail_tch_denom,
(ave_busy_tch) ave_busy_tch,
(ave_avail_tch_den) ave_avail_tch_den,
(ave_avail_tch_sum) ave_avail_tch_sum,
(ave_busy_sdcch) ave_busy_sdcch,
(ave_non_avail_tch_timeslot) ave_non_avail_tch_timeslot,
(peak_busy_sdcch) peak_busy_sdcch,
(res_av_denom15) res_av_denom15,
(sdcch_cong_time) sdcch_cong_time,
(tch_cong_time) tch_cong_time,
(res_av_denom4) res_av_denom4
ommon_objects plmn,
ommon_objects bsc,
ommon_objects bts,
s_resavail_bts_day p
o_gid in ( '5000000366116' ) and

o_oc_id=3 and
co_oc_id=16 and
_oc_id=4 and
p.segment_id
2014-12-24 12:17:06.7 2014-12-24 12:17:06.45 creating tmp table: jf_traffic_2430891967
select
bsc.co_gid bsc_gid,
SUM(BSC_O_HO_CMD_ASSGN
SUM(DROP_AFTER_TCH_ASS
SUM(MSC_O_HO_CMD) MSC_
SUM(SDCCH_A_IF_FAIL_CALL
SUM(SDCCH_A_IF_FAIL_OLD
SUM(SDCCH_ABIS_FAIL_CAL
SUM(SDCCH_ABIS_FAIL_OLD
SUM(SDCCH_ASSIGN) SDCCH
SUM(SDCCH_BCSU_RESET)
SUM(SDCCH_BTS_FAIL) SDC
SUM(SDCCH_BUSY_ATT) SDC
SUM(SDCCH_HO_SEIZ) SDCC
SUM(SDCCH_LAPD_FAIL) SDC
SUM(SDCCH_NETW_ACT) SD
SUM(SDCCH_RADIO_FAIL) SD
SUM(SDCCH_RF_OLD_HO) S
SUM(SDCCH_SEIZ_ATT) SDC
SUM(SDCCH_USER_ACT) SD
SUM(TCH_A_IF_FAIL_CALL) T
SUM(TCH_A_IF_FAIL_OLD) TC
SUM(TCH_ABIS_FAIL_CALL) T
SUM(TCH_ABIS_FAIL_OLD) TC
SUM(TCH_ACT_FAIL_CALL) T
SUM(TCH_BCSU_RESET) TCH
SUM(TCH_BTS_FAIL) TCH_BT
SUM(TCH_CALL_REQ) TCH_C
SUM(TCH_LAPD_FAIL) TCH_L
SUM(TCH_NETW_ACT) TCH_
SUM(TCH_NORM_SEIZ) TCH_
SUM(TCH_RADIO_FAIL) TCH_
SUM(TCH_REJ_DUE_REQ_CH
SUM(TCH_RF_OLD_HO) TCH_
SUM(TCH_SEIZ_DUE_SDCCH
SUM(TCH_SUCC_SEIZ_FOR_
SUM(TCH_TR_FAIL) TCH_TR_
SUM(TCH_TR_FAIL_OLD) TCH
SUM(TCH_USER_ACT) TCH_U
SUM(TCH_REQUESTS_CALL_
SUM(SUCC_TCH_SEIZ_CALL_
from
_traffic_2430891967

co_gid bsc_gid,
gment_id segment,
BSC_O_HO_CMD_ASSGN) BSC_O_HO_CMD_ASSGN,
(DROP_AFTER_TCH_ASSIGN) DROP_AFTER_TCH_ASSIGN,
(MSC_O_HO_CMD) MSC_O_HO_CMD,
(SDCCH_A_IF_FAIL_CALL) SDCCH_A_IF_FAIL_CALL,
(SDCCH_A_IF_FAIL_OLD) SDCCH_A_IF_FAIL_OLD,
(SDCCH_ABIS_FAIL_CALL) SDCCH_ABIS_FAIL_CALL,
(SDCCH_ABIS_FAIL_OLD) SDCCH_ABIS_FAIL_OLD,
(SDCCH_ASSIGN) SDCCH_ASSIGN,
(SDCCH_BCSU_RESET) SDCCH_BCSU_RESET,
(SDCCH_BTS_FAIL) SDCCH_BTS_FAIL,
(SDCCH_BUSY_ATT) SDCCH_BUSY_ATT,
(SDCCH_HO_SEIZ) SDCCH_HO_SEIZ,
(SDCCH_LAPD_FAIL) SDCCH_LAPD_FAIL,
(SDCCH_NETW_ACT) SDCCH_NETW_ACT,
(SDCCH_RADIO_FAIL) SDCCH_RADIO_FAIL,
(SDCCH_RF_OLD_HO) SDCCH_RF_OLD_HO,
(SDCCH_SEIZ_ATT) SDCCH_SEIZ_ATT,
(SDCCH_USER_ACT) SDCCH_USER_ACT,
(TCH_A_IF_FAIL_CALL) TCH_A_IF_FAIL_CALL,
(TCH_A_IF_FAIL_OLD) TCH_A_IF_FAIL_OLD,
(TCH_ABIS_FAIL_CALL) TCH_ABIS_FAIL_CALL,
(TCH_ABIS_FAIL_OLD) TCH_ABIS_FAIL_OLD,
(TCH_ACT_FAIL_CALL) TCH_ACT_FAIL_CALL,
(TCH_BCSU_RESET) TCH_BCSU_RESET,
(TCH_BTS_FAIL) TCH_BTS_FAIL,
(TCH_CALL_REQ) TCH_CALL_REQ,
(TCH_LAPD_FAIL) TCH_LAPD_FAIL,
(TCH_NETW_ACT) TCH_NETW_ACT,
(TCH_NORM_SEIZ) TCH_NORM_SEIZ,
(TCH_RADIO_FAIL) TCH_RADIO_FAIL,
(TCH_REJ_DUE_REQ_CH_A_IF_CRC) TCH_REJ_DUE_REQ_CH_A_IF_CRC,
(TCH_RF_OLD_HO) TCH_RF_OLD_HO,
(TCH_SEIZ_DUE_SDCCH_CON) TCH_SEIZ_DUE_SDCCH_CON,
(TCH_SUCC_SEIZ_FOR_DIR_ACC) TCH_SUCC_SEIZ_FOR_DIR_ACC,
(TCH_TR_FAIL) TCH_TR_FAIL,
(TCH_TR_FAIL_OLD) TCH_TR_FAIL_OLD,
(TCH_USER_ACT) TCH_USER_ACT,
(TCH_REQUESTS_CALL_ATTEMPT) TCH_REQUESTS_CALL_ATTEMPT,
(SUCC_TCH_SEIZ_CALL_ATTEMPT) SUCC_TCH_SEIZ_CALL_ATTEMPT
ommon_objects plmn,
ommon_objects bsc,
ommon_objects bts,
rbs_ps_traffic_bts_day p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
bsc.co_gid,
p.segment_id
2014-12-24 12:17:06.45 2014-12-24 12:17:06.84 creating tmp table: jf_psdtm_2458493106
select
bsc.co_gid bsc_gid,
SUM(DTM_DURATION_SUM_FR
SUM(DTM_DURATION_SUM_H
from
RBS_PS_PSDTM_bts_day p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
bsc.co_gid,
p.segment_id
s_traffic_bts_day p
o_gid in ( '5000000366116' ) and

o_oc_id=3 and
co_oc_id=16 and
_oc_id=4 and
_psdtm_2458493106

co_gid bsc_gid,
gment_id segment,
DTM_DURATION_SUM_FR) DTM_DURATION_SUM_FR,
(DTM_DURATION_SUM_HR) DTM_DURATION_SUM_HR
ommon_objects plmn,
ommon_objects bsc,
ommon_objects bts,
PS_PSDTM_bts_day p
o_gid in ( '5000000366116' ) and

o_oc_id=3 and
co_oc_id=16 and
_oc_id=4 and
2014-12-24 12:17:06.84 2014-12-24 12:17:06.130 creating tmp table: jf_codingsc_2423372847
select
bsc.co_gid bsc_gid,
SUM(DECODE(CODING_SCHE
_codingsc_2423372847

co_gid bsc_gid,
gment_id segment,
DECODE(CODING_SCHEME, 1, UL_RLC_BLOCKS_IN_ACK_MODE, 0)) UL_RLC_BLOCKS_IN_ACK_MODE_1,
(DECODE(CODING_SCHEME, 2, UL_RLC_BLOCKS_IN_ACK_MODE, 0)) UL_RLC_BLOCKS_IN_ACK_MODE_2,
(DECODE(CODING_SCHEME, 1, DL_RLC_BLOCKS_IN_ACK_MODE, 0)) DL_RLC_BLOCKS_IN_ACK_MODE_1,
(DECODE(CODING_SCHEME, 1, UL_RLC_BLOCKS_IN_UNACK_MODE, 0)) UL_RLC_BLOCKS_IN_UNACK_MODE_1,
(DECODE(CODING_SCHEME, 1, DL_RLC_BLOCKS_IN_UNACK_MODE, 0)) DL_RLC_BLOCKS_IN_UNACK_MODE_1,
(DECODE(CODING_SCHEME, 1, RETRANS_RLC_DATA_BLOCKS_DL, 0)) RETRANS_RLC_DATA_BLOCKS_DL_1,
K_MODE_1,
CK_MODE_2,
CK_MODE_3,
CK_MODE_4,
CK_MODE_5,
CK_MODE_6,
CK_MODE_7,
CK_MODE_8,
CK_MODE_9,
ACK_MODE_11,
ACK_MODE_12,
CK_MODE_1,
CK_MODE_2,
CK_MODE_3,
CK_MODE_4,
CK_MODE_5,
CK_MODE_6,
CK_MODE_7,
CK_MODE_8,
CK_MODE_9,
ACK_MODE_11,
ACK_MODE_12,
_UNACK_MODE_1,
_UNACK_MODE_2,
_UNACK_MODE_3,
_UNACK_MODE_4,
_UNACK_MODE_5,
_UNACK_MODE_6,
_UNACK_MODE_7,
_UNACK_MODE_8,
_UNACK_MODE_9,
N_UNACK_MODE_11,
N_UNACK_MODE_12,
_UNACK_MODE_1,
_UNACK_MODE_2,
_UNACK_MODE_3,
_UNACK_MODE_4,
_UNACK_MODE_5,
_UNACK_MODE_6,
_UNACK_MODE_7,
_UNACK_MODE_8,
_UNACK_MODE_9,
N_UNACK_MODE_11,
N_UNACK_MODE_12,
_BLOCKS_DL_1,
_BLOCKS_DL_2,
_BLOCKS_DL_3,
SUM(dl_rlc_blocks_in_ack_mod
SUM(dl_rlc_blocks_in_unack_m
SUM(ul_rlc_blocks_in_ack_mod
SUM(ul_rlc_blocks_in_unack_m
from
rbs_ps_codingsc_cs1_day p
where
bcf.co_gid in ( '5000000366116'
bsc.co_oc_id=3 and
bts.co_oc_id=4 and
bcf.co_oc_id=27
group by
bsc.co_gid,
p.segment_id
2014-12-24 12:17:06.132 2014-12-24 12:17:06.161 creating tmp table: jf_ALLTABLES_2490353012
select
period_start_time,
bsc_gid,
segment
from
(
(
select
period_start_time, TO_CHAR(b
from
jf_codingsc_2423372847
)
UNION
(
select
(dl_rlc_blocks_in_ack_mode) dl_rlc_blocks_in_ack_mode,
(dl_rlc_blocks_in_unack_mode) dl_rlc_blocks_in_unack_mode,
(ul_rlc_blocks_in_ack_mode) ul_rlc_blocks_in_ack_mode,
(ul_rlc_blocks_in_unack_mode) ul_rlc_blocks_in_unack_mode
ommon_objects plmn,
ommon_objects bsc,
ommon_objects bts,
s_codingsc_cs1_day p
o_gid in ( '5000000366116' ) and

o_oc_id=3 and
co_oc_id=16 and
_oc_id=4 and
_ALLTABLES_2490353012
d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment
dingsc_2423372847
_BLOCKS_DL_4,
_BLOCKS_DL_5,
_BLOCKS_DL_6,
_BLOCKS_DL_7,
_BLOCKS_DL_8,
_BLOCKS_DL_9,
from
jf_ho_2442946551
)
UNION
(
select
from
jf_pcu_2425552267
)
UNION
(
select
from
jf_power_ext_2477733887
)
UNION
(
select
from
jf_psdtm_2458493106
)
UNION
(
select
from
jf_resacc_2411313044
)
UNION
(
select
from
jf_resavail_2424413904
)
UNION
(
select
from
jf_resavail_ext_2469946128
)
UNION
(
select
from
jf_rxstat_2470153731
)
UNION
_2442946551
u_2425552267
wer_ext_2477733887
dtm_2458493106
sacc_2411313044
savail_2424413904
savail_ext_2469946128
stat_2470153731
(
select
from
jf_service_2462624695
)
UNION
(
select
from
jf_traffic_2430891967
)
UNION
(
select
from
jf_traffic_ext_2441147716
)
)p
where
p.period_start_time >= to_date('201
p.period_start_time < to_date('2014
2014-12-24 12:17:06.243 2014-12-24 12:17:06.979 report from tmp tables
select
ALLTABLES.period_start_time p
nvl(bsc.co_name,'NN ('||bs
nvl(c.segment_name,'NN ('
ALLTABLES.bsc_gid,
ALLTABLES.segment,
to_number(100 *DECODE(((DE
to_number(resavail.ave_busy_tch_de
to_number(DECODE(resavail_e
to_number((resavail.peak_busy
to_number(DECODE(resavail.re
to_number(DECODE((1024*102
to_number(100*(DECODE((resa
to_number(resacc.IMM_ASSGN
to_number(resacc.IMM_ASSGN
to_number((traffic.SDCCH_RAD
to_number(traffic.SDCCH_ASS
to_number((service.TCH_NEW_
to_number((service.TCH_NEW_
to_number(100*(DECODE((traff
to_number(traffic.SDCCH_BUS
rvice_2462624695
ffic_2430891967
ffic_ext_2441147716

_start_time < to_date('2014/12/24 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
TABLES.period_start_time period_start_time,
nvl(bsc.co_name,'NN ('||bsc.co_gid||')') "BSC Name",
nvl(c.segment_name,'NN ('||ALLTABLES.segment||')') "Segment Name",
ALLTABLES.bsc_gid,
TABLES.segment,
umber(100 *DECODE(((DECODE(resavail.ave_avail_tch_den, 0, 0, resavail.ave_avail_tch_sum/resavail.ave_avail_tch_den))+(DECOD
r(resavail.ave_busy_tch_den*DECODE(60,0,0,resavail.period_duration/60)+ DECODE(NVL((resavail.period_duration*60),0),0,0,DECO
umber(DECODE(resavail_ext.RES_AV_DENOM14,0,0,resavail_ext.AVE_BUSY_TCH/resavail_ext.RES_AV_DENOM14)) "K003",
umber((resavail.peak_busy_sdcch)) "K004",
umber(DECODE(resavail.res_av_denom15,0,0,resavail.ave_busy_sdcch/resavail.res_av_denom15)) "K005",
umber(DECODE((1024*1024), 0, 0, ((codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_1+codingsc.DL_RLC_BLOCKS_IN_UNACK_MOD
umber(DECODE((1024*1024), 0, 0, ((codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_1+codingsc.DL_RLC_BLOCKS_IN_UNACK_MOD
umber(DECODE((1024*1024), 0, 0, ((codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_1+codingsc.UL_RLC_BLOCKS_IN_UNACK_MOD
umber(DECODE((1024*1024), 0, 0, ((pcu.rlc_data_blocks_dl_cs1 + pcu.rlc_data_blocks_ul_cs1)*23 +(pcu.rlc_data_blocks_dl_cs2 + pc
umber(DECODE((1024*1024), 0, 0, ((pcu.rlc_data_blocks_dl_cs1)*23 +(pcu.rlc_data_blocks_dl_cs2)*34 +(codingsc.DL_RLC_BLOCKS
umber(DECODE((1024*1024), 0, 0, ((pcu.rlc_data_blocks_ul_cs1)*23 +(pcu.rlc_data_blocks_ul_cs2)*34 +(codingsc.UL_RLC_BLOCKS
umber(100*(DECODE((resacc.IMM_ASSGN_SENT + resacc.IMM_ASSGN_REJ), 0, 0, (resacc.IMM_ASSGN_SENT - resacc.DEL_IND
umber(resacc.IMM_ASSGN_SENT - resacc.DEL_IND_MSG_REC) "K082",
umber(resacc.IMM_ASSGN_SENT + resacc.IMM_ASSGN_REJ) "K083",
umber((traffic.SDCCH_RADIO_FAIL + traffic.SDCCH_RF_OLD_HO + traffic.SDCCH_USER_ACT + traffic.SDCCH_BCSU_RESET + tra
umber(traffic.SDCCH_ASSIGN) "K085",
umber((service.TCH_NEW_CALL_ASSIGN - service.SERVED_FACCH_REQ + ho.MSC_O_SDCCH_TCH + ho.BSC_O_SDCCH_TCH
umber((service.TCH_NEW_CALL_ASSIGN - service.SERVED_FACCH_REQ + ho.MSC_O_SDCCH_TCH + ho.BSC_O_SDCCH_TCH
umber(100*(DECODE((traffic.SDCCH_SEIZ_ATT), 0, 0,(traffic.SDCCH_BUSY_ATT - traffic.TCH_SEIZ_DUE_SDCCH_CON)/(traffic.SD
umber(traffic.SDCCH_BUSY_ATT - traffic.TCH_SEIZ_DUE_SDCCH_CON) "K014",
ail.ave_avail_tch_den))+(DECODE(resavail.ave_gprs_channels_den, 0, 0, resavail.ave_gprs_channels_sum/resavail.ave_gprs_channe
period_duration*60),0),0,0,DECODE(100,0,0,NVL(psdtm.DTM_DURATION_SUM_FR,0)*DECODE(60,0,0,resavail.period_duration/60)/
S_AV_DENOM14)) "K003",
RLC_BLOCKS_IN_UNACK_MODE_1+codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_1+codingsc.UL_RLC_BLOCKS_IN_UNACK_MOD
RLC_BLOCKS_IN_UNACK_MODE_1)*22 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_2+codingsc.DL_RLC_BLOCKS_IN_UNACK
RLC_BLOCKS_IN_UNACK_MODE_1)*22 +(codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_2+codingsc.UL_RLC_BLOCKS_IN_UNACK
(pcu.rlc_data_blocks_dl_cs2 + pcu.rlc_data_blocks_ul_cs2)*34 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_11 + codingsc.DL_RLC
34 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_11+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_11)*40 +(codingsc.DL_RLC_
34 +(codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_11+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_11)*40 +(codingsc.UL_RLC_
ASSGN_SENT - resacc.DEL_IND_MSG_REC)/(resacc.IMM_ASSGN_SENT + resacc.IMM_ASSGN_REJ)))*(1 -(DECODE(traffic.SDCC
affic.SDCCH_BCSU_RESET + traffic.SDCCH_NETW_ACT + traffic.SDCCH_ABIS_FAIL_OLD + traffic.SDCCH_BTS_FAIL + traffic.SDC
TCH + ho.BSC_O_SDCCH_TCH + ho.CELL_SDCCH_TCH - ho.MSC_I_SDCCH_TCH - ho.BSC_I_SDCCH_TCH)) "K086",

TCH + ho.BSC_O_SDCCH_TCH + ho.CELL_SDCCH_TCH - ho.MSC_I_SDCCH_TCH - ho.BSC_I_SDCCH_TCH + traffic.TCH_REQUE
_DUE_SDCCH_CON)/(traffic.SDCCH_SEIZ_ATT)))) "K013",
s_sum/resavail.ave_gprs_channels_den))+(DECODE(resavail.non_avail_tch_denom, 0, 0, resavail.ave_non_avail_tch_timeslot/resavai
,0,0,resavail.period_duration/60)/100)/(resavail.period_duration*60))) "K002",
RLC_BLOCKS_IN_UNACK_MODE_1)*22 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_2+codingsc.DL_RLC_BLOCKS_IN_UNACK
c.DL_RLC_BLOCKS_IN_UNACK_MODE_2)*28 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_3+codingsc.DL_RLC_BLOCKS_IN_U
c.UL_RLC_BLOCKS_IN_UNACK_MODE_2)*28 +(codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_3+codingsc.UL_RLC_BLOCKS_IN_U
K_MODE_11 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_11 + codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_11+codingsc.UL_
DE_11)*40 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_12+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_12)*54)/(1024*1024
DE_11)*40 +(codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_12+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_12)*54)/(1024*1024
EJ)))*(1 -(DECODE(traffic.SDCCH_ASSIGN, 0, 0, (traffic.SDCCH_RADIO_FAIL + traffic.SDCCH_RF_OLD_HO + traffic.SDCCH_USER
.SDCCH_BTS_FAIL + traffic.SDCCH_LAPD_FAIL)) "K084",
DCCH_TCH)) "K086",
DCCH_TCH + traffic.TCH_REQUESTS_CALL_ATTEMPT - traffic.SUCC_TCH_SEIZ_CALL_ATTEMPT)) "K087",
e_non_avail_tch_timeslot/resavail.non_avail_tch_denom))), 0, 0,((DECODE(resavail.ave_avail_tch_den, 0, 0, resavail.ave_avail_tch_su
sc.DL_RLC_BLOCKS_IN_UNACK_MODE_2+codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_2+codingsc.UL_RLC_BLOCKS_IN_UNAC
odingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_3)*37 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_4+codingsc.DL_RLC_BLOCKS
odingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_3)*37 +(codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_4+codingsc.UL_RLC_BLOCKS
N_ACK_MODE_11+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_11)*40 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_12 + cod
ACK_MODE_12)*54)/(1024*1024))) "K010",
ACK_MODE_12)*54)/(1024*1024))) "K011",
OLD_HO + traffic.SDCCH_USER_ACT + traffic.SDCCH_BCSU_RESET + traffic.SDCCH_NETW_ACT + traffic.SDCCH_ABIS_FAIL_OL
n, 0, 0, resavail.ave_avail_tch_sum/resavail.ave_avail_tch_den))+(DECODE(resavail.ave_gprs_channels_den, 0, 0, resavail.ave_gprs_
sc.UL_RLC_BLOCKS_IN_UNACK_MODE_2)*28 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_3+codingsc.DL_RLC_BLOCKS_IN_
E_4+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_4)*44 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_5+codingsc.DL_RLC_BL
E_4+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_4)*44 +(codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_5+codingsc.UL_RLC_BL
OCKS_IN_ACK_MODE_12 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_12 + codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_12
+ traffic.SDCCH_ABIS_FAIL_OLD + traffic.SDCCH_BTS_FAIL + traffic.SDCCH_LAPD_FAIL)/traffic.SDCCH_ASSIGN)))*(DECODE((s

els_den, 0, 0, resavail.ave_gprs_channels_sum/resavail.ave_gprs_channels_den)))/((DECODE(resavail.ave_avail_tch_den, 0, 0, resava
codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_3+codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_3+codingsc.UL_RLC_BLOCKS_IN
_MODE_5+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_5)*56 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_6+codingsc.DL_R
_MODE_5+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_5)*56 +(codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_6+codingsc.UL_R
C_BLOCKS_IN_ACK_MODE_12+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_12)*54)/(1024*1024))) "K009",
DCCH_ASSIGN)))*(DECODE((service.TCH_NEW_CALL_ASSIGN - service.SERVED_FACCH_REQ + ho.MSC_O_SDCCH_TCH + ho

il.ave_avail_tch_den, 0, 0, resavail.ave_avail_tch_sum/resavail.ave_avail_tch_den))+(DECODE(resavail.ave_gprs_channels_den, 0, 0,
+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_3)*37 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_4+codingsc.DL_RLC_BLOC
_ACK_MODE_6+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_6)*74 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_7+codingsc
_ACK_MODE_6+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_6)*74 +(codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_7+codingsc
24))) "K009",
+ ho.MSC_O_SDCCH_TCH + ho.BSC_O_SDCCH_TCH + ho.CELL_SDCCH_TCH - ho.MSC_I_SDCCH_TCH - ho.BSC_I_SDCCH_TC

ail.ave_gprs_channels_den, 0, 0, resavail.ave_gprs_channels_sum/resavail.ave_gprs_channels_den))+(DECODE(resavail.non_avail_t
ODE_4+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_4+codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_4+codingsc.UL_RLC_BLOC
KS_IN_ACK_MODE_7+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_7)*112 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_8+c
KS_IN_ACK_MODE_7+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_7)*112 +(codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_8+c
CH_TCH - ho.BSC_I_SDCCH_TCH + traffic.TCH_REQUESTS_CALL_ATTEMPT - traffic.SUCC_TCH_SEIZ_CALL_ATTEMPT), 0, 0, (s

+(DECODE(resavail.non_avail_tch_denom, 0, 0, resavail.ave_non_avail_tch_timeslot/resavail.non_avail_tch_denom))))) "K001",
ODE_4+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_4)*44 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_5+codingsc.DL_RLC
_BLOCKS_IN_ACK_MODE_8+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_8)*136 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MOD
_BLOCKS_IN_ACK_MODE_8+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_8)*136 +(codingsc.UL_RLC_BLOCKS_IN_ACK_MOD
SEIZ_CALL_ATTEMPT), 0, 0, (service.TCH_NEW_CALL_ASSIGN - service.SERVED_FACCH_REQ + ho.MSC_O_SDCCH_TCH + ho

ail_tch_denom))))) "K001",
CK_MODE_5+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_5+codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_5+codingsc.UL_RLC
DL_RLC_BLOCKS_IN_ACK_MODE_9+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_9)*148)/(1024*1024))) "K007",
UL_RLC_BLOCKS_IN_ACK_MODE_9+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_9)*148)/(1024*1024))) "K008",
+ ho.MSC_O_SDCCH_TCH + ho.BSC_O_SDCCH_TCH + ho.CELL_SDCCH_TCH - ho.MSC_I_SDCCH_TCH - ho.BSC_I_SDCCH_TC

ACK_MODE_5+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_5)*56 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_6+codingsc.D
4*1024))) "K007",
4*1024))) "K008",
CH_TCH - ho.BSC_I_SDCCH_TCH)/(service.TCH_NEW_CALL_ASSIGN - service.SERVED_FACCH_REQ + ho.MSC_O_SDCCH_TC

S_IN_ACK_MODE_6+codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_6+codingsc.UL_RLC_BLOCKS_IN_ACK_MODE_6+codingsc.
REQ + ho.MSC_O_SDCCH_TCH + ho.BSC_O_SDCCH_TCH + ho.CELL_SDCCH_TCH - ho.MSC_I_SDCCH_TCH - ho.BSC_I_SDCC

KS_IN_ACK_MODE_6+codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE_6)*74 +(codingsc.DL_RLC_BLOCKS_IN_A...
_SDCCH_TCH - ho.BSC_I_SDCC...
BLOCKS_IN_A...
to_number(traffic.SDCCH_SEIZ
to_number(resavail.sdcch_cong
to_number(100*DECODE((traffi
to_number((traffic.SDCCH_ASS
to_number((traffic.SDCCH_ASS
to_number(traffic.SDCCH_RAD
to_number(100*(DECODE(((tra
to_number((traffic.TCH_CALL_R
to_number((traffic.TCH_CALL_R
to_number(DECODE(100, 0, 0,
to_number((100- 100*(DECODE
to_number(100*DECODE(servic
to_number(service.TCH_NEW_
to_number(100*DECODE((serv
to_number(traffic.DROP_AFTER
to_number((traffic.DROP_AFTE
to_number(100*DECODE((rxsta
to_number(100*DECODE((rxsta
to_number(DECODE((power_ex
to_number(100 *(DECODE((traf
to_number(ho.MSC_O_SUCC_
to_number(traffic.MSC_O_HO_
to_number(DECODE(pcu.req_1
to_number(100 -(DECODE((pcu
to_number(pcu.no_radio_res_a
to_number(pcu.req_1_tsl_dl + p
to_number(pcu.req_1_tsl_dl + p
to_number(pcu.req_1_tsl_ul + p
to_number(100*DECODE(((pcu
to_number(pcu.ave_dur_ul_tbf_
to_number(pcu.ave_dur_ul_tbf_
to_number(DECODE((pcu.alloc
to_number(DECODE((pcu.alloc
to_number(0.4*DECODE(((codi
to_number(0.4*DECODE((DEC
to_number(DECODE((resavail.a
to_number(pcu.ave_dur_dl_tbf_
to_number((pcu.ave_dur_dl_tbf
to_number(pcu.AVE_DUR_UL_
to_number(pcu.AVE_DUR_UL_
to_number(DECODE((resavail.a
to_number(resavail.AVE_AVAIL
to_number(resavail.AVE_AVAIL
to_number(resavail.AVE_BUSY
umber(traffic.SDCCH_SEIZ_ATT) "K015",
umber(resavail.sdcch_cong_time/100) "cngt_2",
umber(100*DECODE((traffic.SDCCH_SEIZ_ATT), 0, 0, ((traffic.SDCCH_ASSIGN + traffic.SDCCH_HO_SEIZ)-(traffic.SDCCH_RADIO_
umber(100*DECODE((traffic.SDCCH_SEIZ_ATT), 0, 0, (traffic.SDCCH_RADIO_FAIL + traffic.SDCCH_A_IF_FAIL_CALL + traffic.SDCC
umber((traffic.SDCCH_ASSIGN + traffic.SDCCH_HO_SEIZ)-(traffic.SDCCH_RADIO_FAIL + traffic.SDCCH_A_IF_FAIL_CALL + traffic.S
umber(100*DECODE((traffic.SDCCH_SEIZ_ATT), 0, 0, ((traffic.SDCCH_ASSIGN + traffic.SDCCH_HO_SEIZ)-(traffic.SDCCH_RADIO_
umber((traffic.SDCCH_ASSIGN + traffic.SDCCH_HO_SEIZ)-(traffic.SDCCH_RADIO_FAIL + traffic.SDCCH_A_IF_FAIL_CALL + traffic.S
umber(traffic.SDCCH_RADIO_FAIL + traffic.SDCCH_A_IF_FAIL_CALL + traffic.SDCCH_ABIS_FAIL_CALL + traffic.SDCCH_USER_AC
umber(100*(DECODE(((traffic.TCH_CALL_REQ - traffic.TCH_REJ_DUE_REQ_CH_A_IF_CRC)+(ho.BSC_I_UNSUCC_A_INT_CIRC_T
umber((traffic.TCH_CALL_REQ - traffic.TCH_NORM_SEIZ + traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC - traffic.TCH_REJ_DUE_REQ_
umber((traffic.TCH_CALL_REQ - traffic.TCH_REJ_DUE_REQ_CH_A_IF_CRC)+(ho.BSC_I_UNSUCC_A_INT_CIRC_TYPE + ho.MSC_
umber(DECODE(100, 0, 0, resavail.tch_cong_time/100)) "K025",
umber((100- 100*(DECODE((traffic.TCH_NORM_SEIZ+ ho.BSC_I_SDCCH_TCH+ ho.MSC_I_SDCCH_TCH+ho.CELL_SDCCH_TCH -
umber(100*DECODE(service.TCH_NEW_CALL_ASSIGN, 0, 0, (service.TCH_NEW_CALL_ASSIGN -(traffic.DROP_AFTER_TCH_ASS
umber(service.TCH_NEW_CALL_ASSIGN -(traffic.DROP_AFTER_TCH_ASSIGN - service.TCH_RE_EST_ASSIGN)) "K124",
umber(service.TCH_NEW_CALL_ASSIGN) "K125",
umber(100*DECODE((service.TCH_NEW_CALL_ASSIGN+ho.MSC_I_SUCC_HO + ho.BSC_I_SUCC_HO-(ho.MSC_O_SUCC_HO + h
umber(traffic.DROP_AFTER_TCH_ASSIGN) "K028",
umber(service.TCH_NEW_CALL_ASSIGN+ho.MSC_I_SUCC_HO + ho.BSC_I_SUCC_HO-(ho.MSC_O_SUCC_HO + ho.BSC_O_SUC
umber((traffic.DROP_AFTER_TCH_ASSIGN)) "K030",
umber(100*DECODE((rxstat.FREQ_DL_QUAL0+rxstat.FREQ_DL_QUAL1+rxstat.FREQ_DL_QUAL2+rxstat.FREQ_DL_QUAL3+rxstat.
umber(100*DECODE((rxstat.FREQ_UL_QUAL0+rxstat.FREQ_UL_QUAL1+rxstat.FREQ_UL_QUAL2+rxstat.FREQ_UL_QUAL3+rxstat.
umber(DECODE((power_ext.AVE_SUM_IDLE_TCH_PER_TRX),0,0,(power_ext.AVE_SUM_IDLE_CH_INTERF/(power_ext.AVE_SUM_
umber(100 *(DECODE((traffic.MSC_O_HO_CMD + traffic.BSC_O_HO_CMD_ASSGN), 0, 0, (ho.MSC_O_SUCC_HO + ho.BSC_O_SU
umber(ho.MSC_O_SUCC_HO + ho.BSC_O_SUCC_HO) "K035",
umber(traffic.MSC_O_HO_CMD + traffic.BSC_O_HO_CMD_ASSGN) "K036",
umber(DECODE(pcu.req_1_tsl_dl+pcu.req_2_tsl_dl+pcu.req_3_tsl_dl+pcu.req_4_tsl_dl+pcu.req_5_tsl_dl+pcu.req_6_tsl_dl+pcu.req_7
umber(100 -(DECODE((pcu.req_1_tsl_dl + pcu.req_2_tsl_dl + pcu.req_3_tsl_dl + pcu.req_4_tsl_dl + pcu.req_5_tsl_dl + pcu.req_6_tsl_d
umber(pcu.no_radio_res_ava_dl_tbf+ pcu.dl_tbf_establishment_failed+pcu.no_radio_res_ava_ul_tbf+ pcu.ul_tbf_establishment_failed)
umber(pcu.req_1_tsl_dl + pcu.req_2_tsl_dl + pcu.req_3_tsl_dl + pcu.req_4_tsl_dl + pcu.req_5_tsl_dl + pcu.req_6_tsl_dl + pcu.req_7_ts
umber(100 -(DECODE((pcu.req_1_tsl_dl + pcu.req_2_tsl_dl + pcu.req_3_tsl_dl + pcu.req_4_tsl_dl + pcu.req_5_tsl_dl + pcu.req_6_tsl_d
umber(pcu.no_radio_res_ava_dl_tbf + pcu.dl_tbf_establishment_failed) "K039",
umber(pcu.req_1_tsl_dl + pcu.req_2_tsl_dl + pcu.req_3_tsl_dl + pcu.req_4_tsl_dl + pcu.req_5_tsl_dl + pcu.req_6_tsl_dl + pcu.req_7_ts
umber(100 -(DECODE((pcu.req_1_tsl_ul + pcu.req_2_tsl_ul + pcu.req_3_tsl_ul + pcu.req_4_tsl_ul + pcu.req_5_tsl_ul + pcu.req_6_tsl_u
umber(pcu.no_radio_res_ava_ul_tbf + pcu.ul_tbf_establishment_failed) "K042",
umber(pcu.req_1_tsl_ul + pcu.req_2_tsl_ul + pcu.req_3_tsl_ul + pcu.req_4_tsl_ul + pcu.req_5_tsl_ul + pcu.req_6_tsl_ul + pcu.req_7_ts
umber(100*DECODE(((pcu.ave_dur_ul_tbf_den + pcu.ave_dur_dl_tbf_den -pcu.ul_tbf_rel_due_to_flush - pcu.dl_tbf_rel_due_to_flush -
umber(pcu.ave_dur_ul_tbf_den + pcu.ave_dur_dl_tbf_den + pcu.UL_TBF_RELEASES_DUE_DTM + pcu.DL_TBF_RELEASES_DUE_D
umber(pcu.ave_dur_ul_tbf_den+pcu.ave_dur_dl_tbf_den -pcu.ul_tbf_rel_due_to_flush - pcu.dl_tbf_rel_due_to_flush - pcu.ul_tbf_rel_du
umber(DECODE((pcu.alloc_1_tsl_dl + pcu.alloc_2_tsl_dl + pcu.alloc_3_tsl_dl + pcu.alloc_4_tsl_dl), 0, 0, (pcu.alloc_1_tsl_dl + 2 * pcu.a
umber(DECODE((pcu.alloc_1_tsl_dl + pcu.alloc_2_tsl_dl + pcu.alloc_3_tsl_dl + pcu.alloc_4_tsl_dl), 0, 0, (pcu.alloc_1_tsl_dl + 2 * pcu.a
umber(0.4*DECODE(((codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_1 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_1 + coding
umber(0.4*DECODE((DECODE(2, 0, 0, ((codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_7 + codingsc.DL_RLC_BLOCKS_IN_UNACK_
umber(DECODE((resavail.ave_avail_tch_den),0,NULL,(resavail.ave_avail_tch_sum/resavail.ave_avail_tch_den))) "K048",
umber(pcu.ave_dur_dl_tbf_den) "K049",
umber((pcu.ave_dur_dl_tbf_sum)) "K050",
umber(pcu.AVE_DUR_UL_TBF_DEN) "AVE_DUR_UL_TBF_DEN",
umber(pcu.AVE_DUR_UL_TBF_SUM) "AVE_DUR_UL_TBF_SUM",
umber(DECODE((resavail.ave_gprs_channels_den),0,NULL,(resavail.ave_gprs_channels_sum/resavail.ave_gprs_channels_den))) "ns
umber(resavail.AVE_AVAIL_TCH_DEN) "AVE_AVAIL_TCH_DEN",
umber(resavail.AVE_AVAIL_TCH_SUM) "AVE_AVAIL_TCH_SUM",
umber(resavail.AVE_BUSY_TCH) "AVE_BUSY_TCH",
_SEIZ)-(traffic.SDCCH_RADIO_FAIL + traffic.SDCCH_A_IF_FAIL_CALL + traffic.SDCCH_ABIS_FAIL_CALL + traffic.SDCCH_USER_A
_A_IF_FAIL_CALL + traffic.SDCCH_ABIS_FAIL_CALL + traffic.SDCCH_USER_ACT + traffic.SDCCH_BCSU_RESET + traffic.SDCCH_
CCH_A_IF_FAIL_CALL + traffic.SDCCH_ABIS_FAIL_CALL + traffic.SDCCH_USER_ACT + traffic.SDCCH_BCSU_RESET + traffic.SDC
_SEIZ)-(traffic.SDCCH_RADIO_FAIL + traffic.SDCCH_A_IF_FAIL_CALL + traffic.SDCCH_ABIS_FAIL_CALL + traffic.SDCCH_USER_A

CCH_A_IF_FAIL_CALL + traffic.SDCCH_ABIS_FAIL_CALL + traffic.SDCCH_USER_ACT + traffic.SDCCH_BCSU_RESET + traffic.SDC
CALL + traffic.SDCCH_USER_ACT + traffic.SDCCH_BCSU_RESET + traffic.SDCCH_NETW_ACT + traffic.SDCCH_BTS_FAIL + traffic.

BSC_I_UNSUCC_A_INT_CIRC_TYPE + ho.MSC_CONTROLLED_IN_HO + ho.HO_UNSUCC_A_INT_CIRC_TYPE)), 0, 0, ((traffic.TCH
C - traffic.TCH_REJ_DUE_REQ_CH_A_IF_CRC)-(ho.MSC_O_SDCCH_TCH + ho.BSC_O_SDCCH_TCH + ho.CELL_SDCCH_TCH - h
_A_INT_CIRC_TYPE + ho.MSC_CONTROLLED_IN_HO + ho.HO_UNSUCC_A_INT_CIRC_TYPE)) "K024",
H_TCH+ho.CELL_SDCCH_TCH - traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+ traffic.TCH_SEIZ_DUE_SDCCH_CON+ho.BSC_I_TCH_T

(traffic.DROP_AFTER_TCH_ASSIGN - service.TCH_RE_EST_ASSIGN))/service.TCH_NEW_CALL_ASSIGN)) "K088",
EST_ASSIGN)) "K124",
_HO-(ho.MSC_O_SUCC_HO + ho.BSC_O_SUCC_HO)), 0, 0, traffic.DROP_AFTER_TCH_ASSIGN/(service.TCH_NEW_CALL_ASSIG
O_SUCC_HO + ho.BSC_O_SUCC_HO)) "K029",
rxstat.FREQ_DL_QUAL3+rxstat.FREQ_DL_QUAL4+rxstat.FREQ_DL_QUAL5+rxstat.FREQ_DL_QUAL6+rxstat.FREQ_DL_QUAL7),0,
rxstat.FREQ_UL_QUAL3+rxstat.FREQ_UL_QUAL4+rxstat.FREQ_UL_QUAL5+rxstat.FREQ_UL_QUAL6+rxstat.FREQ_UL_QUAL7),0,
_INTERF/(power_ext.AVE_SUM_IDLE_TCH_PER_TRX))+1)) "K033",
_O_SUCC_HO + ho.BSC_O_SUCC_HO)/(traffic.MSC_O_HO_CMD + traffic.BSC_O_HO_CMD_ASSGN)))) "K034",
_dl+pcu.req_6_tsl_dl+pcu.req_7_tsl_dl+pcu.req_8_tsl_dl+pcu.REQ_9_TSL_DL+pcu.REQ_10_TSL_DL+pcu.REQ_11_TSL_DL+pcu.RE
cu.req_5_tsl_dl + pcu.req_6_tsl_dl + pcu.req_7_tsl_dl + pcu.req_8_tsl_dl+pcu.req_1_tsl_ul + pcu.req_2_tsl_ul + pcu.req_3_tsl_ul + pcu
pcu.ul_tbf_establishment_failed) "K104",
pcu.req_6_tsl_dl + pcu.req_7_tsl_dl + pcu.req_8_tsl_dl+pcu.req_1_tsl_ul + pcu.req_2_tsl_ul + pcu.req_3_tsl_ul + pcu.req_4_tsl_ul + pc
cu.req_5_tsl_dl + pcu.req_6_tsl_dl + pcu.req_7_tsl_dl + pcu.req_8_tsl_dl), 0, 0, (100*(pcu.no_radio_res_ava_dl_tbf + pcu.dl_tbf_establi
pcu.req_6_tsl_dl + pcu.req_7_tsl_dl + pcu.req_8_tsl_dl) "K040",

cu.req_5_tsl_ul + pcu.req_6_tsl_ul + pcu.req_7_tsl_ul + pcu.req_8_tsl_ul), 0, 0, (100*(pcu.no_radio_res_ava_ul_tbf+ pcu.ul_tbf_establis
pcu.req_6_tsl_ul + pcu.req_7_tsl_ul + pcu.req_8_tsl_ul) "K043",

sh - pcu.dl_tbf_rel_due_to_flush - pcu.ul_tbf_rel_due_to_suspend -pcu.dl_tbf_rel_due_to_suspend + pcu.UL_TBF_RELEASES_DUE_D
pcu.DL_TBF_RELEASES_DUE_DTM-pcu.ul_tbf_rel_due_to_flush -pcu.dl_tbf_rel_due_to_flush - pcu.ul_tbf_rel_due_to_suspend -pcu.d
_due_to_flush - pcu.ul_tbf_rel_due_to_suspend -pcu.dl_tbf_rel_due_to_suspend + pcu.UL_TBF_RELEASES_DUE_DTM + pcu.DL_TB
0, (pcu.alloc_1_tsl_dl + 2 * pcu.alloc_2_tsl_dl + 3 * pcu.alloc_3_tsl_dl+ 4 * pcu.alloc_4_tsl_dl)/(pcu.alloc_1_tsl_dl + pcu.alloc_2_tsl_dl +
0, (pcu.alloc_1_tsl_dl + 2 * pcu.alloc_2_tsl_dl + 3 * pcu.alloc_3_tsl_dl+ 4 * pcu.alloc_4_tsl_dl)/(pcu.alloc_1_tsl_dl + pcu.alloc_2_tsl_dl +
S_IN_UNACK_MODE_1 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_1)+(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_2 + codin
DL_RLC_BLOCKS_IN_UNACK_MODE_7 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_7)+(codingsc.DL_RLC_BLOCKS_IN_ACK
_tch_den))) "K048",
il.ave_gprs_channels_den))) "nsn_tinem14",
_CALL + traffic.SDCCH_USER_ACT + traffic.SDCCH_BCSU_RESET + traffic.SDCCH_NETW_ACT + traffic.SDCCH_BTS_FAIL + traff
BCSU_RESET + traffic.SDCCH_NETW_ACT + traffic.SDCCH_BTS_FAIL + traffic.SDCCH_LAPD_FAIL + traffic.SDCCH_RF_OLD_HO
CCH_BCSU_RESET + traffic.SDCCH_NETW_ACT + traffic.SDCCH_BTS_FAIL + traffic.SDCCH_LAPD_FAIL + traffic.SDCCH_RF_OLD
_CALL + traffic.SDCCH_USER_ACT + traffic.SDCCH_BCSU_RESET + traffic.SDCCH_NETW_ACT + traffic.SDCCH_BTS_FAIL + traff

CCH_BCSU_RESET + traffic.SDCCH_NETW_ACT + traffic.SDCCH_BTS_FAIL + traffic.SDCCH_LAPD_FAIL + traffic.SDCCH_RF_OLD
affic.SDCCH_BTS_FAIL + traffic.SDCCH_LAPD_FAIL + traffic.SDCCH_RF_OLD_HO + traffic.SDCCH_ABIS_FAIL_OLD -service.T310

_CIRC_TYPE)), 0, 0, ((traffic.TCH_CALL_REQ - traffic.TCH_NORM_SEIZ + traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC - traffic.TCH_RE
CH + ho.CELL_SDCCH_TCH - ho.BSC_I_UNSUCC_A_INT_CIRC_TYPE - ho.MSC_CONTROLLED_IN_HO - ho.HO_UNSUCC_A_IN
SDCCH_CON+ho.BSC_I_TCH_TCH+ ho.MSC_I_TCH_TCH - service.TCH_RE_EST_ASSIGN), 0, 0, (traffic.TCH_RADIO_FAIL+traffic

ASSIGN)) "K088",
ervice.TCH_NEW_CALL_ASSIGN+ho.MSC_I_SUCC_HO + ho.BSC_I_SUCC_HO-(ho.MSC_O_SUCC_HO + ho.BSC_O_SUCC_HO))
L6+rxstat.FREQ_DL_QUAL7),0,NULL,(rxstat.FREQ_DL_QUAL0+rxstat.FREQ_DL_QUAL1+rxstat.FREQ_DL_QUAL2+rxstat.FREQ_D
L6+rxstat.FREQ_UL_QUAL7),0,NULL,(rxstat.FREQ_UL_QUAL0+rxstat.FREQ_UL_QUAL1+rxstat.FREQ_UL_QUAL2+rxstat.FREQ_U
GN)))) "K034",
L+pcu.REQ_11_TSL_DL+pcu.REQ_12_TSL_DL,0,0,100*pcu.no_radio_res_ava_dl_tbf/(pcu.req_1_tsl_dl+pcu.req_2_tsl_dl+pcu.req_3_
2_tsl_ul + pcu.req_3_tsl_ul + pcu.req_4_tsl_ul + pcu.req_5_tsl_ul + pcu.req_6_tsl_ul + pcu.req_7_tsl_ul + pcu.req_8_tsl_ul), 0, 0, (100*
q_3_tsl_ul + pcu.req_4_tsl_ul + pcu.req_5_tsl_ul + pcu.req_6_tsl_ul + pcu.req_7_tsl_ul + pcu.req_8_tsl_ul) "K105",

s_ava_dl_tbf + pcu.dl_tbf_establishment_failed))/(pcu.req_1_tsl_dl + pcu.req_2_tsl_dl + pcu.req_3_tsl_dl + pcu.req_4_tsl_dl + pcu.req_
s_ava_ul_tbf+ pcu.ul_tbf_establishment_failed))/(pcu.req_1_tsl_ul + pcu.req_2_tsl_ul + pcu.req_3_tsl_ul + pcu.req_4_tsl_ul + pcu.req_
cu.UL_TBF_RELEASES_DUE_DTM + pcu.DL_TBF_RELEASES_DUE_DTM +pcu.ul_tbf_rel_due_csw_traffic +pcu.dl_tbf_rel_due_csw

ul_tbf_rel_due_to_suspend -pcu.dl_tbf_rel_due_to_suspend) "K101",
EASES_DUE_DTM + pcu.DL_TBF_RELEASES_DUE_DTM +pcu.ul_tbf_rel_due_csw_traffic +pcu.dl_tbf_rel_due_csw_traffic +pcu.ul_tb
c_1_tsl_dl + pcu.alloc_2_tsl_dl + pcu.alloc_3_tsl_dl + pcu.alloc_4_tsl_dl))*DECODE(DECODE(50, 0, 0, (codingsc.DL_RLC_BLOCKS_
c_1_tsl_dl + pcu.alloc_2_tsl_dl + pcu.alloc_3_tsl_dl + pcu.alloc_4_tsl_dl))*DECODE((DECODE(50, 0, 0, (pcu.rlc_data_blocks_dl_cs1 +
OCKS_IN_ACK_MODE_2 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_2 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_2)+
ngsc.DL_RLC_BLOCKS_IN_ACK_MODE_8 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_8 + codingsc.RETRANS_RLC_DATA_
traffic.SDCCH_BTS_FAIL + traffic.SDCCH_LAPD_FAIL + traffic.SDCCH_RF_OLD_HO + traffic.SDCCH_ABIS_FAIL_OLD -service.T31
L + traffic.SDCCH_RF_OLD_HO + traffic.SDCCH_ABIS_FAIL_OLD -service.T3101_EXPIRED+ traffic.SDCCH_A_IF_FAIL_OLD)/(traffi
D_FAIL + traffic.SDCCH_RF_OLD_HO + traffic.SDCCH_ABIS_FAIL_OLD -service.T3101_EXPIRED+ traffic.SDCCH_A_IF_FAIL_OLD))
traffic.SDCCH_BTS_FAIL + traffic.SDCCH_LAPD_FAIL + traffic.SDCCH_RF_OLD_HO + traffic.SDCCH_ABIS_FAIL_OLD+ traffic.SDC

D_FAIL + traffic.SDCCH_RF_OLD_HO + traffic.SDCCH_ABIS_FAIL_OLD+ traffic.SDCCH_A_IF_FAIL_OLD)) "K113",
_ABIS_FAIL_OLD -service.T3101_EXPIRED+ traffic.SDCCH_A_IF_FAIL_OLD) "K021",

FOR_DIR_ACC - traffic.TCH_REJ_DUE_REQ_CH_A_IF_CRC)-(ho.MSC_O_SDCCH_TCH + ho.BSC_O_SDCCH_TCH + ho.CELL_SD
IN_HO - ho.HO_UNSUCC_A_INT_CIRC_TYPE)) "K023",
(traffic.TCH_RADIO_FAIL+traffic.TCH_RF_OLD_HO+ traffic.TCH_ABIS_FAIL_CALL+traffic.TCH_ABIS_FAIL_OLD+traffic.TCH_A_IF_F
C_HO + ho.BSC_O_SUCC_HO)))) "K027",
EQ_DL_QUAL2+rxstat.FREQ_DL_QUAL3+rxstat.FREQ_DL_QUAL4+rxstat.FREQ_DL_QUAL5)/(rxstat.FREQ_DL_QUAL0+rxstat.FRE
EQ_UL_QUAL2+rxstat.FREQ_UL_QUAL3+rxstat.FREQ_UL_QUAL4+rxstat.FREQ_UL_QUAL5)/(rxstat.FREQ_UL_QUAL0+rxstat.FRE
_dl+pcu.req_2_tsl_dl+pcu.req_3_tsl_dl+pcu.req_4_tsl_dl+pcu.req_5_tsl_dl+pcu.req_6_tsl_dl+pcu.req_7_tsl_dl+pcu.req_8_tsl_dl+pcu.R
ul + pcu.req_8_tsl_ul), 0, 0, (100*(pcu.no_radio_res_ava_dl_tbf+ pcu.dl_tbf_establishment_failed+pcu.no_radio_res_ava_ul_tbf+ pcu.ul
_ul) "K105",
_dl + pcu.req_4_tsl_dl + pcu.req_5_tsl_dl + pcu.req_6_tsl_dl + pcu.req_7_tsl_dl + pcu.req_8_tsl_dl)))) "K038",
ul + pcu.req_4_tsl_ul + pcu.req_5_tsl_ul + pcu.req_6_tsl_ul + pcu.req_7_tsl_ul + pcu.req_8_tsl_ul)))) "K041",
w_traffic +pcu.dl_tbf_rel_due_csw_traffic +pcu.ul_tbf_rel_due_no_resp_ms + pcu.dl_tbf_rel_due_no_resp_ms)), 0, 0, (pcu.ave_dur_ul_
bf_rel_due_csw_traffic +pcu.ul_tbf_rel_due_no_resp_ms + pcu.dl_tbf_rel_due_no_resp_ms) "K102",

0, (codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_1+ codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_1 + codingsc.DL_RLC_BLOCK
0, (pcu.rlc_data_blocks_dl_cs1 + pcu.rlc_data_blocks_dl_cs2 + pcu.rlc_mac_cntrl_blocks_dl + pcu.retra_rlc_data_blocks_dl_cs1 + pcu
S_RLC_DATA_BLOCKS_DL_2)+(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_3 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_
codingsc.RETRANS_RLC_DATA_BLOCKS_DL_8)+(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_9 + codingsc.DL_RLC_BLOCKS_IN
H_ABIS_FAIL_OLD -service.T3101_EXPIRED+ traffic.SDCCH_A_IF_FAIL_OLD))/(traffic.SDCCH_SEIZ_ATT))) "K016",
SDCCH_A_IF_FAIL_OLD)/(traffic.SDCCH_SEIZ_ATT))) "K018",
raffic.SDCCH_A_IF_FAIL_OLD)) "K019",
H_ABIS_FAIL_OLD+ traffic.SDCCH_A_IF_FAIL_OLD))/(traffic.SDCCH_SEIZ_ATT))) "K111",

OLD)) "K113",
_O_SDCCH_TCH + ho.CELL_SDCCH_TCH - ho.BSC_I_UNSUCC_A_INT_CIRC_TYPE - ho.MSC_CONTROLLED_IN_HO - ho.HO_U
S_FAIL_OLD+traffic.TCH_A_IF_FAIL_CALL+traffic.TCH_A_IF_FAIL_OLD+ traffic.TCH_TR_FAIL+traffic.TCH_TR_FAIL_OLD+ traffic.TC
at.FREQ_DL_QUAL0+rxstat.FREQ_DL_QUAL1+rxstat.FREQ_DL_QUAL2+rxstat.FREQ_DL_QUAL3+rxstat.FREQ_DL_QUAL4+rxstat.F
at.FREQ_UL_QUAL0+rxstat.FREQ_UL_QUAL1+rxstat.FREQ_UL_QUAL2+rxstat.FREQ_UL_QUAL3+rxstat.FREQ_UL_QUAL4+rxstat.F
7_tsl_dl+pcu.req_8_tsl_dl+pcu.REQ_9_TSL_DL+pcu.REQ_10_TSL_DL+pcu.REQ_11_TSL_DL+pcu.REQ_12_TSL_DL))) "K037",
no_radio_res_ava_ul_tbf+ pcu.ul_tbf_establishment_failed))/(pcu.req_1_tsl_dl + pcu.req_2_tsl_dl + pcu.req_3_tsl_dl + pcu.req_4_tsl_d
esp_ms)), 0, 0, (pcu.ave_dur_ul_tbf_den + pcu.ave_dur_dl_tbf_den + pcu.UL_TBF_RELEASES_DUE_DTM + pcu.DL_TBF_RELEASE
E_1 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_2 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_2 + codingsc.DL_RLC_BLO

ra_rlc_data_blocks_dl_cs1 + pcu.retra_rlc_data_blocks_dl_cs2)/50)), 0, 0, (DECODE(1000, 0, 0, ((pcu.rlc_data_blocks_dl_cs1 * 23 + p
C_BLOCKS_IN_UNACK_MODE_3 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_3)+(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE
+ codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_9 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_9))/2)), 0, 0, ((codingsc.DL_RL
IZ_ATT))) "K016",
ONTROLLED_IN_HO - ho.HO_UNSUCC_A_INT_CIRC_TYPE))/((traffic.TCH_CALL_REQ - traffic.TCH_REJ_DUE_REQ_CH_A_IF_CR
c.TCH_TR_FAIL_OLD+ traffic.TCH_LAPD_FAIL+ traffic.TCH_BTS_FAIL+ traffic.TCH_USER_ACT+ traffic.TCH_BCSU_RESET+traffic
xstat.FREQ_DL_QUAL4+rxstat.FREQ_DL_QUAL5+rxstat.FREQ_DL_QUAL6+rxstat.FREQ_DL_QUAL7))) "K031",
xstat.FREQ_UL_QUAL4+rxstat.FREQ_UL_QUAL5+rxstat.FREQ_UL_QUAL6+rxstat.FREQ_UL_QUAL7))) "K032",
REQ_12_TSL_DL))) "K037",
u.req_3_tsl_dl + pcu.req_4_tsl_dl + pcu.req_5_tsl_dl + pcu.req_6_tsl_dl + pcu.req_7_tsl_dl + pcu.req_8_tsl_dl+pcu.req_1_tsl_ul + pcu.r
_DTM + pcu.DL_TBF_RELEASES_DUE_DTM-pcu.ul_tbf_rel_due_to_flush -pcu.dl_tbf_rel_due_to_flush - pcu.ul_tbf_rel_due_to_suspe
ODE_2 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_3 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_3 + codingsc.DL_RLC_B

.rlc_data_blocks_dl_cs1 * 23 + pcu.rlc_data_blocks_dl_cs2 * 33 + pcu.rlc_mac_cntrl_blocks_dl * 23 + pcu.retra_rlc_data_blocks_dl_cs1
_RLC_BLOCKS_IN_ACK_MODE_4 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_4 + codingsc.RETRANS_RLC_DATA_BLOCK
L_9))/2)), 0, 0, ((codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_7 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_7 + codingsc.RE
H_REJ_DUE_REQ_CH_A_IF_CRC)+(ho.BSC_I_UNSUCC_A_INT_CIRC_TYPE + ho.MSC_CONTROLLED_IN_HO + ho.HO_UNSUCC
affic.TCH_BCSU_RESET+traffic.TCH_NETW_ACT+ traffic.TCH_ACT_FAIL_CALL- service.TCH_RE_EST_ASSIGN)/(traffic.TCH_NOR
L7))) "K031",
L7))) "K032",
8_tsl_dl+pcu.req_1_tsl_ul + pcu.req_2_tsl_ul + pcu.req_3_tsl_ul + pcu.req_4_tsl_ul + pcu.req_5_tsl_ul + pcu.req_6_tsl_ul + pcu.req_7_
sh - pcu.ul_tbf_rel_due_to_suspend -pcu.dl_tbf_rel_due_to_suspend)/((pcu.ave_dur_ul_tbf_den + pcu.ave_dur_dl_tbf_den -pcu.ul_tbf_
_MODE_3 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_4 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_4 + codingsc.DL_RL

pcu.retra_rlc_data_blocks_dl_cs1 * 23 + pcu.retra_rlc_data_blocks_dl_cs2 * 33)* 8)/1000))/(DECODE(50, 0, 0, (pcu.rlc_data_blocks_dl
.RETRANS_RLC_DATA_BLOCKS_DL_4)+(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_5 + codingsc.DL_RLC_BLOCKS_IN_UNAC
UNACK_MODE_7 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_7)*56 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_8 + coding
LLED_IN_HO + ho.HO_UNSUCC_A_INT_CIRC_TYPE))))) "K022",
_EST_ASSIGN)/(traffic.TCH_NORM_SEIZ+ ho.BSC_I_SDCCH_TCH+ ho.MSC_I_SDCCH_TCH+ho.CELL_SDCCH_TCH - traffic.TCH_
+ pcu.req_6_tsl_ul + pcu.req_7_tsl_ul + pcu.req_8_tsl_ul)))) "K103",
.ave_dur_dl_tbf_den -pcu.ul_tbf_rel_due_to_flush - pcu.dl_tbf_rel_due_to_flush - pcu.ul_tbf_rel_due_to_suspend -pcu.dl_tbf_rel_due_
CK_MODE_4 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_5 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_5 + codingsc.DL_

(50, 0, 0, (pcu.rlc_data_blocks_dl_cs1 + pcu.rlc_data_blocks_dl_cs2 + pcu.rlc_mac_cntrl_blocks_dl + pcu.retra_rlc_data_blocks_dl_cs1
sc.DL_RLC_BLOCKS_IN_UNACK_MODE_5 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_5)+(codingsc.DL_RLC_BLOCKS_IN_A
CKS_IN_ACK_MODE_8 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_8 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_8)*68
ELL_SDCCH_TCH - traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+ traffic.TCH_SEIZ_DUE_SDCCH_CON+ho.BSC_I_TCH_TCH+ ho.MS
o_suspend -pcu.dl_tbf_rel_due_to_suspend + pcu.UL_TBF_RELEASES_DUE_DTM + pcu.DL_TBF_RELEASES_DUE_DTM +pcu.ul_
NACK_MODE_5 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_6 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_6 + codingsc.R

pcu.retra_rlc_data_blocks_dl_cs1 + pcu.retra_rlc_data_blocks_dl_cs2)/50)))) "K045",
odingsc.DL_RLC_BLOCKS_IN_ACK_MODE_6 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_6 + codingsc.RETRANS_RLC_DAT
RLC_DATA_BLOCKS_DL_8)*68 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_9 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE
N+ho.BSC_I_TCH_TCH+ ho.MSC_I_TCH_TCH - service.TCH_RE_EST_ASSIGN))))) "K026",
RELEASES_DUE_DTM +pcu.ul_tbf_rel_due_csw_traffic +pcu.dl_tbf_rel_due_csw_traffic +pcu.ul_tbf_rel_due_no_resp_ms + pcu.dl_tbf
N_UNACK_MODE_6 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_1 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_2 + coding
+ codingsc.RETRANS_RLC_DATA_BLOCKS_DL_6)), 0, 0, ((codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_1 + codingsc.DL_RLC_BL

LC_BLOCKS_IN_UNACK_MODE_9 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_9)*74)/(DECODE(2, 0, 0, ((codingsc.DL_RLC_B
el_due_no_resp_ms + pcu.dl_tbf_rel_due_no_resp_ms)))) "K100",
_DATA_BLOCKS_DL_2 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_3 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_4 + cod
MODE_1 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_1 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_1)*22 +(codingsc.DL_

DE(2, 0, 0, ((codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_7 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_7 + codingsc.RETRA
LC_DATA_BLOCKS_DL_4 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_5 + codingsc.RETRANS_RLC_...
OCKS_DL_1)*22 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_2 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_2 + codingsc.

CK_MODE_7 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_7)+(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_8 + codingsc.DL_R
N_UNACK_MODE_2 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_2)*28 +(codingsc.DL_R...
ACK_MODE_8 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_8 + codingsc.R...
to_number(resavail.ave_gprs_c
to_number(resavail.ave_gprs_c
to_number(resavail.AVE_NON_
to_number(resavail.NON_AVAIL
to_number(100*DECODE(traffic
to_number(traffic.SDCCH_BUS
to_number(service.T3101_EXP
to_number(traffic.TCH_REQUE
to_number(resacc.TCH_MOC) "
to_number(resacc.TCH_MTC) "
to_number(resacc.DELETE_PA
to_number(ho.CELL_SDCCH_T
to_number(ho.CELL_SDCCH_T
to_number(ho.CELL_TCH_TCH
to_number(ho.CELL_TCH_TCH
to_number(traffic_ext.TCH_CAL
to_number(traffic.TCH_NORM_
to_number(service.TCH_RE_ES
to_number(ho.BSC_I_SUCC_H
to_number(ho.BSC_I_TCH_TC
to_number(traffic.BSC_O_HO_C
to_number(ho.BSC_O_SUCC_H
to_number(ho.BSC_O_TCH_TC
to_number(ho.MSC_CONTROL
to_number(ho.MSC_I_SUCC_H
to_number(ho.MSC_I_TCH_TC
umber(resavail.ave_gprs_channels_den) "AVE_GPRS_CHANNELS_DEN",
umber(resavail.ave_gprs_channels_sum) "AVE_GPRS_CHANNELS_SUM",
umber(resavail.AVE_NON_AVAIL_TCH_TIMESLOT) "AVE_NON_AVAIL_TCH_TIMESLOT",
umber(resavail.NON_AVAIL_TCH_DENOM) "NON_AVAIL_TCH_DENOM",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_RADIO_FAIL/traffic.SDCCH_SEIZ_ATT)) "K051",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_RF_OLD_HO/traffic.SDCCH_SEIZ_ATT)) "K052",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_ABIS_FAIL_CALL/traffic.SDCCH_SEIZ_ATT)) "K053",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_ABIS_FAIL_OLD/traffic.SDCCH_SEIZ_ATT)) "K054",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_A_IF_FAIL_CALL/traffic.SDCCH_SEIZ_ATT)) "K055",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_A_IF_FAIL_OLD/traffic.SDCCH_SEIZ_ATT)) "K056",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_BTS_FAIL/traffic.SDCCH_SEIZ_ATT)) "K057",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_BCSU_RESET/traffic.SDCCH_SEIZ_ATT)) "K058",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_LAPD_FAIL/traffic.SDCCH_SEIZ_ATT)) "K059",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_NETW_ACT/traffic.SDCCH_SEIZ_ATT)) "K060",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_USER_ACT/traffic.SDCCH_SEIZ_ATT)) "K061",
umber(100*DECODE(traffic.SDCCH_SEIZ_ATT, 0, 0, traffic.SDCCH_HO_SEIZ/traffic.SDCCH_SEIZ_ATT)) "K063",
umber(traffic.SDCCH_BUSY_ATT) "K064",
umber(service.T3101_EXPIRED) "K066",
umber(traffic.TCH_REQUESTS_CALL_ATTEMPT) "TCH_REQUESTS_CALL_ATTEMPT",
umber(resacc.TCH_MOC) "TCH_MOC",
umber(resacc.TCH_MTC) "TCH_MTC",
umber(resacc.DELETE_PAGING_COMMAND) "DELETE_PAGING_COMMAND",
umber(ho.CELL_SDCCH_TCH) "CELL_SDCCH_TCH",
umber(ho.CELL_SDCCH_TCH_AT) "CELL_SDCCH_TCH_AT",
umber(ho.CELL_TCH_TCH) "CELL_TCH_TCH",
umber(ho.CELL_TCH_TCH_AT) "CELL_TCH_TCH_AT",
umber(traffic_ext.TCH_CALL_REQ) "TCH_CALL_REQ",
umber(service.TCH_NEW_CALL_ASSIGN) "TCH_NEW_CALL_ASSIGN",
umber(traffic.TCH_NORM_SEIZ) "TCH_NORM_SEIZ",
umber(service.TCH_RE_EST_ASSIGN) "TCH_RE_EST_ASSIGN",
umber(100*DECODE((traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDCCH_TCH-traffic.TC
umber(traffic.MSC_O_HO_CMD + traffic.BSC_O_HO_CMD_ASSGN) "K081",
umber(ho.BSC_I_SUCC_HO) "BSC_I_SUCC_HO",
umber(ho.BSC_I_TCH_TCH) "BSC_I_TCH_TCH",
umber(traffic.BSC_O_HO_CMD_ASSGN) "BSC_O_HO_CMD_ASSGN",
umber(ho.BSC_O_SUCC_HO) "BSC_O_SUCC_HO",
umber(ho.BSC_O_TCH_TCH) "BSC_O_TCH_TCH",
umber(ho.MSC_CONTROLLED_IN_HO) "MSC_CONTROLLED_IN_HO",
umber(ho.MSC_I_SUCC_HO) "MSC_I_SUCC_HO",
umber(ho.MSC_I_TCH_TCH) "MSC_I_TCH_TCH",
Z_ATT)) "K051",
Z_ATT)) "K052",
_SEIZ_ATT)) "K053",
SEIZ_ATT)) "K054",
_SEIZ_ATT)) "K055",
SEIZ_ATT)) "K056",
ATT)) "K057",
EIZ_ATT)) "K058",
_ATT)) "K059",
Z_ATT)) "K060",
_ATT)) "K061",
ATT)) "K063",
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_RADIO_F
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_RF_OLD_
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_ABIS_FA
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_ABIS_FA
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_A_IF_FAI
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_TR_FAIL/
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_A_IF_FAI
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_ACT_FAI
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_BCSU_R
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_BTS_FAIL
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_LAPD_FA
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_NETW_A
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_TR_FAIL_
ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON), 0, 0, traffic.TCH_USER_AC
CON), 0, 0, traffic.TCH_RADIO_FAIL/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDCCH
CON), 0, 0, traffic.TCH_RF_OLD_HO/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDCCH
CON), 0, 0, traffic.TCH_ABIS_FAIL_CALL/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SD
CON), 0, 0, traffic.TCH_ABIS_FAIL_OLD/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDC
CON), 0, 0, traffic.TCH_A_IF_FAIL_CALL/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SD
CON), 0, 0, traffic.TCH_TR_FAIL/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDCCH_TC
CON), 0, 0, traffic.TCH_A_IF_FAIL_OLD/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDC
CON), 0, 0, traffic.TCH_ACT_FAIL_CALL/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDC
CON), 0, 0, traffic.TCH_BCSU_RESET/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDCC
CON), 0, 0, traffic.TCH_BTS_FAIL/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDCCH_T
CON), 0, 0, traffic.TCH_LAPD_FAIL/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDCCH_
CON), 0, 0, traffic.TCH_NETW_ACT/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDCCH
CON), 0, 0, traffic.TCH_TR_FAIL_OLD/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDCC
CON), 0, 0, traffic.TCH_USER_ACT/(traffic.TCH_NORM_SEIZ+ho.MSC_I_SDCCH_TCH+ho.BSC_I_SDCCH_TCH+ho.CELL_SDCCH_
SDCCH_TCH+ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON))) "K076",
C_I_SDCCH_TCH+ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON))) "K067
C_I_SDCCH_TCH+ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON))) "K068"
CH_TCH+ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON))) "K078",
_I_SDCCH_TCH+ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON))) "K071"
I_SDCCH_TCH+ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON))) "K072",
CCH_TCH+ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON))) "K073",
DCCH_TCH+ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON))) "K074",
_SDCCH_TCH+ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON))) "K079",
DCCH_TCH+ho.CELL_SDCCH_TCH-traffic.TCH_SUCC_SEIZ_FOR_DIR_ACC+traffic.TCH_SEIZ_DUE_SDCCH_CON))) "K080",
DUE_SDCCH_CON))) "K076",
DUE_SDCCH_CON))) "K077",
EIZ_DUE_SDCCH_CON))) "K067",
Z_DUE_SDCCH_CON))) "K068",
IZ_DUE_SDCCH_CON))) "K070",
_SDCCH_CON))) "K078",
Z_DUE_SDCCH_CON))) "K071",
IZ_DUE_SDCCH_CON))) "K069",
_DUE_SDCCH_CON))) "K072",
E_SDCCH_CON))) "K073",
UE_SDCCH_CON))) "K074",
_DUE_SDCCH_CON))) "K079",
to_number(ho.MSC_O_SUCC_
to_number(ho.MSC_O_TCH_TC
to_number(pcu.NBR_OF_DL_T
to_number(pcu.NBR_OF_UL_T
to_number(pcu.NO_RADIO_RE
to_number(pcu.NO_RADIO_RE
to_number(pcu.REQ_1_TSL_D
to_number(pcu.REQ_1_TSL_U
to_number(pcu.DL_EGPRS_TB
to_number(codingsc.DL_RLC_B
to_number(codingsc.DL_RLC_B
to_number(pcu.DL_TBF_ESTAB
to_number(pcu.DL_TBF_REL_D
to_number(pcu.DL_TBF_RELE
to_number(psdtm.DTM_DURAT
to_number(psdtm.DTM_DURAT
to_number(pcu.UL_EGPRS_TB
to_number(codingsc.UL_RLC_B
to_number(codingsc.UL_RLC_B
to_number(pcu.UL_TBF_ESTAB
to_number(pcu.UL_TBF_REL_D
to_number(pcu.UL_TBF_RELE
to_number(resavail.RES_AV_D
to_number((DECODE(resavail.a
to_number((DECODE(resavail.a
to_number((pcu.alloc_1_tsl_dl +
to_number((pcu.alloc_1_tsl_dl +
to_number((DECODE(1000, 0,
to_number((DECODE(50, 0, 0,
to_number(8*DECODE(1000, 0
to_number(DECODE(50, 0, 0, (
to_number(DECODE(180, 0, 0,
from
(
select distinct
bsc.co_gid bsc_gid,
bsc.co_name bsc_name,
umber(traffic.MSC_O_HO_CMD) "MSC_O_HO_CMD",
umber(ho.MSC_O_SUCC_HO) "MSC_O_SUCC_HO",
umber(ho.MSC_O_TCH_TCH) "MSC_O_TCH_TCH",
umber(pcu.NBR_OF_DL_TBF) "NBR_OF_DL_TBF",
umber(pcu.NBR_OF_UL_TBF) "NBR_OF_UL_TBF",
umber(pcu.NO_RADIO_RES_AVAIL_FOR_DL_TBF) "NO_RADIO_RES_AVAIL_FOR_DL_TBF",
umber(pcu.NO_RADIO_RES_AVAIL_FOR_UL_TBF) "NO_RADIO_RES_AVAIL_FOR_UL_TBF",
umber(pcu.REQ_1_TSL_DL) "REQ_1_TSL_DL",
umber(pcu.REQ_1_TSL_UL) "REQ_1_TSL_UL",
umber(pcu.DL_EGPRS_TBF_REL_DUE_NO_RESP) "DL_EGPRS_TBF_REL_DUE_NO_RESP",
umber(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE) "DL_RLC_BLOCKS_IN_ACK_MODE",
umber(codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE) "DL_RLC_BLOCKS_IN_UNACK_MODE",
umber(pcu.DL_TBF_ESTABLISHMENT_FAILED) "DL_TBF_ESTABLISHMENT_FAILED",
umber(pcu.DL_TBF_REL_DUE_CSW_TRAFFIC) "DL_TBF_REL_DUE_CSW_TRAFFIC",
umber(pcu.DL_TBF_REL_DUE_NO_RESP_MS) "DL_TBF_REL_DUE_NO_RESP_MS",
umber(pcu.DL_TBF_REL_DUE_TO_FLUSH) "DL_TBF_REL_DUE_TO_FLUSH",
umber(pcu.DL_TBF_REL_DUE_TO_SUSPEND) "DL_TBF_REL_DUE_TO_SUSPEND",
umber(pcu.DL_TBF_RELEASES_DUE_DTM) "DL_TBF_RELEASES_DUE_DTM",
umber(psdtm.DTM_DURATION_SUM_FR) "DTM_DURATION_SUM_FR",
umber(psdtm.DTM_DURATION_SUM_HR) "DTM_DURATION_SUM_HR",
umber(pcu.UL_EGPRS_TBF_REL_DUE_NO_RESP) "UL_EGPRS_TBF_REL_DUE_NO_RESP",
umber(codingsc.UL_RLC_BLOCKS_IN_ACK_MODE) "UL_RLC_BLOCKS_IN_ACK_MODE",
umber(codingsc.UL_RLC_BLOCKS_IN_UNACK_MODE) "UL_RLC_BLOCKS_IN_UNACK_MODE",
umber(pcu.UL_TBF_ESTABLISHMENT_FAILED) "UL_TBF_ESTABLISHMENT_FAILED",
umber(pcu.UL_TBF_REL_DUE_CSW_TRAFFIC) "UL_TBF_REL_DUE_CSW_TRAFFIC",
umber(pcu.UL_TBF_REL_DUE_NO_RESP_MS) "UL_TBF_REL_DUE_NO_RESP_MS",
umber(pcu.UL_TBF_REL_DUE_TO_FLUSH) "UL_TBF_REL_DUE_TO_FLUSH",
umber(pcu.UL_TBF_REL_DUE_TO_SUSPEND) "UL_TBF_REL_DUE_TO_SUSPEND",
umber(pcu.UL_TBF_RELEASES_DUE_DTM) "UL_TBF_RELEASES_DUE_DTM",
umber(resavail.RES_AV_DENOM4) "RES_AV_DENOM4",
umber((DECODE(resavail.ave_avail_tch_den, 0, 0, resavail.ave_avail_tch_sum/resavail.ave_avail_tch_den))+(DECODE(resavail.ave_g
umber((DECODE(resavail.ave_avail_tch_den, 0, 0, resavail.ave_avail_tch_sum/resavail.ave_avail_tch_den))+(DECODE(resavail.ave_g
umber((pcu.alloc_1_tsl_dl + 2 * pcu.alloc_2_tsl_dl + 3 * pcu.alloc_3_tsl_dl+ 4 * pcu.alloc_4_tsl_dl)) "K117",
umber((pcu.alloc_1_tsl_dl + pcu.alloc_2_tsl_dl + pcu.alloc_3_tsl_dl + pcu.alloc_4_tsl_dl)) "K118",
umber((DECODE(1000, 0, 0, ((pcu.rlc_data_blocks_dl_cs1 * 23 + pcu.rlc_data_blocks_dl_cs2 * 33 + pcu.rlc_mac_cntrl_blocks_dl * 23 +
umber((DECODE(50, 0, 0, (pcu.rlc_data_blocks_dl_cs1 + pcu.rlc_data_blocks_dl_cs2 + pcu.rlc_mac_cntrl_blocks_dl + pcu.retra_rlc_da
umber(8*DECODE(1000, 0, 0, (DECODE(2, 0, 0, ((codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_1 + codingsc.DL_RLC_BLOCKS_IN_
umber(DECODE(50, 0, 0, (codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_1 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_1 + co
umber(DECODE(180, 0, 0, resavail.ave_busy_tch/180)) "K126"
c.co_gid bsc_gid,
c.co_name bsc_name,
_den))+(DECODE(resavail.ave_gprs_channels_den, 0, 0, resavail.ave_gprs_channels_sum/resavail.ave_gprs_channels_den))) "K115"
_den))+(DECODE(resavail.ave_gprs_channels_den, 0, 0, resavail.ave_gprs_channels_sum/resavail.ave_gprs_channels_den))+(DECO
cu.rlc_mac_cntrl_blocks_dl * 23 + pcu.retra_rlc_data_blocks_dl_cs1 * 23 + pcu.retra_rlc_data_blocks_dl_cs2 * 33)* 8)/1000))) "K119",

cntrl_blocks_dl + pcu.retra_rlc_data_blocks_dl_cs1 + pcu.retra_rlc_data_blocks_dl_cs2)/50))) "K120",
codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_1)* 22 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_2 + codingsc.DL_RLC_BLOC
CKS_IN_UNACK_MODE_1 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_2 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_2 +
ve_gprs_channels_den))) "K115",
ve_gprs_channels_den))+(DECODE(resavail.non_avail_tch_denom, 0, 0, resavail.ave_non_avail_tch_timeslot/resavail.non_avail_tch_d
dl_cs2 * 33)* 8)/1000))) "K119",
DE_2 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_2)* 28 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_3 + codingsc.DL_RL

LOCKS_IN_UNACK_MODE_2 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_3 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_
_timeslot/resavail.non_avail_tch_denom))) "K116",
ACK_MODE_3 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_3)* 37 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_4 + codings

C_BLOCKS_IN_UNACK_MODE_3 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_4 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MOD
KS_IN_ACK_MODE_4 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_4)* 44 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_5 +
RLC_BLOCKS_IN_UNACK_MODE_4 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_5 + codingsc.DL_RLC_BLOCKS_IN_UNACK_M
C_BLOCKS_IN_ACK_MODE_5 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_5)* 56 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MO
DL_RLC_BLOCKS_IN_UNACK_MODE_5 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_6 + codingsc.DL_RLC_BLOCKS_IN_UNAC
DL_RLC_BLOCKS_IN_ACK_MODE_6 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_6)* 74 +((codingsc.DL_RLC_BLOCKS_IN_
sc.DL_RLC_BLOCKS_IN_UNACK_MODE_6 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_1 + codingsc.RETRANS_RLC_DATA_
codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_7 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_7)* 112 +(codingsc.DL_RLC_BLO
odingsc.RETRANS_RLC_DATA_BLOCKS_DL_2 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_3 + codingsc.RETRANS_RLC_DAT
7)* 112 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_8 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_8)* 136 +(codingsc.DL_R
+ codingsc.RETRANS_RLC_DATA_BLOCKS_DL_4 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_5 + codingsc.RETRANS_RLC_D
_MODE_8)* 136 +(codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_9 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_9)* 148))/2))/10
_5 + codingsc.RETRANS_RLC_DATA_BLOCKS_DL_6 +DECODE(2, 0, 0, (codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_7 + codings
_UNACK_MODE_9)* 148))/2))/1000)) "K121",
KS_IN_ACK_MODE_7 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_7 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_8 + codin
OCKS_IN_ACK_MODE_8 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_8 + codingsc.DL_RLC_BLOCKS_IN_ACK_MODE_9 + c
BLOCKS_IN_ACK_MODE_9 + codingsc.DL_RLC_BLOCKS_IN_UNACK_MODE_9 + codingsc....
c_bts.segment_id,
c_bts.segment_name
from
roh_c_bts c_bts
where
c_bts.valid_finish_time >sysd
bts.co_parent_gid = bcf.co_g
bcf.co_parent_gid = bsc.co_g
c_bts.co_gid = bts.co_gid and
c_bts.conf_id=1 and
bts.co_oc_id=4 and
bsc.co_oc_id=3 and
bcf.co_oc_id=27
) c,
utp_common_objects bsc
,
jf_ALLTABLES_2490353012 ALL
jf_codingsc_2423372847 codings
jf_ho_2442946551 ho,
jf_pcu_2425552267 pcu,
jf_power_ext_2477733887 powe
jf_psdtm_2458493106 psdtm,
jf_resacc_2411313044 resacc,
jf_resavail_2424413904 resavail,
jf_resavail_ext_2469946128 resa
jf_rxstat_2470153731 rxstat,
jf_service_2462624695 service,
jf_traffic_2430891967 traffic,
jf_traffic_ext_2441147716 traffic_
where
bsc.co_oc_id=3 and
ALLTABLES.bsc_gid = bsc.co_g
ALLTABLES.bsc_gid = c.bsc_gi
ALLTABLES.segment = c.segm
and ALLTABLES.period_start_ti
order by
2,1,3
bts.segment_id,
bts.segment_name
p_common_objects bsc,
p_common_objects bcf,
p_common_objects bts,
h_c_bts c_bts
bts.valid_finish_time >sysdate and

s.co_parent_gid = bcf.co_gid and
f.co_parent_gid = bsc.co_gid and
bts.co_gid = bts.co_gid and
bts.conf_id=1 and
s.co_oc_id=4 and
c.co_oc_id=3 and
f.co_oc_id=27
common_objects bsc
LTABLES_2490353012 ALLTABLES,
ingsc_2423372847 codingsc,
2442946551 ho,
_2425552267 pcu,
wer_ext_2477733887 power_ext,
tm_2458493106 psdtm,
acc_2411313044 resacc,
avail_2424413904 resavail,
avail_ext_2469946128 resavail_ext,
at_2470153731 rxstat,
vice_2462624695 service,
ic_2430891967 traffic,
ic_ext_2441147716 traffic_ext
co_oc_id=3 and
TABLES.bsc_gid = bsc.co_gid and
TABLES.bsc_gid = c.bsc_gid (+) and
TABLES.segment = c.segment_id (+)
ALLTABLES.period_start_time = codingsc.period_start_time (+) and ALLTABLES.bsc_gid = codingsc.bsc_gid (+) and ALLTABLES.segm
ALLTABLES.period_start_time = ho.period_start_time (+) and ALLTABLES.bsc_gid = ho.bsc_gid (+) and ALLTABLES.segment = ho.seg
ALLTABLES.period_start_time = pcu.period_start_time (+) and ALLTABLES.bsc_gid = pcu.bsc_gid (+) and ALLTABLES.segment = pcu.
ALLTABLES.period_start_time = power_ext.period_start_time (+) and ALLTABLES.bsc_gid = power_ext.bsc_gid (+) and ALLTABLES.se
ALLTABLES.period_start_time = psdtm.period_start_time (+) and ALLTABLES.bsc_gid = psdtm.bsc_gid (+) and ALLTABLES.segment =
ALLTABLES.period_start_time = resacc.period_start_time (+) and ALLTABLES.bsc_gid = resacc.bsc_gid (+) and ALLTABLES.segment
ALLTABLES.period_start_time = resavail.period_start_time (+) and ALLTABLES.bsc_gid = resavail.bsc_gid (+) and ALLTABLES.segmen
ALLTABLES.period_start_time = resavail_ext.period_start_time (+) and ALLTABLES.bsc_gid = resavail_ext.bsc_gid (+) and ALLTABLES
ALLTABLES.period_start_time = rxstat.period_start_time (+) and ALLTABLES.bsc_gid = rxstat.bsc_gid (+) and ALLTABLES.segment = r
ALLTABLES.period_start_time = service.period_start_time (+) and ALLTABLES.bsc_gid = service.bsc_gid (+) and ALLTABLES.segment
ALLTABLES.period_start_time = traffic.period_start_time (+) and ALLTABLES.bsc_gid = traffic.bsc_gid (+) and ALLTABLES.segment = t
ALLTABLES.period_start_time = traffic_ext.period_start_time (+) and ALLTABLES.bsc_gid = traffic_ext.bsc_gid (+) and ALLTABLES.seg
sc_gid (+) and ALLTABLES.segment = codingsc.segment (+)
nd ALLTABLES.segment = ho.segment (+)
and ALLTABLES.segment = pcu.segment (+)
xt.bsc_gid (+) and ALLTABLES.segment = power_ext.segment (+)
d (+) and ALLTABLES.segment = psdtm.segment (+)
id (+) and ALLTABLES.segment = resacc.segment (+)
_gid (+) and ALLTABLES.segment = resavail.segment (+)
_ext.bsc_gid (+) and ALLTABLES.segment = resavail_ext.segment (+)
(+) and ALLTABLES.segment = rxstat.segment (+)
gid (+) and ALLTABLES.segment = service.segment (+)
(+) and ALLTABLES.segment = traffic.segment (+)
.bsc_gid (+) and ALLTABLES.segment = traffic_ext.segment (+)

2G Npi Kpi

Uploaded by

Copyright:

Available Formats

2G Npi Kpi

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

2G Npi Kpi

Uploaded by

Copyright:

Available Formats

Period start time BSC Name Segment Name SEGMENT TCH_AVAILABILITY

KPI Alias KPI Title KPI FormulUnit

Start Time End Time Note Sql

( p.period_start_time, 'dd' ) period_start_time,

co_gid in ( '5000000366116' ) and

2014-12-24 12:17:05.260 2014-12-24 12:17:05.355 creating tmp table: jf_power_ext_2477733887

2014-12-24 12:17:05.355 2014-12-24 12:17:05.391 creating tmp table: jf_resacc_2411313044

p.period_start_time, 'dd' ) period_start_time,

o_gid in ( '5000000366116' ) and

p.period_start_time, 'dd' ) period_start_time,

2014-12-24 12:17:05.392 2014-12-24 12:17:05.423 creating tmp table: jf_ho_2442946551

o_gid in ( '5000000366116' ) and

p.period_start_time, 'dd' ) period_start_time,

2014-12-24 12:17:05.425 2014-12-24 12:17:05.664 creating tmp table: jf_resavail_ext_2469946128

o_gid in ( '5000000366116' ) and

p.period_start_time, 'dd' ) period_start_time,

ECT a.ave_idle_f_tch_3, a.res_av_denom6, a.ave_idle_f_tch_4,

o_gid in ( '5000000366116' ) and

2014-12-24 12:17:05.664 2014-12-24 12:17:05.681 creating tmp table: jf_service_2462624695

2014-12-24 12:17:05.682 2014-12-24 12:17:05.719 creating tmp table: jf_pcu_2425552267

p.period_start_time, 'dd' ) period_start_time,

o_gid in ( '5000000366116' ) and

p.period_start_time, 'dd' ) period_start_time,

2014-12-24 12:17:05.719 2014-12-24 12:17:05.983 creating tmp table: jf_traffic_ext_2441147716

o_gid in ( '5000000366116' ) and

p.period_start_time, 'dd' ) period_start_time,

o_gid in ( '5000000366116' ) and

2014-12-24 12:17:05.984 2014-12-24 12:17:06.7 creating tmp table: jf_resavail_2424413904

p.period_start_time, 'dd' ) period_start_time,

o_gid in ( '5000000366116' ) and

2014-12-24 12:17:06.7 2014-12-24 12:17:06.45 creating tmp table: jf_traffic_2430891967

p.period_start_time, 'dd' ) period_start_time,

2014-12-24 12:17:06.45 2014-12-24 12:17:06.84 creating tmp table: jf_psdtm_2458493106

o_gid in ( '5000000366116' ) and

p.period_start_time, 'dd' ) period_start_time,

o_gid in ( '5000000366116' ) and

p.period_start_time, 'dd' ) period_start_time,

2014-12-24 12:17:06.132 2014-12-24 12:17:06.161 creating tmp table: jf_ALLTABLES_2490353012

o_gid in ( '5000000366116' ) and

d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment

d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment

d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment

d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment

d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment

d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment

d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment

d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment

2014-12-24 12:17:06.243 2014-12-24 12:17:06.979 report from tmp tables

d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment

d_start_time, TO_CHAR(bsc_gid) bsc_gid, TO_CHAR(segment) segment

_start_time >= to_date('2014/12/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss') and

affic.SDCCH_BCSU_RESET + traffic.SDCCH_NETW_ACT + traffic.SDCCH_ABIS_FAIL_OLD + traffic.SDCCH_BTS_FAIL + traffic.SDC

TCH + ho.BSC_O_SDCCH_TCH + ho.CELL_SDCCH_TCH - ho.MSC_I_SDCCH_TCH - ho.BSC_I_SDCCH_TCH)) "K086",

.SDCCH_BTS_FAIL + traffic.SDCCH_LAPD_FAIL)) "K084",

+ traffic.SDCCH_ABIS_FAIL_OLD + traffic.SDCCH_BTS_FAIL + traffic.SDCCH_LAPD_FAIL)/traffic.SDCCH_ASSIGN)))*(DECODE((s

DCCH_ASSIGN)))*(DECODE((service.TCH_NEW_CALL_ASSIGN - service.SERVED_FACCH_REQ + ho.MSC_O_SDCCH_TCH + ho

+ ho.MSC_O_SDCCH_TCH + ho.BSC_O_SDCCH_TCH + ho.CELL_SDCCH_TCH - ho.MSC_I_SDCCH_TCH - ho.BSC_I_SDCCH_TC

CH_TCH - ho.BSC_I_SDCCH_TCH + traffic.TCH_REQUESTS_CALL_ATTEMPT - traffic.SUCC_TCH_SEIZ_CALL_ATTEMPT), 0, 0, (s