3G Kousseri

Data
Period start time ws Grp_Cell_Availability

GRP_CELL_AVAILABILITY
09.05.2020 Kousseri_all_3G 100
Page 1
Data
grp_traffic_speech_erlangs Grp_Total_Data_Traffic_Vol_DlUL
GRP_TRAFFIC_SPEECH_ERLANGRP_TOTAL_DATA_TRAFIC_VOL_DLU
3,233.76 723
2,952.73 732
3,232.92 747
3,308.28 715
3,323.87 780
2,652.39 659
2,581.35 558
3,231.33 704
2,534.18 687
3,329.31 621
247.79 349
2,761.79 596
2,937.80 688
2,863.56 687
2,744.80 694
2,382.74 492
2,875.17 454
3,228.48 464
2,845.67 459
3,126.50 486
3,277.06 739
3,553.63 752
3,446.82 728
3,673.75 692
3,675.97 698
3,435.87 739
3,544.97 791
3,438.94 754
3,751.50 757
3,535.29 839
Page 2
Data
Grp_CSSR_CS_CellPCHandUraPCHGrp_valid_cssr_ps_with_cellpch grp_3G_Drop_Call_CS
GRP_CSSR_CS_CELLPCHANDUR GRP_VALID_CSSR_PS_WITH_CELLPGRP_3G_DROP_CALL_
99.580 99.09 0.20
99.538 99.14 0.32
99.356 99.11 0.28
99.478 99.31 0.26
99.435 99.28 0.26
98.669 99.23 0.66
88.578 98.03 1.49
98.986 99.18 0.44
96.569 99.22 2.96
99.596 99.23 0.37
96.346 99.18 2.78
98.722 99.30 1.19
96.519 98.87 1.58
79.682 98.60 1.83
82.910 98.56 1.93
86.527 98.36 1.58
85.279 97.65 1.80
89.554 97.40 1.24
85.620 97.34 1.73
88.816 97.18 1.30
97.339 99.32 0.47
98.780 99.31 0.30
98.751 99.26 0.28
99.046 99.30 0.29
98.863 99.28 0.31
98.906 99.30 0.75
96.630 99.26 0.60
98.570 99.25 0.30
98.424 99.30 0.34
93.875 99.22 0.85
Page 3
Data
cs_drop_nb Groupe 3G_Radio_Congestion_Rate Grp_Code_Congestion_Voice

CS_DROP_NBGRP_3G_RADIO_CONGESTION_RATEGRP_CODE_CONGESTION_VO
279 0.000 0.000
370 0.000 0.000
384 0.012 0.000
373 0.001 0.000
358 0.001 0.000
829 0.000 0.000
1,676 0.041 0.000
566 0.003 0.000
3,444 0.006 0.000
481 0.007 0.000
372 0.001 0.000
1,443 0.000 0.000
2,061 0.019 0.000
2,466 0.020 0.000
2,493 0.030 0.000
1,668 0.014 0.000
2,347 0.041 0.000
1,774 0.069 0.000
2,385 0.082 0.000
1,882 0.091 0.000
625 0.001 0.000
433 0.002 0.000
388 0.003 0.000
426 0.002 0.000
461 0.000 0.000
1,071 0.001 0.000
909 0.001 0.000
429 0.004 0.000
544 0.001 0.000
1,321 0.003 0.000
Page 4
Data
Grp_CE_Congestion_Voice 3G_DCR_MultiRAB grp_3G_Drop - HSDPA Data services

GRP_CE_CONGESTION_VOIDCR_3G_MULTIRAGRP_3G_DROP_HSDPA_DATA
0.00 0.35 42,177
0.00 0.60 44,453
0.01 0.51 50,732
0.00 0.46 41,833
0.00 0.46 37,111
0.01 0.77 46,230
1.64 2.04 57,585
0.00 0.65 47,032
0.04 3.12 52,317
0.00 0.59 62,169
0.03 3.13 80,315
0.01 1.33 48,209
0.40 2.36 76,606
0.05 3.80 184,327
0.09 4.16 166,533
0.15 3.83 112,165
0.47 3.72 152,046
0.34 2.98 124,308
0.63 3.94 126,766
0.36 3.02 114,244
0.00 1.12 51,889
0.00 0.59 42,988
0.00 0.57 41,209
0.00 0.58 44,261
0.00 0.67 44,565
0.00 0.96 44,315
0.00 1.21 70,230
0.00 0.70 46,569
0.00 0.77 48,610
0.00 2.00 88,819
Page 5
Data
3G Drop Call Rate - All Data services grp_Number_of_users_queued IFHO SR

GRP_3G_DCR_ALL_DATA_SERVICES GRP_NUMBER_OF_USERS_QU RNC_2328A
0.318 2 84.99
0.339 2 88.03
0.351 2 85.94
0.404 2 85.39
0.436 2 84.90
0.483 1 84.90
2.232 2 83.92
0.434 2 87.67
1.784 2 88.67
0.402 2 87.68
0.943 1 82.15
0.628 2 84.56
0.987 2 85.39
0.983 2 87.32
1.116 2 87.29
1.065 1 86.68
1.024 2 84.14
0.861 2 85.27
1.078 2 87.40
1.002 2 84.72
0.494 2 87.11
0.374 2 87.26
0.374 2 86.96
0.365 2 86.49
0.387 2 86.96
0.858 2 87.12
0.942 2 87.65
0.393 2 87.84
0.424 2 87.72
0.584 2 87.51
Page 6
Data
Inter-Sys HHO SR Soft HO Success rate, RT

RNC_169F RNC_153B
82.90 99.56
77.51 99.62
81.07 99.69
80.20 99.65
83.13 99.57
84.73 99.49
81.84 98.71
81.07 99.54
79.23 99.41
78.35 99.63
88.42 95.61
82.23 99.51
82.90 99.41
78.20 99.37
79.62 99.45
78.52 99.45
86.30 98.79
81.19 99.15
83.69 98.33
85.30 98.81
79.94 99.55
81.61 99.58
80.17 99.58
77.19 99.55
78.53 99.55
79.56 99.56
82.42 99.52
82.48 99.57
82.59 99.62
79.74 99.57
Page 7
Data
3G to 2G Handover Success Rate-Speech Custom Average CPICH ECNO Avg UL R99 Load
N3GTO2GHORATESPEECCUSTOM RNC_5388A RNC_101C
82.90 -8 -106.32
77.51 -8 -106.53
81.07 -8 -106.36
80.20 -8 -106.27
83.13 -8 -106.31
84.73 -8 -106.22
81.84 -7 -104.41
81.07 -8 -106.33
79.23 -7 -105.94
78.35 -8 -106.40
88.42 -8 -104.75
82.23 -8 -106.29
82.90 -8 -105.61
78.20 -8 -102.26
79.62 -8 -102.44
78.52 -8 -104.31
86.30 -8 -104.15
81.19 -8 -104.96
83.69 -8 -104.13
85.30 -8 -104.31
79.94 -8 -105.93
81.61 -8 -106.30
80.17 -8 -106.12
77.19 -8 -105.80
78.53 -8 -106.27
79.56 -8 -106.35
82.42 -8 -105.12
82.48 -8 -106.02
82.59 -8 -106.23
79.74 -8 -104.63
Page 8
Data
Average RTWP CQI>21 CQI_15 Soft Handover Overhead for RT

RNC_19A CQI_21 CQI_15 RNC_980B
-105.35 32 64 1.48
-106.02 32 64 1.45
-105.20 31 64 1.47
-105.38 32 65 1.50
-105.52 33 65 1.48
-105.23 34 66 1.50
-102.02 33 65 1.47
-105.21 31 63 1.47
-103.84 32 65 1.44
-106.09 31 63 1.44
-102.48 32 64 1.38
-105.79 33 66 1.48
-103.38 33 65 1.47
-97.34 32 65 1.47
-97.73 33 65 1.47
-100.43 35 68 1.48
-100.35 33 66 1.48
-101.41 34 66 1.49
-99.93 35 67 1.48
-100.75 34 66 1.45
-103.83 33 65 1.45
-105.16 32 64 1.47
-105.11 32 65 1.50
-104.74 33 65 1.48
-105.20 31 64 1.47
-105.09 32 65 1.47
-102.67 32 64 1.46
-104.72 32 64 1.48
-104.56 33 66 1.48
-101.09 31 64 1.48
Page 9
Data
Grp_HSDPA_Avg_Throughput_per_user_(Kbit/s)
GRP_HSDPA_AVG_THRGPUT_PER_USER
1,313.01
1,312.00
1,288.73
1,415.41
1,434.82
1,627.89
1,352.36
1,067.79
1,293.51
1,029.49
1,459.43
1,282.28
1,440.40
1,190.35
1,296.98
1,478.11
790.44
793.41
795.29
721.52
1,358.84
1,296.82
1,326.88
1,357.60
1,257.36
1,360.63
1,252.37
1,325.29
1,310.94
1,356.67
Page 10
Data
Grp_HSUPA_Avg_Throughput_per_user_(Kbit/s)
GRP_HSUPA_AVG_THRGPUT_PER_USER
197.63
196.23
200.54
199.05
203.95
206.42
201.37
180.63
198.05
166.33
197.22
195.79
200.31
172.25
184.14
190.86
158.35
166.55
151.35
156.45
194.55
199.21
197.44
201.98
183.35
197.24
201.77
181.25
202.56
199.33
Page 11
Documentation
Report Title 3G KPI Report Acceptance

NOP Report Release Version none
RS Report Release Version none
Report ID PM_24103
Report Description none
Start Time 09.05.2020 00:00:00
End Time 10.05.2020 00:00:00
Objects Level: WS_RSRAN-WCEL; Kousseri_all_3G ('Kousseri_all_3G')
Object Aggregation Level WS_WCEL
Time Aggregation Level day
Threshold none
Data Source pmrPool
Advanced Filter none
KPI ID KPI Alias

grp_cell_availability Grp_Cell_Availability
grp_traffic_speech_erlangs grp_traffic_speech_erlangs
grp_total_data_trafic_vol_dlul Grp_Total_Data_Traffic_Vol_DlUL
grp_cssr_cs_cellpchandurapch Grp_CSSR_CS_CellPCHandUraPCH
grp_valid_cssr_ps_with_cellpch Grp_valid_cssr_ps_with_cellpch
grp_3g_drop_call_cs grp_3G_Drop_Call_CS
cs_drop_nb cs_drop_nb
grp_3g_radio_congestion_rate Groupe 3G_Radio_Congestion_Rate
grp_code_congestion_voice Grp_Code_Congestion_Voice
grp_ce_congestion_voice Grp_CE_Congestion_Voice
dcr_3g_multirab 3G_DCR_MultiRAB
grp_3g_drop_hsdpa_data grp_3G_Drop - HSDPA Data services
grp_3g_dcr_all_data_services 3G Drop Call Rate - All Data services
grp_number_of_users_queued grp_Number_of_users_queued
RNC_2328a IFHO SR
RNC_169f Inter-Sys HHO SR
RNC_153b Soft HO Success rate, RT
n3gto2ghoratespeeccustom 3G to 2G Handover Success Rate-Speech Custom
RNC_5388a Average CPICH ECNO
RNC_101c Avg UL R99 Load
RNC_19a Average RTWP
cqi_21 CQI>21
cqi_15 CQI_15
RNC_980b Soft Handover Overhead for RT
grp_hsdpa_avg_thrgput_per_user Grp_HSDPA_Avg_Throughput_per_user_(Kbit/s)
grp_hsupa_avg_thrgput_per_user Grp_HSUPA_Avg_Throughput_per_user_(Kbit/s)
Page 12
Documentation
ousseri_all_3G')
KPI Title KPI FormulUnit

Grp_Cell_AvaDECODE((N [#]
grp_traffic decode((100
[#/Erl]
Grp_Total_decode((1 [#/GB]
Grp_CSSR_100*(deco [ratio]
Grp_valid_c100*((dec [rate]
grp_3G_Dro100*decode[%]
cs_drop_nb(SERVLEV.r[#]
Groupe 3G_100*decode[ratio]
Grp_Code_C decode(SER[ratio]
Grp_CE_Con decode(SER[%]
3G_DCR_Mu 100-(100* [%]
grp_3G_DroPKTCALL. [#]
3G Drop Cal100*decode[ratio]
grp_Numberdecode(( [#]
Inter Frequ 100*decode(
[%]
Inter Syste 100*decode(
[%]
Soft HO Sucdecode( (so[%]
3G to 2G H(decode(( [%]
Average C decode( (cp[dB]
Average Up10*log(10,d[dBm]
Average R 10*log(10, [dBm]
CQI>21 100*decod [#]
CQI_15 100*decod [#]
Soft Handovdecode( (sof[#]
Grp_HSDPA_ decode(HS[kbit/s]
Grp_HSUPA_ decode(HS[kbit/s]
Page 13
Report Execution
Cache handler com.nokia.oss.qengine.support.CacheAwareEngine

Evaluation method tmp tables(1)
Init duration 0.239
Sql generation 0.035
Execution duration 163.139
Load from cache none
Create tmp Tables 163.057
Drop tmp Tables none
Load data db none
Load data and write to cache none
Start Time End Time

2020-10-05 15:54:11.857 2020-10-05 15:54:11.917
2020-10-05 15:54:11.917 2020-10-05 15:54:14.188
Page 14
Report Execution
2020-10-05 15:54:14.188 2020-10-05 15:54:21.19
Page 15
Report Execution
2020-10-05 15:54:21.19 2020-10-05 15:54:33.634
Page 16
Report Execution
2020-10-05 15:54:33.634 2020-10-05 15:55:05.455
Page 17
Report Execution
2020-10-05 15:55:05.456 2020-10-05 15:55:21.0
Page 18
Report Execution
Page 19
Report Execution
2020-10-05 15:55:21.0 2020-10-05 15:55:48.543
Page 20
Report Execution
2020-10-05 15:55:48.543 2020-10-05 15:55:52.798
Page 21
Report Execution
2020-10-05 15:55:52.798 2020-10-05 15:56:16.970
Page 22
Report Execution
2020-10-05 15:56:16.970 2020-10-05 15:56:25.499
Page 23
Report Execution
2020-10-05 15:56:25.500 2020-10-05 15:56:30.741
Page 24
Report Execution
2020-10-05 15:56:30.741 2020-10-05 15:56:54.885
Page 25
Report Execution
2020-10-05 15:56:54.886 2020-10-05 15:56:54.914
Page 26
Report Execution
2020-10-05 15:56:54.914 2020-10-05 15:56:54.996
Page 27
Report Execution
Page 28
Report Execution
Note Sql
executing sql extra step
create global temporary table jf_wcel_0565160216 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_CPICHQ_0543894637
create global temporary table jf_CPICHQ_0543894637 on commit preserve rows as
select
a.period_start_time,
g.ws,
SUM(RRC_CPICH_ECNO_CLASS_0) RRC_CPICH_ECNO_CLASS_0,
Page 29
Report Execution
SUM(RRC_CPICH_ECNO_CLASS_9) RRC_CPICH_ECNO_CLASS_9
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, w.gid ws_gid
from
w_manual_sets w) g ) g ,
(
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,
g.ws ws,
SUM(RRC_CPICH_ECNO_CLASS_9) RRC_CPICH_ECNO_CLASS_9
from
from
jf_wcel_0565160216 t,
nokrww_ps_cpichq_wcel_day p
where
g.ws_gid = t."wcel_gid" and g.ws in ( 'Kousseri_all_3G' )
and period_start_time >= to_date('2020/09/05 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2020/10/05 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",
g.ws
)a
where
g.ws_gid = a.wcel_gid and g.ws in ( 'Kousseri_all_3G' ) and a.ws = g.ws
group by
g.ws
creating tmp table: jf_CELTPW_0583189786
Page 30
Report Execution
create global temporary table jf_CELTPW_0583189786 on commit preserve rows as

select
g.ws,
SUM(MC_HSDPA_ORIG_DATA_PRI) MC_HSDPA_ORIG_DATA_PRI,
SUM(MC_HSDPA_ORIG_DATA_SEC) MC_HSDPA_ORIG_DATA_SEC
from
from
(
select
g.ws ws,
SUM(MC_HSDPA_ORIG_DATA_PRI) MC_HSDPA_ORIG_DATA_PRI,
SUM(MC_HSDPA_ORIG_DATA_SEC) MC_HSDPA_ORIG_DATA_SEC
from
from
jf_wcel_0565160216 t,
nokrww_ps_celtpw_wcel_day p
where
group by
t."rnc_gid",
t."wbts_gid",
t."wcel_gid",
g.ws
)a
where
group by
g.ws
creating tmp table: jf_INTERSHO_0563655464
create global temporary table jf_INTERSHO_0563655464 on commit preserve rows as
select
g.ws,
SUM(is_hho_att_ul_dch_q_rt) is_hho_att_ul_dch_q_rt,
Page 31
Report Execution
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,
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(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(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(IS_HHO_ATT_DR_AMR_RT) IS_HHO_ATT_DR_AMR_RT,
SUM(SUCC_IS_HHO_DR_AMR_RT) SUCC_IS_HHO_DR_AMR_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(ATT_ISHO_CELL_BLOCK_NRT) ATT_ISHO_CELL_BLOCK_NRT,
Page 32
Report Execution
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
from
(
select
g.ws ws,
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,
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(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,
Page 33
Report Execution
SUM(SUCC_IS_HHO_SB_RT) SUCC_IS_HHO_SB_RT,
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(IS_HHO_ATT_DR_AMR_RT) IS_HHO_ATT_DR_AMR_RT,
SUM(SUCC_IS_HHO_DR_AMR_RT) SUCC_IS_HHO_DR_AMR_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(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
from
jf_wcel_0565160216 t,
nokrww_ps_intersho_wcel_day p
where
group by
t."rnc_gid",
t."wbts_gid",
t."wcel_gid",
g.ws
)a
where
group by
g.ws
creating tmp table: jf_CELLRES_0580467437
create global temporary table jf_CELLRES_0580467437 on commit preserve rows as
select
g.ws ws,
(((DECODE(SUM(PRXTOT_DENOM_0),0,-112.1,10*LOG(10,(SUM(PRXTOT_DENOM_0*0.001*
SUM(prxtot_denom_0) prxtot_denom_0,
Page 34
Report Execution
(((DECODE(SUM(PRXTOT_DENOM_1),0,-112.1,10*LOG(10,(SUM(PRXTOT_DENOM_1*0.001*P
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,
SUM(RTWP_CLASS_0) RTWP_CLASS_0,
SUM(RTWP_CLASS_21) RTWP_CLASS_21
from
(select
from
w_manual_sets w) g ,
jf_wcel_0565160216 t,
nokrww_ps_cellres_wcel_day p
where
group by
g.ws
creating tmp table: jf_PKTCALL_0598278223
create global temporary table jf_PKTCALL_0598278223 on commit preserve rows as
Page 35
Report Execution
select
g.ws,
SUM(PS_REL_PRE_EMP_HS_E_INT) PS_REL_PRE_EMP_HS_E_INT,
SUM(PS_REL_PRE_EMP_HS_E_BGR) PS_REL_PRE_EMP_HS_E_BGR,
SUM(PS_REL_PRE_EMP_HS_D_INT) PS_REL_PRE_EMP_HS_D_INT,
SUM(PS_REL_PRE_EMP_HS_D_BGR) PS_REL_PRE_EMP_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_REL_PRE_EMP_HS_E_STRE) PS_REL_PRE_EMP_HS_E_STRE,
SUM(PS_REL_PRE_EMP_HS_D_STRE) PS_REL_PRE_EMP_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
from
from
(
select
g.ws ws,
SUM(PS_REL_PRE_EMP_HS_E_INT) PS_REL_PRE_EMP_HS_E_INT,
SUM(PS_REL_PRE_EMP_HS_E_BGR) PS_REL_PRE_EMP_HS_E_BGR,
SUM(PS_REL_PRE_EMP_HS_D_INT) PS_REL_PRE_EMP_HS_D_INT,
SUM(PS_REL_PRE_EMP_HS_D_BGR) PS_REL_PRE_EMP_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_REL_PRE_EMP_HS_E_STRE) PS_REL_PRE_EMP_HS_E_STRE,
SUM(PS_REL_PRE_EMP_HS_D_STRE) PS_REL_PRE_EMP_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,
Page 36
Report Execution
SUM(PS_REL_OTH_FAIL_HS_D_STRE) PS_REL_OTH_FAIL_HS_D_STRE
from
from
jf_wcel_0565160216 t,
nokrww_ps_pktcall_wcel_day p
where
group by
t."rnc_gid",
t."wbts_gid",
t."wcel_gid",
g.ws
)a
where
group by
g.ws
creating tmp table: jf_HSDPAW_0596178379
create global temporary table jf_HSDPAW_0596178379 on commit preserve rows as
select
g.ws,
SUM(CQI_DIST_CL_0) CQI_DIST_CL_0,
Page 37
Report Execution
SUM(HS_SCCH_PWR_DIST_CLASS_0) HS_SCCH_PWR_DIST_CLASS_0,
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,
SUM(MACE_PDUS_2MS_TTI) MACE_PDUS_2MS_TTI,
SUM(MACE_PDU_DATA_2MS_TTI) MACE_PDU_DATA_2MS_TTI,
SUM(MACE_PDU_DATA_10MS_TTI) MACE_PDU_DATA_10MS_TTI
from
from
(
select
g.ws ws,
Page 38
Report Execution
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,
SUM(MACE_PDU_DATA_2MS_TTI) MACE_PDU_DATA_2MS_TTI,
SUM(MACE_PDU_DATA_10MS_TTI) MACE_PDU_DATA_10MS_TTI
from
from
jf_wcel_0565160216 t,
nokrww_ps_hsdpaw_wcel_day p
where
group by
t."rnc_gid",
t."wbts_gid",
t."wcel_gid",
g.ws
)a
where
Page 39
Report Execution

group by
g.ws
creating tmp table: jf_CELLTP_0578834938
create global temporary table jf_CELLTP_0578834938 on commit preserve rows as
select
g.ws,
SUM(RT_PS_DCH_UL_DATA_VOL) RT_PS_DCH_UL_DATA_VOL,
SUM(RT_PS_DCH_DL_DATA_VOL) RT_PS_DCH_DL_DATA_VOL,
SUM(NRT_DCH_UL_DATA_VOL) NRT_DCH_UL_DATA_VOL,
SUM(NRT_DCH_DL_DATA_VOL) NRT_DCH_DL_DATA_VOL,
SUM(HS_DSCH_DATA_VOL) HS_DSCH_DATA_VOL,
SUM(NRT_DCH_HSDPA_UL_DATA_VOL) NRT_DCH_HSDPA_UL_DATA_VOL,
SUM(NRT_EDCH_UL_DATA_VOL) NRT_EDCH_UL_DATA_VOL,
SUM(RT_E_DCH_UL_STREA_DATA) RT_E_DCH_UL_STREA_DATA,
SUM(RT_DCH_HSDPA_UL_STREA_DATA) RT_DCH_HSDPA_UL_STREA_DATA,
SUM(RT_HS_DSCH_DL_STREA_DATA) RT_HS_DSCH_DL_STREA_DATA
from
from
(
select
g.ws ws,
SUM(RT_PS_DCH_UL_DATA_VOL) RT_PS_DCH_UL_DATA_VOL,
SUM(RT_PS_DCH_DL_DATA_VOL) RT_PS_DCH_DL_DATA_VOL,
SUM(NRT_DCH_UL_DATA_VOL) NRT_DCH_UL_DATA_VOL,
SUM(NRT_DCH_DL_DATA_VOL) NRT_DCH_DL_DATA_VOL,
SUM(HS_DSCH_DATA_VOL) HS_DSCH_DATA_VOL,
SUM(NRT_DCH_HSDPA_UL_DATA_VOL) NRT_DCH_HSDPA_UL_DATA_VOL,
SUM(NRT_EDCH_UL_DATA_VOL) NRT_EDCH_UL_DATA_VOL,
SUM(RT_E_DCH_UL_STREA_DATA) RT_E_DCH_UL_STREA_DATA,
SUM(RT_DCH_HSDPA_UL_STREA_DATA) RT_DCH_HSDPA_UL_STREA_DATA,
SUM(RT_HS_DSCH_DL_STREA_DATA) RT_HS_DSCH_DL_STREA_DATA
from
from
jf_wcel_0565160216 t,
nokrww_ps_celltp_wcel_day p
where
Page 40
Report Execution

group by
t."rnc_gid",
t."wbts_gid",
t."wcel_gid",
g.ws
)a
where
group by
g.ws
creating tmp table: jf_SERVLEV_0558378467
create global temporary table jf_SERVLEV_0558378467 on commit preserve rows as
select
g.ws,
SUM(moc_conv_call_atts) moc_conv_call_atts,
SUM(moc_conv_call_fails) moc_conv_call_fails,
SUM(moc_strea_call_atts) moc_strea_call_atts,
SUM(moc_strea_call_fails) moc_strea_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(moc_subsc_traf_call_atts) moc_subsc_traf_call_atts,
SUM(moc_subsc_traf_call_fails) moc_subsc_traf_call_fails,
SUM(mtc_conv_call_atts) mtc_conv_call_atts,
SUM(mtc_conv_call_fails) mtc_conv_call_fails,
SUM(mtc_strea_call_atts) mtc_strea_call_atts,
SUM(mtc_strea_call_fails) mtc_strea_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_cs_conv) rab_stp_att_cs_conv,
SUM(rab_stp_att_cs_strea) rab_stp_att_cs_strea,
SUM(rab_stp_att_ps_conv) rab_stp_att_ps_conv,
SUM(RAB_STP_ATT_PS_STREA) RAB_STP_ATT_PS_STREA,
SUM(rab_stp_att_ps_inter) rab_stp_att_ps_inter,
Page 41
Report Execution
SUM(RAB_STP_ATT_PS_BACKG) RAB_STP_ATT_PS_BACKG,
SUM(rab_stp_fail_cs_voice_ac) rab_stp_fail_cs_voice_ac,
SUM(rab_stp_fail_cs_voice_bts) rab_stp_fail_cs_voice_bts,
SUM(rab_stp_fail_cs_conv_ac) rab_stp_fail_cs_conv_ac,
SUM(rab_stp_fail_cs_strea_ac) rab_stp_fail_cs_strea_ac,
SUM(rab_stp_fail_ps_strea_ac) rab_stp_fail_ps_strea_ac,
SUM(rab_stp_fail_ps_inter_ac) rab_stp_fail_ps_inter_ac,
SUM(rab_stp_fail_ps_backg_ac) rab_stp_fail_ps_backg_ac,
SUM(rab_acc_comp_cs_voice) rab_acc_comp_cs_voice,
SUM(rab_acc_comp_cs_conv) rab_acc_comp_cs_conv,
SUM(rab_acc_comp_cs_strea) rab_acc_comp_cs_strea,
SUM(rab_acc_comp_ps_strea) rab_acc_comp_ps_strea,
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_cs_conv) rab_act_comp_cs_conv,
SUM(rab_act_comp_cs_strea) rab_act_comp_cs_strea,
SUM(rab_act_comp_ps_strea) rab_act_comp_ps_strea,
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_rel_cs_voice_srnc) rab_act_rel_cs_voice_srnc,
SUM(rab_act_rel_cs_voice_p_emp) rab_act_rel_cs_voice_p_emp,
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_cs_conv_srnc) rab_act_rel_cs_conv_srnc,
SUM(rab_act_rel_cs_conv_p_emp) rab_act_rel_cs_conv_p_emp,
SUM(rab_act_rel_cs_strea_srnc) rab_act_rel_cs_strea_srnc,
SUM(rab_act_rel_cs_strea_p_emp) rab_act_rel_cs_strea_p_emp,
SUM(rab_act_fail_cs_conv_iu) rab_act_fail_cs_conv_iu,
SUM(rab_act_fail_cs_conv_radio) rab_act_fail_cs_conv_radio,
SUM(rab_act_fail_cs_conv_bts) rab_act_fail_cs_conv_bts,
SUM(rab_act_fail_cs_conv_iur) rab_act_fail_cs_conv_iur,
SUM(rab_act_fail_cs_conv_rnc) rab_act_fail_cs_conv_rnc,
SUM(rab_act_fail_cs_strea_iu) rab_act_fail_cs_strea_iu,
SUM(rab_act_fail_cs_strea_radio) rab_act_fail_cs_strea_radio,
SUM(rab_act_fail_cs_strea_bts) rab_act_fail_cs_strea_bts,
SUM(rab_act_fail_cs_strea_iur) rab_act_fail_cs_strea_iur,
SUM(rab_act_fail_cs_strea_rnc) rab_act_fail_cs_strea_rnc,
SUM(rab_act_rel_ps_strea_srnc) rab_act_rel_ps_strea_srnc,
SUM(rab_act_rel_ps_strea_p_emp) rab_act_rel_ps_strea_p_emp,
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_strea_iu) rab_act_fail_ps_strea_iu,
SUM(rab_act_fail_ps_strea_radio) rab_act_fail_ps_strea_radio,
SUM(rab_act_fail_ps_strea_bts) rab_act_fail_ps_strea_bts,
SUM(rab_act_fail_ps_strea_iur) rab_act_fail_ps_strea_iur,
SUM(rab_act_fail_ps_strea_rnc) rab_act_fail_ps_strea_rnc,
Page 42
Report Execution
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(RAB_ACT_FAIL_CS_VOICE_UE) RAB_ACT_FAIL_CS_VOICE_UE,
SUM(RAB_ACT_FAIL_CS_CONV_UE) RAB_ACT_FAIL_CS_CONV_UE,
SUM(RAB_ACT_FAIL_CS_STREA_UE) RAB_ACT_FAIL_CS_STREA_UE,
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_STREAMING) RRC_ACC_REL_MO_STREAMING,
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_MO_SUBSCRIBED) RRC_ACC_REL_MO_SUBSCRIBED,
SUM(RRC_ACC_REL_MT_CONV) RRC_ACC_REL_MT_CONV,
SUM(RRC_ACC_REL_MT_STREAMING) RRC_ACC_REL_MT_STREAMING,
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_STREAMING) RRC_ATT_REP_MO_STREAMING,
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_MO_SUBSCRIBED) RRC_ATT_REP_MO_SUBSCRIBED,
SUM(RRC_ATT_REP_MT_CONV) RRC_ATT_REP_MT_CONV,
SUM(RRC_ATT_REP_MT_STREAMING) RRC_ATT_REP_MT_STREAMING,
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(RAB_ACT_FAIL_PS_INT_PCH) RAB_ACT_FAIL_PS_INT_PCH,
SUM(RAB_ACT_FAIL_PS_BACKG_PCH) RAB_ACT_FAIL_PS_BACKG_PCH,
SUM(RAB_ACT_REL_CS_VOICE_HHO) RAB_ACT_REL_CS_VOICE_HHO,
SUM(RAB_ACT_REL_CS_CONV_HHO) RAB_ACT_REL_CS_CONV_HHO,
SUM(RAB_ACT_REL_CS_VOICE_ISHO) RAB_ACT_REL_CS_VOICE_ISHO,
SUM(RAB_ACT_REL_CS_CONV_ISHO) RAB_ACT_REL_CS_CONV_ISHO,
SUM(RAB_ACT_REL_CS_VOICE_GANHO) RAB_ACT_REL_CS_VOICE_GANHO,
SUM(RAB_ACT_FAIL_CS_VOICE_TRANS) RAB_ACT_FAIL_CS_VOICE_TRANS,
SUM(RAB_ACT_FAIL_CS_CONV_TRANS) RAB_ACT_FAIL_CS_CONV_TRANS,
SUM(RAB_ACT_FAIL_PS_STREA_TRANS) RAB_ACT_FAIL_PS_STREA_TRANS,
Page 43
Report Execution
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_COMP_AMR_PSNRT) RAB_ACT_COMP_AMR_PSNRT,
SUM(RAB_ACT_FAIL_AMR_PSNRT) RAB_ACT_FAIL_AMR_PSNRT,
SUM(RAB_STP_FAIL_CS_VOICE_AC_COD) RAB_STP_FAIL_CS_VOICE_AC_COD,
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,
SUM(RAB_ACT_REL_PS_STREA_HHO) RAB_ACT_REL_PS_STREA_HHO,
SUM(RAB_ACT_REL_PS_STREA_ISHO) RAB_ACT_REL_PS_STREA_ISHO
from
from
(
select
g.ws ws,
SUM(moc_conv_call_atts) moc_conv_call_atts,
SUM(moc_conv_call_fails) moc_conv_call_fails,
SUM(moc_strea_call_atts) moc_strea_call_atts,
SUM(moc_strea_call_fails) moc_strea_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(moc_subsc_traf_call_atts) moc_subsc_traf_call_atts,
SUM(moc_subsc_traf_call_fails) moc_subsc_traf_call_fails,
SUM(mtc_conv_call_atts) mtc_conv_call_atts,
SUM(mtc_conv_call_fails) mtc_conv_call_fails,
SUM(mtc_strea_call_atts) mtc_strea_call_atts,
SUM(mtc_strea_call_fails) mtc_strea_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_cs_conv) rab_stp_att_cs_conv,
SUM(rab_stp_att_cs_strea) rab_stp_att_cs_strea,
Page 44
Report Execution
SUM(rab_stp_att_ps_conv) rab_stp_att_ps_conv,
SUM(RAB_STP_ATT_PS_STREA) RAB_STP_ATT_PS_STREA,
SUM(rab_stp_att_ps_inter) rab_stp_att_ps_inter,
SUM(RAB_STP_ATT_PS_BACKG) RAB_STP_ATT_PS_BACKG,
SUM(rab_stp_fail_cs_voice_ac) rab_stp_fail_cs_voice_ac,
SUM(rab_stp_fail_cs_voice_bts) rab_stp_fail_cs_voice_bts,
SUM(rab_stp_fail_cs_conv_ac) rab_stp_fail_cs_conv_ac,
SUM(rab_stp_fail_cs_strea_ac) rab_stp_fail_cs_strea_ac,
SUM(rab_stp_fail_ps_strea_ac) rab_stp_fail_ps_strea_ac,
SUM(rab_stp_fail_ps_inter_ac) rab_stp_fail_ps_inter_ac,
SUM(rab_stp_fail_ps_backg_ac) rab_stp_fail_ps_backg_ac,
SUM(rab_acc_comp_cs_voice) rab_acc_comp_cs_voice,
SUM(rab_acc_comp_cs_conv) rab_acc_comp_cs_conv,
SUM(rab_acc_comp_cs_strea) rab_acc_comp_cs_strea,
SUM(rab_acc_comp_ps_strea) rab_acc_comp_ps_strea,
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_cs_conv) rab_act_comp_cs_conv,
SUM(rab_act_comp_cs_strea) rab_act_comp_cs_strea,
SUM(rab_act_comp_ps_strea) rab_act_comp_ps_strea,
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_rel_cs_voice_srnc) rab_act_rel_cs_voice_srnc,
SUM(rab_act_rel_cs_voice_p_emp) rab_act_rel_cs_voice_p_emp,
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_cs_conv_srnc) rab_act_rel_cs_conv_srnc,
SUM(rab_act_rel_cs_conv_p_emp) rab_act_rel_cs_conv_p_emp,
SUM(rab_act_rel_cs_strea_srnc) rab_act_rel_cs_strea_srnc,
SUM(rab_act_rel_cs_strea_p_emp) rab_act_rel_cs_strea_p_emp,
SUM(rab_act_fail_cs_conv_iu) rab_act_fail_cs_conv_iu,
SUM(rab_act_fail_cs_conv_radio) rab_act_fail_cs_conv_radio,
SUM(rab_act_fail_cs_conv_bts) rab_act_fail_cs_conv_bts,
SUM(rab_act_fail_cs_conv_iur) rab_act_fail_cs_conv_iur,
SUM(rab_act_fail_cs_conv_rnc) rab_act_fail_cs_conv_rnc,
SUM(rab_act_fail_cs_strea_iu) rab_act_fail_cs_strea_iu,
SUM(rab_act_fail_cs_strea_radio) rab_act_fail_cs_strea_radio,
SUM(rab_act_fail_cs_strea_bts) rab_act_fail_cs_strea_bts,
SUM(rab_act_fail_cs_strea_iur) rab_act_fail_cs_strea_iur,
SUM(rab_act_fail_cs_strea_rnc) rab_act_fail_cs_strea_rnc,
SUM(rab_act_rel_ps_strea_srnc) rab_act_rel_ps_strea_srnc,
SUM(rab_act_rel_ps_strea_p_emp) rab_act_rel_ps_strea_p_emp,
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_strea_iu) rab_act_fail_ps_strea_iu,
SUM(rab_act_fail_ps_strea_radio) rab_act_fail_ps_strea_radio,
Page 45
Report Execution
SUM(rab_act_fail_ps_strea_bts) rab_act_fail_ps_strea_bts,
SUM(rab_act_fail_ps_strea_iur) rab_act_fail_ps_strea_iur,
SUM(rab_act_fail_ps_strea_rnc) rab_act_fail_ps_strea_rnc,
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(RAB_ACT_FAIL_CS_VOICE_UE) RAB_ACT_FAIL_CS_VOICE_UE,
SUM(RAB_ACT_FAIL_CS_CONV_UE) RAB_ACT_FAIL_CS_CONV_UE,
SUM(RAB_ACT_FAIL_CS_STREA_UE) RAB_ACT_FAIL_CS_STREA_UE,
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_STREAMING) RRC_ACC_REL_MO_STREAMING,
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_MO_SUBSCRIBED) RRC_ACC_REL_MO_SUBSCRIBED,
SUM(RRC_ACC_REL_MT_CONV) RRC_ACC_REL_MT_CONV,
SUM(RRC_ACC_REL_MT_STREAMING) RRC_ACC_REL_MT_STREAMING,
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_STREAMING) RRC_ATT_REP_MO_STREAMING,
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_MO_SUBSCRIBED) RRC_ATT_REP_MO_SUBSCRIBED,
SUM(RRC_ATT_REP_MT_CONV) RRC_ATT_REP_MT_CONV,
SUM(RRC_ATT_REP_MT_STREAMING) RRC_ATT_REP_MT_STREAMING,
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(RAB_ACT_FAIL_PS_INT_PCH) RAB_ACT_FAIL_PS_INT_PCH,
SUM(RAB_ACT_FAIL_PS_BACKG_PCH) RAB_ACT_FAIL_PS_BACKG_PCH,
SUM(RAB_ACT_REL_CS_VOICE_HHO) RAB_ACT_REL_CS_VOICE_HHO,
SUM(RAB_ACT_REL_CS_CONV_HHO) RAB_ACT_REL_CS_CONV_HHO,
SUM(RAB_ACT_REL_CS_VOICE_ISHO) RAB_ACT_REL_CS_VOICE_ISHO,
SUM(RAB_ACT_REL_CS_CONV_ISHO) RAB_ACT_REL_CS_CONV_ISHO,
SUM(RAB_ACT_REL_CS_VOICE_GANHO) RAB_ACT_REL_CS_VOICE_GANHO,
Page 46
Report Execution
SUM(RAB_ACT_FAIL_CS_VOICE_TRANS) RAB_ACT_FAIL_CS_VOICE_TRANS,
SUM(RAB_ACT_FAIL_CS_CONV_TRANS) RAB_ACT_FAIL_CS_CONV_TRANS,
SUM(RAB_ACT_FAIL_PS_STREA_TRANS) RAB_ACT_FAIL_PS_STREA_TRANS,
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_COMP_AMR_PSNRT) RAB_ACT_COMP_AMR_PSNRT,
SUM(RAB_ACT_FAIL_AMR_PSNRT) RAB_ACT_FAIL_AMR_PSNRT,
SUM(RAB_STP_FAIL_CS_VOICE_AC_COD) RAB_STP_FAIL_CS_VOICE_AC_COD,
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,
SUM(RAB_ACT_REL_PS_STREA_HHO) RAB_ACT_REL_PS_STREA_HHO,
SUM(RAB_ACT_REL_PS_STREA_ISHO) RAB_ACT_REL_PS_STREA_ISHO
from
from
jf_wcel_0565160216 t,
nokrww_ps_servlev_wcel_day p
where
group by
t."rnc_gid",
t."wbts_gid",
t."wcel_gid",
g.ws
)a
where
group by
g.ws
creating tmp table: jf_SOFTHO_0529120204
create global temporary table jf_SOFTHO_0529120204 on commit preserve rows as
select
g.ws,
SUM(one_cell_in_act_set_for_rt) one_cell_in_act_set_for_rt,
SUM(two_cells_in_act_set_for_rt) two_cells_in_act_set_for_rt,
SUM(three_cells_in_act_set_rt) three_cells_in_act_set_rt,
SUM(cell_add_req_on_sho_for_rt) cell_add_req_on_sho_for_rt,
SUM(cell_del_req_on_sho_for_rt) cell_del_req_on_sho_for_rt,
SUM(cell_repl_req_on_sho_for_rt) cell_repl_req_on_sho_for_rt,
SUM(succ_updates_on_sho_for_rt) succ_updates_on_sho_for_rt
Page 47
Report Execution
from
from
(
select
g.ws ws,
SUM(one_cell_in_act_set_for_rt) one_cell_in_act_set_for_rt,
SUM(two_cells_in_act_set_for_rt) two_cells_in_act_set_for_rt,
SUM(three_cells_in_act_set_rt) three_cells_in_act_set_rt,
SUM(cell_add_req_on_sho_for_rt) cell_add_req_on_sho_for_rt,
SUM(cell_del_req_on_sho_for_rt) cell_del_req_on_sho_for_rt,
SUM(cell_repl_req_on_sho_for_rt) cell_repl_req_on_sho_for_rt,
SUM(succ_updates_on_sho_for_rt) succ_updates_on_sho_for_rt
from
from
jf_wcel_0565160216 t,
nokrww_ps_softho_wcel_day p
where
group by
t."rnc_gid",
t."wbts_gid",
t."wcel_gid",
g.ws
)a
where
group by
g.ws
creating tmp table: jf_INTSYSHO_0571495996
create global temporary table jf_INTSYSHO_0571495996 on commit preserve rows as
select
g.ws,
SUM(intra_intra_hho_att_rt) intra_intra_hho_att_rt,
SUM(succ_intra_intra_hho_att_rt) succ_intra_intra_hho_att_rt,
Page 48
Report Execution
SUM(intra_inter_hho_att_rt) intra_inter_hho_att_rt,
SUM(succ_intra_inter_hho_att_rt) succ_intra_inter_hho_att_rt,
SUM(inter_hho_att_rt) inter_hho_att_rt,
SUM(succ_inter_hho_att_rt) succ_inter_hho_att_rt,
SUM(intra_intra_hho_att_nrt) intra_intra_hho_att_nrt,
SUM(succ_intra_intra_hho_att_nrt) succ_intra_intra_hho_att_nrt,
SUM(intra_inter_hho_att_nrt) intra_inter_hho_att_nrt,
SUM(succ_intra_inter_hho_att_nrt) succ_intra_inter_hho_att_nrt,
SUM(inter_hho_att_nrt) inter_hho_att_nrt,
SUM(succ_inter_hho_att_nrt) succ_inter_hho_att_nrt
from
from
(
select
g.ws ws,
SUM(intra_intra_hho_att_rt) intra_intra_hho_att_rt,
SUM(succ_intra_intra_hho_att_rt) succ_intra_intra_hho_att_rt,
SUM(intra_inter_hho_att_rt) intra_inter_hho_att_rt,
SUM(succ_intra_inter_hho_att_rt) succ_intra_inter_hho_att_rt,
SUM(inter_hho_att_rt) inter_hho_att_rt,
SUM(succ_inter_hho_att_rt) succ_inter_hho_att_rt,
SUM(intra_intra_hho_att_nrt) intra_intra_hho_att_nrt,
SUM(succ_intra_intra_hho_att_nrt) succ_intra_intra_hho_att_nrt,
SUM(intra_inter_hho_att_nrt) intra_inter_hho_att_nrt,
SUM(succ_intra_inter_hho_att_nrt) succ_intra_inter_hho_att_nrt,
SUM(inter_hho_att_nrt) inter_hho_att_nrt,
SUM(succ_inter_hho_att_nrt) succ_inter_hho_att_nrt
from
from
jf_wcel_0565160216 t,
nokrww_ps_intsysho_wcel_day p
where
group by
t."rnc_gid",
t."wbts_gid",
Page 49
Report Execution
t."wcel_gid",
g.ws
)a
where
group by
g.ws
creating tmp table: jf_RRC_0524242335
create global temporary table jf_RRC_0524242335 on commit preserve rows as
select
g.ws,
SUM(DENOM_ST_TRANS_TIME_PCH_FACH) DENOM_ST_TRANS_TIME_PCH_FACH,
SUM(DENOM_ST_TRANS_TIME_FACH_DCH) DENOM_ST_TRANS_TIME_FACH_DCH,
SUM(ATT_PCH_DCH_TRANS_UMRLC) ATT_PCH_DCH_TRANS_UMRLC,
SUM(SUCC_PCH_DCH_TRANS_UMRLC) SUCC_PCH_DCH_TRANS_UMRLC,
SUM(ATT_FACH_TO_DCH) ATT_FACH_TO_DCH,
SUM(ATT_PCH_TO_FACH) ATT_PCH_TO_FACH,
SUM(CELL_UPDATE_ATT_CS_CALL) CELL_UPDATE_ATT_CS_CALL,
SUM(CELL_UPDATE_SUCC_CS_CALL) CELL_UPDATE_SUCC_CS_CALL
from
from
(
select
g.ws ws,
SUM(DENOM_ST_TRANS_TIME_PCH_FACH) DENOM_ST_TRANS_TIME_PCH_FACH,
SUM(DENOM_ST_TRANS_TIME_FACH_DCH) DENOM_ST_TRANS_TIME_FACH_DCH,
SUM(ATT_PCH_DCH_TRANS_UMRLC) ATT_PCH_DCH_TRANS_UMRLC,
SUM(SUCC_PCH_DCH_TRANS_UMRLC) SUCC_PCH_DCH_TRANS_UMRLC,
SUM(ATT_FACH_TO_DCH) ATT_FACH_TO_DCH,
SUM(ATT_PCH_TO_FACH) ATT_PCH_TO_FACH,
SUM(CELL_UPDATE_ATT_CS_CALL) CELL_UPDATE_ATT_CS_CALL,
SUM(CELL_UPDATE_SUCC_CS_CALL) CELL_UPDATE_SUCC_CS_CALL
from
from
jf_wcel_0565160216 t,
nokrww_ps_rrc_wcel_day p
where
Page 50
Report Execution

group by
t."rnc_gid",
t."wbts_gid",
t."wcel_gid",
g.ws
)a
where
group by
g.ws
creating tmp table: jf_ALLTABLES_0579820174
create global temporary table jf_ALLTABLES_0579820174 on commit preserve rows as
select
period_start_time,
ws
from
(
(
select
period_start_time, TO_CHAR(ws) ws
from
jf_CELLRES_0580467437
)
UNION
(
select
from
jf_CELLTP_0578834938
)
UNION
(
select
from
jf_CELTPW_0583189786
)
UNION
(
select
from
jf_CPICHQ_0543894637
)
UNION
Page 51
Report Execution
(
select
from
jf_HSDPAW_0596178379
)
UNION
(
select
from
jf_INTERSHO_0563655464
)
UNION
(
select
from
jf_INTSYSHO_0571495996
)
UNION
(
select
from
jf_PKTCALL_0598278223
)
UNION
(
select
from
jf_RRC_0524242335
)
UNION
(
select
from
jf_SERVLEV_0558378467
)
UNION
(
select
from
jf_SOFTHO_0529120204
)
)p
report from tmp tables
Page 52
Report Execution
select
ALLTABLES.period_start_time,
ALLTABLES.ws,
1 WS_DUMMY,
to_number(DECODE((NVL(CELLRES.AVAIL_WCELL_EXISTS_IN_RNW_DB,0)-NVL(CELLRES.A
to_number(decode((100*3600), 0, 0, (SERVLEV.avg_rab_hld_tm_cs_voice)/(100*3600))) grp_traff
to_number(decode((1000*1000*1000), 0, 0, (CELLTP.RT_PS_DCH_UL_DATA_VOL+CELLTP.NR
to_number(100*(decode((SERVLEV.moc_conv_call_atts+SERVLEV.mtc_conv_call_atts+SERVLE
to_number(100*((decode(((SERVLEV.moc_inter_call_atts+SERVLEV.moc_backg_call_atts+SERV
to_number(100*decode((SERVLEV.rab_act_comp_cs_voice+SERVLEV.rab_act_comp_cs_conv+
to_number((SERVLEV.rab_act_rel_cs_voice_p_emp+SERVLEV.rab_act_fail_cs_voice_iu+SERVL
to_number(100*decode((SERVLEV.rab_stp_att_cs_conv+SERVLEV.rab_stp_att_cs_strea+SERVL
to_number(decode(SERVLEV.rab_stp_att_cs_voice, 0, 0, SERVLEV.RAB_STP_FAIL_CS_VOICE
to_number(decode(SERVLEV.rab_stp_att_cs_voice, 0, 0, SERVLEV.rab_stp_fail_cs_voice_bts/SE
to_number(100-(100*decode((SERVLEV.RAB_ACT_COMP_AMR_PSNRT+SERVLEV.RAB_ACT_
to_number(PKTCALL.PS_REL_PRE_EMP_HS_E_INT+PKTCALL.PS_REL_PRE_EMP_HS_E_BG
to_number(100*decode((SERVLEV.rab_act_comp_ps_strea+SERVLEV.rab_act_comp_ps_inter+S
to_number(decode((HSDPAW.HS_SCCH_PWR_DIST_CLASS_0+HSDPAW.HS_SCCH_PWR_DI
to_number(100*decode( (intsysho.intra_intra_hho_att_rt + intsysho.intra_inter_hho_att_rt + intsysh
to_number(100*decode( ((INTERSHO.is_hho_att_ul_dch_q_rt + INTERSHO.is_hho_att_ue_trx_pw
to_number(decode( (softho.cell_add_req_on_sho_for_rt + softho.cell_repl_req_on_sho_for_rt + so
to_number((decode((INTERSHO.is_hho_att_ul_dch_q_rt+INTERSHO.is_hho_att_ue_trx_pwr_rt+I
to_number(decode( (cpichq.rrc_cpich_ecno_class_0 + cpichq.rrc_cpich_ecno_class_1 + cpichq.rrc
to_number(10*log(10,decode( (cellres.prxtot_denom_0 + cellres.prxtot_denom_1 + cellres.prxtot_d
to_number(10*log(10, decode( (cellres.rtwp_class_0 + cellres.rtwp_class_1 + cellres.rtwp_class_2
to_number(100*decode((HSDPAW.CQI_DIST_CL_0+HSDPAW.CQI_DIST_CL_1+HSDPAW.CQI_
to_number(100*decode((HSDPAW.CQI_DIST_CL_0+HSDPAW.CQI_DIST_CL_1+HSDPAW.CQI_
to_number(decode( (softho.one_cell_in_act_set_for_rt + softho.two_cells_in_act_set_for_rt/2 + so
to_number(decode(HSDPAW.HSDPA_BUFF_WITH_DATA_PER_TTI, 0, 0, ( (HSDPAW.RECEIVE
to_number(decode(HSDPAW.MACE_PDUS_2MS_TTI+HSDPAW.MACE_PDUS_10MS_TTI,0,0,(H
from
dual
,
jf_ALLTABLES_0579820174 ALLTABLES,
jf_CELLRES_0580467437 CELLRES,
jf_CELLTP_0578834938 CELLTP,
jf_CELTPW_0583189786 CELTPW,
jf_CPICHQ_0543894637 CPICHQ,
jf_HSDPAW_0596178379 HSDPAW,
jf_INTERSHO_0563655464 INTERSHO,
jf_INTSYSHO_0571495996 INTSYSHO,
jf_PKTCALL_0598278223 PKTCALL,
jf_RRC_0524242335 RRC,
jf_SERVLEV_0558378467 SERVLEV,
jf_SOFTHO_0529120204 SOFTHO
where
1=1
and ALLTABLES.period_start_time = CELLRES.period_start_time (+) and ALLTABLES.ws = CELL
and ALLTABLES.period_start_time = CELLTP.period_start_time (+) and ALLTABLES.ws = CELLT
and ALLTABLES.period_start_time = CELTPW.period_start_time (+) and ALLTABLES.ws = CELT
Page 53
Report Execution
and ALLTABLES.period_start_time = CPICHQ.period_start_time (+) and ALLTABLES.ws = CPICH

and ALLTABLES.period_start_time = HSDPAW.period_start_time (+) and ALLTABLES.ws = HSDP
and ALLTABLES.period_start_time = INTERSHO.period_start_time (+) and ALLTABLES.ws = INT
and ALLTABLES.period_start_time = INTSYSHO.period_start_time (+) and ALLTABLES.ws = INT
and ALLTABLES.period_start_time = PKTCALL.period_start_time (+) and ALLTABLES.ws = PKTC
and ALLTABLES.period_start_time = RRC.period_start_time (+) and ALLTABLES.ws = RRC.ws (+
and ALLTABLES.period_start_time = SERVLEV.period_start_time (+) and ALLTABLES.ws = SERV
and ALLTABLES.period_start_time = SOFTHO.period_start_time (+) and ALLTABLES.ws = SOFT
order by
2,1,3
Page 54
Report Execution
DOWN_NRT,
Page 55
Report Execution
DOWN_NRT,
TOT_DENOM_0*0.001*POWER(10,((ave_prxtot_class_0/621*62-112.1)/10)))/SUM(PRXTOT_DENOM_0))/0.001)))+112)*621/
Page 56
Report Execution
OT_DENOM_1*0.001*POWER(10,((ave_prxtot_class_1/621*62-112.1)/10)))/SUM(PRXTOT_DENOM_1))/0.001)))+112)*621/6
BY_USER,
_RNW_DB,
Page 57
Report Execution
A_PER_TTI,
Page 58
Report Execution
A_PER_TTI,
Page 59
Report Execution
_PR_SIGN,
_PR_SIGN,
Page 60
Report Execution
E_AC_COD,
Page 61
Report Execution
_PR_SIGN,
_PR_SIGN,
Page 62
Report Execution
E_AC_COD,
Page 63
Report Execution
ME_FACH_DCH,
ME_PCH_FACH,
ME_FACH_DCH,
Page 64
Report Execution
DB,0)-NVL(CELLRES.AVAIL_WCELL_BLOCKED_BY_USER,0)), 0, 0,decode((NVL(CELLRES.AVAIL_WCELL_EXISTS_IN_R
)/(100*3600))) grp_traffic_speech_erlangs,
ATA_VOL+CELLTP.NRT_DCH_UL_DATA_VOL+CELLTP.NRT_DCH_HSDPA_UL_DATA_VOL+CELLTP.RT_DCH_HSDPA_U
onv_call_atts+SERVLEV.emergency_call_atts-SERVLEV.RRC_ATT_REP_MO_CONV-SERVLEV.RRC_ATT_REP_MT_CONV
_backg_call_atts+SERVLEV.moc_high_prior_sign_atts+SERVLEV.mtc_inter_call_atts+SERVLEV.mtc_backg_call_atts+SERVL
b_act_comp_cs_conv+SERVLEV.rab_act_comp_cs_strea+SERVLEV.rab_act_rel_cs_voice_srnc+SERVLEV.rab_act_rel_cs_c
ail_cs_voice_iu+SERVLEV.rab_act_fail_cs_voice_radio+SERVLEV.rab_act_fail_cs_voice_bts+SERVLEV.rab_act_fail_cs_voic
tp_att_cs_strea+SERVLEV.rab_stp_att_cs_voice+SERVLEV.RAB_STP_ATT_PS_BACKG+SERVLEV.rab_stp_att_ps_conv+S
_STP_FAIL_CS_VOICE_AC_COD/SERVLEV.rab_stp_att_cs_voice)) grp_code_congestion_voice,
tp_fail_cs_voice_bts/SERVLEV.rab_stp_att_cs_voice)*100) grp_ce_congestion_voice,
+SERVLEV.RAB_ACT_FAIL_AMR_PSNRT), 0, 0,(SERVLEV.RAB_ACT_COMP_AMR_PSNRT)/(SERVLEV.RAB_ACT_COMP
L_PRE_EMP_HS_E_BGR+PKTCALL.PS_REL_PRE_EMP_HS_E_STRE+PKTCALL.PS_REL_PRE_EMP_HS_D_INT+PKTCA
b_act_comp_ps_inter+SERVLEV.rab_act_comp_ps_backg+SERVLEV.rab_act_rel_ps_strea_srnc+SERVLEV.rab_act_rel_ps_
W.HS_SCCH_PWR_DIST_CLASS_1+HSDPAW.HS_SCCH_PWR_DIST_CLASS_2+HSDPAW.HS_SCCH_PWR_DIST_CLAS
ter_hho_att_rt + intsysho.inter_hho_att_rt + intsysho.intra_intra_hho_att_nrt + intsysho.intra_inter_hho_att_nrt + intsysho.inter_
O.is_hho_att_ue_trx_pwr_rt + INTERSHO.is_hho_att_dpch_pwr_rt + INTERSHO.is_hho_att_cpich_rscp_rt + INTERSHO.is_hh
req_on_sho_for_rt + softho.cell_del_req_on_sho_for_rt),0,null, 100*(softho.succ_updates_on_sho_for_rt) / (softho.cell_add_re
ho_att_ue_trx_pwr_rt+INTERSHO.is_hho_att_dpch_pwr_rt+INTERSHO.is_hho_att_cpich_rscp_rt+INTERSHO.is_hho_att_cpic
no_class_1 + cpichq.rrc_cpich_ecno_class_2 + cpichq.rrc_cpich_ecno_class_3 + cpichq.rrc_cpich_ecno_class_4 + cpichq.rrc_
nom_1 + cellres.prxtot_denom_2 + cellres.prxtot_denom_3 + cellres.prxtot_denom_4),0,null, ((power(10, (-112.1 + cellres.ave_
1 + cellres.rtwp_class_2 + cellres.rtwp_class_3 + cellres.rtwp_class_4 + cellres.rtwp_class_5 + cellres.rtwp_class_6 + cellres.rtw
_CL_1+HSDPAW.CQI_DIST_CL_2+HSDPAW.CQI_DIST_CL_3+HSDPAW.CQI_DIST_CL_4+HSDPAW.CQI_DIST_CL_5+HS
_CL_1+HSDPAW.CQI_DIST_CL_2+HSDPAW.CQI_DIST_CL_3+HSDPAW.CQI_DIST_CL_4+HSDPAW.CQI_DIST_CL_5+HS
n_act_set_for_rt/2 + softho.three_cells_in_act_set_rt/3),0,null, ((softho.one_cell_in_act_set_for_rt + softho.two_cells_in_act_se
, ( (HSDPAW.RECEIVED_HS_MACD_BITS-HSDPAW.DISCARDED_HS_MACD_BITS+ (CELTPW.MC_HSDPA_ORIG_DATA
PDUS_10MS_TTI,0,0,(HSDPAW.MACE_PDU_DATA_2MS_TTI+HSDPAW.MACE_PDU_DATA_10MS_TTI)*8/(HSDPAW.MAC
ALLTABLES.ws = CELLRES.ws (+)

LLTABLES.ws = CELLTP.ws (+)
LLTABLES.ws = CELTPW.ws (+)
Page 65
Report Execution
LLTABLES.ws = CPICHQ.ws (+)

ALLTABLES.ws = HSDPAW.ws (+)
d ALLTABLES.ws = INTERSHO.ws (+)
ALLTABLES.ws = INTSYSHO.ws (+)
ALLTABLES.ws = PKTCALL.ws (+)
ABLES.ws = RRC.ws (+)
ALLTABLES.ws = SERVLEV.ws (+)
LLTABLES.ws = SOFTHO.ws (+)
Page 66
Report Execution
_0))/0.001)))+112)*621/62+1) ave_prxtot_class_0,
Page 67
Report Execution
1))/0.001)))+112)*621/62+1) ave_prxtot_class_1,
2))/0.001)))+112)*621/62+1) ave_prxtot_class_2,
3))/0.001)))+112)*621/62+1) ave_prxtot_class_3,
4))/0.001)))+112)*621/62+1) ave_prxtot_class_4,
Page 68
Report Execution
WCELL_EXISTS_IN_RNW_DB,0)-NVL(CELLRES.AVAIL_WCELL_BLOCKED_BY_USER,0)), 0, 0, (100*((CELLRES.AVAIL_W
TP.RT_DCH_HSDPA_UL_STREA_DATA+ CELLTP.RT_PS_DCH_DL_DATA_VOL+CELLTP.NRT_DCH_DL_DATA_VOL+CEL
C_ATT_REP_MT_CONV-SERVLEV.RRC_ATT_REP_EMERGENCY-SERVLEV.RRC_ACC_REL_EMERGENCY-SERVLEV.RR
backg_call_atts+SERVLEV.mtc_high_prior_sign_atts+SERVLEV.moc_strea_call_atts+SERVLEV.mtc_strea_call_atts+SERVLE
VLEV.rab_act_rel_cs_conv_srnc+SERVLEV.rab_act_rel_cs_conv_p_emp+SERVLEV.rab_act_rel_cs_strea_srnc+SERVLEV.r
EV.rab_act_fail_cs_voice_iur+SERVLEV.rab_act_fail_cs_voice_rnc+SERVLEV.RAB_ACT_FAIL_CS_VOICE_UE+SERVLEV.R
rab_stp_att_ps_conv+SERVLEV.rab_stp_att_ps_inter+SERVLEV.RAB_STP_ATT_PS_STREA), 0, 0, (SERVLEV.rab_stp_fail_
VLEV.RAB_ACT_COMP_AMR_PSNRT+SERVLEV.RAB_ACT_FAIL_AMR_PSNRT)))) dcr_3g_multirab,
MP_HS_D_INT+PKTCALL.PS_REL_PRE_EMP_HS_D_BGR+PKTCALL.PS_REL_PRE_EMP_HS_D_STRE+PKTCALL.PS_RE
RVLEV.rab_act_rel_ps_strea_p_emp+SERVLEV.rab_act_rel_ps_inter_srnc+SERVLEV.rab_act_rel_ps_backg_srnc+SERVLEV
CCH_PWR_DIST_CLASS_3+HSDPAW.HS_SCCH_PWR_DIST_CLASS_4+HSDPAW.HS_SCCH_PWR_DIST_CLASS_5), 0, 0
_att_nrt + intsysho.inter_hho_att_nrt),0,null, (intsysho.succ_intra_intra_hho_att_rt + intsysho.succ_intra_inter_hho_att_rt + intsy
p_rt + INTERSHO.is_hho_att_cpich_ecno_rt + INTERSHO.is_hho_att_im_ims_rt + intersho.att_isho_cell_shutdown_rt + intersh
rt) / (softho.cell_add_req_on_sho_for_rt + softho.cell_repl_req_on_sho_for_rt + softho.cell_del_req_on_sho_for_rt))) RNC_153
ERSHO.is_hho_att_cpich_ecno_rt+INTERSHO.IS_HHO_ATT_IM_IMS_RT+INTERSHO.IS_HHO_ATT_EMERG_CALL+INTER
o_class_4 + cpichq.rrc_cpich_ecno_class_5 + cpichq.rrc_cpich_ecno_class_6 + cpichq.rrc_cpich_ecno_class_7 + cpichq.rrc_c
, (-112.1 + cellres.ave_prxtot_class_0/10)/10)*cellres.prxtot_denom_0 )+ (power(10, (-112.1 + cellres.ave_prxtot_class_1/10)/1
wp_class_6 + cellres.rtwp_class_7 + cellres.rtwp_class_8 + cellres.rtwp_class_9 + cellres.rtwp_class_10 + cellres.rtwp_class_
W.CQI_DIST_CL_5+HSDPAW.CQI_DIST_CL_6+HSDPAW.CQI_DIST_CL_7+HSDPAW.CQI_DIST_CL_8+HSDPAW.CQI_DIS
W.CQI_DIST_CL_5+HSDPAW.CQI_DIST_CL_6+HSDPAW.CQI_DIST_CL_7+HSDPAW.CQI_DIST_CL_8+HSDPAW.CQI_DIS
tho.two_cells_in_act_set_for_rt + softho.three_cells_in_act_set_rt) / (softho.one_cell_in_act_set_for_rt + softho.two_cells_in_a
_HSDPA_ORIG_DATA_PRI+CELTPW.MC_HSDPA_ORIG_DATA_SEC)*8)*500)/HSDPAW.HSDPA_BUFF_WITH_DATA_PE
_TTI)*8/(HSDPAW.MACE_PDUS_2MS_TTI*decode(1000, 0, 0, 2/1000)+HSDPAW.MACE_PDUS_10MS_TTI*decode(100, 0, 0
Page 69
Report Execution
00*((CELLRES.AVAIL_WCELL_IN_WO_STATE)))/(NVL(CELLRES.AVAIL_WCELL_EXISTS_IN_RNW_DB,0)-NVL(CELLRES.A
H_DL_DATA_VOL+CELLTP.HS_DSCH_DATA_VOL+CELLTP.RT_HS_DSCH_DL_STREA_DATA+CELLTP.NRT_EDCH_UL_
RGENCY-SERVLEV.RRC_ACC_REL_MO_CONV-SERVLEV.RRC_ACC_REL_MT_CONV+RRC.CELL_UPDATE_ATT_CS_C
strea_call_atts+SERVLEV.moc_subsc_traf_call_atts-SERVLEV.RRC_ATT_REP_INTERACTIVE-SERVLEV.RRC_ATT_REP_M
strea_srnc+SERVLEV.rab_act_rel_cs_strea_p_emp+SERVLEV.RAB_ACT_REL_CS_VOICE_HHO+SERVLEV.RAB_ACT_RE
OICE_UE+SERVLEV.RAB_ACT_FAIL_CS_VOICE_TRANS)) cs_drop_nb,
SERVLEV.rab_stp_fail_cs_conv_ac+SERVLEV.rab_stp_fail_cs_strea_ac+SERVLEV.rab_stp_fail_cs_voice_ac+SERVLEV.rab
TRE+PKTCALL.PS_REL_RL_FAIL_HS_E_INT+PKTCALL.PS_REL_RL_FAIL_HS_E_BGR+PKTCALL.PS_REL_RL_FAIL_HS
_backg_srnc+SERVLEV.rab_act_fail_ps_strea_iu+SERVLEV.rab_act_fail_ps_strea_radio+SERVLEV.rab_act_fail_ps_strea_bt
_DIST_CLASS_5), 0, 0, HSDPAW.HSDPA_BUFF_WITH_DATA_PER_TTI/(HSDPAW.HS_SCCH_PWR_DIST_CLASS_0+HS
_inter_hho_att_rt + intsysho.succ_inter_hho_att_rt + intsysho.succ_intra_intra_hho_att_nrt + intsysho.succ_intra_inter_hho_att
ll_shutdown_rt + intersho.att_isho_cell_block_rt + intersho.is_hho_att_dr_amr_rt + intersho.att_ganho_amr_rt + INTERSHO.is_
_sho_for_rt))) RNC_153b,
EMERG_CALL+INTERSHO.IS_HHO_ATT_LB_CAPA_DL_RT+INTERSHO.IS_HHO_ATT_LB_CAPA_UL_RT+INTERSHO.IS_
_class_7 + cpichq.rrc_cpich_ecno_class_8 + cpichq.rrc_cpich_ecno_class_9),0,null, 10*log( 10, ((power(10,(-18)/10) * cpichq.r
ve_prxtot_class_1/10)/10)*cellres.prxtot_denom_1 )+ (power(10, (-112.1 + cellres.ave_prxtot_class_2/10)/10)*cellres.prxtot_de
0 + cellres.rtwp_class_11 + cellres.rtwp_class_12 + cellres.rtwp_class_13 + cellres.rtwp_class_14 + cellres.rtwp_class_15 + ce
_8+HSDPAW.CQI_DIST_CL_9+HSDPAW.CQI_DIST_CL_10+HSDPAW.CQI_DIST_CL_11+HSDPAW.CQI_DIST_CL_12+HS
_8+HSDPAW.CQI_DIST_CL_9+HSDPAW.CQI_DIST_CL_10+HSDPAW.CQI_DIST_CL_11+HSDPAW.CQI_DIST_CL_12+HS
+ softho.two_cells_in_act_set_for_rt/2 + softho.three_cells_in_act_set_rt/3)))) RNC_980b,
UFF_WITH_DATA_PER_TTI)) grp_hsdpa_avg_thrgput_per_user,
S_TTI*decode(100, 0, 0, 1/100)))) grp_hsupa_avg_thrgput_per_user
Page 70
Report Execution
DB,0)-NVL(CELLRES.AVAIL_WCELL_BLOCKED_BY_USER,0))))) grp_cell_availability,
LLTP.NRT_EDCH_UL_DATA_VOL+CELLTP.RT_E_DCH_UL_STREA_DATA)/(1000*1000*1000))) grp_total_data_trafic_vol_d
_UPDATE_ATT_CS_CALL), 0, 0,(SERVLEV.moc_conv_call_atts-SERVLEV.moc_conv_call_fails+SERVLEV.mtc_conv_call_a
LEV.RRC_ATT_REP_MO_INTERACTIVE-SERVLEV.RRC_ATT_REP_MO_HIGH_PR_SIGN-SERVLEV.RRC_ATT_REP_MO_
ERVLEV.RAB_ACT_REL_CS_CONV_HHO+SERVLEV.RAB_ACT_REL_CS_VOICE_ISHO+SERVLEV.RAB_ACT_REL_CS_C
oice_ac+SERVLEV.rab_stp_fail_ps_backg_ac+SERVLEV.rab_stp_fail_ps_inter_ac+SERVLEV.rab_stp_fail_ps_strea_ac)/(SER
PS_REL_RL_FAIL_HS_E_STRE+PKTCALL.PS_REL_RL_FAIL_HS_D_INT+PKTCALL.PS_REL_RL_FAIL_HS_D_BGR+PKT
ab_act_fail_ps_strea_bts+SERVLEV.rab_act_fail_ps_strea_iur+SERVLEV.rab_act_fail_ps_strea_rnc+SERVLEV.rab_act_fail_p
R_DIST_CLASS_0+HSDPAW.HS_SCCH_PWR_DIST_CLASS_1+HSDPAW.HS_SCCH_PWR_DIST_CLASS_2+HSDPAW.HS
ucc_intra_inter_hho_att_nrt + intsysho.succ_inter_hho_att_nrt) / (intsysho.intra_intra_hho_att_rt + intsysho.intra_inter_hho_att_
amr_rt + INTERSHO.is_hho_att_emerg_call + INTERSHO.is_hho_att_ul_dch_q_nrt + INTERSHO.is_hho_att_ue_trx_pwr_nrt +
UL_RT+INTERSHO.IS_HHO_ATT_LB_PRX_TOT_RT+INTERSHO.IS_HHO_ATT_LB_PTX_TOT_RT+INTERSHO.IS_HHO_A
er(10,(-18)/10) * cpichq.rrc_cpich_ecno_class_0) + (power(10,(-17)/10) * cpichq.rrc_cpich_ecno_class_1) + (power(10,(-15)/10)
0)/10)*cellres.prxtot_denom_2 )+ (power(10, (-112.1 + cellres.ave_prxtot_class_3/10)/10)*cellres.prxtot_denom_3 )+ (power(10
llres.rtwp_class_15 + cellres.rtwp_class_16 + cellres.rtwp_class_17 + cellres.rtwp_class_18 + cellres.rtwp_class_19 + cellres.r
.CQI_DIST_CL_12+HSDPAW.CQI_DIST_CL_13+HSDPAW.CQI_DIST_CL_14+HSDPAW.CQI_DIST_CL_15+HSDPAW.CQI_
.CQI_DIST_CL_12+HSDPAW.CQI_DIST_CL_13+HSDPAW.CQI_DIST_CL_14+HSDPAW.CQI_DIST_CL_15+HSDPAW.CQI_
Page 71
Report Execution
_total_data_trafic_vol_dlul,
VLEV.mtc_conv_call_atts-SERVLEV.mtc_conv_call_fails+SERVLEV.emergency_call_atts-SERVLEV.emergency_call_fails-SE
V.RRC_ATT_REP_MO_BACKGROUND-SERVLEV.RRC_ATT_REP_MT_BACKGROUND-SERVLEV.RRC_ATT_REP_MT_HI
RAB_ACT_REL_CS_CONV_ISHO+SERVLEV.RAB_ACT_REL_CS_VOICE_GANHO+SERVLEV.rab_act_fail_cs_voice_iu+SE
_fail_ps_strea_ac)/(SERVLEV.rab_stp_att_cs_conv+SERVLEV.rab_stp_att_cs_strea+SERVLEV.rab_stp_att_cs_voice+SERV
FAIL_HS_D_BGR+PKTCALL.PS_REL_RL_FAIL_HS_D_STRE+PKTCALL.PS_REL_OTH_FAIL_HS_E_INT+PKTCALL.PS_RE
ERVLEV.rab_act_fail_ps_inter_iu+SERVLEV.rab_act_fail_ps_inter_radio+SERVLEV.rab_act_fail_ps_inter_bts+SERVLEV.rab
CLASS_2+HSDPAW.HS_SCCH_PWR_DIST_CLASS_3+HSDPAW.HS_SCCH_PWR_DIST_CLASS_4+HSDPAW.HS_SCCH_P
sho.intra_inter_hho_att_rt + intsysho.inter_hho_att_rt + intsysho.intra_intra_hho_att_nrt + intsysho.intra_inter_hho_att_nrt + ints
ho_att_ue_trx_pwr_nrt + INTERSHO.is_hho_att_dl_dpch_pwr_nrt + INTERSHO.is_hho_att_cpich_rscp_nrt + INTERSHO.is_hh
INTERSHO.IS_HHO_ATT_LB_RES_LIM_RT+INTERSHO.IS_HHO_ATT_LB_RSVR_SC_RT+INTERSHO.IS_HHO_ATT_SB_R
1) + (power(10,(-15)/10) * cpichq.rrc_cpich_ecno_class_2) + (power(10,(-13)/10) * cpichq.rrc_cpich_ecno_class_3) + (power(10
_denom_3 )+ (power(10, (-112.1 + cellres.ave_prxtot_class_4/10)/10)*cellres.prxtot_denom_4 )) / (cellres.prxtot_denom_0 + ce
wp_class_19 + cellres.rtwp_class_20 + cellres.rtwp_class_21 ),0,null, (power(10,-11.0)*cellres.rtwp_class_0 + power(10,-10.75
CL_15+HSDPAW.CQI_DIST_CL_16+HSDPAW.CQI_DIST_CL_17+HSDPAW.CQI_DIST_CL_18+HSDPAW.CQI_DIST_CL_19
CL_15+HSDPAW.CQI_DIST_CL_16+HSDPAW.CQI_DIST_CL_17+HSDPAW.CQI_DIST_CL_18+HSDPAW.CQI_DIST_CL_19
Page 72
Report Execution
mergency_call_fails-SERVLEV.RRC_ACC_REL_EMERGENCY-SERVLEV.RRC_ACC_REL_MO_CONV-SERVLEV.RRC_ACC
RRC_ATT_REP_MT_HIGH_PR_SIGN-SERVLEV.RRC_ATT_REP_MO_STREAMING-SERVLEV.RRC_ATT_REP_MO_SUBSC
ct_fail_cs_voice_iu+SERVLEV.rab_act_fail_cs_voice_radio+SERVLEV.rab_act_fail_cs_voice_bts+SERVLEV.rab_act_fail_cs_
tp_att_cs_voice+SERVLEV.RAB_STP_ATT_PS_BACKG+SERVLEV.rab_stp_att_ps_conv+SERVLEV.rab_stp_att_ps_inter+S
_INT+PKTCALL.PS_REL_OTH_FAIL_HS_E_BGR+PKTCALL.PS_REL_OTH_FAIL_HS_E_STRE+PKTCALL.PS_REL_OTH_F
nter_bts+SERVLEV.rab_act_fail_ps_inter_iur+SERVLEV.rab_act_fail_ps_inter_rnc+SERVLEV.rab_act_fail_ps_backg_iu+SER
+HSDPAW.HS_SCCH_PWR_DIST_CLASS_5))) grp_number_of_users_queued,
_inter_hho_att_nrt + intsysho.inter_hho_att_nrt))) RNC_2328a,
_nrt + INTERSHO.is_hho_att_cpich_ecno_nrt + INTERSHO.is_hho_att_im_ims_nrt + intersho.att_isho_cell_shutdown_nrt + int
HO.IS_HHO_ATT_SB_RT+INTERSHO.IS_HHO_ATT_UL_DCH_WPS_RT+INTERSHO.ATT_GANHO_AMR_RT+INTERSHO.A
o_class_3) + (power(10,(-11)/10) * cpichq.rrc_cpich_ecno_class_4) + (power(10,(-9)/10) * cpichq.rrc_cpich_ecno_class_5) + (p
es.prxtot_denom_0 + cellres.prxtot_denom_1 + cellres.prxtot_denom_2 + cellres.prxtot_denom_3 + cellres.prxtot_denom_4))))
ss_0 + power(10,-10.75)*cellres.rtwp_class_1 + power(10,-10.65)*cellres.rtwp_class_2 + power(10,-10.55)*cellres.rtwp_class_
PAW.CQI_DIST_CL_19+HSDPAW.CQI_DIST_CL_20+HSDPAW.CQI_DIST_CL_21+HSDPAW.CQI_DIST_CL_22+HSDPAW.C
PAW.CQI_DIST_CL_19+HSDPAW.CQI_DIST_CL_20+HSDPAW.CQI_DIST_CL_21+HSDPAW.CQI_DIST_CL_22+HSDPAW.C
Page 73
Report Execution
V-SERVLEV.RRC_ACC_REL_MT_CONV+RRC.CELL_UPDATE_SUCC_CS_CALL)/(SERVLEV.moc_conv_call_atts+SERVLE
ATT_REP_MO_SUBSCRIBED-SERVLEV.RRC_ATT_REP_MT_STREAMING-SERVLEV.RRC_ACC_REL_INTERACTIVE-SE
RVLEV.rab_act_fail_cs_voice_iur+SERVLEV.rab_act_fail_cs_voice_rnc+SERVLEV.rab_act_fail_cs_conv_iu+SERVLEV.rab_ac
rab_stp_att_ps_inter+SERVLEV.RAB_STP_ATT_PS_STREA))) grp_3g_radio_congestion_rate,
CALL.PS_REL_OTH_FAIL_HS_D_INT+PKTCALL.PS_REL_OTH_FAIL_HS_D_BGR+PKTCALL.PS_REL_OTH_FAIL_HS_D_S
_fail_ps_backg_iu+SERVLEV.rab_act_fail_ps_backg_radio+SERVLEV.rab_act_fail_ps_backg_bts+SERVLEV.rab_act_fail_ps_
_cell_shutdown_nrt + intersho.att_isho_cell_block_nrt)),0,null, ((INTERSHO.succ_is_hho_ul_dch_q_rt + INTERSHO.succ_is_hh
AMR_RT+INTERSHO.ATT_ISHO_CELL_SHUTDOWN_RT+INTERSHO.ATT_ISHO_CELL_BLOCK_RT+INTERSHO.IS_HHO_
pich_ecno_class_5) + (power(10,(-7)/10) * cpichq.rrc_cpich_ecno_class_6) + (power(10,(-5)/10) * cpichq.rrc_cpich_ecno_class_
res.prxtot_denom_4)))) RNC_101c,
55)*cellres.rtwp_class_3 + power(10,-10.45)*cellres.rtwp_class_4 + power(10,-10.35)*cellres.rtwp_class_5 + power(10,-10.25)
IST_CL_22+HSDPAW.CQI_DIST_CL_23+HSDPAW.CQI_DIST_CL_24+HSDPAW.CQI_DIST_CL_25+HSDPAW.CQI_DIST_C
IST_CL_22+HSDPAW.CQI_DIST_CL_23+HSDPAW.CQI_DIST_CL_24+HSDPAW.CQI_DIST_CL_25+HSDPAW.CQI_DIST_C
Page 74
Report Execution
conv_call_atts+SERVLEV.mtc_conv_call_atts+SERVLEV.emergency_call_atts-SERVLEV.RRC_ATT_REP_MO_CONV-SERVL
REL_INTERACTIVE-SERVLEV.RRC_ACC_REL_MO_BACKGROUND-SERVLEV.RRC_ACC_REL_MO_HIGH_PR_SIGN-SER
v_iu+SERVLEV.rab_act_fail_cs_conv_radio+SERVLEV.rab_act_fail_cs_conv_bts+SERVLEV.rab_act_fail_cs_conv_iur+SERV
EL_OTH_FAIL_HS_D_STRE) grp_3g_drop_hsdpa_data,
RVLEV.rab_act_fail_ps_backg_iur+SERVLEV.rab_act_fail_ps_backg_rnc+SERVLEV.RAB_ACT_FAIL_PS_INTER_UE+SERVL
INTERSHO.succ_is_hho_ue_trx_pwr_rt + INTERSHO.succ_is_hho_dl_dpch_pwr_rt + INTERSHO.succ_is_hho_cpich_rscp_rt
T+INTERSHO.IS_HHO_ATT_DR_AMR_RT), 0, null,(INTERSHO.succ_is_hho_ul_dch_q_rt+INTERSHO.succ_is_hho_ue_trx_p
q.rrc_cpich_ecno_class_7) + (power(10,(-3)/10) * cpichq.rrc_cpich_ecno_class_8) + (power(10,(-2)/10) * cpichq.rrc_cpich_ecno
s_5 + power(10,-10.25)*cellres.rtwp_class_6 + power(10,-10.15)*cellres.rtwp_class_7 + power(10,-10.05)*cellres.rtwp_class_8

HSDPAW.CQI_DIST_CL_26+HSDPAW.CQI_DIST_CL_27+HSDPAW.CQI_DIST_CL_28+HSDPAW.CQI_DIST_CL_29+HSDP
HSDPAW.CQI_DIST_CL_26+HSDPAW.CQI_DIST_CL_27+HSDPAW.CQI_DIST_CL_28+HSDPAW.CQI_DIST_CL_29+HSDP
Page 75
Report Execution
REP_MO_CONV-SERVLEV.RRC_ATT_REP_MT_CONV-SERVLEV.RRC_ATT_REP_EMERGENCY-SERVLEV.RRC_ACC_RE
O_HIGH_PR_SIGN-SERVLEV.RRC_ACC_REL_MO_INTERACTIVE-SERVLEV.RRC_ACC_REL_MT_BACKGROUND-SERVL
fail_cs_conv_iur+SERVLEV.rab_act_fail_cs_conv_rnc+SERVLEV.rab_act_fail_cs_strea_iu+SERVLEV.rab_act_fail_cs_strea_r
PS_INTER_UE+SERVLEV.RAB_ACT_FAIL_PS_BACKG_UE+SERVLEV.RAB_ACT_FAIL_PS_INTER_TRANS+SERVLEV.RA
c_is_hho_cpich_rscp_rt + INTERSHO.succ_is_hho_cpich_ecno_rt + INTERSHO.succ_is_hho_im_ims_rt + intersho.succ_isho_
O.succ_is_hho_ue_trx_pwr_rt+INTERSHO.succ_is_hho_dl_dpch_pwr_rt+INTERSHO.succ_is_hho_cpich_rscp_rt+INTERSHO.
* cpichq.rrc_cpich_ecno_class_9)) / (cpichq.rrc_cpich_ecno_class_0 + cpichq.rrc_cpich_ecno_class_1 + cpichq.rrc_cpich_ecno
5)*cellres.rtwp_class_8 + power(10,-09.95)*cellres.rtwp_class_9 + power(10,-09.85)*cellres.rtwp_class_10 + power(10,-09.70)

QI_DIST_CL_29+HSDPAW.CQI_DIST_CL_30), 0, 0, (HSDPAW.CQI_DIST_CL_22+HSDPAW.CQI_DIST_CL_23+HSDPAW.C
QI_DIST_CL_29+HSDPAW.CQI_DIST_CL_30), 0, 0, (HSDPAW.CQI_DIST_CL_16+HSDPAW.CQI_DIST_CL_17+HSDPAW.C
Page 76
Report Execution
ERVLEV.RRC_ACC_REL_EMERGENCY-SERVLEV.RRC_ACC_REL_MO_CONV-SERVLEV.RRC_ACC_REL_MT_CONV+RR
BACKGROUND-SERVLEV.RRC_ACC_REL_MT_HIGH_PR_SIGN-SERVLEV.RRC_ACC_REL_MT_STREAMING-SERVLEV.R
rab_act_fail_cs_strea_radio+SERVLEV.rab_act_fail_cs_strea_bts+SERVLEV.rab_act_fail_cs_strea_iur+SERVLEV.rab_act_fa
_TRANS+SERVLEV.RAB_ACT_FAIL_PS_BACKG_TRANS+SERVLEV.RAB_ACT_REL_PS_INTER_HHO+SERVLEV.RAB_AC
rt + intersho.succ_isho_cell_shutdown_rt + intersho.succ_isho_cell_block_rt + intersho.succ_is_hho_dr_amr...
h_rscp_rt+INTERSHO.succ_is_hho_cpich_ecno_rt+INTERSHO.SUCC_IS_HHO_IM_IMS_RT+INTERSHO.SUCC_IS_HHO_E
+ cpichq.rrc_cpich_ecno_class_2 + cpichq.rrc_...
_10 + power(10,-09.70)...
ST_CL_23+HSDPAW.CQI_DIST_CL_24+HSDPAW.CQI_DIST_CL_25+HSDPAW.CQI_DIST_CL_26+HSDPAW.CQI_DIST_CL
ST_CL_17+HSDPAW.CQI_DIST_CL_18+HSDPAW.CQI_DIST_CL_19+HSDPAW.CQI_DIST_CL_20+HSDPAW.CQI_DIST_CL
Page 77
Report Execution
C_REL_MT_CONV+RRC.CELL_UPDATE_ATT_CS_CALL)))*(decode((SERVLEV.rab_stp_att_cs_voice-INTERSHO.SUCC_IS
REAMING-SERVLEV.RRC_ACC_REL_MO_STREAMING-SERVLEV.RRC_ACC_REL_MO_SUBSCRIBED)+(RRC.ATT_PCH_
r+SERVLEV.rab_act_fail_cs_strea_rnc+SERVLEV.RAB_ACT_FAIL_CS_VOICE_UE+SERVLEV.RAB_ACT_FAIL_CS_...
HO+SERVLEV.RAB_ACT_REL_PS_BACKG_HHO+SERVLEV.RAB_ACT_REL_PS_INTER_ISHO+SERVLEV.RAB_A...
HO.SUCC_IS_HHO_EMERG_CALL+INTERSHO.SUCC_IS_HHO_LB_CAPA_DL_RT+INTERSHO.SUCC_IS_HHO_LB_CAPA
SDPAW.CQI_DIST_CL_27+HSDPAW.CQI_DIST_CL_28+HSDPAW.CQI_DIST_CL_29+HSDPAW.CQI_DIST_CL_30)/(HSDPA
SDPAW.CQI_DIST_CL_21+HSDPAW.CQI_DIST_CL_22+HSDPAW.CQI_DIST_CL_23+HSDPAW.CQI_DIST_CL_24+HSDPA
Page 78
Report Execution
e-INTERSHO.SUCC_IS_HHO_DR_AMR_RT+SERVLEV.rab_stp_att_cs_conv+SERVLEV.rab_stp_att_cs_strea), 0, ...
BED)+(RRC.ATT_PCH_DCH_TRANS_UMRLC+RRC.ATT_FACH_TO_DCH+RRC.ATT_PCH_TO_FACH)), 0, null,(SERVLEV.m
ACT_FAIL_CS_...
RVLEV.RAB_A...
CC_IS_HHO_LB_CAPA_UL_RT+INTERSHO.SUCC_IS_HHO_LB_PRX_TOT_RT+INTERSHO.SUCC_IS_HHO_LB_PTX...
I_DIST_CL_30)/(HSDPAW.CQI_DIST_CL_0+HSDPAW.CQI_DIST_CL_1+HSDPAW.CQI_DIST_CL_2+HSDPAW.CQI_DIST_C
I_DIST_CL_24+HSDPAW.CQI_DIST_CL_25+HSDPAW.CQI_DIST_CL_26+HSDPAW.CQI_DIST_CL_27+HSDPAW.CQI_DIST
Page 79
Report Execution
_cs_strea), 0, ...
H)), 0, null,(SERVLEV.moc_inter_call_at...
IS_HHO_LB_PTX...
+HSDPAW.CQI_DIST_CL_3+HSDPAW.CQI_DIST_CL_4+HSDPA...
27+HSDPAW.CQI_DIST_CL_28+HSDPAW.CQI_DIST_CL_29+HS...
Page 80
Charts
102.00
100.00
98.00
96.00
94.00
92.00
90.00
88.00
86.00
84.00
82.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
4,000.00
3,500.00
3,000.00
2,500.00
2,000.00
1,500.00
1,000.00
500.00
0.00 Page 81
0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 02
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.2
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
1,500.00
1,000.00 Charts
500.00
0.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 02
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 .2
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
900.00
800.00
700.00
600.00
500.00
400.00
300.00
200.00
100.00
0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.
9.0 9.0 9.0 9.0 9.0 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
120.00
100.00
80.00
60.00
Page 82
40.00
100.00
Charts
80.00
60.00
40.00
20.00
0.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
99.50
99.00
98.50
98.00
97.50
97.00
96.50
96.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
. . . . . . . . . . . . . . .
. 05 . 06 . 07 . 08 . 09 . 10 . 11 . 12 . 13 . 14 . 15 . 16 . 17 . 18 . 19
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
3.50
Page 83
3.00
Charts
3.50
3.00
2.50
2.00
1.50
1.00
0.50
0.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
4,000.00
3,500.00
3,000.00
2,500.00
2,000.00
1,500.00
1,000.00
500.00
0.00 Page 84
0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 02
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.2
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
1,500.00
1,000.00 Charts
500.00
0.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 02
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 .2
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
0.10
0.09
0.08
0.07
0.06
0.05
0.04
0.03
0.02
0.01
0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.
9.0 9.0 9.0 9.0 9.0 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
0.00
0.00
0.00
0.00
0.00
Page 85
0.00
0.00
Charts
0.00
0.00
0.00
0.00
0.00
0.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
1.80
1.60
1.40
1.20
1.00
0.80
0.60
0.40
0.20
0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
. . . . . . . . . . . . . . .
. 05 . 06 . 07 . 08 . 09 . 10 . 11 . 12 . 13 . 14 . 15 . 16 . 17 . 18 . 19
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
4.50
4.00
Page 86
3.50
Charts
4.50
4.00
3.50
3.00
2.50
2.00
1.50
1.00
0.50
0.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
200,000.00
180,000.00
160,000.00
140,000.00
120,000.00
100,000.00
80,000.00
60,000.00
40,000.00
20,000.00
0.00 Page 87
0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 02
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.2
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
80,000.00
60,000.00
Charts
40,000.00
20,000.00
0.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 02
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 .2
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
2.50
2.00
1.50
1.00
0.50
0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.
9.0 9.0 9.0 9.0 9.0 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
2.50
2.00
1.50
Page 88
1.00
2.00
Charts
1.50
1.00
0.50
0.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
90.00
88.00
86.00
84.00
82.00
80.00
78.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
. . . . . . . . . . . . . . .
. 05 . 06 . 07 . 08 . 09 . 10 . 11 . 12 . 13 . 14 . 15 . 16 . 17 . 18 . 19
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
90.00
88.00 Page 89
86.00
Charts
90.00
88.00
86.00
84.00
82.00
80.00
78.00
76.00
74.00
72.00
70.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
101.00
100.00
99.00
98.00
97.00
96.00
95.00
94.00
93.00 Page 90
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
96.00
95.00 Charts
94.00
93.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
90.00
88.00
86.00
84.00
82.00
80.00
78.00
76.00
74.00
72.00
70.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.
9.0 9.0 9.0 9.0 9.0 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
-6.60
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5
-6.80 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
-7.00
-7.20
-7.40
Page 91
-7.60
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
-7.00
Charts
-7.20
-7.40
-7.60
-7.80
-8.00
-8.20
-8.40
-8.60
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
-100.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
9.0 9.0 9.0 9.0 9.0 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1
0
-101.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0
-102.00
-103.00
-104.00
-105.00
-106.00
-107.00
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
-92.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20Page .92 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09
-94.00 09 09 09 09 09 09 09 09 09 09 09 09 09 09
Charts
-92.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.
9.0 9.0 9.0 9.0 9.0 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1
-94.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
-96.00
-98.00
-100.00
-102.00
-104.00
-106.00
-108.00
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
36.00
35.00
34.00
33.00
32.00
31.00
30.00
29.00
28.00 Page 93
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
31.00
30.00 Charts
29.00
28.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
69.00
68.00
67.00
66.00
65.00
64.00
63.00
62.00
61.00
60.00
59.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
5. 6. 7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9.
9.0 9.0 9.0 9.0 9.0 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1 9.1
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
1.55
1.50
1.45
Page 94
1.40
1.50
Charts
1.45
1.40
1.35
1.30
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
1,800.00
1,600.00
1,400.00
1,200.00
1,000.00
800.00
600.00
400.00
200.00
0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
. . . . . . . . . . . . . . .
. 05 . 06 . 07 . 08 . 09 . 10 . 11 . 12 . 13 . 14 . 15 . 16 . 17 . 18 . 19
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09 0
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
250.00
Page 95
200.00
Charts
250.00
200.00
150.00
100.00
50.00
0.00
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
.0 .0 .0 .0 .0 .1 .1 .1 .1 .1 .1 .1 .1 .1 .1
09 09 09 09 09 09 09 09 09 09 09 09 09 09 09
09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.20.2020 09.21.2020 09.22.2020 09.23.2020 09.24.2020 09.25.2020 09.26.2020 09
Page 96
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 97
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
02 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
Charts
02
0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
9.1 9.1 9.1 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.3 0.0 0.0 0.0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 98
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
. 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2
. 17 . 18 . 19 . 20 . 21 . 22 . 23 . 24 . 25 . 26 . 27 . 28 . 29 . 30 . 01 . 02 . 03
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 99
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 100
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
02 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
Charts
02
0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
9.1 9.1 9.1 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.3 0.0 0.0 0.0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 101
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
. 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2
. 17 . 18 . 19 . 20 . 21 . 22 . 23 . 24 . 25 . 26 . 27 . 28 . 29 . 30 . 01 . 02 . 03
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 102
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 103
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
02 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0 .
Charts
02
0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0 .
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 10
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
9.1 9.1 9.1 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.3 0.0 0.0 0.0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 104
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
. 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2 . 2
. 17 . 18 . 19 . 20 . 21 . 22 . 23 . 24 . 25 . 26 . 27 . 28 . 29 . 30 . 01 . 02 . 03
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 105
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 106
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
9.1 9.1 9.1 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.3 0.0 0.0 0.0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
Page 107
0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1
Charts
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
9.1 9.1 9.1 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.3 0.0 0.0 0.0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 20 20 20 20 20 20 20 20 02
0 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 Page.2108 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
Charts
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
9.1 9.1 9.1 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.3 0.0 0.0 0.0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 109
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
20 02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
02
0
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
7. 8. 9. 0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 0. 1. 2. 3.
9.1 9.1 9.1 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.2 9.3 0.0 0.0 0.0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 110
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
. . . . . . . . . . . . . . . . .
. 17 . 18 . 19 . 20 . 21 . 22 . 23 . 24 . 25 . 26 . 27 . 28 . 29 . 30 . 01 . 02 . 03 .
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 10
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 111
Charts
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
. 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20 . 20
7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
.1 .1 .1 .2 .2 .2 .2 .2 .2 .2 .2 .2 .2 .3 .0 .0 .0
09 09 09 09 09 09 09 09 09 09 09 09 09 09 10 10 10 1
09.11.2020 09.12.2020 09.13.2020 09.14.2020 09.15.2020 09.16.2020 09.17.2020 09.18.2020 09

09.26.2020 09.27.2020 09.28.2020 09.29.2020 09.30.2020 10.01.2020 10.02.2020 10.03.2020 10
Page 112
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 113
0 0 0 0 0
202 202 202 202
1. 2. 3. 4.
.0 .0 .0 .0
Charts
0 20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
0 0 0 0
202 202 202 202
1. 2. 3. 4.
0.0 0.0 0.0 0.0
1 1 1 1
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 114
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
0 0 0 0
202 202 202 202
. . . .
. 01 . 02 . 03 . 04
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 115
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 116
0 0 0 0 0
202 202 202 202
1. 2. 3. 4.
.0 .0 .0 .0
Charts
0 20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
0 0 0 0
202 202 202 202
1. 2. 3. 4.
0.0 0.0 0.0 0.0
1 1 1 1
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 117
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
0 0 0 0
202 202 202 202
. . . .
. 01 . 02 . 03 . 04
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 118
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 119
0 0 0 0
202 202 202 202
1. 2. 3. 4.
.0 .0 .0 .0
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
0 0 0 0
202 202 202 202
1. 2. 3. 4.
0.0 0.0 0.0 0.0
1 1 1 1
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 120
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
0 0 0 0
202 202 202 202
. . . .
. 01 . 02 . 03 . 04
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 121
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 122
0 0 0 0
202 202 202 202
1. 2. 3. 4.
.0 .0 .0 .0
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
0 0 0 0
202 202 202 202
1. 2. 3. 4.
0.0 0.0 0.0 0.0
1 1 1 1
09.18.2020 09.19.2020
10.03.2020 10.04.2020
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
Page 123
1 1 1 1
Charts
09.18.2020 09.19.2020
10.03.2020 10.04.2020
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
0.0 0.0 0.0 0.0
1 1 1 1
09.18.2020 09.19.2020
10.03.2020 10.04.2020
20 20 20 20
. 20 . 20 . 20 . 20 Page 124
1 2 3 4
.0 .0 .0 .0
10 10 10 10
Charts
0 0 0 0
202 202 202 202
1. 2. 3. 4.
0.0 0.0 0.0 0.0
1 1 1 1
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 125
0 0 0 0
202 202 202 202
1. 2. 3. 4.
.0 .0 .0 .0
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
0 0 0 0
202 202 202 202
1. 2. 3. 4.
0.0 0.0 0.0 0.0
1 1 1 1
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 126
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
0 0 0 0
202 202 202 202
. . . .
01 02 03 04
0. 10
.
10
.
10
.
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 127
Charts
20 20 20 20
. 20 . 20 . 20 . 20
1 2 3 4
.0 .0 .0 .0
10 10 10 10
09.18.2020 09.19.2020
10.03.2020 10.04.2020
Page 128

3G Kousseri

Uploaded by

Copyright:

Available Formats

3G Kousseri

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

3G Kousseri

Uploaded by

Copyright:

Available Formats

Data

Period start time ws Grp_Cell_Availability

cs_drop_nb Groupe 3G_Radio_Congestion_Rate Grp_Code_Congestion_Voice

Grp_CE_Congestion_Voice 3G_DCR_MultiRAB grp_3G_Drop - HSDPA Data services

3G Drop Call Rate - All Data services grp_Number_of_users_queued IFHO SR

Inter-Sys HHO SR Soft HO Success rate, RT

Average RTWP CQI>21 CQI_15 Soft Handover Overhead for RT

Report Title 3G KPI Report Acceptance

KPI ID KPI Alias

KPI Title KPI FormulUnit

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

Start Time End Time

2020-10-05 15:54:11.917 2020-10-05 15:54:14.188

2020-10-05 15:54:14.188 2020-10-05 15:54:21.19

2020-10-05 15:54:21.19 2020-10-05 15:54:33.634

2020-10-05 15:54:33.634 2020-10-05 15:55:05.455

2020-10-05 15:55:05.456 2020-10-05 15:55:21.0

2020-10-05 15:55:21.0 2020-10-05 15:55:48.543

2020-10-05 15:55:48.543 2020-10-05 15:55:52.798

2020-10-05 15:55:52.798 2020-10-05 15:56:16.970

2020-10-05 15:56:16.970 2020-10-05 15:56:25.499

2020-10-05 15:56:25.500 2020-10-05 15:56:30.741

2020-10-05 15:56:30.741 2020-10-05 15:56:54.885

2020-10-05 15:56:54.886 2020-10-05 15:56:54.914

2020-10-05 15:56:54.914 2020-10-05 15:56:54.996

create global temporary table jf_CELTPW_0583189786 on commit preserve rows as

g.ws_gid = a.wcel_gid and g.ws in ( 'Kousseri_all_3G' ) and a.ws = g.ws

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

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

and ALLTABLES.period_start_time = CPICHQ.period_start_time (+) and ALLTABLES.ws = CPICH

ALLTABLES.ws = CELLRES.ws (+)

LLTABLES.ws = CPICHQ.ws (+)

_cell_shutdown_nrt + intersho.att_isho_cell_block_nrt)),0,null, ((INTERSHO.succ_is_hho_ul_dch_q_rt + INTERSHO.succ_is_hh

INTERSHO.succ_is_hho_ue_trx_pwr_rt + INTERSHO.succ_is_hho_dl_dpch_pwr_rt + INTERSHO.succ_is_hho_cpich_rscp_rt

s_5 + power(10,-10.25)*cellres.rtwp_class_6 + power(10,-10.15)*cellres.rtwp_class_7 + power(10,-10.05)*cellres.rtwp_class_8

c_is_hho_cpich_rscp_rt + INTERSHO.succ_is_hho_cpich_ecno_rt + INTERSHO.succ_is_hho_im_ims_rt + intersho.succ_isho_

5)*cellres.rtwp_class_8 + power(10,-09.95)*cellres.rtwp_class_9 + power(10,-09.85)*cellres.rtwp_class_10 + power(10,-09.70)

rt + intersho.succ_isho_cell_shutdown_rt + intersho.succ_isho_cell_block_rt + intersho.succ_is_hho_dr_amr...

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

09.05.2020 09.06.2020 09.07.2020 09.08.2020 09.09.2020 09.10.2020 09.11.2020 09

s_5 + power(10,-10.25)cellres.rtwp_class_6 + power(10,-10.15)cellres.rtwp_class_7 + power(10,-10.05)*cellres.rtwp_class_8

5)cellres.rtwp_class_8 + power(10,-09.95)cellres.rtwp_class_9 + power(10,-09.85)*cellres.rtwp_class_10 + power(10,-09.70)