traffic_network-rsran-rnc-day-pm_10680-2015_09_18-08_54_27__551
TRANSCRIPT
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
1/23
Data
Page 1
Period start time PLMN Name
RNC_280C
09.16.2015 PLMN 39,569.82
09.17.2015 PLMN 34,785.86
Total C tra!!i" # $rl
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
2/23
Data
Page 2
P_T%T<R&''(C
11,560
10,434
P_Total Tra!!i"
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
3/23
Documentation
Page 3
Re)ort Title Tra!!i"_Net*or+
N%P Re)ort Release ersio- -o-e
R Re)ort Release ersio- -o-e
Re)ort ( PM_10680
Re)ort es"ri)tio- -o-e
tart Time 09.16.2015 00/00/00$-d Time 09.18.2015 00/00/00
%e"ts Leel/ RNC PLMNRNC#3101 100413, PLMNRNC
%e"t &reatio- Leel PLMN
Time &reatio- Leel da
T:res:old -o-e
orti- -;ll
ata o;r"e )mrPool
&da-"ed 'ilter -o-e
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
4/23
Documentation
Page 4
3102 100414, PLMNRNC#57 100415, PLMNRNC#58 100426, PLMNRNC#59 100564, PLMN
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
5/23
Documentation
Page 5
RNC#60 100570
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
6/23
Report Execution
Page 6
Ca":e :a-dler
$al;atio- met:od
(-it d;ratio-
l e-eratio-
$De";tio- d;ratio-
Load !rom "a":eCreate tm) Tales
ro) tm) Tales
Load data d
Load data a-d *rite to "a":e
tart Time
2015#09#18 08/54/24.250
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
7/23
Report Execution
Page 7
2015#09#18 08/54/24.328
2015#09#18 08/54/24.356
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
8/23
Report Execution
Page 8
2015#09#18 08/54/24.370
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
9/23
Report Execution
Page 9
"om.-o+ia.oss.e-i-e.s;))ort.Ca":e&*are$-i-e
tm) tales1
0.026
0.0020
0.133
-o-e0.119
-o-e
-o-e
-o-e
$-d Time Note l
2015#09#18 08/54/24.328 "reati- tm) tale/ !_$R
"reate loal
sele"t
a.)eriod_sta a.)lm-_
=Ma_ra
=MR
=MR
=MR
!rom
sele"t
tr;-"
F)lm-F.
Fr-"F."o
=Ma
=MR
=MR
=MR
!rom
;t)_"
;t)_"
-o+r*
*:ere
Fr-"F.
a-d )ea-d )e
a-d F)l
a-d Fr
a-d Fr
a-d Fr
ro;)
tr;-"
F)lm-F.
Fr-"F."o
a
ro;)
a.)eriod_sta a.)lm-_
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
10/23
Report Execution
Page 10
2015#09#18 08/54/24.355 "reati- tm) tale/ !_C$L
"reate loal
sele"t
a.)eriod_sta
a.)lm-_
=MNRT_=MN
=ME
=MN
=MR
!rom
sele"t
tr;-"
F)lm-F.
Fr-"F."o
=M
=MN =ME
=MN
=MR
!rom
;t)_"
;t)_"
-o+r*
*:ere
Fr-"F.
a-d )e
a-d )e
a-d F)l
a-d Fr
a-d Fr
a-d Fr
ro;)
tr;-"
F)lm-F.
Fr-"F."o
a
ro;)
a.)eriod_sta a.)lm-_
2015#09#18 08/54/24.367 "reati- tm) tale/ !_&LL
"reate loal
sele"t
)eriod_star
)lm-_id
!rom
sele"t
)eriod_
!rom !_C$LL
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
11/23
Report Execution
Page 11
=N(%N
sele"t
)eriod_
!rom !_$R
)
2015#09#18 08/54/24.382 re)ort !rom tm) tales
sele"t
to_-;merd
!_&LLT&
!_C$LLT
!_$R
a-d &L
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
12/23
Report Execution
Page 12
L$_1875106644
tem)orar tale !_$RL$_1875106644 o- "ommit )resere ro*s as
t_time,id,
_:ld_tm_"s_oi"e a_ra_:ld_tm_"s_oi"e,
B_E%L_T(M$_C_C%N_64 R&B_E%L_T(M$_C_C%N_64,
B_E%L_T(M$_C_TR$&M_14_4 R&B_E%L_T(M$_C_TR$&M_14_4,
B_E%L_T(M$_C_TR$&M_57_6 R&B_E%L_T(M$_C_TR$&M_57_6
).)eriod_start_time, dd )eriod_start_time,
o_id )lm-_id,
_id r-"_id,
_ra_:ld_tm_"s_oi"e a_ra_:ld_tm_"s_oi"e,
B_E%L_T(M$_C_C%N_64 R&B_E%L_T(M$_C_C%N_64,
B_E%L_T(M$_C_TR$&M_14_4 R&B_E%L_T(M$_C_TR$&M_14_4,
B_E%L_T(M$_C_TR$&M_57_6 R&B_E%L_T(M$_C_TR$&M_57_6
ommo-_oe"ts F)lm-F,
ommo-_oe"ts Fr-"F,
_)s_serle_r-"_da )
o_id i- 100413,100414,100415,100426,100564,100570
riod_start_time GH to_date20150916 00/00/00, mmdd ::24/mi/ssriod_start_time I to_date20150918 00/00/00, mmdd ::24/mi/ss
lm-F."o_o"_id H 16
"F."o_id H ).r-"_id
"F."o_)are-t_id H F)lm-F."o_id
"F."o_o"_id H 811
).)eriod_start_time, dd ,
o_id,
_id
t_time,id
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
13/23
Report Execution
Page 13
LTP_1875875877
tem)orar tale !_C$LLTP_1875875877 o- "ommit )resere ro*s as
t_time,
id,
CE_=L_&T&_%L NRT_CE_=L_&T&_%L,T_CE_L_&T&_%L NRT_CE_L_&T&_%L,
_CE_&T&_%L E_CE_&T&_%L,
T_$CE_=L_&T&_%L NRT_$CE_=L_&T&_%L,
_$_CE_=L_TR$&_&T& RT_$_CE_=L_TR$&_&T&
).)eriod_start_time, dd )eriod_start_time,
o_id )lm-_id,
_id r-"_id,
RT_CE_=L_&T&_%L NRT_CE_=L_&T&_%L,
T_CE_L_&T&_%L NRT_CE_L_&T&_%L,_CE_&T&_%L E_CE_&T&_%L,
T_$CE_=L_&T&_%L NRT_$CE_=L_&T&_%L,
_$_CE_=L_TR$&_&T& RT_$_CE_=L_TR$&_&T&
ommo-_oe"ts F)lm-F,
ommo-_oe"ts Fr-"F,
_)s_"ellt)_r-"_da )
o_id i- 100413,100414,100415,100426,100564,100570
riod_start_time GH to_date20150916 00/00/00, mmdd ::24/mi/ss
riod_start_time I to_date20150918 00/00/00, mmdd ::24/mi/ss
lm-F."o_o"_id H 16
"F."o_id H ).r-"_id
"F."o_)are-t_id H F)lm-F."o_id
"F."o_o"_id H 811
).)eriod_start_time, dd ,
o_id,
_id
t_time,id
&BL$_1863392330
tem)orar tale !_&LLT&BL$_1863392330 o- "ommit )resere ro*s as
_time,
tart_time, T%_CE&R)lm-_id )lm-_id
TP_1875875877
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
14/23
Report Execution
Page 14
tart_time, T%_CE&R)lm-_id )lm-_id
L$_1875106644
&LLT&BL$.)eriod_start_time )eriod_start_time,
-l)lm-."o_-ame, -l)lm-."o_oe"t_i-sta-"e, NNJJ)lm-."o_idJJ FPLMN NameF,
&LLT&BL$.)lm-_id, -l)lm-."o_eDt_d-, )lm-."o_d- FNF,
to_-;merserle.a_ra_:ld_tm_"s_oi"e K serle.ra_:old_time_"s_"o-_646412.2 K serle
e"ode10001000, 0, 0, C$LLTP.NRT_CE_L_&T&_%L100010001000Kde"ode10001000,
!rom
;t)_"ommo-_oe"ts )lm-,
BL$_1863392330 &LLT&BL$,
P_1875875877 C$LLTP,
$_1875106644 $RL$
*:ere
)lm-."o_id H &LLT&BL$.)lm-_id
a-d &LLT&BL$.)eriod_start_time H C$LLTP.)eriod_start_time K a-d &LLT&BL$.)lm-_id H C$L
T&BL$.)eriod_start_time H $RL$.)eriod_start_time K a-d &LLT&BL$.)lm-_id H $RL$.)l
order
2,1,3
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
15/23
Report Execution
Page 15
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
16/23
Report Execution
Page 16
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
17/23
Report Execution
Page 17
.ra_:old_time_"s_stream_14_414.412.2 K serle.ra_:old_time_"s_stream_57_657.612.2 601
0, 0, C$LLTP.NRT_CE_=L_&T&_%L100010001000Kde"ode10000001000, 0, 0, C$LLTP.E
LTP.)lm-_id K
-_id K
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
18/23
Report Execution
Page 18
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
19/23
Report Execution
Page 19
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
20/23
Report Execution
Page 20
0060 RNC_280",
_CE_&T&_%L10000001000Kde"ode10000001000, 0, 0,C$LLTP.NRT_$CE_=L_&T&_
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
21/23
Report Execution
Page 21
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
22/23
Report Execution
Page 22
-
7/24/2019 Traffic_Network-RSRAN-RNC-day-PM_10680-2015_09_18-08_54_27__551
23/23
Report Execution
%LKC$LLTP.RT_$_CE_=L_TR$&_&T&10000001000 )s_totaltra!!i"