RRC Setup Success Rate (%)

1400 1400
1200 1200
1000 1000
800 800
600 600
400 400
200 200
0 0
1 2 3 4 5 6 7 8 9 0 1 2 3 lt 1 2 3 4 5
22 22 22 22 22 22 22 22 22 23 23 23 23 su 22 22 22 22 22
45 45 45 45 45 45 45 45 45 45 45 45 45 l Re 45 45 45 45 45
ta
To

WBTS name NOEPE-MOOV

CSSR PS (%) Packet Sessi

1400 1400
1200 1200
1000 1000
800 800
600 600
400 400
200 200
0 0
1 2 3 4 5 6 7 8 9 0 1 2 3 lt 1 2 3 4 5
522 522 522 522 522 522 522 522 522 523 523 523 523 e su 22 22 22 22 22
4 4 4 4 4 4 4 4 4 4 4 4 4 lR 45 45 45 45 45
ota
T

WBTS name NOEPE-MOOV

DCR CS (%)
2.5 8
7
2
6
1.5
5
1 4
3
0.5
2
0
1 2 3 4 5 6 7 8 9 0 1 2 3 lt 1
522 522 522 522 522 522 522 522 522 523 523 523 523 e su
4 4 4 4 4 4 4 4 4 4 4 4 4 0
lR 45221 45222 45223 45224 45225 4
ota
T

WBTS name NOEPE-MOOV

HSDPA SR (%) H
1400 1400
1200 1200
1000 1000
800 800
600 600
 HSDPA SR (%) H
1400 1400
1200 1200
1000 1000
800 800
600 600
400 400
200 200
0 0
1 2 3 4 5 6 7 8 9 0 1 2 3 lt 1 2 3 4 5
22 22 22 22 22 22 22 22 22 23 23 23 23 su 22 22 22 22 22
45 45 45 45 45 45 45 45 45 45 45 45 45 l Re 45 45 45 45 45
ta
To

WBTS name NOEPE-MOOV

3G2G HO Sucess rate RT (%) 3G2G H

1400 1400
1200 1200

1000 1000
800
800
600
600 400
400 200
200 0
1 2 3 4 5
522 522 522 522 522
0 4 4 4 4 4 4
1 2 3 4 5 6 7 8 9 0 1 2 3 lt
522 522 522 522 522 522 522 522 522 523 523 523 523 e su
4 4 4 4 4 4 4 4 4 4 4 4 4 lR
ota
WBTS name NOEPE-MOOV T

Traffic CS (erl) T
4000 3000
3500 2500
3000
2500 2000
2000 1500
1500 1000
1000
500 500
0 0
1 2 3 4 5 6 7 8 9 0 1 2 3 lt 1 2 3 4 5
22 22 22 22 22 22 22 22 22 23 23 23 23 su 22 22 22 22 22
45 45 45 45 45 45 45 45 45 45 45 45 45 l Re 45 45 45 45 45 4
ta
To

WBTS name NOEPE-MOOV W

 This shape represents a slicer. This shape rep
CSSR CS (%) Slicers are supported in Excel Slicers are sup
0 2010 or later. 2010 or later.
0
If the shape was modified in If the shape w
0
an earlier version of Excel, or an earlier vers
0 if the workbook was saved in if the workboo
0 Excel 2003 or earlier, the Excel 2003 or
0 slicer cannot be used. slicer cannot b
0
0
1 2 3 4 5 6 7 8 9 0 1 2 3 lt
522 522 522 522 522 522 522 522 522 523 523 523 523 e su
4 4 4 4 4 4 4 4 4 4 4 4 4 lR
ota
T

WBTS name NOEPE-MOOV

Packet Session Setup Success Rate (%)

0
0
0
0
0
0
0
0
1 2 3 4 5 6 7 8 9 0 1 2 3 lt
22 22 22 22 22 22 22 22 22 23 23 23 23 su
45 45 45 45 45 45 45 45 45 45 45 45 45 l Re
ta
To

WBTS name NOEPE-MOOV

DCR PS (%)

5221 45222 45223 45224 45225 45226 45227 45228 45229 45230 45231 45232 45233 Total
Result

WBTS name NOEPE-MOOV

HSUPA SR (%)
0
0
0
0
0
 HSUPA SR (%)
0
0
0
0
0
0
0
0
1 2 3 4 5 6 7 8 9 0 1 2 3 lt
22 22 22 22 22 22 22 22 22 23 23 23 23 su
45 45 45 45 45 45 45 45 45 45 45 45 45 l Re
ta
To

WBTS name NOEPE-MOOV

3G2G HO Sucess rate RT (%)

1 2 3 4 5 6 7 8 9 0 1 2 3 lt
522 522 522 522 522 522 522 522 522 523 523 523 523 e su
4 4 4 4 4 4 4 4 4 4 4 4 4 lR
ta
To

WBTS name NOEPE-MOOV

Traffic PS (GB)

1 2 3 4 5 6 7 8 9 0 1 2 3 lt
22 22 22 22 22 22 22 22 22 23 23 23 23 su
45 45 45 45 45 45 45 45 45 45 45 45 45 l Re
ta
To

WBTS name NOEPE-MOOV

This shape represents a slicer.
Slicers are supported in Excel
2010 or later.

If the shape was modified in

an earlier version of Excel, or
if the workbook was saved in
Excel 2003 or earlier, the
slicer cannot be used.
 Data

Period start time PLMN nameRNC name WBTS nameWBTS ID

10.22.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738

10.23.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
10.24.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
10.25.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
10.26.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
10.27.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
10.28.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
10.29.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
10.30.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
10.31.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
11.01.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
11.02.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738
11.03.2023 PLMN mcRNC NRNC1_NNOEPE-MO 3738

Page 6
 Data

RRC Setup and Access Complete Ratio from end user perspective
Voice Call Setup SR (RRC+CU)
RNC_154D RNC_5093B
99.61 99.85
99.79 99.89
99.73 99.88
99.71 99.89
99.72 99.89
99.62 99.89
99.54 99.86
99.54 99.78
99.63 99.89
99.76 99.76
99.72 99.90
99.79 99.89
99.67 99.88

Page 7
 Data

CSSR PS NRT Packet Session stp SR

HSDPA SR UsrHSUPA SR UsrInter sys RT Hard HO SR
RNC_576E RNC_916B RNC_920B RNC_921C RNC_300H
99.41 99.85 99.00 98.96 93.90
99.51 99.80 99.11 99.08 97.02
99.56 99.76 98.96 98.92 95.17
99.41 99.88 99.19 99.17 95.26
99.49 99.89 99.15 99.12 95.08
99.41 99.86 99.11 99.09 96.69
99.35 99.85 99.15 99.12 94.78
99.39 99.87 98.99 98.96 94.26
99.56 99.88 99.10 99.06 98.28
99.21 99.69 99.04 99.06 100.00
99.32 99.42 98.47 98.42 92.31
99.60 99.69 98.74 98.69 96.73
99.53 99.86 98.96 98.91 96.97

Page 8
 Data

Inter sys NRT Hard HO SRTotal CS traffic - Erl PS usr data RLC UL PS usr data RLC DL
RNC_301F RNC_280D RNC_3173A RNC_3172A
93.86 271.67 8,543.066 87,359.546
96.59 302.36 10,243.170 84,581.871
92.11 280.88 10,997.825 71,181.020
93.67 304.62 7,447.356 71,534.900
95.80 417.32 7,194.310 62,806.487
94.19 307.38 6,694.372 62,511.855
92.91 308.12 7,792.295 74,561.697
89.66 250.54 6,150.480 63,857.181
91.67 301.17 7,223.961 77,494.914
100.00 5.99 398.111 3,917.876
95.71 188.35 5,377.831 44,010.196
96.00 464.25 8,217.002 69,556.053
95.83 325.48 7,227.580 64,415.696

Page 9
 Data

Active HS-DSCH cell thr

rabdroprate_ps rabdroprate_cs Act HS-DSCH end usr thp (Mbps)
RNC_722D RABDROPRATE_ RABDROPRATE_CS
5,135.05 0.57 0.14 -105.05
4,803.83 0.63 0.15 -102.59
4,809.08 0.59 0.11 -104.72
4,760.59 0.65 0.15 -105.23
4,116.04 0.63 0.14 -105.43
4,394.47 0.52 0.22 -105.38
4,296.25 0.69 0.18 -104.56
4,549.07 0.59 0.23 -105.68
5,103.20 0.67 0.15 -105.65
3,925.58 0.59 0.25 -106.36
4,287.54 0.35 0.19 -103.74
3,710.53 0.36 0.12 -104.65
4,369.42 0.69 0.20 -104.96

Page 10
 Data

Traffic PS

197.96
198.20
197.88
198.36
198.27
198.20
198.27
197.94
198.16
198.10
196.89
197.43
197.87

Page 11
 Documentation

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
Data Source
Advanced Filter

KPI ID
RNC_154d
RNC_5093b
RNC_576e
RNC_916b
RNC_920b
RNC_921c
RNC_300h
RNC_301f
RNC_280d
RNC_3173a
RNC_3172a
RNC_722d
rabdroprate_ps
rabdroprate_cs

Page 12
Documentation

Page 13
 Documentation

3ACN
none
none
PM_10420
none
04.02.2020 00:00:00
04.22.2020 00:00:00
Level: RSRAN-WBTS; LAPAIX ('6774075')
PLMN/RNC/WBTS
day
none
pmrPool
none

KPI Alias KPI Title

RRC Setup and Access Complete Ratio from end user perspective RRC Setup
Voice Call Setup SR (RRC+CU) Voice Call
CSSR PS NRT Packet Ser
Packet Session stp SR Packet Ses
HSDPA SR Usr HSDPA Succ
HSUPA SR Usr HSUPA Succ
Inter sys RT Hard HO SR Inter Syst
Inter sys NRT Hard HO SR Inter Syst
Total CS traffic - Erl Total CS tra
PS usr data RLC UL Sent PS use
PS usr data RLC DL Received PS
Active HS-DSCH cell thr Active HS-D
rabdroprate_ps rabdroprate
rabdroprate_cs rabdroprate

Page 14
Documentation

Page 15
 Documentation

KPI FormulUnit
decode( (se[%]
100*decode( [%]
decode( (se[%]
decode( (pk[%]
decode( (pk[%]
100 - 100*d[%]
100*decode( [%]
100*decode( [%]
(servlev.av [E]
decode( (10[MB]
decode( (10[MB]
decode( (h [kbit/s]
decode((SE[%]
decode( (S [%]

Page 16
Documentation

Page 17
 Report Execution

Cache handler com.nokia.oss.qengine.support.CacheAwareEngine

Evaluation method tmp tables(1)
Init duration 1.558
Sql generation 0.016
Execution duration 4.67
Load from cache none
Create tmp Tables 4.598
Drop tmp Tables none
Load data db none
Load data and write to cache none

Start Time End Time

2020-04-22 09:32:04.100 2020-04-22 09:32:04.135

2020-04-22 09:32:04.135 2020-04-22 09:32:05.227

Page 18
Report Execution

Page 19
 Report Execution

2020-04-22 09:32:05.227 2020-04-22 09:32:05.876

Page 20
 Report Execution

2020-04-22 09:32:05.876 2020-04-22 09:32:06.788

Page 21
 Report Execution

2020-04-22 09:32:06.788 2020-04-22 09:32:07.714

Page 22
 Report Execution

2020-04-22 09:32:07.715 2020-04-22 09:32:07.832

Page 23
 Report Execution

2020-04-22 09:32:07.832 2020-04-22 09:32:08.84

Page 24
 Report Execution

2020-04-22 09:32:08.84 2020-04-22 09:32:08.681

2020-04-22 09:32:08.685 2020-04-22 09:32:08.697

Page 25
 Report Execution

2020-04-22 09:32:08.697 2020-04-22 09:32:08.769

Page 26
 Report Execution

Note Sql
executing sql extra step
create global temporary table jf_wcel_2260635819 on commit preserve rows as

select
"plmn".co_gid "plmn_gid",
"rnc".co_gid "rnc_gid",
"rnc".co_mr_gid "rnc_mr_gid",
"wbts".co_gid "wbts_gid",
"wbts".co_mr_gid "wbts_mr_gid",
"wcel".co_gid "wcel_gid",
"wcel".co_mr_gid "wcel_mr_gid"
from
utp_common_objects "plmn",
utp_common_objects "rnc",
utp_common_objects "wbts",
utp_common_objects "wcel"
where
"plmn".co_oc_id = 16 and
"rnc".co_oc_id = 811 and
"rnc".co_parent_gid = "plmn".co_gid and
"wbts".co_oc_id = 812 and
"wbts".co_parent_gid = "rnc".co_gid and
"wcel".co_oc_id = 813 and
"wcel".co_parent_gid = "wbts".co_gid
creating tmp table: jf_SERVLEV_2233839730
create global temporary table jf_SERVLEV_2233839730 on commit preserve rows as
select
a.period_start_time,
a.wbts_gid,
SUM(rrc_conn_stp_att) rrc_conn_stp_att,
SUM(rrc_conn_acc_comp) rrc_conn_acc_comp,
SUM(moc_conv_call_atts) moc_conv_call_atts,
SUM(moc_conv_call_fails) moc_conv_call_fails,

Page 27
 Report Execution

SUM(moc_inter_call_atts) moc_inter_call_atts,
SUM(moc_inter_call_fails) moc_inter_call_fails,
SUM(moc_backg_call_atts) moc_backg_call_atts,
SUM(moc_backg_call_fails) moc_backg_call_fails,
SUM(mtc_conv_call_atts) mtc_conv_call_atts,
SUM(mtc_conv_call_fails) mtc_conv_call_fails,
SUM(mtc_inter_call_atts) mtc_inter_call_atts,
SUM(mtc_inter_call_fails) mtc_inter_call_fails,
SUM(mtc_backg_call_atts) mtc_backg_call_atts,
SUM(mtc_backg_call_fails) mtc_backg_call_fails,
SUM(emergency_call_atts) emergency_call_atts,
SUM(emergency_call_fails) emergency_call_fails,
SUM(moc_high_prior_sign_atts) moc_high_prior_sign_atts,
SUM(moc_high_prior_sign_fails) moc_high_prior_sign_fails,
SUM(mtc_high_prior_sign_atts) mtc_high_prior_sign_atts,
SUM(mtc_high_prior_sign_fails) mtc_high_prior_sign_fails,
SUM(rab_stp_att_cs_voice) rab_stp_att_cs_voice,
SUM(rab_stp_att_ps_inter) rab_stp_att_ps_inter,
SUM(RAB_STP_ATT_PS_BACKG) RAB_STP_ATT_PS_BACKG,
SUM(rab_acc_comp_cs_voice) rab_acc_comp_cs_voice,
SUM(rab_acc_comp_ps_inter) rab_acc_comp_ps_inter,
SUM(rab_acc_comp_ps_backg) rab_acc_comp_ps_backg,
SUM(rab_act_comp_cs_voice) rab_act_comp_cs_voice,
SUM(rab_act_comp_ps_inter) rab_act_comp_ps_inter,
SUM(rab_act_comp_ps_backg) rab_act_comp_ps_backg,
SUM(rab_act_fail_cs_voice_iu) rab_act_fail_cs_voice_iu,
SUM(rab_act_fail_cs_voice_radio) rab_act_fail_cs_voice_radio,
SUM(rab_act_fail_cs_voice_bts) rab_act_fail_cs_voice_bts,
SUM(rab_act_fail_cs_voice_iur) rab_act_fail_cs_voice_iur,
SUM(rab_act_fail_cs_voice_rnc) rab_act_fail_cs_voice_rnc,
SUM(rab_act_rel_ps_inter_srnc) rab_act_rel_ps_inter_srnc,
SUM(rab_act_rel_ps_backg_srnc) rab_act_rel_ps_backg_srnc,
SUM(rab_act_fail_ps_inter_iu) rab_act_fail_ps_inter_iu,
SUM(rab_act_fail_ps_inter_radio) rab_act_fail_ps_inter_radio,
SUM(rab_act_fail_ps_inter_bts) rab_act_fail_ps_inter_bts,
SUM(rab_act_fail_ps_inter_iur) rab_act_fail_ps_inter_iur,
SUM(rab_act_fail_ps_inter_rnc) rab_act_fail_ps_inter_rnc,
SUM(rab_act_fail_ps_backg_iu) rab_act_fail_ps_backg_iu,
SUM(rab_act_fail_ps_backg_radio) rab_act_fail_ps_backg_radio,
SUM(rab_act_fail_ps_backg_bts) rab_act_fail_ps_backg_bts,
SUM(rab_act_fail_ps_backg_iur) rab_act_fail_ps_backg_iur,
SUM(rab_act_fail_ps_backg_rnc) rab_act_fail_ps_backg_rnc,
SUM(avg_rab_hld_tm_cs_voice) avg_rab_hld_tm_cs_voice,
SUM(RRC_CONN_ACC_REL_CELL_RESEL) RRC_CONN_ACC_REL_CELL_RESEL,
SUM(RRC_CONN_SETUP_ATT_REPEAT) RRC_CONN_SETUP_ATT_REPEAT,
SUM(RRC_CONN_SETUP_COMP_AFT_DIR) RRC_CONN_SETUP_COMP_AFT_DIR,
SUM(RRC_CON_SETUP_COMP_DIRECTED) RRC_CON_SETUP_COMP_DIRECTED,

Page 28
 Report Execution

SUM(RAB_HOLD_TIME_CS_CONV_64) RAB_HOLD_TIME_CS_CONV_64,
SUM(RAB_HOLD_TIME_CS_STREAM_14_4) RAB_HOLD_TIME_CS_STREAM_14_4,
SUM(RAB_HOLD_TIME_CS_STREAM_57_6) RAB_HOLD_TIME_CS_STREAM_57_6,
SUM(RAB_ACT_FAIL_PS_INTER_UE) RAB_ACT_FAIL_PS_INTER_UE,
SUM(RAB_ACT_FAIL_PS_BACKG_UE) RAB_ACT_FAIL_PS_BACKG_UE,
SUM(RRC_ACC_REL_MO_CONV) RRC_ACC_REL_MO_CONV,
SUM(RRC_ACC_REL_MO_INTERACTIVE) RRC_ACC_REL_MO_INTERACTIVE,
SUM(RRC_ACC_REL_MO_BACKGROUND) RRC_ACC_REL_MO_BACKGROUND,
SUM(RRC_ACC_REL_MT_CONV) RRC_ACC_REL_MT_CONV,
SUM(RRC_ACC_REL_INTERACTIVE) RRC_ACC_REL_INTERACTIVE,
SUM(RRC_ACC_REL_MT_BACKGROUND) RRC_ACC_REL_MT_BACKGROUND,
SUM(RRC_ACC_REL_EMERGENCY) RRC_ACC_REL_EMERGENCY,
SUM(RRC_ACC_REL_MO_HIGH_PR_SIGN) RRC_ACC_REL_MO_HIGH_PR_SIGN,
SUM(RRC_ACC_REL_MT_HIGH_PR_SIGN) RRC_ACC_REL_MT_HIGH_PR_SIGN,
SUM(RRC_ATT_REP_MO_CONV) RRC_ATT_REP_MO_CONV,
SUM(RRC_ATT_REP_MO_INTERACTIVE) RRC_ATT_REP_MO_INTERACTIVE,
SUM(RRC_ATT_REP_MO_BACKGROUND) RRC_ATT_REP_MO_BACKGROUND,
SUM(RRC_ATT_REP_MT_CONV) RRC_ATT_REP_MT_CONV,
SUM(RRC_ATT_REP_INTERACTIVE) RRC_ATT_REP_INTERACTIVE,
SUM(RRC_ATT_REP_MT_BACKGROUND) RRC_ATT_REP_MT_BACKGROUND,
SUM(RRC_ATT_REP_EMERGENCY) RRC_ATT_REP_EMERGENCY,
SUM(RRC_ATT_REP_MO_HIGH_PR_SIGN) RRC_ATT_REP_MO_HIGH_PR_SIGN,
SUM(RRC_ATT_REP_MT_HIGH_PR_SIGN) RRC_ATT_REP_MT_HIGH_PR_SIGN,
SUM(RRC_CONN_STP_REJ_EMERG_CALL) RRC_CONN_STP_REJ_EMERG_CALL,
SUM(RAB_ACT_FAIL_PS_INTER_TRANS) RAB_ACT_FAIL_PS_INTER_TRANS,
SUM(RAB_ACT_FAIL_PS_BACKG_TRANS) RAB_ACT_FAIL_PS_BACKG_TRANS,
SUM(RAB_ACT_REL_PS_INTER_HHO) RAB_ACT_REL_PS_INTER_HHO,
SUM(RAB_ACT_REL_PS_BACKG_HHO) RAB_ACT_REL_PS_BACKG_HHO,
SUM(RAB_ACT_REL_PS_INTER_ISHO) RAB_ACT_REL_PS_INTER_ISHO,
SUM(RAB_ACT_REL_PS_BGR_ISHO) RAB_ACT_REL_PS_BGR_ISHO
from
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t."rnc_gid" rnc_gid,
t."wbts_gid" wbts_gid,
t."wcel_gid" wcel_gid,
SUM(rrc_conn_stp_att) rrc_conn_stp_att,
SUM(rrc_conn_acc_comp) rrc_conn_acc_comp,
SUM(moc_conv_call_atts) moc_conv_call_atts,
SUM(moc_conv_call_fails) moc_conv_call_fails,
SUM(moc_inter_call_atts) moc_inter_call_atts,
SUM(moc_inter_call_fails) moc_inter_call_fails,
SUM(moc_backg_call_atts) moc_backg_call_atts,
SUM(moc_backg_call_fails) moc_backg_call_fails,
SUM(mtc_conv_call_atts) mtc_conv_call_atts,
SUM(mtc_conv_call_fails) mtc_conv_call_fails,

Page 29
 Report Execution

SUM(mtc_inter_call_atts) mtc_inter_call_atts,
SUM(mtc_inter_call_fails) mtc_inter_call_fails,
SUM(mtc_backg_call_atts) mtc_backg_call_atts,
SUM(mtc_backg_call_fails) mtc_backg_call_fails,
SUM(emergency_call_atts) emergency_call_atts,
SUM(emergency_call_fails) emergency_call_fails,
SUM(moc_high_prior_sign_atts) moc_high_prior_sign_atts,
SUM(moc_high_prior_sign_fails) moc_high_prior_sign_fails,
SUM(mtc_high_prior_sign_atts) mtc_high_prior_sign_atts,
SUM(mtc_high_prior_sign_fails) mtc_high_prior_sign_fails,
SUM(rab_stp_att_cs_voice) rab_stp_att_cs_voice,
SUM(rab_stp_att_ps_inter) rab_stp_att_ps_inter,
SUM(RAB_STP_ATT_PS_BACKG) RAB_STP_ATT_PS_BACKG,
SUM(rab_acc_comp_cs_voice) rab_acc_comp_cs_voice,
SUM(rab_acc_comp_ps_inter) rab_acc_comp_ps_inter,
SUM(rab_acc_comp_ps_backg) rab_acc_comp_ps_backg,
SUM(rab_act_comp_cs_voice) rab_act_comp_cs_voice,
SUM(rab_act_comp_ps_inter) rab_act_comp_ps_inter,
SUM(rab_act_comp_ps_backg) rab_act_comp_ps_backg,
SUM(rab_act_fail_cs_voice_iu) rab_act_fail_cs_voice_iu,
SUM(rab_act_fail_cs_voice_radio) rab_act_fail_cs_voice_radio,
SUM(rab_act_fail_cs_voice_bts) rab_act_fail_cs_voice_bts,
SUM(rab_act_fail_cs_voice_iur) rab_act_fail_cs_voice_iur,
SUM(rab_act_fail_cs_voice_rnc) rab_act_fail_cs_voice_rnc,
SUM(rab_act_rel_ps_inter_srnc) rab_act_rel_ps_inter_srnc,
SUM(rab_act_rel_ps_backg_srnc) rab_act_rel_ps_backg_srnc,
SUM(rab_act_fail_ps_inter_iu) rab_act_fail_ps_inter_iu,
SUM(rab_act_fail_ps_inter_radio) rab_act_fail_ps_inter_radio,
SUM(rab_act_fail_ps_inter_bts) rab_act_fail_ps_inter_bts,
SUM(rab_act_fail_ps_inter_iur) rab_act_fail_ps_inter_iur,
SUM(rab_act_fail_ps_inter_rnc) rab_act_fail_ps_inter_rnc,
SUM(rab_act_fail_ps_backg_iu) rab_act_fail_ps_backg_iu,
SUM(rab_act_fail_ps_backg_radio) rab_act_fail_ps_backg_radio,
SUM(rab_act_fail_ps_backg_bts) rab_act_fail_ps_backg_bts,
SUM(rab_act_fail_ps_backg_iur) rab_act_fail_ps_backg_iur,
SUM(rab_act_fail_ps_backg_rnc) rab_act_fail_ps_backg_rnc,
SUM(avg_rab_hld_tm_cs_voice) avg_rab_hld_tm_cs_voice,
SUM(RRC_CONN_ACC_REL_CELL_RESEL) RRC_CONN_ACC_REL_CELL_RESEL,
SUM(RRC_CONN_SETUP_ATT_REPEAT) RRC_CONN_SETUP_ATT_REPEAT,
SUM(RRC_CONN_SETUP_COMP_AFT_DIR) RRC_CONN_SETUP_COMP_AFT_DIR,
SUM(RRC_CON_SETUP_COMP_DIRECTED) RRC_CON_SETUP_COMP_DIRECTED,
SUM(RAB_HOLD_TIME_CS_CONV_64) RAB_HOLD_TIME_CS_CONV_64,
SUM(RAB_HOLD_TIME_CS_STREAM_14_4) RAB_HOLD_TIME_CS_STREAM_14_4,
SUM(RAB_HOLD_TIME_CS_STREAM_57_6) RAB_HOLD_TIME_CS_STREAM_57_6,
SUM(RAB_ACT_FAIL_PS_INTER_UE) RAB_ACT_FAIL_PS_INTER_UE,
SUM(RAB_ACT_FAIL_PS_BACKG_UE) RAB_ACT_FAIL_PS_BACKG_UE,
SUM(RRC_ACC_REL_MO_CONV) RRC_ACC_REL_MO_CONV,

Page 30
 Report Execution

SUM(RRC_ACC_REL_MO_INTERACTIVE) RRC_ACC_REL_MO_INTERACTIVE,
SUM(RRC_ACC_REL_MO_BACKGROUND) RRC_ACC_REL_MO_BACKGROUND,
SUM(RRC_ACC_REL_MT_CONV) RRC_ACC_REL_MT_CONV,
SUM(RRC_ACC_REL_INTERACTIVE) RRC_ACC_REL_INTERACTIVE,
SUM(RRC_ACC_REL_MT_BACKGROUND) RRC_ACC_REL_MT_BACKGROUND,
SUM(RRC_ACC_REL_EMERGENCY) RRC_ACC_REL_EMERGENCY,
SUM(RRC_ACC_REL_MO_HIGH_PR_SIGN) RRC_ACC_REL_MO_HIGH_PR_SIGN,
SUM(RRC_ACC_REL_MT_HIGH_PR_SIGN) RRC_ACC_REL_MT_HIGH_PR_SIGN,
SUM(RRC_ATT_REP_MO_CONV) RRC_ATT_REP_MO_CONV,
SUM(RRC_ATT_REP_MO_INTERACTIVE) RRC_ATT_REP_MO_INTERACTIVE,
SUM(RRC_ATT_REP_MO_BACKGROUND) RRC_ATT_REP_MO_BACKGROUND,
SUM(RRC_ATT_REP_MT_CONV) RRC_ATT_REP_MT_CONV,
SUM(RRC_ATT_REP_INTERACTIVE) RRC_ATT_REP_INTERACTIVE,
SUM(RRC_ATT_REP_MT_BACKGROUND) RRC_ATT_REP_MT_BACKGROUND,
SUM(RRC_ATT_REP_EMERGENCY) RRC_ATT_REP_EMERGENCY,
SUM(RRC_ATT_REP_MO_HIGH_PR_SIGN) RRC_ATT_REP_MO_HIGH_PR_SIGN,
SUM(RRC_ATT_REP_MT_HIGH_PR_SIGN) RRC_ATT_REP_MT_HIGH_PR_SIGN,
SUM(RRC_CONN_STP_REJ_EMERG_CALL) RRC_CONN_STP_REJ_EMERG_CALL,
SUM(RAB_ACT_FAIL_PS_INTER_TRANS) RAB_ACT_FAIL_PS_INTER_TRANS,
SUM(RAB_ACT_FAIL_PS_BACKG_TRANS) RAB_ACT_FAIL_PS_BACKG_TRANS,
SUM(RAB_ACT_REL_PS_INTER_HHO) RAB_ACT_REL_PS_INTER_HHO,
SUM(RAB_ACT_REL_PS_BACKG_HHO) RAB_ACT_REL_PS_BACKG_HHO,
SUM(RAB_ACT_REL_PS_INTER_ISHO) RAB_ACT_REL_PS_INTER_ISHO,
SUM(RAB_ACT_REL_PS_BGR_ISHO) RAB_ACT_REL_PS_BGR_ISHO
from

jf_wcel_2260635819 t,
nokrww_ps_servlev_wcel_day p
where
t."wbts_gid" in ( '6774075' )
and period_start_time >= to_date('2020/04/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/04/22 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t."wcel_gid" = p.wcel_id
group by
trunc( p.period_start_time, 'dd' ),
t."rnc_gid",
t."wbts_gid",
t."wcel_gid"
)a
group by
a.period_start_time,
a.wbts_gid
creating tmp table: jf_RRC_2234530832
create global temporary table jf_RRC_2234530832 on commit preserve rows as
select
a.period_start_time,
a.wbts_gid,

Page 31
 Report Execution

SUM(CELL_UPDATE_ATT_CS_CALL) CELL_UPDATE_ATT_CS_CALL,
SUM(CELL_UPDATE_SUCC_CS_CALL) CELL_UPDATE_SUCC_CS_CALL
from
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t."rnc_gid" rnc_gid,
t."wbts_gid" wbts_gid,
t."wcel_gid" wcel_gid,
SUM(CELL_UPDATE_ATT_CS_CALL) CELL_UPDATE_ATT_CS_CALL,
SUM(CELL_UPDATE_SUCC_CS_CALL) CELL_UPDATE_SUCC_CS_CALL
from

jf_wcel_2260635819 t,
nokrww_ps_rrc_wcel_day p
where
t."wbts_gid" in ( '6774075' )
and period_start_time >= to_date('2020/04/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/04/22 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t."wcel_gid" = p.wcel_id
group by
trunc( p.period_start_time, 'dd' ),
t."rnc_gid",
t."wbts_gid",
t."wcel_gid"
)a
group by
a.period_start_time,
a.wbts_gid
creating tmp table: jf_PKTCALL_2213471215
create global temporary table jf_PKTCALL_2213471215 on commit preserve rows as
select
a.period_start_time,
a.wbts_gid,
SUM(PS_ATT_HSDSCH_EDCH_INT) PS_ATT_HSDSCH_EDCH_INT,
SUM(PS_ATT_HSDSCH_EDCH_BGR) PS_ATT_HSDSCH_EDCH_BGR,
SUM(PS_ATT_HSDSCH_DCH_INT) PS_ATT_HSDSCH_DCH_INT,
SUM(PS_ATT_HSDSCH_DCH_BGR) PS_ATT_HSDSCH_DCH_BGR,
SUM(PS_ATT_DCH_DCH_INT) PS_ATT_DCH_DCH_INT,
SUM(PS_ATT_DCH_DCH_BGR) PS_ATT_DCH_DCH_BGR,
SUM(HS_E_REQ_HS_E_ALLO_INT) HS_E_REQ_HS_E_ALLO_INT,
SUM(HS_E_REQ_HS_E_ALLO_BGR) HS_E_REQ_HS_E_ALLO_BGR,
SUM(HS_E_REQ_HS_D_ALLO_INT) HS_E_REQ_HS_D_ALLO_INT,
SUM(HS_E_REQ_HS_D_ALLO_BGR) HS_E_REQ_HS_D_ALLO_BGR,
SUM(HS_D_REQ_HS_D_ALLO_INT) HS_D_REQ_HS_D_ALLO_INT,
SUM(HS_D_REQ_HS_D_ALLO_BGR) HS_D_REQ_HS_D_ALLO_BGR,
SUM(HS_E_REQ_D_D_ALLO_INT) HS_E_REQ_D_D_ALLO_INT,

Page 32
 Report Execution

SUM(HS_E_REQ_D_D_ALLO_BGR) HS_E_REQ_D_D_ALLO_BGR,
SUM(HS_D_REQ_D_D_ALLO_INT) HS_D_REQ_D_D_ALLO_INT,
SUM(HS_D_REQ_D_D_ALLO_BGR) HS_D_REQ_D_D_ALLO_BGR,
SUM(D_D_REQ_D_D_ALLO_INT) D_D_REQ_D_D_ALLO_INT,
SUM(D_D_REQ_D_D_ALLO_BGR) D_D_REQ_D_D_ALLO_BGR,
SUM(PS_SWI_HS_E_TO_HS_D_INT) PS_SWI_HS_E_TO_HS_D_INT,
SUM(PS_SWI_HS_E_TO_HS_D_BGR) PS_SWI_HS_E_TO_HS_D_BGR,
SUM(PS_SWI_HS_E_TO_D_D_INT) PS_SWI_HS_E_TO_D_D_INT,
SUM(PS_SWI_HS_E_TO_D_D_BGR) PS_SWI_HS_E_TO_D_D_BGR,
SUM(PS_SWI_HS_D_TO_D_D_INT) PS_SWI_HS_D_TO_D_D_INT,
SUM(PS_SWI_HS_D_TO_D_D_BGR) PS_SWI_HS_D_TO_D_D_BGR,
SUM(PS_REL_NORM_HS_E_INT) PS_REL_NORM_HS_E_INT,
SUM(PS_REL_NORM_HS_E_BGR) PS_REL_NORM_HS_E_BGR,
SUM(PS_REL_NORM_HS_D_INT) PS_REL_NORM_HS_D_INT,
SUM(PS_REL_NORM_HS_D_BGR) PS_REL_NORM_HS_D_BGR,
SUM(PS_REL_RL_FAIL_HS_E_INT) PS_REL_RL_FAIL_HS_E_INT,
SUM(PS_REL_RL_FAIL_HS_E_BGR) PS_REL_RL_FAIL_HS_E_BGR,
SUM(PS_REL_RL_FAIL_HS_D_INT) PS_REL_RL_FAIL_HS_D_INT,
SUM(PS_REL_RL_FAIL_HS_D_BGR) PS_REL_RL_FAIL_HS_D_BGR,
SUM(PS_REL_OTH_FAIL_HS_E_INT) PS_REL_OTH_FAIL_HS_E_INT,
SUM(PS_REL_OTH_FAIL_HS_E_BGR) PS_REL_OTH_FAIL_HS_E_BGR,
SUM(PS_REL_OTH_FAIL_HS_D_INT) PS_REL_OTH_FAIL_HS_D_INT,
SUM(PS_REL_OTH_FAIL_HS_D_BGR) PS_REL_OTH_FAIL_HS_D_BGR,
SUM(PS_ATT_HSDSCH_EDCH_STRE) PS_ATT_HSDSCH_EDCH_STRE,
SUM(PS_ATT_HSDSCH_DCH_STRE) PS_ATT_HSDSCH_DCH_STRE,
SUM(PS_ATT_DCH_DCH_STRE) PS_ATT_DCH_DCH_STRE,
SUM(HS_E_REQ_HS_E_ALLO_STRE) HS_E_REQ_HS_E_ALLO_STRE,
SUM(HS_E_REQ_HS_D_ALLO_STRE) HS_E_REQ_HS_D_ALLO_STRE,
SUM(HS_D_REQ_HS_D_ALLO_STRE) HS_D_REQ_HS_D_ALLO_STRE,
SUM(HS_E_REQ_D_D_ALLO_STRE) HS_E_REQ_D_D_ALLO_STRE,
SUM(HS_D_REQ_D_D_ALLO_STRE) HS_D_REQ_D_D_ALLO_STRE,
SUM(D_D_REQ_D_D_ALLO_STRE) D_D_REQ_D_D_ALLO_STRE,
SUM(PS_SWI_HS_E_TO_HS_D_STRE) PS_SWI_HS_E_TO_HS_D_STRE,
SUM(PS_SWI_HS_E_TO_D_D_STRE) PS_SWI_HS_E_TO_D_D_STRE,
SUM(PS_SWI_HS_D_TO_D_D_STRE) PS_SWI_HS_D_TO_D_D_STRE,
SUM(PS_REL_NORM_HS_E_STRE) PS_REL_NORM_HS_E_STRE,
SUM(PS_REL_NORM_HS_D_STRE) PS_REL_NORM_HS_D_STRE,
SUM(PS_REL_RL_FAIL_HS_E_STRE) PS_REL_RL_FAIL_HS_E_STRE,
SUM(PS_REL_RL_FAIL_HS_D_STRE) PS_REL_RL_FAIL_HS_D_STRE,
SUM(PS_REL_OTH_FAIL_HS_E_STRE) PS_REL_OTH_FAIL_HS_E_STRE,
SUM(PS_REL_OTH_FAIL_HS_D_STRE) PS_REL_OTH_FAIL_HS_D_STRE,
SUM(RLC_DL_SDU_BYTES_RECEIVED) RLC_DL_SDU_BYTES_RECEIVED,
SUM(RLC_UL_SDU_BYTES_RECEIVED) RLC_UL_SDU_BYTES_RECEIVED
from
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,

Page 33
 Report Execution

t."rnc_gid" rnc_gid,
t."wbts_gid" wbts_gid,
t."wcel_gid" wcel_gid,
SUM(PS_ATT_HSDSCH_EDCH_INT) PS_ATT_HSDSCH_EDCH_INT,
SUM(PS_ATT_HSDSCH_EDCH_BGR) PS_ATT_HSDSCH_EDCH_BGR,
SUM(PS_ATT_HSDSCH_DCH_INT) PS_ATT_HSDSCH_DCH_INT,
SUM(PS_ATT_HSDSCH_DCH_BGR) PS_ATT_HSDSCH_DCH_BGR,
SUM(PS_ATT_DCH_DCH_INT) PS_ATT_DCH_DCH_INT,
SUM(PS_ATT_DCH_DCH_BGR) PS_ATT_DCH_DCH_BGR,
SUM(HS_E_REQ_HS_E_ALLO_INT) HS_E_REQ_HS_E_ALLO_INT,
SUM(HS_E_REQ_HS_E_ALLO_BGR) HS_E_REQ_HS_E_ALLO_BGR,
SUM(HS_E_REQ_HS_D_ALLO_INT) HS_E_REQ_HS_D_ALLO_INT,
SUM(HS_E_REQ_HS_D_ALLO_BGR) HS_E_REQ_HS_D_ALLO_BGR,
SUM(HS_D_REQ_HS_D_ALLO_INT) HS_D_REQ_HS_D_ALLO_INT,
SUM(HS_D_REQ_HS_D_ALLO_BGR) HS_D_REQ_HS_D_ALLO_BGR,
SUM(HS_E_REQ_D_D_ALLO_INT) HS_E_REQ_D_D_ALLO_INT,
SUM(HS_E_REQ_D_D_ALLO_BGR) HS_E_REQ_D_D_ALLO_BGR,
SUM(HS_D_REQ_D_D_ALLO_INT) HS_D_REQ_D_D_ALLO_INT,
SUM(HS_D_REQ_D_D_ALLO_BGR) HS_D_REQ_D_D_ALLO_BGR,
SUM(D_D_REQ_D_D_ALLO_INT) D_D_REQ_D_D_ALLO_INT,
SUM(D_D_REQ_D_D_ALLO_BGR) D_D_REQ_D_D_ALLO_BGR,
SUM(PS_SWI_HS_E_TO_HS_D_INT) PS_SWI_HS_E_TO_HS_D_INT,
SUM(PS_SWI_HS_E_TO_HS_D_BGR) PS_SWI_HS_E_TO_HS_D_BGR,
SUM(PS_SWI_HS_E_TO_D_D_INT) PS_SWI_HS_E_TO_D_D_INT,
SUM(PS_SWI_HS_E_TO_D_D_BGR) PS_SWI_HS_E_TO_D_D_BGR,
SUM(PS_SWI_HS_D_TO_D_D_INT) PS_SWI_HS_D_TO_D_D_INT,
SUM(PS_SWI_HS_D_TO_D_D_BGR) PS_SWI_HS_D_TO_D_D_BGR,
SUM(PS_REL_NORM_HS_E_INT) PS_REL_NORM_HS_E_INT,
SUM(PS_REL_NORM_HS_E_BGR) PS_REL_NORM_HS_E_BGR,
SUM(PS_REL_NORM_HS_D_INT) PS_REL_NORM_HS_D_INT,
SUM(PS_REL_NORM_HS_D_BGR) PS_REL_NORM_HS_D_BGR,
SUM(PS_REL_RL_FAIL_HS_E_INT) PS_REL_RL_FAIL_HS_E_INT,
SUM(PS_REL_RL_FAIL_HS_E_BGR) PS_REL_RL_FAIL_HS_E_BGR,
SUM(PS_REL_RL_FAIL_HS_D_INT) PS_REL_RL_FAIL_HS_D_INT,
SUM(PS_REL_RL_FAIL_HS_D_BGR) PS_REL_RL_FAIL_HS_D_BGR,
SUM(PS_REL_OTH_FAIL_HS_E_INT) PS_REL_OTH_FAIL_HS_E_INT,
SUM(PS_REL_OTH_FAIL_HS_E_BGR) PS_REL_OTH_FAIL_HS_E_BGR,
SUM(PS_REL_OTH_FAIL_HS_D_INT) PS_REL_OTH_FAIL_HS_D_INT,
SUM(PS_REL_OTH_FAIL_HS_D_BGR) PS_REL_OTH_FAIL_HS_D_BGR,
SUM(PS_ATT_HSDSCH_EDCH_STRE) PS_ATT_HSDSCH_EDCH_STRE,
SUM(PS_ATT_HSDSCH_DCH_STRE) PS_ATT_HSDSCH_DCH_STRE,
SUM(PS_ATT_DCH_DCH_STRE) PS_ATT_DCH_DCH_STRE,
SUM(HS_E_REQ_HS_E_ALLO_STRE) HS_E_REQ_HS_E_ALLO_STRE,
SUM(HS_E_REQ_HS_D_ALLO_STRE) HS_E_REQ_HS_D_ALLO_STRE,
SUM(HS_D_REQ_HS_D_ALLO_STRE) HS_D_REQ_HS_D_ALLO_STRE,
SUM(HS_E_REQ_D_D_ALLO_STRE) HS_E_REQ_D_D_ALLO_STRE,
SUM(HS_D_REQ_D_D_ALLO_STRE) HS_D_REQ_D_D_ALLO_STRE,

Page 34
 Report Execution

SUM(D_D_REQ_D_D_ALLO_STRE) D_D_REQ_D_D_ALLO_STRE,
SUM(PS_SWI_HS_E_TO_HS_D_STRE) PS_SWI_HS_E_TO_HS_D_STRE,
SUM(PS_SWI_HS_E_TO_D_D_STRE) PS_SWI_HS_E_TO_D_D_STRE,
SUM(PS_SWI_HS_D_TO_D_D_STRE) PS_SWI_HS_D_TO_D_D_STRE,
SUM(PS_REL_NORM_HS_E_STRE) PS_REL_NORM_HS_E_STRE,
SUM(PS_REL_NORM_HS_D_STRE) PS_REL_NORM_HS_D_STRE,
SUM(PS_REL_RL_FAIL_HS_E_STRE) PS_REL_RL_FAIL_HS_E_STRE,
SUM(PS_REL_RL_FAIL_HS_D_STRE) PS_REL_RL_FAIL_HS_D_STRE,
SUM(PS_REL_OTH_FAIL_HS_E_STRE) PS_REL_OTH_FAIL_HS_E_STRE,
SUM(PS_REL_OTH_FAIL_HS_D_STRE) PS_REL_OTH_FAIL_HS_D_STRE,
SUM(RLC_DL_SDU_BYTES_RECEIVED) RLC_DL_SDU_BYTES_RECEIVED,
SUM(RLC_UL_SDU_BYTES_RECEIVED) RLC_UL_SDU_BYTES_RECEIVED
from

jf_wcel_2260635819 t,
nokrww_ps_pktcall_wcel_day p
where
t."wbts_gid" in ( '6774075' )
and period_start_time >= to_date('2020/04/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/04/22 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t."wcel_gid" = p.wcel_id
group by
trunc( p.period_start_time, 'dd' ),
t."rnc_gid",
t."wbts_gid",
t."wcel_gid"
)a
group by
a.period_start_time,
a.wbts_gid
creating tmp table: jf_INTERSHO_2271032594
create global temporary table jf_INTERSHO_2271032594 on commit preserve rows as
select
a.period_start_time,
a.wbts_gid,
SUM(is_hho_att_ul_dch_q_rt) is_hho_att_ul_dch_q_rt,
SUM(succ_is_hho_ul_dch_q_rt) succ_is_hho_ul_dch_q_rt,
SUM(is_hho_att_ue_trx_pwr_rt) is_hho_att_ue_trx_pwr_rt,
SUM(succ_is_hho_ue_trx_pwr_rt) succ_is_hho_ue_trx_pwr_rt,
SUM(is_hho_att_dpch_pwr_rt) is_hho_att_dpch_pwr_rt,
SUM(succ_is_hho_dl_dpch_pwr_rt) succ_is_hho_dl_dpch_pwr_rt,
SUM(is_hho_att_cpich_rscp_rt) is_hho_att_cpich_rscp_rt,
SUM(succ_is_hho_cpich_rscp_rt) succ_is_hho_cpich_rscp_rt,
SUM(is_hho_att_cpich_ecno_rt) is_hho_att_cpich_ecno_rt,
SUM(succ_is_hho_cpich_ecno_rt) succ_is_hho_cpich_ecno_rt,
SUM(is_hho_att_ul_dch_q_nrt) is_hho_att_ul_dch_q_nrt,
SUM(succ_is_hho_ul_dch_q_nrt) succ_is_hho_ul_dch_q_nrt,

Page 35
 Report Execution

SUM(is_hho_att_ue_trx_pwr_nrt) is_hho_att_ue_trx_pwr_nrt,
SUM(succ_is_hho_ue_trx_pwr_nrt) succ_is_hho_ue_trx_pwr_nrt,
SUM(is_hho_att_dl_dpch_pwr_nrt) is_hho_att_dl_dpch_pwr_nrt,
SUM(succ_is_hho_dl_dpch_pwr_nrt) succ_is_hho_dl_dpch_pwr_nrt,
SUM(is_hho_att_cpich_rscp_nrt) is_hho_att_cpich_rscp_nrt,
SUM(succ_is_hho_cpich_rscp_nrt) succ_is_hho_cpich_rscp_nrt,
SUM(is_hho_att_cpich_ecno_nrt) is_hho_att_cpich_ecno_nrt,
SUM(succ_is_hho_cpich_ecno_nrt) succ_is_hho_cpich_ecno_nrt,
SUM(IS_HHO_ATT_IM_IMS_RT) IS_HHO_ATT_IM_IMS_RT,
SUM(SUCC_IS_HHO_IM_IMS_RT) SUCC_IS_HHO_IM_IMS_RT,
SUM(IS_HHO_ATT_IM_IMS_NRT) IS_HHO_ATT_IM_IMS_NRT,
SUM(SUCC_IS_HHO_IM_IMS_NRT) SUCC_IS_HHO_IM_IMS_NRT,
SUM(IS_HHO_ATT_EMERG_CALL) IS_HHO_ATT_EMERG_CALL,
SUM(SUCC_IS_HHO_EMERG_CALL) SUCC_IS_HHO_EMERG_CALL,
SUM(IS_HHO_ATT_LB_PRX_TOT_RT) IS_HHO_ATT_LB_PRX_TOT_RT,
SUM(IS_HHO_ATT_LB_PTX_TOT_RT) IS_HHO_ATT_LB_PTX_TOT_RT,
SUM(IS_HHO_ATT_LB_RSVR_SC_RT) IS_HHO_ATT_LB_RSVR_SC_RT,
SUM(IS_HHO_ATT_LB_RES_LIM_RT) IS_HHO_ATT_LB_RES_LIM_RT,
SUM(IS_HHO_ATT_SB_RT) IS_HHO_ATT_SB_RT,
SUM(IS_HHO_ATT_LB_PRX_TOT_NRT) IS_HHO_ATT_LB_PRX_TOT_NRT,
SUM(IS_HHO_ATT_LB_PTX_TOT_NRT) IS_HHO_ATT_LB_PTX_TOT_NRT,
SUM(IS_HHO_ATT_LB_CAPA_UL_NRT) IS_HHO_ATT_LB_CAPA_UL_NRT,
SUM(IS_HHO_ATT_LB_CAPA_DL_NRT) IS_HHO_ATT_LB_CAPA_DL_NRT,
SUM(IS_HHO_ATT_LB_RSVR_SC_NRT) IS_HHO_ATT_LB_RSVR_SC_NRT,
SUM(IS_HHO_ATT_LB_RES_LIM_NRT) IS_HHO_ATT_LB_RES_LIM_NRT,
SUM(IS_HHO_ATT_SB_NRT) IS_HHO_ATT_SB_NRT,
SUM(SUCC_IS_HHO_LB_PRX_TOT_RT) SUCC_IS_HHO_LB_PRX_TOT_RT,
SUM(SUCC_IS_HHO_LB_PTX_TOT_RT) SUCC_IS_HHO_LB_PTX_TOT_RT,
SUM(SUCC_IS_HHO_LB_RSVR_SC_RT) SUCC_IS_HHO_LB_RSVR_SC_RT,
SUM(SUCC_IS_HHO_LB_RES_LIM_RT) SUCC_IS_HHO_LB_RES_LIM_RT,
SUM(SUCC_IS_HHO_SB_RT) SUCC_IS_HHO_SB_RT,
SUM(SUCC_IS_HHO_LB_PRX_TOT_NRT) SUCC_IS_HHO_LB_PRX_TOT_NRT,
SUM(SUCC_IS_HHO_LB_PTX_TOT_NRT) SUCC_IS_HHO_LB_PTX_TOT_NRT,
SUM(SUCC_IS_HHO_LB_CAPA_UL_NRT) SUCC_IS_HHO_LB_CAPA_UL_NRT,
SUM(SUCC_IS_HHO_LB_CAPA_DL_NRT) SUCC_IS_HHO_LB_CAPA_DL_NRT,
SUM(SUCC_IS_HHO_LB_RSVR_SC_NRT) SUCC_IS_HHO_LB_RSVR_SC_NRT,
SUM(SUCC_IS_HHO_LB_RES_LIM_NRT) SUCC_IS_HHO_LB_RES_LIM_NRT,
SUM(SUCC_IS_HHO_SB_NRT) SUCC_IS_HHO_SB_NRT,
SUM(IS_HHO_ATT_UL_DCH_WPS_RT) IS_HHO_ATT_UL_DCH_WPS_RT,
SUM(SUCC_IS_HHO_WPS_RT) SUCC_IS_HHO_WPS_RT,
SUM(IS_HHO_ATT_LB_CAPA_UL_RT) IS_HHO_ATT_LB_CAPA_UL_RT,
SUM(IS_HHO_ATT_LB_CAPA_DL_RT) IS_HHO_ATT_LB_CAPA_DL_RT,
SUM(SUCC_IS_HHO_LB_CAPA_UL_RT) SUCC_IS_HHO_LB_CAPA_UL_RT,
SUM(SUCC_IS_HHO_LB_CAPA_DL_RT) SUCC_IS_HHO_LB_CAPA_DL_RT,
SUM(ATT_GANHO_AMR_RT) ATT_GANHO_AMR_RT,
SUM(SUCC_GANHO_AMR_RT) SUCC_GANHO_AMR_RT,
SUM(ATT_ISHO_CELL_SHUTDOWN_NRT) ATT_ISHO_CELL_SHUTDOWN_NRT,

Page 36
 Report Execution

SUM(ATT_ISHO_CELL_SHUTDOWN_RT) ATT_ISHO_CELL_SHUTDOWN_RT,
SUM(SUCC_ISHO_CELL_SHUTDOWN_NRT) SUCC_ISHO_CELL_SHUTDOWN_NRT,
SUM(SUCC_ISHO_CELL_SHUTDOWN_RT) SUCC_ISHO_CELL_SHUTDOWN_RT,
SUM(IS_HHO_ATT_2ND_BEST_CELL_RT) IS_HHO_ATT_2ND_BEST_CELL_RT,
SUM(IS_HHO_ATT_3RD_BEST_CELL_RT) IS_HHO_ATT_3RD_BEST_CELL_RT,
SUM(IS_HHO_ATT_2ND_BEST_CELL_NRT) IS_HHO_ATT_2ND_BEST_CELL_NRT,
SUM(IS_HHO_ATT_3RD_BEST_CELL_NRT) IS_HHO_ATT_3RD_BEST_CELL_NRT,
SUM(ATT_ISHO_CELL_BLOCK_NRT) ATT_ISHO_CELL_BLOCK_NRT,
SUM(ATT_ISHO_CELL_BLOCK_RT) ATT_ISHO_CELL_BLOCK_RT,
SUM(SUCC_ISHO_CELL_BLOCK_NRT) SUCC_ISHO_CELL_BLOCK_NRT,
SUM(SUCC_ISHO_CELL_BLOCK_RT) SUCC_ISHO_CELL_BLOCK_RT
from
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t."rnc_gid" rnc_gid,
t."wbts_gid" wbts_gid,
t."wcel_gid" wcel_gid,
SUM(is_hho_att_ul_dch_q_rt) is_hho_att_ul_dch_q_rt,
SUM(succ_is_hho_ul_dch_q_rt) succ_is_hho_ul_dch_q_rt,
SUM(is_hho_att_ue_trx_pwr_rt) is_hho_att_ue_trx_pwr_rt,
SUM(succ_is_hho_ue_trx_pwr_rt) succ_is_hho_ue_trx_pwr_rt,
SUM(is_hho_att_dpch_pwr_rt) is_hho_att_dpch_pwr_rt,
SUM(succ_is_hho_dl_dpch_pwr_rt) succ_is_hho_dl_dpch_pwr_rt,
SUM(is_hho_att_cpich_rscp_rt) is_hho_att_cpich_rscp_rt,
SUM(succ_is_hho_cpich_rscp_rt) succ_is_hho_cpich_rscp_rt,
SUM(is_hho_att_cpich_ecno_rt) is_hho_att_cpich_ecno_rt,
SUM(succ_is_hho_cpich_ecno_rt) succ_is_hho_cpich_ecno_rt,
SUM(is_hho_att_ul_dch_q_nrt) is_hho_att_ul_dch_q_nrt,
SUM(succ_is_hho_ul_dch_q_nrt) succ_is_hho_ul_dch_q_nrt,
SUM(is_hho_att_ue_trx_pwr_nrt) is_hho_att_ue_trx_pwr_nrt,
SUM(succ_is_hho_ue_trx_pwr_nrt) succ_is_hho_ue_trx_pwr_nrt,
SUM(is_hho_att_dl_dpch_pwr_nrt) is_hho_att_dl_dpch_pwr_nrt,
SUM(succ_is_hho_dl_dpch_pwr_nrt) succ_is_hho_dl_dpch_pwr_nrt,
SUM(is_hho_att_cpich_rscp_nrt) is_hho_att_cpich_rscp_nrt,
SUM(succ_is_hho_cpich_rscp_nrt) succ_is_hho_cpich_rscp_nrt,
SUM(is_hho_att_cpich_ecno_nrt) is_hho_att_cpich_ecno_nrt,
SUM(succ_is_hho_cpich_ecno_nrt) succ_is_hho_cpich_ecno_nrt,
SUM(IS_HHO_ATT_IM_IMS_RT) IS_HHO_ATT_IM_IMS_RT,
SUM(SUCC_IS_HHO_IM_IMS_RT) SUCC_IS_HHO_IM_IMS_RT,
SUM(IS_HHO_ATT_IM_IMS_NRT) IS_HHO_ATT_IM_IMS_NRT,
SUM(SUCC_IS_HHO_IM_IMS_NRT) SUCC_IS_HHO_IM_IMS_NRT,
SUM(IS_HHO_ATT_EMERG_CALL) IS_HHO_ATT_EMERG_CALL,
SUM(SUCC_IS_HHO_EMERG_CALL) SUCC_IS_HHO_EMERG_CALL,
SUM(IS_HHO_ATT_LB_PRX_TOT_RT) IS_HHO_ATT_LB_PRX_TOT_RT,
SUM(IS_HHO_ATT_LB_PTX_TOT_RT) IS_HHO_ATT_LB_PTX_TOT_RT,
SUM(IS_HHO_ATT_LB_RSVR_SC_RT) IS_HHO_ATT_LB_RSVR_SC_RT,

Page 37
 Report Execution

SUM(IS_HHO_ATT_LB_RES_LIM_RT) IS_HHO_ATT_LB_RES_LIM_RT,
SUM(IS_HHO_ATT_SB_RT) IS_HHO_ATT_SB_RT,
SUM(IS_HHO_ATT_LB_PRX_TOT_NRT) IS_HHO_ATT_LB_PRX_TOT_NRT,
SUM(IS_HHO_ATT_LB_PTX_TOT_NRT) IS_HHO_ATT_LB_PTX_TOT_NRT,
SUM(IS_HHO_ATT_LB_CAPA_UL_NRT) IS_HHO_ATT_LB_CAPA_UL_NRT,
SUM(IS_HHO_ATT_LB_CAPA_DL_NRT) IS_HHO_ATT_LB_CAPA_DL_NRT,
SUM(IS_HHO_ATT_LB_RSVR_SC_NRT) IS_HHO_ATT_LB_RSVR_SC_NRT,
SUM(IS_HHO_ATT_LB_RES_LIM_NRT) IS_HHO_ATT_LB_RES_LIM_NRT,
SUM(IS_HHO_ATT_SB_NRT) IS_HHO_ATT_SB_NRT,
SUM(SUCC_IS_HHO_LB_PRX_TOT_RT) SUCC_IS_HHO_LB_PRX_TOT_RT,
SUM(SUCC_IS_HHO_LB_PTX_TOT_RT) SUCC_IS_HHO_LB_PTX_TOT_RT,
SUM(SUCC_IS_HHO_LB_RSVR_SC_RT) SUCC_IS_HHO_LB_RSVR_SC_RT,
SUM(SUCC_IS_HHO_LB_RES_LIM_RT) SUCC_IS_HHO_LB_RES_LIM_RT,
SUM(SUCC_IS_HHO_SB_RT) SUCC_IS_HHO_SB_RT,
SUM(SUCC_IS_HHO_LB_PRX_TOT_NRT) SUCC_IS_HHO_LB_PRX_TOT_NRT,
SUM(SUCC_IS_HHO_LB_PTX_TOT_NRT) SUCC_IS_HHO_LB_PTX_TOT_NRT,
SUM(SUCC_IS_HHO_LB_CAPA_UL_NRT) SUCC_IS_HHO_LB_CAPA_UL_NRT,
SUM(SUCC_IS_HHO_LB_CAPA_DL_NRT) SUCC_IS_HHO_LB_CAPA_DL_NRT,
SUM(SUCC_IS_HHO_LB_RSVR_SC_NRT) SUCC_IS_HHO_LB_RSVR_SC_NRT,
SUM(SUCC_IS_HHO_LB_RES_LIM_NRT) SUCC_IS_HHO_LB_RES_LIM_NRT,
SUM(SUCC_IS_HHO_SB_NRT) SUCC_IS_HHO_SB_NRT,
SUM(IS_HHO_ATT_UL_DCH_WPS_RT) IS_HHO_ATT_UL_DCH_WPS_RT,
SUM(SUCC_IS_HHO_WPS_RT) SUCC_IS_HHO_WPS_RT,
SUM(IS_HHO_ATT_LB_CAPA_UL_RT) IS_HHO_ATT_LB_CAPA_UL_RT,
SUM(IS_HHO_ATT_LB_CAPA_DL_RT) IS_HHO_ATT_LB_CAPA_DL_RT,
SUM(SUCC_IS_HHO_LB_CAPA_UL_RT) SUCC_IS_HHO_LB_CAPA_UL_RT,
SUM(SUCC_IS_HHO_LB_CAPA_DL_RT) SUCC_IS_HHO_LB_CAPA_DL_RT,
SUM(ATT_GANHO_AMR_RT) ATT_GANHO_AMR_RT,
SUM(SUCC_GANHO_AMR_RT) SUCC_GANHO_AMR_RT,
SUM(ATT_ISHO_CELL_SHUTDOWN_NRT) ATT_ISHO_CELL_SHUTDOWN_NRT,
SUM(ATT_ISHO_CELL_SHUTDOWN_RT) ATT_ISHO_CELL_SHUTDOWN_RT,
SUM(SUCC_ISHO_CELL_SHUTDOWN_NRT) SUCC_ISHO_CELL_SHUTDOWN_NRT,
SUM(SUCC_ISHO_CELL_SHUTDOWN_RT) SUCC_ISHO_CELL_SHUTDOWN_RT,
SUM(IS_HHO_ATT_2ND_BEST_CELL_RT) IS_HHO_ATT_2ND_BEST_CELL_RT,
SUM(IS_HHO_ATT_3RD_BEST_CELL_RT) IS_HHO_ATT_3RD_BEST_CELL_RT,
SUM(IS_HHO_ATT_2ND_BEST_CELL_NRT) IS_HHO_ATT_2ND_BEST_CELL_NRT,
SUM(IS_HHO_ATT_3RD_BEST_CELL_NRT) IS_HHO_ATT_3RD_BEST_CELL_NRT,
SUM(ATT_ISHO_CELL_BLOCK_NRT) ATT_ISHO_CELL_BLOCK_NRT,
SUM(ATT_ISHO_CELL_BLOCK_RT) ATT_ISHO_CELL_BLOCK_RT,
SUM(SUCC_ISHO_CELL_BLOCK_NRT) SUCC_ISHO_CELL_BLOCK_NRT,
SUM(SUCC_ISHO_CELL_BLOCK_RT) SUCC_ISHO_CELL_BLOCK_RT
from

jf_wcel_2260635819 t,
nokrww_ps_intersho_wcel_day p
where
t."wbts_gid" in ( '6774075' )

Page 38
 Report Execution

and period_start_time >= to_date('2020/04/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')

and period_start_time < to_date('2020/04/22 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t."wcel_gid" = p.wcel_id
group by
trunc( p.period_start_time, 'dd' ),
t."rnc_gid",
t."wbts_gid",
t."wcel_gid"
)a
group by
a.period_start_time,
a.wbts_gid
creating tmp table: jf_HSDPAW_2279392935
create global temporary table jf_HSDPAW_2279392935 on commit preserve rows as
select
a.period_start_time,
a.wbts_gid,
SUM(HS_SCCH_PWR_DIST_CLASS_0) HS_SCCH_PWR_DIST_CLASS_0,
SUM(HS_SCCH_PWR_DIST_CLASS_1) HS_SCCH_PWR_DIST_CLASS_1,
SUM(HS_SCCH_PWR_DIST_CLASS_2) HS_SCCH_PWR_DIST_CLASS_2,
SUM(HS_SCCH_PWR_DIST_CLASS_3) HS_SCCH_PWR_DIST_CLASS_3,
SUM(HS_SCCH_PWR_DIST_CLASS_4) HS_SCCH_PWR_DIST_CLASS_4,
SUM(HS_SCCH_PWR_DIST_CLASS_5) HS_SCCH_PWR_DIST_CLASS_5,
SUM(HSDPA_BUFF_WITH_DATA_PER_TTI) HSDPA_BUFF_WITH_DATA_PER_TTI,
SUM(RECEIVED_HS_MACD_BITS) RECEIVED_HS_MACD_BITS,
SUM(DISCARDED_HS_MACD_BITS) DISCARDED_HS_MACD_BITS
from
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t."rnc_gid" rnc_gid,
t."wbts_gid" wbts_gid,
t."wcel_gid" wcel_gid,
SUM(HS_SCCH_PWR_DIST_CLASS_0) HS_SCCH_PWR_DIST_CLASS_0,
SUM(HS_SCCH_PWR_DIST_CLASS_1) HS_SCCH_PWR_DIST_CLASS_1,
SUM(HS_SCCH_PWR_DIST_CLASS_2) HS_SCCH_PWR_DIST_CLASS_2,
SUM(HS_SCCH_PWR_DIST_CLASS_3) HS_SCCH_PWR_DIST_CLASS_3,
SUM(HS_SCCH_PWR_DIST_CLASS_4) HS_SCCH_PWR_DIST_CLASS_4,
SUM(HS_SCCH_PWR_DIST_CLASS_5) HS_SCCH_PWR_DIST_CLASS_5,
SUM(HSDPA_BUFF_WITH_DATA_PER_TTI) HSDPA_BUFF_WITH_DATA_PER_TTI,
SUM(RECEIVED_HS_MACD_BITS) RECEIVED_HS_MACD_BITS,
SUM(DISCARDED_HS_MACD_BITS) DISCARDED_HS_MACD_BITS
from

jf_wcel_2260635819 t,
nokrww_ps_hsdpaw_wcel_day p
where

Page 39
 Report Execution

t."wbts_gid" in ( '6774075' )
and period_start_time >= to_date('2020/04/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/04/22 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t."wcel_gid" = p.wcel_id
group by
trunc( p.period_start_time, 'dd' ),
t."rnc_gid",
t."wbts_gid",
t."wcel_gid"
)a
group by
a.period_start_time,
a.wbts_gid
creating tmp table: jf_CELTPW_228411479
create global temporary table jf_CELTPW_228411479 on commit preserve rows as
select
a.period_start_time,
a.wbts_gid,
SUM(MC_HSDPA_ORIG_DATA_PRI) MC_HSDPA_ORIG_DATA_PRI,
SUM(MC_HSDPA_ORIG_DATA_SEC) MC_HSDPA_ORIG_DATA_SEC,
SUM(HSDPA_ORIG_DATA) HSDPA_ORIG_DATA
from
(
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t."rnc_gid" rnc_gid,
t."wbts_gid" wbts_gid,
t."wcel_gid" wcel_gid,
SUM(MC_HSDPA_ORIG_DATA_PRI) MC_HSDPA_ORIG_DATA_PRI,
SUM(MC_HSDPA_ORIG_DATA_SEC) MC_HSDPA_ORIG_DATA_SEC,
SUM(HSDPA_ORIG_DATA) HSDPA_ORIG_DATA
from

jf_wcel_2260635819 t,
nokrww_ps_celtpw_wcel_day p
where
t."wbts_gid" in ( '6774075' )
and period_start_time >= to_date('2020/04/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/04/22 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t."wcel_gid" = p.wcel_id
group by
trunc( p.period_start_time, 'dd' ),
t."rnc_gid",
t."wbts_gid",
t."wcel_gid"
)a
group by

Page 40
 Report Execution

a.period_start_time,
a.wbts_gid
creating tmp table: jf_CELLRES_2298958344
create global temporary table jf_CELLRES_2298958344 on commit preserve rows as
select
trunc( p.period_start_time, 'dd' ) period_start_time,
t."wbts_gid" wbts_gid,
SUM(AVAIL_WCELL_IN_WO_STATE) AVAIL_WCELL_IN_WO_STATE,
SUM(AVAIL_WCELL_BLOCKED_BY_USER) AVAIL_WCELL_BLOCKED_BY_USER,
SUM(AVAIL_WCELL_EXISTS_IN_RNW_DB) AVAIL_WCELL_EXISTS_IN_RNW_DB
from

jf_wcel_2260635819 t,
nokrww_ps_cellres_wcel_day p
where
t."wbts_gid" in ( '6774075' )
and period_start_time >= to_date('2020/04/02 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/04/22 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and t."wcel_gid" = p.wcel_id
group by
trunc( p.period_start_time, 'dd' ),
t."wbts_gid"
creating tmp table: jf_ALLTABLES_2212280614
create global temporary table jf_ALLTABLES_2212280614 on commit preserve rows as
select
period_start_time,
wbts_gid
from
(
(
select
period_start_time, TO_CHAR(wbts_gid) wbts_gid
from
jf_CELLRES_2298958344
)
UNION
(
select
period_start_time, TO_CHAR(wbts_gid) wbts_gid
from
jf_CELTPW_228411479
)
UNION
(
select
period_start_time, TO_CHAR(wbts_gid) wbts_gid
from

Page 41
 Report Execution

jf_HSDPAW_2279392935
)
UNION
(
select
period_start_time, TO_CHAR(wbts_gid) wbts_gid
from
jf_INTERSHO_2271032594
)
UNION
(
select
period_start_time, TO_CHAR(wbts_gid) wbts_gid
from
jf_PKTCALL_2213471215
)
UNION
(
select
period_start_time, TO_CHAR(wbts_gid) wbts_gid
from
jf_RRC_2234530832
)
UNION
(
select
period_start_time, TO_CHAR(wbts_gid) wbts_gid
from
jf_SERVLEV_2233839730
)
)p
report from tmp tables
select
ALLTABLES.period_start_time period_start_time,
nvl("plmn".co_name, nvl("plmn".co_object_instance, 'NN('||"plmn".co_gid||')')) "PLMN name",
nvl("rnc".co_name, nvl("rnc".co_object_instance, 'NN('||"rnc".co_gid||')')) "RNC name",
nvl("wbts".co_name, nvl("wbts".co_object_instance, 'NN('||"wbts".co_gid||')')) "WBTS name",
"wbts".co_object_instance "WBTS ID",
ALLTABLES.wbts_gid, nvl("wbts".co_ext_dn, "wbts".co_dn) "DN",
to_number(decode( (servlev.rrc_conn_stp_att - servlev.rrc_conn_setup_att_repeat - servlev.rrc_co
to_number(100*decode( (servlev.moc_conv_call_atts + servlev.mtc_conv_call_atts + servlev.emer
to_number(decode( (servlev.moc_inter_call_atts + servlev.moc_backg_call_atts + servlev.moc_hig
to_number(decode( (pktcall.ps_att_hsdsch_edch_int + pktcall.ps_att_hsdsch_edch_bgr + pktcall.p
to_number(decode( (SERVLEV.rab_act_comp_cs_voice+ SERVLEV.rab_act_fail_cs_voice_iu+ SE
to_number(decode((SERVLEV.rab_act_comp_ps_inter+ SERVLEV.rab_act_comp_ps_backg+ SE
to_number(decode( (pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_r
to_number(100 - 100*decode( (pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_e_int + p

Page 42
 Report Execution

to_number(100*decode( (intersho.is_hho_att_ul_dch_q_rt + intersho.is_hho_att_ue_trx_pwr_rt + in

to_number(100*decode( (intersho.is_hho_att_ul_dch_q_nrt + intersho.is_hho_att_ue_trx_pwr_nrt +
to_number((servlev.avg_rab_hld_tm_cs_voice + nvl(servlev.rab_hold_time_cs_conv_64,0)*64/12.2
to_number(decode( (1000*1000),0,null, (pktcall.rlc_dl_sdu_bytes_received) / (1000*1000))) RNC_3
to_number(decode( (1000*1000),0,null, (pktcall.rlc_ul_sdu_bytes_received) / (1000*1000))) RNC_3
to_number(decode( (hsdpaw.hs_scch_pwr_dist_class_0 + hsdpaw.hs_scch_pwr_dist_class_1 + h
to_number(decode( hsdpaw.hsdpa_buff_with_data_per_tti,0,null, (celtpw.hsdpa_orig_data*8*500)
to_number(decode( (cellres.avail_wcell_exists_in_rnw_db - cellres.avail_wcell_blocked_by_user),0
from
utp_common_objects "plmn",
utp_common_objects "rnc",
utp_common_objects "wbts"
,
jf_ALLTABLES_2212280614 ALLTABLES,
jf_CELLRES_2298958344 CELLRES,
jf_CELTPW_228411479 CELTPW,
jf_HSDPAW_2279392935 HSDPAW,
jf_INTERSHO_2271032594 INTERSHO,
jf_PKTCALL_2213471215 PKTCALL,
jf_RRC_2234530832 RRC,
jf_SERVLEV_2233839730 SERVLEV
where
"rnc".co_parent_gid = "plmn".co_gid and
"wbts".co_parent_gid = "rnc".co_gid and
ALLTABLES.wbts_gid = "wbts".co_gid
and ALLTABLES.period_start_time = CELLRES.period_start_time (+) and ALLTABLES.wbts_gid =
and ALLTABLES.period_start_time = CELTPW.period_start_time (+) and ALLTABLES.wbts_gid =
and ALLTABLES.period_start_time = HSDPAW.period_start_time (+) and ALLTABLES.wbts_gid =
and ALLTABLES.period_start_time = INTERSHO.period_start_time (+) and ALLTABLES.wbts_gid
and ALLTABLES.period_start_time = PKTCALL.period_start_time (+) and ALLTABLES.wbts_gid =
and ALLTABLES.period_start_time = RRC.period_start_time (+) and ALLTABLES.wbts_gid = RRC
and ALLTABLES.period_start_time = SERVLEV.period_start_time (+) and ALLTABLES.wbts_gid =

order by
2,1,3,4

Page 43
 Report Execution

ELL_RESEL,

MP_AFT_DIR,
P_DIRECTED,

Page 44
 Report Execution

REAM_14_4,
REAM_57_6,

H_PR_SIGN,
_PR_SIGN,

_PR_SIGN,

MERG_CALL,

Page 45
 Report Execution

ELL_RESEL,

MP_AFT_DIR,
P_DIRECTED,

REAM_14_4,
REAM_57_6,

Page 46
 Report Execution

H_PR_SIGN,
_PR_SIGN,

_PR_SIGN,

MERG_CALL,

Page 47
 Report Execution

TDOWN_NRT,

CELL_NRT,
CELL_NRT,

Page 48
 Report Execution

TDOWN_NRT,

CELL_NRT,
CELL_NRT,

Page 49
 Report Execution

A_PER_TTI,

A_PER_TTI,

Page 50
 Report Execution

_BY_USER,

Page 51
 Report Execution

)')) "PLMN name",

)) "WBTS name",

t_repeat - servlev.rrc_conn_acc_rel_cell_resel + servlev.rrc_conn_setup_comp_aft_dir - servlev.rrc_conn_stp_rej_emerg_call),

call_atts + servlev.emergency_call_atts - servlev.rrc_att_rep_mo_conv - servlev.rrc_att_rep_mt_conv - servlev.rrc_att_rep_em
l_atts + servlev.moc_high_prior_sign_atts + servlev.mtc_inter_call_atts + servlev.mtc_backg_call_atts + servlev.mtc_high_prio
ch_edch_bgr + pktcall.ps_att_hsdsch_dch_int + pktcall.ps_att_hsdsch_dch_bgr + pktcall.ps_att_dch_dch_int + pktcall.ps_att_d
act_fail_cs_voice_iu+ SERVLEV.rab_act_fail_cs_voice_radio+ SERVLEV.rab_act_fail_cs_voice_bts+ SERVLEV.rab_act_fail_c
ct_comp_ps_backg+ SERVLEV.rab_act_rel_ps_inter_srnc+ SERVLEV.RAB_ACT_REL_PS_INTER_HHO+ SERVLEV.RAB_AC
_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_d_stre + pktcall.ps_rel_rl_fail_hs_d_int + pktcall.ps_rel_r
_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + p

Page 52
 Report Execution

o_att_ue_trx_pwr_rt + intersho.is_hho_att_dpch_pwr_rt + intersho.is_hho_att_cpich_rscp_rt + intersho.is_hho_att_cpich_ecno

ho_att_ue_trx_pwr_nrt + intersho.is_hho_att_dl_dpch_pwr_nrt + intersho.is_hho_att_cpich_rscp_nrt + intersho.is_hho_att_cpic
_cs_conv_64,0)*64/12.2 + nvl(servlev.rab_hold_time_cs_stream_14_4,0)*14.4/12.2 + nvl(servlev.rab_hold_time_cs_stream_5
) / (1000*1000))) RNC_3172a,
) / (1000*1000))) RNC_3173a,
h_pwr_dist_class_1 + hsdpaw.hs_scch_pwr_dist_class_2 + hsdpaw.hs_scch_pwr_dist_class_3 + hsdpaw.hs_scch_pwr_dist_c
sdpa_orig_data*8*500) / hsdpaw.hsdpa_buff_with_data_per_tti)) RNC_1879e,
cell_blocked_by_user),0,null, 100*(cellres.avail_wcell_in_wo_state) / (cellres.avail_wcell_exists_in_rnw_db - cellres.avail_wcel

ALLTABLES.wbts_gid = CELLRES.wbts_gid (+)

ALLTABLES.wbts_gid = CELTPW.wbts_gid (+)
ALLTABLES.wbts_gid = HSDPAW.wbts_gid (+)
d ALLTABLES.wbts_gid = INTERSHO.wbts_gid (+)
ALLTABLES.wbts_gid = PKTCALL.wbts_gid (+)
ABLES.wbts_gid = RRC.wbts_gid (+)
ALLTABLES.wbts_gid = SERVLEV.wbts_gid (+)

Page 53
 Report Execution

nn_stp_rej_emerg_call),0,null, (100*(servlev.rrc_conn_acc_comp + servlev.rrc_con_setup_comp_directed) / (servlev.rrc_conn_

servlev.rrc_att_rep_emergency - servlev.rrc_acc_rel_emergency - servlev.rrc_acc_rel_mo_conv - servlev.rrc_acc_rel_mt_con
+ servlev.mtc_high_prior_sign_atts - servlev.rrc_att_rep_interactive - servlev.rrc_att_rep_mo_interactive - servlev.rrc_att_rep_m
ch_int + pktcall.ps_att_dch_dch_bgr + pktcall.ps_att_hsdsch_edch_stre + pktcall.ps_att_hsdsch_dch_stre + pktcall.ps_att_dch_
SERVLEV.rab_act_fail_cs_voice_rnc+ SERVLEV.rab_act_fail_cs_voice_iur) ,0,null, 100*(SERVLEV.rab_act_fail_cs_voice_iu+
HO+ SERVLEV.RAB_ACT_REL_PS_INTER_ISHO+ SERVLEV.rab_act_rel_ps_backg_srnc+ SERVLEV.RAB_ACT_REL_PS_B
_d_int + pktcall.ps_rel_rl_fail_hs_d_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_o
el_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_norm_hs_e_stre + pktcall.ps_rel_norm_hs_e_int + pktc

Page 54
 Report Execution

.is_hho_att_cpich_ecno_rt + intersho.is_hho_att_im_ims_rt + intersho.is_hho_att_emerg_call + intersho.is_hho_att_lb_capa_d

intersho.is_hho_att_cpich_ecno_nrt + intersho.is_hho_att_im_ims_nrt + intersho.is_hho_att_lb_capa_dl_nrt + intersho.is_hho_
hold_time_cs_stream_57_6,0)*57.6/12.2) / (60*100*60)) RNC_280d,

aw.hs_scch_pwr_dist_class_4 + hsdpaw.hs_scch_pwr_dist_class_5),0,null, ((hsdpaw.received_hs_macd_bits - hsdpaw.discar

_db - cellres.avail_wcell_blocked_by_user))) RNC_727a

Page 55
 Report Execution

ted) / (servlev.rrc_conn_stp_att - servlev.rrc_conn_setup_att_repeat - servlev.rrc_conn_acc_rel_cell_resel + servlev.rrc_conn_

vlev.rrc_acc_rel_mt_conv - servlev.rrc_conn_stp_rej_emerg_call + nvl(rrc.cell_update_att_cs_call,0)),0,null, (servlev.moc_conv
e - servlev.rrc_att_rep_mo_high_pr_sign - servlev.rrc_att_rep_mo_background - servlev.rrc_att_rep_mt_background - servlev.r
tre + pktcall.ps_att_dch_dch_stre),0,null, (100*(pktcall.hs_e_req_hs_e_allo_int + pktcall.hs_e_req_hs_e_allo_bgr + pktcall.hs_
_act_fail_cs_voice_iu+ SERVLEV.rab_act_fail_cs_voice_radio+ SERVLEV.rab_act_fail_cs_voice_bts+ SERVLEV.rab_act_fail
V.RAB_ACT_REL_PS_BACKG_HHO+ SERVLEV.RAB_ACT_REL_PS_BGR_ISHO+ SERVLEV.rab_act_fail_ps_inter_iu+ SER
_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_d_stre + pktcall.ps_rel_oth_fail_hs_d_int + pktcall.ps_rel
el_norm_hs_e_int + pktcall.ps_rel_norm_hs_e_bgr + pktcall.ps_swi_hs_e_to_d_d_stre + pktcall.ps_swi_hs_e_to_d_d_int + pkt

Page 56
 Report Execution

o.is_hho_att_lb_capa_dl_rt + intersho.is_hho_att_lb_capa_ul_rt + intersho.is_hho_att_lb_prx_tot_rt + intersho.is_hho_att_lb_pt

l_nrt + intersho.is_hho_att_lb_capa_ul_nrt + intersho.is_hho_att_lb_prx_tot_nrt + intersho.is_hho_att_lb_ptx_tot_nrt + intersho

acd_bits - hsdpaw.discarded_hs_macd_bits + (celtpw.mc_hsdpa_orig_data_pri + celtpw.mc_hsdpa_orig_data_sec)*8)*500) / (h

Page 57
 Report Execution

esel + servlev.rrc_conn_setup_comp_aft_dir - servlev.rrc_conn_stp_rej_emerg_call)))) RNC_154d,

null, (servlev.moc_conv_call_atts - servlev.moc_conv_call_fails + servlev.mtc_conv_call_atts - servlev.mtc_conv_call_fails + se
t_background - servlev.rrc_att_rep_mt_high_pr_sign - servlev.rrc_acc_rel_interactive - servlev.rrc_acc_rel_mo_background - s
e_allo_bgr + pktcall.hs_e_req_hs_d_allo_int + pktcall.hs_e_req_hs_d_allo_bgr + pktcall.hs_d_req_hs_d_allo_int + pktcall.hs_d
SERVLEV.rab_act_fail_cs_voice_rnc+ SERVLEV.rab_act_fail_cs_voice_iur)/ (SERVLEV.rab_act_comp_cs_voice+ SERVLEV
ct_fail_ps_inter_iu+ SERVLEV.rab_act_fail_ps_inter_radio+ SERVLEV.rab_act_fail_ps_inter_bts+ SERVLEV.rab_act_fail_ps_i
hs_d_int + pktcall.ps_rel_oth_fail_hs_d_bgr + pktcall.ps_rel_norm_hs_e_stre + pktcall.ps_rel_norm_hs_e_int + pktcall.ps_rel_n
i_hs_e_to_d_d_int + pktcall.ps_swi_hs_e_to_d_d_bgr + pktcall.ps_swi_hs_e_to_hs_d_bgr + pktcall.ps_swi_hs_e_to_hs_d_int

Page 58
 Report Execution

ntersho.is_hho_att_lb_ptx_tot_rt + intersho.is_hho_att_lb_res_lim_rt + intersho.is_hho_att_lb_rsvr_sc_rt + intersho.is_hho_att_

b_ptx_tot_nrt + intersho.is_hho_att_lb_res_lim_nrt + intersho.is_hho_att_lb_rsvr_sc_nrt + intersho.is_hho_att_sb_nrt + intersho

g_data_sec)*8)*500) / (hsdpaw.hs_scch_pwr_dist_class_0 + hsdpaw.hs_scch_pwr_dist_class_1 + hsdpaw.hs_scch_pwr_dist_c

Page 59
 Report Execution

mtc_conv_call_fails + servlev.emergency_call_atts - servlev.emergency_call_fails - servlev.rrc_acc_rel_emergency - servlev.rr

_rel_mo_background - servlev.rrc_acc_rel_mo_high_pr_sign - servlev.rrc_acc_rel_mo_interactive - servlev.rrc_acc_rel_mt_bac
d_allo_int + pktcall.hs_d_req_hs_d_allo_bgr + pktcall.hs_e_req_d_d_allo_int + pktcall.hs_e_req_d_d_allo_bgr + pktcall.hs_d_re
mp_cs_voice+ SERVLEV.rab_act_fail_cs_voice_iu+ SERVLEV.rab_act_fail_cs_voice_radio+ SERVLEV.rab_act_fail_cs_voice_
RVLEV.rab_act_fail_ps_inter_iur+ SERVLEV.rab_act_fail_ps_inter_rnc+ SERVLEV.rab_act_fail_ps_backg_iu+ SERVLEV.rab_a
_e_int + pktcall.ps_rel_norm_hs_e_bgr + pktcall.ps_rel_norm_hs_d_stre + pktcall.ps_rel_norm_hs_d_int + pktcall.ps_rel_norm_
_swi_hs_e_to_hs_d_int + pktcall.ps_swi_hs_e_to_hs_d_stre),0,null, (pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_

Page 60
 Report Execution

t + intersho.is_hho_att_sb_rt + intersho.is_hho_att_ul_dch_wps_rt + nvl(intersho.att_ganho_amr_rt,0) + intersho.att_isho_cell_

ho_att_sb_nrt + intersho.att_isho_cell_shutdown_nrt + intersho.att_isho_cell_block_nrt - intersho.is_hho_att_2nd_best_cell_nr

paw.hs_scch_pwr_dist_class_2 + hsdpaw.hs_scch_pwr_dist_class_3 + hsdpaw.hs_scch_pwr_dist_class_4 + hsdpaw.hs_scch_

Page 61
 Report Execution

_emergency - servlev.rrc_acc_rel_mo_conv - servlev.rrc_acc_rel_mt_conv + nvl(rrc.cell_update_succ_cs_call,0)) / (servlev.mo

vlev.rrc_acc_rel_mt_background - servlev.rrc_acc_rel_mt_high_pr_sign),0,null, (100*(servlev.moc_inter_call_atts - servlev.moc
llo_bgr + pktcall.hs_d_req_d_d_allo_int + pktcall.hs_d_req_d_d_allo_bgr + pktcall.d_d_req_d_d_allo_int + pktcall.d_d_req_d_d
.rab_act_fail_cs_voice_bts+ SERVLEV.rab_act_fail_cs_voice_rnc+ SERVLEV.rab_act_fail_cs_voice_iur))) rabdroprate_cs,
ckg_iu+ SERVLEV.rab_act_fail_ps_backg_radio+ SERVLEV.rab_act_fail_ps_backg_bts+ SERVLEV.rab_act_fail_ps_backg_iur
t + pktcall.ps_rel_norm_hs_d_bgr + pktcall.ps_swi_hs_e_to_d_d_stre + pktcall.ps_swi_hs_e_to_d_d_int + pktcall.ps_swi_hs_e
pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_

Page 62
 Report Execution

+ intersho.att_isho_cell_shutdown_rt + intersho.att_isho_cell_block_rt - intersho.is_hho_att_2nd_best_cell_rt - intersho.is_hho_

o_att_2nd_best_cell_nrt - intersho.is_hho_att_3rd_best_cell_nrt),0,null, (intersho.succ_is_hho_ul_dch_q_nrt + intersho.succ_is

ss_4 + hsdpaw.hs_scch_pwr_dist_class_5))) RNC_722d,

Page 63
 Report Execution

cs_call,0)) / (servlev.moc_conv_call_atts + servlev.mtc_conv_call_atts + servlev.emergency_call_atts - servlev.rrc_att_rep_mo

r_call_atts - servlev.moc_inter_call_fails + servlev.moc_backg_call_atts - servlev.moc_backg_call_fails + servlev.mtc_inter_call
nt + pktcall.d_d_req_d_d_allo_bgr + pktcall.hs_e_req_hs_e_allo_stre + pktcall.hs_e_req_hs_d_allo_stre + pktcall.hs_d_req_hs_
ur))) rabdroprate_cs,
b_act_fail_ps_backg_iur+ SERVLEV.rab_act_fail_ps_backg_rnc+ SERVLEV.RAB_ACT_FAIL_PS_BACKG_UE+ SERVLEV.RA
nt + pktcall.ps_swi_hs_e_to_d_d_bgr + pktcall.ps_swi_hs_d_to_d_d_stre + pktcall.ps_swi_hs_d_to_d_d_int + pktcall.ps_swi_hs
tcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr) / (pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_e

Page 64
 Report Execution

cell_rt - intersho.is_hho_att_3rd_best_cell_rt),0,null, (intersho.succ_is_hho_ul_dch_q_rt + intersho.succ_is_hho_ue_trx_pwr_rt

_q_nrt + intersho.succ_is_hho_ue_trx_pwr_nrt + intersho.succ_is_hho_dl_dpch_pwr_nrt + intersho.succ_is_hho_cpich_rscp_nr

Page 65
 Report Execution

servlev.rrc_att_rep_mo_conv - servlev.rrc_att_rep_mt_conv - servlev.rrc_att_rep_emergency - servlev.rrc_acc_rel_emergency

+ servlev.mtc_inter_call_atts - servlev.mtc_inter_call_fails + servlev.mtc_backg_call_atts - servlev.mtc_backg_call_fails + serv
e + pktcall.hs_d_req_hs_d_allo_stre + pktcall.hs_e_req_d_d_allo_stre + pktcall.hs_d_req_d_d_allo_stre + pktcall.d_d_req_d_d

CKG_UE+ SERVLEV.RAB_ACT_FAIL_PS_INTER_UE+ SERVLEV.RAB_ACT_FAIL_PS_INTER_TRANS+ SERVLEV.RAB_AC

d_int + pktcall.ps_swi_hs_d_to_d_d_bgr),0,null, (100 - 100*(pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_e_int + p
ktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e

Page 66
 Report Execution

_is_hho_ue_trx_pwr_rt + intersho.succ_is_hho_dl_dpch_pwr_rt + intersho.succ_is_hho_cpich_rscp_rt + intersho.succ_is_hho_

c_is_hho_cpich_rscp_nrt + intersho.succ_is_hho_cpich_ecno_nrt + intersho.succ_is_hho_im_ims_nrt + intersho.succ_is_hho_

Page 67
 Report Execution

.rrc_acc_rel_emergency - servlev.rrc_acc_rel_mo_conv - servlev.rrc_acc_rel_mt_conv - servlev.rrc_conn_stp_rej_emerg_call

_backg_call_fails + servlev.moc_high_prior_sign_atts - servlev.moc_high_prior_sign_fails + servlev.mtc_high_prior_sign_atts -
e + pktcall.d_d_req_d_d_allo_stre) / (pktcall.ps_att_hsdsch_edch_int + pktcall.ps_att_hsdsch_edch_bgr + pktcall.ps_att_hsdsch

NS+ SERVLEV.RAB_ACT_FAIL_PS_BACKG_TRANS) ,0,null, 100*(SERVLEV.rab_act_fail_ps_inter_iu+ SERVLEV.rab_act_fa

_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_d_stre + pktcall.ps_rel_rl_fail_hs_d_int...
call.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_norm_hs_e_stre + pktcall.ps_rel_nor...

Page 68
 Report Execution

+ intersho.succ_is_hho_cpich_ecno_rt + intersho.succ_is_hho_im_ims_rt + intersho.succ_is_hho_emerg_call + intersho.succ_

+ intersho.succ_is_hho_lb_capa_dl_nrt + intersho.succ_is_hho_lb_capa_ul_nrt + intersho.succ_is_hho_lb_prx_tot_nrt + intersh

Page 69
 Report Execution

nn_stp_rej_emerg_call + nvl(rrc.cell_u...
c_high_prior_sign_atts - ser...
r + pktcall.ps_att_hsdsch_dch_int + pktcall....

u+ SERVLEV.rab_act_fail_ps_inter_radio+ SERVLEV.rab_act_fail_ps_inter_bts+ SERVLEV.rab_act_fail_ps_inter_iur+ SERVLE

_rl_fail_hs_d_int...
call.ps_rel_nor...

Page 70
 Report Execution

erg_call + intersho.succ_is_hho_lb_ca...
_lb_prx_tot_nrt + intersho.succ_is_hho_lb_...

Page 71
 Report Execution

il_ps_inter_iur+ SERVLEV.rab_act_fail_ps_inter_rnc+ SERVLEV.rab_act_fail_ps_backg_iu+ SERVLEV.r...

Page 72
Report Execution

Page 73