Data

RRC conn access

Period start time PLMN name RNC name WBTS name WBTS ID WCEL name WCEL ID SR
RNC_217F
03.23.2018 PLMN RBDQN1N BDPC41 482 BDPC41D 4 100.00
03.24.2018 PLMN RBDQN1N BDPC41 482 BDPC41D 4 100.00
03.25.2018 PLMN RBDQN1N BDPC41 482 BDPC41D 4 98.78
03.26.2018 PLMN RBDQN1N BDPC41 482 BDPC41D 4 100.00
03.27.2018 PLMN RBDQN1N BDPC41 482 BDPC41D 4 99.28
03.28.2018 PLMN RBDQN1N BDPC41 482 BDPC41D 4 100.00
03.29.2018 PLMN RBDQN1N BDPC41 482 BDPC41D 4 99.14

Page 1
 Data

RRC conn access RRC a

completions IU FR IU fails Radio FR Radio Fails BTS FR BTS Fails IUR FR
RNC_334A RNC_339B RNC_2226A RNC_340B RNC_2227A RNC_341B RNC_2228A RNC_342B
233 0.00 0 0.00 0 0.00 0 0.00
360 0.00 0 0.00 0 0.00 0 0.00
219 0.91 2 0.46 1 0.00 0 0.00
302 0.00 0 0.00 0 0.00 0 0.00
239 0.42 1 0.00 0 0.00 0 0.00
261 0.00 0 0.00 0 0.00 0 0.00
217 0.00 0 0.92 2 0.00 0 0.00

Page 2
 Data

RRC active, drops

IUR Fails CIPH FR CIPH Fails RNC FR RNC Fails UE FR UE Fails
RNC_2229A RNC_343B RNC_2230A RNC_345B RNC_2231A RNC_1069A M1001C391
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.42 1
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.00 0

Page 3
 Data

RAB Retainability AMR RAB setup access

Trans FR Trans Fails CS Voice SR CS Conv SRPS SR completions
RNC_2015A M1001C689 RNC_231D RNC_232E RNC_571C RNC_390A
0.00 0 100.00 100.00 50
0.00 0 98.85 100.00 77
0.00 0 100.00 98.80 36
0.00 0 100.00 100.00 32
0.00 0 98.36 98.78 60
0.00 0 98.63 100.00 73
0.00 0 98.04 97.67 37

Page 4
 Data

AMR RAB retainability

Succ completions Total completions IU FR IU Fails Radio FR Radio Fails BTS FR
M1001C136 RNC_2008A RNC_409D RNC_2239A RNC_410D RNC_2240A RNC_411D
59 61 0.00 0 0.00 0 0.00
86 87 0.00 0 1.15 1 0.00
41 42 0.00 0 0.00 0 0.00
42 42 0.00 0 0.00 0 0.00
59 61 0.00 0 1.64 1 0.00
72 73 0.00 0 1.37 1 0.00
49 51 0.00 0 1.96 1 0.00

Page 5
 Data

AMR RAB active, drops

BTS Fails IUR FR IUR Fails RNC FR RNC Fails UE FR UE Fails
RNC_2241A RNC_412D RNC_2242A RNC_414D RNC_2243A RNC_1070C M1001C392
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.00 0
0 0.00 0 0.00 0 0.00 0

Page 6
 Data

CS Conv RAB setup access CS Conv RAB retainability

Trans FR Trans Fails completions Succ Completions Total Completions
RNC_2010A M1001C690 M1001C116 M1001C137 RNC_415B
0.00 0 0 0 0
0.00 0 0 0 0
0.00 0 0 0 0
0.00 0 0 0 0
0.00 0 0 0 0
0.00 0 0 0 0
0.00 0 0 0 0

Page 7
 Data

CS Conv RAB active, drops

Iu FR Iu Fails Radio FR Radio Fails BTS FR BTS Fails Iur FR
RNC_1972B M1001C155 RNC_1973B M1001C156 RNC_1974B M1001C157 RNC_1975B
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0

Page 8
 Data

S Conv RAB active, drops

Iur Fails RNC FR RNC Fails UE FR UE Fails Trans FR Trans Fails
M1001C158 RNC_1976B M1001C160 RNC_1977B M1001C393 RNC_2002A M1001C691
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0

Page 9
 Data

Packet service RAB setup access Packet service RAB retainability

Completions Succ Completions Total Completions IU FR IU Fails
RNC_1978A RNC_1957A RNC_2011A RNC_1958B RNC_1964A
109 94 99 0.00 0
155 160 165 0.00 0
84 70 83 0.00 0
126 122 124 0.00 0
78 76 82 0.00 0
97 93 98 0.00 0
95 80 86 0.00 0

Page 10
 Data

Packet service RAB active, drops

Radio FR Radio Fails BTS FR BTS Fails IUR FR IUR Fails RNC FR
RNC_1959B RNC_1965A RNC_1960B RNC_1966A RNC_1961B RNC_1967A RNC_1962B
0.00 0 0.00 0 0.00 0 0.00
0.00 0 0.00 0 0.00 0 0.00
1.20 1 0.00 0 0.00 0 0.00
0.00 0 0.00 0 0.00 0 0.00
0.00 0 0.00 0 0.00 0 0.00
0.00 0 0.00 0 0.00 0 0.00
2.33 2 0.00 0 0.00 0 0.00

Page 11
 Data

ps Packet session, Rel

RNC Fails UE FR UE Fails Trans FR Trans Fails HS-DSCH/E-DCH HS-DSCH/DCH
RNC_1968A RNC_1963B RNC_1969A RNC_2005A RNC_2009A RNC_2202A RNC_2198A
0 0.00 0 0.00 0 3,779 1
0 0.00 0 0.00 0 4,190 3
0 0.00 0 0.00 0 4,628 1
0 0.00 0 0.00 0 4,220 16
0 1.22 1 0.00 0 5,488 2
0 0.00 0 0.00 0 5,556 1
0 0.00 0 0.00 0 6,103 3

Page 12
 Data

ssion, Rel Packet session Success Ratio

DCH/DCH SR HSDPA SR HSUPA SR R99 SR HS-DSCH/E-DCH DR, RL
RNC_2206A RNC_922B RNC_920B RNC_921C RNC_944C RNC_2210A
6 84.42 84.47 84.47 93.33 15.43
4 75.98 75.99 76.03 100.00 23.91
1 68.06 68.13 68.15 100.00 31.89
9 77.10 77.20 77.35 88.89 22.68
4 71.95 71.95 71.94 100.00 27.99
5 80.15 80.18 80.18 97.62 19.76
5 73.90 73.91 73.90 100.00 26.00

Page 13
 Data

HS-DSCH/E-DCH Drops, RL HS-DSCH/DCH DR, RL HS-DSCH/DCH Drops,RL DCH/DCH DR, RL

RNC_1839A RNC_2208A RNC_1840A RNC_2204A
583 0.00 0 33.33
1,002 66.67 2 0.00
1,476 0.00 0 0.00
957 62.50 10 22.22
1,536 0.00 0 0.00
1,098 0.00 0 20.00
1,587 0.00 0 0.00

Page 14
 Data

Packet session, drops

DCH/DCH Drops, RL HS-DSCH/E-DCH DR, Other HS-DSCH/E-DCH Drops, Other
RNC_1841A RNC_2200A RNC_1842A
2 0.13 5
0 0.10 4
0 0.06 3
2 0.02 1
0 0.09 5
1 0.09 5
0 0.13 8

Page 15
 Data

HS-DSCH/DCH DR, Other HS-DSCH/DCH Drops, Other DCH/DCH DR, Other

RNC_2196A RNC_1843A RNC_1100D
0.00 0 0.00
0.00 0 0.00
0.00 0 0.00
0.00 0 22.22
0.00 0 0.00
0.00 0 0.00
0.00 0 0.00

Page 16
 Data

HS-DSCH alloc rel

DCH/DCH Drops, Other Alloc rel RL FR RL Fails Non-RL FR Non-RL Fails
RNC_1844A RNC_2664A RNC_2666A RNC_2660A RNC_2676A RNC_2659A
0 5,875 10.06 591 0.02 1
0 6,347 15.88 1,008 0.00 0
0 6,714 22.12 1,485 0.00 0
2 6,427 15.03 966 0.00 0
0 7,963 19.43 1,547 0.00 0
0 7,918 13.94 1,104 0.01 1
0 8,064 19.75 1,593 0.00 0

Page 17
 Data

HSDPA retain FR
Mobility FR Mobility Fails Pre-emption FR Pre-emption Fails Other than Mob FR
RNC_2678A RNC_2661A RNC_2680A RNC_2662A RNC_2682A
0.14 8 0.00 0 0.00
0.13 8 0.00 0 0.00
0.10 7 0.00 0 0.00
0.11 7 0.00 0 0.00
0.10 8 0.00 0 0.00
0.16 13 0.00 0 0.00
0.05 4 0.00 0 0.00

Page 18
 Data

E-DCH alloc rel HSUPA retain FR

Other than Mob Fails Alloc rel RL FR RL Fails E-DCH RelRate, HS-DSCH SCC
RNC_2663A RNC_2669A RNC_2671A RNC_2012A RNC_2675A
0 13,275 4.72 626 0.00
0 13,506 7.76 1,048 0.00
0 14,965 10.12 1,515 0.02
0 12,672 7.84 994 0.01
0 14,790 10.68 1,579 0.00
0 14,170 8.05 1,141 0.00
0 13,891 11.63 1,615 0.00

Page 19
 Data

HSUPA retain FR HS-DSCH SCC

E-DCH Rel, HS-DSCH SCCOther FR Other Fails Att UE UE Fails
RNC_2013A RNC_2673A RNC_2014A RNC_906A RNC_1110A M1008C217
0 0.01 1 2,086 0.10 2
0 0.00 0 2,145 0.05 1
3 0.00 0 2,073 0.29 6
1 0.00 0 2,184 0.05 1
0 0.00 0 2,465 0.24 6
0 0.01 1 2,350 0.13 3
0 0.00 0 1,955 0.20 4

Page 20
 Data

HS-DSCH SCC, failures

BTS BTS Fails Transp Transp Fails AC AC Fails Other
RNC_1111A M1008C218 RNC_1112A M1008C219 RNC_1113A M1008C220 RNC_1114A
0.00 0 0.00 0 0.00 0 0.05
0.00 0 0.00 0 0.00 0 0.05
0.00 0 0.00 0 0.00 0 0.10
0.00 0 0.00 0 0.00 0 0.00
0.00 0 0.00 0 0.00 0 0.04
0.00 0 0.00 0 0.00 0 0.04
0.00 0 0.00 0 0.00 0 0.00

Page 21
 Data

HSUPA SCC HHO SCC, failures

Other Fails HSUPA SCC att HSUPA SCC SRInter-RNC SCC Att Inter-RNC SCC FR
M1008C221 RNC_929A RNC_918B M1008C243 RNC_1163A
1 2,080 97.79 0
1 2,134 99.11 0
2 2,062 88.75 0
0 2,173 97.42 0
1 2,457 93.98 0
1 2,344 94.37 0
0 1,947 96.51 0

Page 22
 Data

HHO SCC, failures

Inter-RNC SCC Fails Inter-RNC SCC DR Inter-RNC SCC Drops RT Succ, RT
M1008C245 RNC_1164A M1008C246 RNC_2719B M1006C186
0 0 0.30 15
0 0 0.49 37
0 0 0.44 16
0 0 0.09 3
0 0 0.40 24
0 0 0.26 19
0 0 0.49 18

Page 23
 Data

RRC
Fail UE, RT Fail NoR, RT CS term during re-est SR, RT NRT Succ, NRT
M1006C187 M1006C188 M1006C270 RNC_1295A RNC_2720B M1006C118
0 0 0 100.00 1.45 154
1 0 1 97.37 2.07 320
0 0 0 100.00 8.64 725
0 0 0 100.00 2.48 312
0 0 0 100.00 7.04 547
0 0 0 100.00 3.32 318
0 0 0 100.00 6.92 656

Page 24
 Data

RRC Conn re-establish

Fail UE, NRT Fail NoR, NRT SR, NRT Multi-RAB Succ, MR Fail UE, MR Fail NoR, MR
M1006C119 M1006C120 RNC_1294A RNC_2721B M1006C189 M1006C190 M1006C191
4 0 97.47 0.52 15 0 0
1 0 99.69 0.86 37 1 0
1 0 99.86 0.73 16 0 0
0 0 100.00 0.21 3 0 0
2 0 99.64 0.71 24 0 0
3 1 98.76 0.45 19 0 0
1 0 99.85 0.90 18 0 0

Page 25
 Data

SR, MR RL FAIL SRNC RNLCell Upd ATT RL, Fail Cell Upd ATT RLC, Fail Inactivity
RNC_1296A M1005C204 M1006C39 M1006C40 M1006C262
100.00 493 39 149 0
97.37 369 38 326 0
100.00 355 29 792 0
100.00 343 25 436 0
100.00 292 60 630 0
100.00 330 49 362 0
100.00 329 37 830 0

Page 26
 Data

RRC Conn r
CH type switch CS call release Prevented by timer Call re-establish attempts
M1006C263 M1006C291 M1006C264 M1001C58
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0

Page 27
 Data

RRC Conn release Lte redir

RRC conn release lte redirection in DCH LTE carrier not found for redirection
RRC_REL_LTE_REDIR_DCH LTE_NOT_FOUND_REDIR
0 0
0 0
0 0
0
0 0
0 0
0 0

Page 28
 Data

LTE redirection started after measurement Duration of LTE carrier measurement

LTE_REDIR_START_AFTER_MEAS DURATION_LTE_MEASUREMENT
0 0.00
0 0.00
0 0.00

0 0.00
0 0.00
0 0.00

Page 29
 Documentation

Report Title
NOP Report Release Version
RS Report Release Version
Report ID
Report Description
Start Time
End Time
Objects
Object Aggregation Level
Time Aggregation Level
Threshold
Sorting
Data Source
Advanced Filter

KPI ID
RNC_217f
RNC_334a
RNC_339b
RNC_2226a
RNC_340b
RNC_2227a
RNC_341b
RNC_2228a
RNC_342b
RNC_2229a
RNC_343b
RNC_2230a
RNC_345b
RNC_2231a
RNC_1069a
M1001C391
RNC_2015a
M1001C689
RNC_231d
RNC_232e
RNC_571c
RNC_390a
M1001C136
RNC_2008a
RNC_409d
RNC_2239a
RNC_410d
RNC_2240a
RNC_411d
RNC_2241a
RNC_412d
RNC_2242a

Page 30
 Documentation

RNC_414d
RNC_2243a
RNC_1070c
M1001C392
RNC_2010a
M1001C690
M1001C116
M1001C137
RNC_415b
RNC_1972b
M1001C155
RNC_1973b
M1001C156
RNC_1974b
M1001C157
RNC_1975b
M1001C158
RNC_1976b
M1001C160
RNC_1977b
M1001C393
RNC_2002a
M1001C691
RNC_1978a
RNC_1957a
RNC_2011a
RNC_1958b
RNC_1964a
RNC_1959b
RNC_1965a
RNC_1960b
RNC_1966a
RNC_1961b
RNC_1967a
RNC_1962b
RNC_1968a
RNC_1963b
RNC_1969a
RNC_2005a
RNC_2009a
RNC_2202a
RNC_2198a
RNC_2206a
RNC_922b
RNC_920b
RNC_921c
RNC_944c
RNC_2210a
RNC_1839a
RNC_2208a

Page 31
 Documentation

RNC_1840a
RNC_2204a
RNC_1841a
RNC_2200a
RNC_1842a
RNC_2196a
RNC_1843a
RNC_1100d
RNC_1844a
RNC_2664a
RNC_2666a
RNC_2660a
RNC_2676a
RNC_2659a
RNC_2678a
RNC_2661a
RNC_2680a
RNC_2662a
RNC_2682a
RNC_2663a
RNC_2669a
RNC_2671a
RNC_2012a
RNC_2675a
RNC_2013a
RNC_2673a
RNC_2014a
RNC_906a
RNC_1110a
M1008C217
RNC_1111a
M1008C218
RNC_1112a
M1008C219
RNC_1113a
M1008C220
RNC_1114a
M1008C221
RNC_929a
RNC_918b
M1008C243
RNC_1163a
M1008C245
RNC_1164a
M1008C246
RNC_2719b
M1006C186
M1006C187
M1006C188
M1006C270

Page 32
 Documentation

RNC_1295a
RNC_2720b
M1006C118
M1006C119
M1006C120
RNC_1294a
RNC_2721b
M1006C189
M1006C190
M1006C191
RNC_1296a
M1005C204
M1006C39
M1006C40
M1006C262
M1006C263
M1006C291
M1006C264
M1001C58
RRC_REL_LTE_REDIR_DCH
LTE_NOT_FOUND_REDIR
LTE_REDIR_START_AFTER_MEAS
DURATION_LTE_MEASUREMENT

Page 33
 Documentation

RSRAN079 - Service/Session Retainability Analysis

RSRAN WCDMA16
16.1.4-405
rsran_WCDMA16/reports/RSRAN079.xml
Service/Session Retainability Analysis
03.23.2018 00:00:00
03.30.2018 00:00:00
Level: RSRAN-WCEL; BDPC41D ('485633')
PLMN/RNC/WBTS/WCEL
day
none
null
pmrPool
none

KPI Alias KPI Title KPI Formul Unit

SR RRC Succes decode( (ser[%]
completions RRC Connec (servlev.rr [#]
IU FR RRC Active decode((serv[%]
IU fails RRC connecti
servlev.rrc_[#]
Radio FR RRC Activedecode((serv [%]
Radio Fails RRC connecti
servlev.rrc_[#]
BTS FR RRC Active decode((serv[%]
BTS Fails RRC connectservlev.rrc_[#]
IUR FR RRC Active decode((serv[%]
IUR Fails RRC connecti
servlev.rrc_[#]
CIPH FR RRC Active decode((serv[%]
CIPH Fails RRC connecti
servlev.rrc_[#]
RNC FR RRC Activedecode((serv [%]
RNC Fails RRC connectservlev.rrc_[#]
UE FR RRC Active decode((serv[%]
UE Fails RRC ACTIVservlev.rrc_[#]
Trans FR RRC Active 100*decode([%]
Trans Fails RRC ACTIV(servlev.rrc [#]
CS Voice SR RAB Success100 - 100*de[%]
CS Conv SR RAB Success100 - 100*d[%]
PS SR RAB retainab
100 - 100*de[%]
completions RAB setup aservlev.rab [#]
Succ completions RAB ACTIV(servlev.ra [#]
Total completions Amount CS (SERVLEV.ra
V [#]
IU FR RAB Active 100*decode([%]
IU Fails A number ofservlev.rab_[#]
Radio FR RAB Active 100*decode([%]
Radio Fails A number ofservlev.rab_[#]
BTS FR RAB Active 100*decode([%]
BTS Fails A number ofservlev.rab_[#]
IUR FR RAB Active 100*decode([%]
IUR Fails A number ofservlev.rab_[#]

Page 34
 Documentation

RNC FR RAB Active 100*decode([%]

RNC Fails A number ofservlev.rab_[#]
UE FR RAB Active 100*decode([%]
UE Fails RAB ACTIVservlev.rab [#]
Trans FR RAB Active 100*decode([%]
Trans Fails RAB ACTIV(servlev.rab[#]
completions RAB ACCES servlev.ra [#]
Succ Completions RAB ACTIVservlev.rab [#]
Total Completions RAB active (SERVLEV.ra [#]
Iu FR RAB Active 100*decode([%]
Iu Fails RAB ACTIVservlev.rab_[#]
Radio FR RAB Active 100*decode([%]
Radio Fails RAB ACTIVservlev.rab [#]
BTS FR RAB Active 100*decode([%]
BTS Fails RAB ACTIVservlev.rab [#]
Iur FR RAB Active 100*decode([%]
Iur Fails RAB ACTIVservlev.rab_[#]
RNC FR RAB Active 100*decode([%]
RNC Fails RAB ACTIVservlev.rab [#]
UE FR RAB Active 100*decode([%]
UE Fails RAB ACTIVservlev.rab [#]
Trans FR RAB Active 100*decode([%]
Trans Fails RAB ACTIV(servlev.rab[#]
Completions PS RAB setuservlev.rab [#]
Succ Completions RAB Active servlev.rab [#]
Total Completions Amount of P(SERVLEV.ra [#]
IU FR RAB Active 100*decode([%]
IU Fails RAB Active sFervlev.rab_[#]
Radio FR RAB Active 100*decode([%]
Radio Fails RAB Active servlev.rab_[#]
BTS FR RAB Active 100*decode([%]
BTS Fails RAB Active servlev.rab_[#]
IUR FR RAB Active 100*decode([%]
IUR Fails RAB Active sFervlev.rab_[#]
RNC FR RAB Active 100*decode([%]
RNC Fails RAB Active servlev.rab_[#]
UE FR RAB Active 100*decode([%]
UE Fails RAB Active servlev.rab_[#]
Trans FR RAB Active 100*decode([%]
Trans Fails RAB Active (SERVLEV.ra [#]
HS-DSCH/E-DCH HS-DSCH/E- (pktcall.ps_ [#]
HS-DSCH/DCH HS-DSCH/DC (pktcall.ps_ [#]
DCH/DCH DCH/DCH Pa (pktcall.ps_ [#]
SR Packet Sessdecode( (pkt[%]
HSDPA SR HSDPA Succedecode( (pkt[%]
HSUPA SR HSUPA Succe100 - 100*de [%]
R99 SR R99 Success100 - 100*de [%]
HS-DSCH/E-DCH DR, RL HS-DSCH/E-D100*decode([%]
HS-DSCH/E-DCH Drops, RL HS-DSCH/E-Dpktcall.ps_r [#]
HS-DSCH/DCH DR, RL HS-DSCH/DCH100*decode([%]

Page 35
 Documentation

HS-DSCH/DCH Drops,RL HS-DSCH/DCHpktcall.ps_r [#]

DCH/DCH DR, RL DCH/DCH Pac100*decode([%]
DCH/DCH Drops, RL DCH/DCH Pacpktcall.ps_r [#]
HS-DSCH/E-DCH DR, Other HS-DSCH/E-D100*decode([%]
HS-DSCH/E-DCH Drops, Other HS-DSCH/E-Dpktcall.ps_r [#]
HS-DSCH/DCH DR, Other HS-DSCH/DCH100*decode([%]
HS-DSCH/DCH Drops, Other HS-DSCH/DCHpktcall.ps_r [#]
DCH/DCH DR, Other DCH/DCH Pac100*decode([%]
DCH/DCH Drops, Other DCH/DCH Pacpktcall.ps_r [#]
Alloc rel HS-DSCH All(traffic.rel [#]
RL FR HS-DSCH Rel100*decode([%]
RL Fails HSDPA Radio(traffic.rel_ [#]
Non-RL FR HS-DSCH All100*decode([%]
Non-RL Fails HSDPA Non(traffic.rel
- [#]
Mobility FR HS-DSCH All100*decode([%]
Mobility Fails HS-DSCH rel(traffic.re [#]
Pre-emption FR HS-DSCH All100*decode([%]
Pre-emption Fails HS-DSCH re (traffic.rel [#]
Other than Mob FR HS-DSCH All100*decode([%]
Other than Mob Fails HS-DSCH to(traffic.rel [#]
Alloc rel E-DCH Alloc(traffic.rel [#]
RL FR E-DCH Relea100*decode([%] (
RL Fails E-DCH Rel (dTRAFFIC.rel [#]
E-DCH RelRate, HS-DSCH SCC E-DCH Rel 1d00*decode([%]
E-DCH Rel, HS-DSCH SCC E-DCH Rel (dTRAFFIC.re [#]
Other FR E-DCH RelRa100*decode([%]
Other Fails E-DCH Relea(TRAFFIC.rel [#]
Att HSDPA SCC( intsysho. [#]
UE SCC FR duedecode((int [%]
UE Fails HS-DSCH S(intsysho.s [#]
BTS SCC FR duedecode((int [%]
BTS Fails HS-DSCH S(intsysho.s [#]
Transp SCC FR dudecode((int [%]
Transp Fails HS-DSCH S(intsysho.s [#]
AC SCC FR duedecode((int [%]
AC Fails HS-DSCH S(intsysho.s [#]
Other SCC FR duedecode((int [%]
Other Fails HS-DSCH S(intsysho.s [#]
HSUPA SCC att HSUPA Serviintsysho.ed [#]
HSUPA SCC SR HSUPA Servidecode( (in [%]
Inter-RNC SCC Att INTER RNC(intsysho.i [#]
Inter-RNC SCC FR HSPA Inter-decode( (in [%]
Inter-RNC SCC Fails UNSUCCESS (intsysho.u [#]
Inter-RNC SCC DR HSPA Inter decode( (int[%]
Inter-RNC SCC Drops CONNECTIO (intsysho.i [#]
RT RRC re-estadecode( (( [#]
Succ, RT RRC RE-ES(rrc.rrc_re_ [#]
Fail UE, RT RRC RE-ES(rrc.rrc_re_ [#]
Fail NoR, RT RRC RE-ES(rrc.rrc_re_ [#]
CS term during re-est CS CALL T (rrc.cs_call [#]

Page 36
 Documentation

SR, RT RRC Re-estdecode( (rrc[%]

NRT RRC re-estadecode( (( [#]
Succ, NRT RRC RE-ES(rrc.rrc_re_ [#]
Fail UE, NRT RRC RE-ES(rrc.rrc_re_ [#]
Fail NoR, NRT RRC RE-ES(rrc.rrc_re_ [#]
SR, NRT RRC Re-estdecode( (rrc[%]
Multi-RAB RRC re-estadecode( ( [#]
Succ, MR RRC RE-ES(rrc.rrc_re [#]
Fail UE, MR RRC RE-ES(rrc.rrc_re_ [#]
Fail NoR, MR RRC RE-ES(rrc.rrc_re_ [#]
SR, MR RRC Re-estadecode( (rrc[%]
RL FAIL SRNC RNL RL FAIL O (l3iub.rl_fai [#]
Cell Upd ATT RL, Fail CELL UPDA(rrc.cell_upd[#]
Cell Upd ATT RLC, Fail CELL UPDA(rrc.cell_up [#]
Inactivity RRC CONN(rrc.rrc_rel_[#]
CH type switch RRC CONN(rrc.rrc_rel [#]
CS call release RRC CONN(rrc.rrc_rel_[#]
Prevented by timer LTE REDIR(rrc.lte_red [#]
Call re-establish attempts CALL RE E servlev.call [#]
RRC conn release lte redirection in DCH RRC_REL_L RRC.RRC_[#]
LTE carrier not found for redirection LTE_NOT_FINTERSHO[#]
LTE redirection started after measurement LTE_REDIRINTERSHO.[#]
Duration of LTE carrier measurement DURATION_INTERSHO[10ms]

Page 37
 Report Execution

Cache handler
Evaluation method
Init duration
Sql generation
Execution duration
Load from cache
Create tmp Tables
Drop tmp Tables
Load data db
Load data and write to cache

Start Time
2018-03-30 08:29:44.580

Page 38
 Report Execution

2018-03-30 08:29:44.635

Page 39
 Report Execution

2018-03-30 08:29:44.681

Page 40
 Report Execution

2018-03-30 08:29:44.756

Page 41
 Report Execution

2018-03-30 08:29:44.935

Page 42
 Report Execution

2018-03-30 08:29:45.26

Page 43
 Report Execution

2018-03-30 08:29:45.70

Page 44
 Report Execution

2018-03-30 08:29:45.240

Page 45
 Report Execution

2018-03-30 08:29:45.251

Page 46
 Report Execution

com.nokia.oss.qengine.support.CacheAwareEngine
tmp tables(1)
0.071
0.033
0.84
none
0.671
none
none
none

End Time Note Sql

2018-03-30 08:29:44.635 creating tmp table: jf_INTERSHO_3062159142
create global temporary table jf_INTER
select
a.period_start_time,
a.wcel_gid,
SUM(LTE_NOT_FOUND_REDIR) LTE
SUM(LTE_REDIR_START_AFTE
SUM(DURATION_LTE_MEASUR
from
(
select
trunc( p.period_start_time, 'dd' )
"rnc".co_gid rnc_gid,
"wbts".co_gid wbts_gid,
"wcel".co_gid wcel_gid,
SUM(LTE_NOT_FOUND_REDIR
SUM(LTE_REDIR_START_AFTE
SUM(DURATION_LTE_MEASUR
from

utp_common_objects "plmn",
utp_common_objects "rnc",
utp_common_objects "wbts",
utp_common_objects "wcel",
nokrww_ps_intersho_wcel_day p
where
"wcel".co_gid in ( '485633' )
and period_start_time >= to_dat
and period_start_time < to_date
and "plmn".co_oc_id = 16
and "rnc".co_gid = p.rnc_id
and "rnc".co_parent_gid = "plmn
and "rnc".co_oc_id = 811
and "wbts".co_gid = p.wbts_id
and "wbts".co_parent_gid = "rnc
and "wbts".co_oc_id = 812

Page 47
 Report Execution

and "wcel".co_gid = p.wcel_id

and "wcel".co_parent_gid = "wbt
and "wcel".co_oc_id = 813
group by
trunc( p.period_start_time, 'dd' ),
"rnc".co_gid,
"wbts".co_gid,
"wcel".co_gid
)a
group by
a.period_start_time,
a.wcel_gid
2018-03-30 08:29:44.681 creating tmp table: jf_L3IUB_3019096004
create global temporary table jf_L3IUB
select
a.period_start_time,
a.wcel_gid,
SUM(RL_FAIL_SRNC_RNL) RL_FAIL_
from
(
select
trunc( p.period_start_time, 'dd' )
"rnc".co_gid rnc_gid,
"wbts".co_gid wbts_gid,
"wcel".co_gid wcel_gid,
SUM(RL_FAIL_SRNC_RNL) RL
from

utp_common_objects "plmn",
utp_common_objects "rnc",
utp_common_objects "wbts",
utp_common_objects "wcel",
nokrww_ps_l3iub_wcel_day p
where
"wcel".co_gid in ( '485633' )
and period_start_time >= to_dat
and period_start_time < to_date
and "plmn".co_oc_id = 16
and "rnc".co_gid = p.rnc_id
and "rnc".co_parent_gid = "plmn
and "rnc".co_oc_id = 811
and "wbts".co_gid = p.wbts_id
and "wbts".co_parent_gid = "rnc
and "wbts".co_oc_id = 812
and "wcel".co_gid = p.wcel_id
and "wcel".co_parent_gid = "wbt
and "wcel".co_oc_id = 813
group by
trunc( p.period_start_time, 'dd' ),
"rnc".co_gid,

Page 48
 Report Execution

"wbts".co_gid,
"wcel".co_gid
)a
group by
a.period_start_time,
a.wcel_gid
2018-03-30 08:29:44.756 creating tmp table: jf_PKTCALL_3016743234
create global temporary table jf_PKTCA
select
a.period_start_time,
a.wcel_gid,
SUM(PS_SWI_HS_E_TO_HS_D_INT)
SUM(PS_SWI_HS_E_TO_HS_D_
SUM(PS_SWI_HS_E_TO_D_D_I
SUM(PS_SWI_HS_E_TO_D_D_B
SUM(PS_SWI_HS_D_TO_D_D_I
SUM(PS_SWI_HS_D_TO_D_D_B
SUM(PS_SWI_D_D_TO_HS_D_I
SUM(PS_SWI_D_D_TO_HS_D_B
SUM(PS_SWI_D_D_TO_HS_E_I
SUM(PS_SWI_D_D_TO_HS_E_B
SUM(PS_REL_NORM_HS_E_INT
SUM(PS_REL_NORM_HS_E_BG
SUM(PS_REL_NORM_HS_D_IN
SUM(PS_REL_NORM_HS_D_BG
SUM(PS_REL_NORM_D_D_INT)
SUM(PS_REL_NORM_D_D_BGR
SUM(PS_REL_RL_FAIL_HS_E_I
SUM(PS_REL_RL_FAIL_HS_E_B
SUM(PS_REL_RL_FAIL_HS_D_I
SUM(PS_REL_RL_FAIL_HS_D_B
SUM(PS_REL_RL_FAIL_D_D_IN
SUM(PS_REL_RL_FAIL_D_D_BG
SUM(PS_REL_OTH_FAIL_HS_E
SUM(PS_REL_OTH_FAIL_HS_E
SUM(PS_REL_OTH_FAIL_HS_D
SUM(PS_REL_OTH_FAIL_HS_D
SUM(PS_REL_OTH_FAIL_D_D_
SUM(PS_REL_OTH_FAIL_D_D_
SUM(PS_SWI_HS_E_TO_HS_D_
SUM(PS_SWI_HS_E_TO_D_D_S
SUM(PS_SWI_HS_D_TO_D_D_S
SUM(PS_SWI_D_D_TO_HS_D_S
SUM(PS_SWI_D_D_TO_HS_E_S
SUM(PS_REL_NORM_HS_E_ST
SUM(PS_REL_NORM_HS_D_ST
SUM(PS_REL_NORM_D_D_STR
SUM(PS_REL_RL_FAIL_HS_E_S
SUM(PS_REL_RL_FAIL_HS_D_S
SUM(PS_REL_RL_FAIL_D_D_ST

Page 49
Report Execution

SUM(PS_REL_OTH_FAIL_HS_E
SUM(PS_REL_OTH_FAIL_HS_D
SUM(PS_REL_OTH_FAIL_D_D_
from
(
select
trunc( p.period_start_time, 'dd' )
"rnc".co_gid rnc_gid,
"wbts".co_gid wbts_gid,
"wcel".co_gid wcel_gid,
SUM(PS_SWI_HS_E_TO_HS_D
SUM(PS_SWI_HS_E_TO_HS_D_
SUM(PS_SWI_HS_E_TO_D_D_I
SUM(PS_SWI_HS_E_TO_D_D_B
SUM(PS_SWI_HS_D_TO_D_D_I
SUM(PS_SWI_HS_D_TO_D_D_B
SUM(PS_SWI_D_D_TO_HS_D_I
SUM(PS_SWI_D_D_TO_HS_D_B
SUM(PS_SWI_D_D_TO_HS_E_I
SUM(PS_SWI_D_D_TO_HS_E_B
SUM(PS_REL_NORM_HS_E_INT
SUM(PS_REL_NORM_HS_E_BG
SUM(PS_REL_NORM_HS_D_IN
SUM(PS_REL_NORM_HS_D_BG
SUM(PS_REL_NORM_D_D_INT)
SUM(PS_REL_NORM_D_D_BGR
SUM(PS_REL_RL_FAIL_HS_E_I
SUM(PS_REL_RL_FAIL_HS_E_B
SUM(PS_REL_RL_FAIL_HS_D_I
SUM(PS_REL_RL_FAIL_HS_D_B
SUM(PS_REL_RL_FAIL_D_D_IN
SUM(PS_REL_RL_FAIL_D_D_BG
SUM(PS_REL_OTH_FAIL_HS_E
SUM(PS_REL_OTH_FAIL_HS_E
SUM(PS_REL_OTH_FAIL_HS_D
SUM(PS_REL_OTH_FAIL_HS_D
SUM(PS_REL_OTH_FAIL_D_D_
SUM(PS_REL_OTH_FAIL_D_D_
SUM(PS_SWI_HS_E_TO_HS_D_
SUM(PS_SWI_HS_E_TO_D_D_S
SUM(PS_SWI_HS_D_TO_D_D_S
SUM(PS_SWI_D_D_TO_HS_D_S
SUM(PS_SWI_D_D_TO_HS_E_S
SUM(PS_REL_NORM_HS_E_ST
SUM(PS_REL_NORM_HS_D_ST
SUM(PS_REL_NORM_D_D_STR
SUM(PS_REL_RL_FAIL_HS_E_S
SUM(PS_REL_RL_FAIL_HS_D_S
SUM(PS_REL_RL_FAIL_D_D_ST
SUM(PS_REL_OTH_FAIL_HS_E

Page 50
 Report Execution

SUM(PS_REL_OTH_FAIL_HS_D
SUM(PS_REL_OTH_FAIL_D_D_
from

utp_common_objects "plmn",
utp_common_objects "rnc",
utp_common_objects "wbts",
utp_common_objects "wcel",
nokrww_ps_pktcall_wcel_day p
where
"wcel".co_gid in ( '485633' )
and period_start_time >= to_dat
and period_start_time < to_date
and "plmn".co_oc_id = 16
and "rnc".co_gid = p.rnc_id
and "rnc".co_parent_gid = "plmn
and "rnc".co_oc_id = 811
and "wbts".co_gid = p.wbts_id
and "wbts".co_parent_gid = "rnc
and "wbts".co_oc_id = 812
and "wcel".co_gid = p.wcel_id
and "wcel".co_parent_gid = "wbt
and "wcel".co_oc_id = 813
group by
trunc( p.period_start_time, 'dd' ),
"rnc".co_gid,
"wbts".co_gid,
"wcel".co_gid
)a
group by
a.period_start_time,
a.wcel_gid
2018-03-30 08:29:44.935 creating tmp table: jf_SERVLEV_3086513947
create global temporary table jf_SERV
select
trunc( p.period_start_time, 'dd' )
"wcel".co_gid wcel_gid,
sum(rrc_conn_acc_comp) rnc_3
SUM(rrc_conn_acc_comp) rrc_co
SUM(rrc_conn_act_comp) rrc_co
SUM(rrc_conn_act_rel_srnc) rrc_
SUM(rrc_conn_act_rel_p_emp) rr
SUM(rrc_conn_act_fail_iu) rrc_co
SUM(rrc_conn_act_fail_radio) rrc
SUM(rrc_conn_act_fail_bts) rrc_c
SUM(rrc_conn_act_fail_iur) rrc_co
SUM(rrc_conn_act_fail_ciph) rrc_
SUM(rrc_conn_act_fail_rnc) rrc_c
SUM(call_re_estab_atts) call_re_
SUM(rab_acc_comp_cs_voice) ra

Page 51
Report Execution

SUM(rab_acc_comp_cs_conv) ra
SUM(rab_acc_comp_ps_strea) ra
SUM(rab_acc_comp_ps_inter) ra
SUM(rab_acc_comp_ps_backg) r
SUM(rab_act_comp_cs_voice) ra
SUM(rab_act_comp_cs_conv) rab
SUM(rab_act_comp_ps_strea) ra
SUM(rab_act_comp_ps_inter) rab
SUM(rab_act_comp_ps_backg) ra
SUM(rab_act_rel_cs_voice_srnc)
SUM(rab_act_rel_cs_voice_p_em
SUM(rab_act_fail_cs_voice_iu) ra
SUM(rab_act_fail_cs_voice_radio
SUM(rab_act_fail_cs_voice_bts) r
SUM(rab_act_fail_cs_voice_iur) r
SUM(rab_act_fail_cs_voice_rnc)
SUM(rab_act_rel_cs_conv_srnc)
SUM(rab_act_rel_cs_conv_p_em
SUM(rab_act_fail_cs_conv_iu) ra
SUM(rab_act_fail_cs_conv_radio
SUM(rab_act_fail_cs_conv_bts) r
SUM(rab_act_fail_cs_conv_iur) ra
SUM(rab_act_fail_cs_conv_rnc) r
SUM(rab_act_rel_ps_strea_srnc)
SUM(rab_act_rel_ps_strea_p_em
SUM(rab_act_rel_ps_inter_srnc)
SUM(rab_act_rel_ps_backg_srnc
SUM(rab_act_fail_ps_strea_iu) ra
SUM(rab_act_fail_ps_strea_radio
SUM(rab_act_fail_ps_strea_bts) r
SUM(rab_act_fail_ps_strea_iur) r
SUM(rab_act_fail_ps_strea_rnc) r
SUM(rab_act_fail_ps_inter_iu) rab
SUM(rab_act_fail_ps_inter_radio)
SUM(rab_act_fail_ps_inter_bts) ra
SUM(rab_act_fail_ps_inter_iur) ra
SUM(rab_act_fail_ps_inter_rnc) r
SUM(rab_act_fail_ps_backg_iu) r
SUM(rab_act_fail_ps_backg_radi
SUM(rab_act_fail_ps_backg_bts)
SUM(rab_act_fail_ps_backg_iur)
SUM(rab_act_fail_ps_backg_rnc)
SUM(RRC_CONN_ACT_FAIL_UE
SUM(RAB_ACT_FAIL_CS_VOICE
SUM(RAB_ACT_FAIL_CS_CONV
SUM(RAB_ACT_FAIL_PS_STRE
SUM(RAB_ACT_FAIL_PS_INTER
SUM(RAB_ACT_FAIL_PS_BACK
SUM(RRC_CONN_ACT_REL_IN
SUM(RRC_CONN_ACT_REL_GA

Page 52
 Report Execution

SUM(RRC_CONN_ACT_REL_HH
SUM(RRC_CONN_ACT_REL_IS
SUM(RAB_ACT_REL_CS_VOICE
SUM(RAB_ACT_REL_CS_CONV
SUM(RAB_ACT_REL_CS_VOICE
SUM(RAB_ACT_REL_CS_CONV
SUM(RAB_ACT_REL_CS_VOICE
SUM(RRC_CONN_ACT_FAIL_TR
SUM(RAB_ACT_FAIL_CS_VOICE
SUM(RAB_ACT_FAIL_CS_CONV
SUM(RAB_ACT_FAIL_PS_STRE
SUM(RAB_ACT_FAIL_PS_INTER
SUM(RAB_ACT_FAIL_PS_BACK
SUM(RAB_ACC_COMP_AMR_P
SUM(RAB_ACT_REL_PS_INTER
SUM(RAB_ACT_REL_PS_BACK
SUM(RAB_ACT_REL_PS_INTER
SUM(RAB_ACT_REL_PS_BGR_
SUM(RAB_ACT_REL_PS_STRE
SUM(RAB_ACT_REL_PS_STRE
from

utp_common_objects "plmn",
utp_common_objects "rnc",
utp_common_objects "wbts",
utp_common_objects "wcel",
nokrww_ps_servlev_wcel_day p
where
"wcel".co_gid in ( '485633' )
and period_start_time >= to_dat
and period_start_time < to_date
and "plmn".co_oc_id = 16
and "rnc".co_gid = p.rnc_id
and "rnc".co_parent_gid = "plmn
and "rnc".co_oc_id = 811
and "wbts".co_gid = p.wbts_id
and "wbts".co_parent_gid = "rnc
and "wbts".co_oc_id = 812
and "wcel".co_gid = p.wcel_id
and "wcel".co_parent_gid = "wbt
and "wcel".co_oc_id = 813
group by
trunc( p.period_start_time, 'dd' ),
"wcel".co_gid
2018-03-30 08:29:45.26 creating tmp table: jf_INTSYSHO_3080758564
create global temporary table jf_INTSY
select
trunc( p.period_start_time, 'dd' )
"wcel".co_gid wcel_gid,
sum(scc_started_cpich_ecno+sc

Page 53
 Report Execution

SUM(SCC_STARTED_CPICH_EC
SUM(SCC_STARTED_UL_SIR_E
SUM(SCC_STARTED_ACTIVE_S
SUM(SCC_STARTED_OTHER_R
SUM(SCC_FAILED_DUE_TO_UE
SUM(SCC_FAILED_DUE_TO_BT
SUM(SCC_FAILED_DUE_TO_TR
SUM(SCC_FAILED_DUE_TO_AC
SUM(SCC_FAILED_DUE_TO_OT
SUM(EDCH_SCC_STARTED) ED
SUM(EDCH_SCC_INTRA_BTS_S
SUM(EDCH_SCC_INTER_BTS_S
SUM(INTER_RNC_HHO_ATT_HS
SUM(UNSUCC_INTER_RNC_HH
SUM(INTER_RNC_HHO_DROP_
from

utp_common_objects "plmn",
utp_common_objects "rnc",
utp_common_objects "wbts",
utp_common_objects "wcel",
nokrww_ps_intsysho_wcel_day
where
"wcel".co_gid in ( '485633' )
and period_start_time >= to_dat
and period_start_time < to_date
and "plmn".co_oc_id = 16
and "rnc".co_gid = p.rnc_id
and "rnc".co_parent_gid = "plmn
and "rnc".co_oc_id = 811
and "wbts".co_gid = p.wbts_id
and "wbts".co_parent_gid = "rnc
and "wbts".co_oc_id = 812
and "wcel".co_gid = p.wcel_id
and "wcel".co_parent_gid = "wbt
and "wcel".co_oc_id = 813
group by
trunc( p.period_start_time, 'dd' ),
"wcel".co_gid
2018-03-30 08:29:45.70 creating tmp table: jf_RRC_307295514
create global temporary table jf_RRC_
select
a.period_start_time,
a.wcel_gid,
SUM(cell_update_att_r_link_fail) cell_u
SUM(cell_update_att_rlc_err) cell
SUM(RRC_RE_EST_SUCC_NRT
SUM(RRC_RE_EST_FAIL_UE_N
SUM(RRC_RE_EST_FAIL_NORE
SUM(RRC_RE_EST_SUCC_RT)

Page 54
Report Execution

SUM(RRC_RE_EST_FAIL_UE_R
SUM(RRC_RE_EST_FAIL_NORE
SUM(RRC_RE_EST_SUCC_MR)
SUM(RRC_RE_EST_FAIL_UE_M
SUM(RRC_RE_EST_FAIL_NORE
SUM(RRC_REL_LTE_REDIR_IN
SUM(RRC_REL_LTE_REDIR_CH
SUM(LTE_REDIR_PREV_TIMER
SUM(CS_CALL_TERM_RE_EST
SUM(RRC_REL_LTE_REDIR_CS
SUM(RRC_REL_LTE_REDIR_DC
from
(
select
trunc( p.period_start_time, 'dd' )
"rnc".co_gid rnc_gid,
"wbts".co_gid wbts_gid,
"wcel".co_gid wcel_gid,
SUM(cell_update_att_r_link_fail)
SUM(cell_update_att_rlc_err) cell
SUM(RRC_RE_EST_SUCC_NRT
SUM(RRC_RE_EST_FAIL_UE_N
SUM(RRC_RE_EST_FAIL_NORE
SUM(RRC_RE_EST_SUCC_RT)
SUM(RRC_RE_EST_FAIL_UE_R
SUM(RRC_RE_EST_FAIL_NORE
SUM(RRC_RE_EST_SUCC_MR)
SUM(RRC_RE_EST_FAIL_UE_M
SUM(RRC_RE_EST_FAIL_NORE
SUM(RRC_REL_LTE_REDIR_IN
SUM(RRC_REL_LTE_REDIR_CH
SUM(LTE_REDIR_PREV_TIMER
SUM(CS_CALL_TERM_RE_EST
SUM(RRC_REL_LTE_REDIR_CS
SUM(RRC_REL_LTE_REDIR_DC
from

utp_common_objects "plmn",
utp_common_objects "rnc",
utp_common_objects "wbts",
utp_common_objects "wcel",
nokrww_ps_rrc_wcel_day p
where
"wcel".co_gid in ( '485633' )
and period_start_time >= to_dat
and period_start_time < to_date
and "plmn".co_oc_id = 16
and "rnc".co_gid = p.rnc_id
and "rnc".co_parent_gid = "plmn
and "rnc".co_oc_id = 811

Page 55
 Report Execution

and "wbts".co_gid = p.wbts_id

and "wbts".co_parent_gid = "rnc
and "wbts".co_oc_id = 812
and "wcel".co_gid = p.wcel_id
and "wcel".co_parent_gid = "wbt
and "wcel".co_oc_id = 813
group by
trunc( p.period_start_time, 'dd' ),
"rnc".co_gid,
"wbts".co_gid,
"wcel".co_gid
)a
group by
a.period_start_time,
a.wcel_gid
2018-03-30 08:29:45.240 creating tmp table: jf_TRAFFIC_3023811760
create global temporary table jf_TRAFF
select
a.period_start_time,
a.wcel_gid,
SUM(REL_ALLO_NORM_HS_DSCH_
SUM(REL_ALLO_OTH_FAIL_HS
SUM(REL_ALLO_HS_DSCH_MO
SUM(REL_ALLO_NORM_HS_DS
SUM(REL_ALLO_OTH_FAIL_HS
SUM(REL_ALLO_HS_DSCH_MO
SUM(REL_ALLO_HS_DSCH_OT
SUM(REL_ALLO_HS_DSCH_PR
SUM(REL_ALLO_RL_FAIL_HS_D
SUM(REL_ALLO_HS_DSCH_OT
SUM(REL_ALLO_HS_DSCH_PR
SUM(REL_ALLO_RL_FAIL_HS_D
SUM(REL_EDCH_NORM_INT) R
SUM(REL_EDCH_NORM_BGR)
SUM(REL_EDCH_HSDSCH_SCC
SUM(REL_EDCH_HSDSCH_SCC
SUM(REL_EDCH_RL_FAIL_INT)
SUM(REL_EDCH_RL_FAIL_BGR
SUM(REL_EDCH_OTHER_FAIL_
SUM(REL_EDCH_OTHER_FAIL_
SUM(REL_ALLO_NORM_HS_DS
SUM(REL_ALLO_OTH_FAIL_HS
SUM(REL_ALLO_HS_DSCH_MO
SUM(REL_ALLO_HS_DSCH_OT
SUM(REL_ALLO_HS_DSCH_PR
SUM(REL_ALLO_RL_FAIL_HS_D
SUM(REL_EDCH_NORM_STR) R
SUM(REL_EDCH_HSDSCH_SCC
SUM(REL_EDCH_RL_FAIL_STR
SUM(REL_EDCH_OTHER_FAIL_

Page 56
Report Execution

from
(
select
trunc( p.period_start_time, 'dd' )
"rnc".co_gid rnc_gid,
"wbts".co_gid wbts_gid,
"wcel".co_gid wcel_gid,
SUM(REL_ALLO_NORM_HS_D
SUM(REL_ALLO_OTH_FAIL_HS
SUM(REL_ALLO_HS_DSCH_MO
SUM(REL_ALLO_NORM_HS_DS
SUM(REL_ALLO_OTH_FAIL_HS
SUM(REL_ALLO_HS_DSCH_MO
SUM(REL_ALLO_HS_DSCH_OT
SUM(REL_ALLO_HS_DSCH_PR
SUM(REL_ALLO_RL_FAIL_HS_D
SUM(REL_ALLO_HS_DSCH_OT
SUM(REL_ALLO_HS_DSCH_PR
SUM(REL_ALLO_RL_FAIL_HS_D
SUM(REL_EDCH_NORM_INT) R
SUM(REL_EDCH_NORM_BGR)
SUM(REL_EDCH_HSDSCH_SCC
SUM(REL_EDCH_HSDSCH_SCC
SUM(REL_EDCH_RL_FAIL_INT)
SUM(REL_EDCH_RL_FAIL_BGR
SUM(REL_EDCH_OTHER_FAIL_
SUM(REL_EDCH_OTHER_FAIL_
SUM(REL_ALLO_NORM_HS_DS
SUM(REL_ALLO_OTH_FAIL_HS
SUM(REL_ALLO_HS_DSCH_MO
SUM(REL_ALLO_HS_DSCH_OT
SUM(REL_ALLO_HS_DSCH_PR
SUM(REL_ALLO_RL_FAIL_HS_D
SUM(REL_EDCH_NORM_STR) R
SUM(REL_EDCH_HSDSCH_SCC
SUM(REL_EDCH_RL_FAIL_STR
SUM(REL_EDCH_OTHER_FAIL_
from

utp_common_objects "plmn",
utp_common_objects "rnc",
utp_common_objects "wbts",
utp_common_objects "wcel",
nokrww_ps_traffic_wcel_day p
where
"wcel".co_gid in ( '485633' )
and period_start_time >= to_dat
and period_start_time < to_date
and "plmn".co_oc_id = 16
and "rnc".co_gid = p.rnc_id

Page 57
 Report Execution

and "rnc".co_parent_gid = "plmn

and "rnc".co_oc_id = 811
and "wbts".co_gid = p.wbts_id
and "wbts".co_parent_gid = "rnc
and "wbts".co_oc_id = 812
and "wcel".co_gid = p.wcel_id
and "wcel".co_parent_gid = "wbt
and "wcel".co_oc_id = 813
group by
trunc( p.period_start_time, 'dd' ),
"rnc".co_gid,
"wbts".co_gid,
"wcel".co_gid
)a
group by
a.period_start_time,
a.wcel_gid
2018-03-30 08:29:45.251 creating tmp table: jf_ALLTABLES_3098631933
create global temporary table jf_ALLTA
select
period_start_time,
wcel_gid
from
(
(
select
period_start_time, TO_CHAR(wce
from
jf_INTERSHO_3062159142
)
UNION
(
select
period_start_time, TO_CHAR(wce
from
jf_INTSYSHO_3080758564
)
UNION
(
select
period_start_time, TO_CHAR(wce
from
jf_L3IUB_3019096004
)
UNION
(
select
period_start_time, TO_CHAR(wce
from
jf_PKTCALL_3016743234

Page 58
 Report Execution

)
UNION
(
select
period_start_time, TO_CHAR(wce
from
jf_RRC_307295514
)
UNION
(
select
period_start_time, TO_CHAR(wce
from
jf_SERVLEV_3086513947
)
UNION
(
select
period_start_time, TO_CHAR(wce
from
jf_TRAFFIC_3023811760
)
)p
2018-03-30 08:29:45.420 report from tmp tables
select
ALLTABLES.period_start_time pe
nvl("plmn".co_name, nvl("plmn".co
nvl("rnc".co_name, nvl("rnc".co_o
nvl("wbts".co_name, nvl("wbts".co
"wbts".co_object_instance "WBTS
nvl("wcel".co_name, nvl("wcel".co
"wcel".co_object_instance "WCEL
ALLTABLES.wcel_gid, nvl("wcel".c
to_number(decode( (servlev.rrc_c
to_number((servlev.rrc_conn_acc
to_number(decode((servlev.rnc_3
to_number(servlev.rrc_conn_act_
to_number(decode((servlev.rnc_3
to_number(servlev.rrc_conn_act_
to_number(decode((servlev.rnc_3
to_number(servlev.rrc_conn_act_
to_number(decode((servlev.rnc_3
to_number(servlev.rrc_conn_act_
to_number(decode((servlev.rnc_3
to_number(servlev.rrc_conn_act_
to_number(decode((servlev.rnc_3
to_number(servlev.rrc_conn_act_
to_number(decode((servlev.rnc_3
to_number(servlev.rrc_conn_act_
to_number(100*decode( ((SERVL

Page 59
Report Execution

to_number((servlev.rrc_conn_act_
to_number(100 - 100*decode( (se
to_number(100 - 100*decode( (se
to_number(100 - 100*decode( ((s
to_number(servlev.rab_acc_comp
to_number((servlev.rab_act_comp
to_number((SERVLEV.rab_act_co
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number((servlev.rab_act_fail_c
to_number(servlev.rab_acc_comp
to_number(servlev.rab_act_comp
to_number((SERVLEV.rab_act_co
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_cs
to_number(100*decode( ((SERVL
to_number((servlev.rab_act_fail_c
to_number(servlev.rab_acc_comp
to_number(servlev.rab_act_comp
to_number((SERVLEV.rab_act_co
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_p
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_p
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_p
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_p
to_number(100*decode( ((SERVL

Page 60
Report Execution

to_number(servlev.rab_act_fail_p
to_number(100*decode( ((SERVL
to_number(servlev.rab_act_fail_p
to_number(100*decode( ((SERVL
to_number((SERVLEV.rab_act_fa
to_number((pktcall.ps_rel_rl_fail_
to_number((pktcall.ps_rel_rl_fail_
to_number((pktcall.ps_rel_rl_fail_
to_number(decode( (pktcall.ps_re
to_number(decode( (pktcall.ps_re
to_number(100 - 100*decode( (pk
to_number(100 - 100*decode( (pk
to_number(100*decode( pktcall.p
to_number(pktcall.ps_rel_rl_fail_h
to_number(100*decode( pktcall.p
to_number(pktcall.ps_rel_rl_fail_h
to_number(100*decode( pktcall.p
to_number(pktcall.ps_rel_rl_fail_d
to_number(100*decode( pktcall.p
to_number(pktcall.ps_rel_oth_fail
to_number(100*decode( pktcall.p
to_number(pktcall.ps_rel_oth_fail
to_number(100*decode( pktcall.p
to_number(pktcall.ps_rel_oth_fail
to_number((traffic.rel_allo_norm_
to_number(100*decode( (traffic.re
to_number((traffic.rel_allo_rl_fail_
to_number(100*decode( (traffic.re
to_number((traffic.rel_allo_oth_fa
to_number(100*decode( (traffic.re
to_number((traffic.rel_allo_hs_dsc
to_number(100*decode( (traffic.re
to_number((traffic.rel_allo_hs_dsc
to_number(100*decode( (traffic.re
to_number((traffic.rel_allo_hs_dsc
to_number((traffic.rel_edch_norm
to_number(100*decode( (traffic.re
to_number((TRAFFIC.rel_edch_rl
to_number(100*decode( (traffic.re
to_number((TRAFFIC.rel_edch_h
to_number(100*decode( (traffic.re
to_number((TRAFFIC.rel_edch_o
to_number(( intsysho.scc_started
to_number(decode((intsysho.rnc_
to_number((intsysho.scc_failed_d
to_number(decode((intsysho.rnc_
to_number((intsysho.scc_failed_d
to_number(decode((intsysho.rnc_
to_number((intsysho.scc_failed_d
to_number(decode((intsysho.rnc_

Page 61
Report Execution

to_number((intsysho.scc_failed_d
to_number(decode((intsysho.rnc_
to_number((intsysho.scc_failed_d
to_number(intsysho.edch_scc_sta
to_number(decode( (intsysho.edc
to_number((intsysho.inter_rnc_hh
to_number(decode( (intsysho.inte
to_number((intsysho.unsucc_inte
to_number(decode( (intsysho.inte
to_number((intsysho.inter_rnc_hh
to_number(decode( ((SERVLEV.r
to_number((rrc.rrc_re_est_succ_r
to_number((rrc.rrc_re_est_fail_ue
to_number((rrc.rrc_re_est_fail_no
to_number((rrc.cs_call_term_re_e
to_number(decode( (rrc.rrc_re_es
to_number(decode( ((SERVLEV.r
to_number((rrc.rrc_re_est_succ_n
to_number((rrc.rrc_re_est_fail_ue
to_number((rrc.rrc_re_est_fail_no
to_number(decode( (rrc.rrc_re_es
to_number(decode( ((SERVLEV.R
to_number((rrc.rrc_re_est_succ_m
to_number((rrc.rrc_re_est_fail_ue
to_number((rrc.rrc_re_est_fail_no
to_number(decode( (rrc.rrc_re_es
to_number((l3iub.rl_fail_srnc_rnl))
to_number((rrc.cell_update_att_r_
to_number((rrc.cell_update_att_rl
to_number((rrc.rrc_rel_lte_redir_in
to_number((rrc.rrc_rel_lte_redir_c
to_number((rrc.rrc_rel_lte_redir_c
to_number((rrc.lte_redir_prev_tim
to_number(servlev.call_re_estab_
to_number(RRC.RRC_REL_LTE_
to_number(INTERSHO.LTE_NOT
to_number(INTERSHO.LTE_RED
to_number(INTERSHO.DURATIO
from
utp_common_objects "plmn",
utp_common_objects "rnc",
utp_common_objects "wbts",
utp_common_objects "wcel"
,
jf_ALLTABLES_3098631933 ALLTA
jf_INTERSHO_3062159142 INTER
jf_INTSYSHO_3080758564 INTSY
jf_L3IUB_3019096004 L3IUB,
jf_PKTCALL_3016743234 PKTCAL
jf_RRC_307295514 RRC,

Page 62
Report Execution

jf_SERVLEV_3086513947 SERVLE
jf_TRAFFIC_3023811760 TRAFFIC
where
"rnc".co_parent_gid = "plmn".co_g
"wbts".co_parent_gid = "rnc".co_g
"wcel".co_parent_gid = "wbts".co_
ALLTABLES.wcel_gid = "wcel".co_
and ALLTABLES.period_start_tim
and ALLTABLES.period_start_tim
and ALLTABLES.period_start_tim
and ALLTABLES.period_start_tim
and ALLTABLES.period_start_tim
and ALLTABLES.period_start_tim
and ALLTABLES.period_start_tim

order by
2,1,3,4,5

Page 63
 Report Execution

NTERSHO_3062159142
al temporary table jf_INTERSHO_3062159142 on commit preserve rows as

NOT_FOUND_REDIR) LTE_NOT_FOUND_REDIR,
TE_REDIR_START_AFTER_MEAS) LTE_REDIR_START_AFTER_MEAS,
DURATION_LTE_MEASUREMENT) DURATION_LTE_MEASUREMENT

( p.period_start_time, 'dd' ) period_start_time,

o_gid rnc_gid,
co_gid wbts_gid,
co_gid wcel_gid,
LTE_NOT_FOUND_REDIR) LTE_NOT_FOUND_REDIR,
TE_REDIR_START_AFTER_MEAS) LTE_REDIR_START_AFTER_MEAS,
DURATION_LTE_MEASUREMENT) DURATION_LTE_MEASUREMENT

common_objects "plmn",
common_objects "rnc",
common_objects "wbts",
common_objects "wcel",
ww_ps_intersho_wcel_day p

l".co_gid in ( '485633' )
eriod_start_time >= to_date('2018/03/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
eriod_start_time < to_date('2018/03/30 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
plmn".co_oc_id = 16
rnc".co_gid = p.rnc_id
rnc".co_parent_gid = "plmn".co_gid
rnc".co_oc_id = 811
wbts".co_gid = p.wbts_id
wbts".co_parent_gid = "rnc".co_gid
wbts".co_oc_id = 812

Page 64
 Report Execution

wcel".co_gid = p.wcel_id
wcel".co_parent_gid = "wbts".co_gid
wcel".co_oc_id = 813

( p.period_start_time, 'dd' ),

3IUB_3019096004
al temporary table jf_L3IUB_3019096004 on commit preserve rows as

AIL_SRNC_RNL) RL_FAIL_SRNC_RNL

( p.period_start_time, 'dd' ) period_start_time,

o_gid rnc_gid,
co_gid wbts_gid,
co_gid wcel_gid,
RL_FAIL_SRNC_RNL) RL_FAIL_SRNC_RNL

common_objects "plmn",
common_objects "rnc",
common_objects "wbts",
common_objects "wcel",
ww_ps_l3iub_wcel_day p

l".co_gid in ( '485633' )
eriod_start_time >= to_date('2018/03/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
eriod_start_time < to_date('2018/03/30 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
plmn".co_oc_id = 16
rnc".co_gid = p.rnc_id
rnc".co_parent_gid = "plmn".co_gid
rnc".co_oc_id = 811
wbts".co_gid = p.wbts_id
wbts".co_parent_gid = "rnc".co_gid
wbts".co_oc_id = 812
wcel".co_gid = p.wcel_id
wcel".co_parent_gid = "wbts".co_gid
wcel".co_oc_id = 813

( p.period_start_time, 'dd' ),

Page 65
 Report Execution

KTCALL_3016743234
al temporary table jf_PKTCALL_3016743234 on commit preserve rows as

WI_HS_E_TO_HS_D_INT) PS_SWI_HS_E_TO_HS_D_INT,
PS_SWI_HS_E_TO_HS_D_BGR) PS_SWI_HS_E_TO_HS_D_BGR,
PS_SWI_HS_E_TO_D_D_INT) PS_SWI_HS_E_TO_D_D_INT,
PS_SWI_HS_E_TO_D_D_BGR) PS_SWI_HS_E_TO_D_D_BGR,
PS_SWI_HS_D_TO_D_D_INT) PS_SWI_HS_D_TO_D_D_INT,
PS_SWI_HS_D_TO_D_D_BGR) PS_SWI_HS_D_TO_D_D_BGR,
PS_SWI_D_D_TO_HS_D_INT) PS_SWI_D_D_TO_HS_D_INT,
PS_SWI_D_D_TO_HS_D_BGR) PS_SWI_D_D_TO_HS_D_BGR,
PS_SWI_D_D_TO_HS_E_INT) PS_SWI_D_D_TO_HS_E_INT,
PS_SWI_D_D_TO_HS_E_BGR) PS_SWI_D_D_TO_HS_E_BGR,
PS_REL_NORM_HS_E_INT) PS_REL_NORM_HS_E_INT,
PS_REL_NORM_HS_E_BGR) PS_REL_NORM_HS_E_BGR,
PS_REL_NORM_HS_D_INT) PS_REL_NORM_HS_D_INT,
PS_REL_NORM_HS_D_BGR) PS_REL_NORM_HS_D_BGR,
PS_REL_NORM_D_D_INT) PS_REL_NORM_D_D_INT,
PS_REL_NORM_D_D_BGR) PS_REL_NORM_D_D_BGR,
PS_REL_RL_FAIL_HS_E_INT) PS_REL_RL_FAIL_HS_E_INT,
PS_REL_RL_FAIL_HS_E_BGR) PS_REL_RL_FAIL_HS_E_BGR,
PS_REL_RL_FAIL_HS_D_INT) PS_REL_RL_FAIL_HS_D_INT,
PS_REL_RL_FAIL_HS_D_BGR) PS_REL_RL_FAIL_HS_D_BGR,
PS_REL_RL_FAIL_D_D_INT) PS_REL_RL_FAIL_D_D_INT,
PS_REL_RL_FAIL_D_D_BGR) PS_REL_RL_FAIL_D_D_BGR,
PS_REL_OTH_FAIL_HS_E_INT) PS_REL_OTH_FAIL_HS_E_INT,
PS_REL_OTH_FAIL_HS_E_BGR) PS_REL_OTH_FAIL_HS_E_BGR,
PS_REL_OTH_FAIL_HS_D_INT) PS_REL_OTH_FAIL_HS_D_INT,
PS_REL_OTH_FAIL_HS_D_BGR) PS_REL_OTH_FAIL_HS_D_BGR,
PS_REL_OTH_FAIL_D_D_INT) PS_REL_OTH_FAIL_D_D_INT,
PS_REL_OTH_FAIL_D_D_BGR) PS_REL_OTH_FAIL_D_D_BGR,
PS_SWI_HS_E_TO_HS_D_STRE) PS_SWI_HS_E_TO_HS_D_STRE,
PS_SWI_HS_E_TO_D_D_STRE) PS_SWI_HS_E_TO_D_D_STRE,
PS_SWI_HS_D_TO_D_D_STRE) PS_SWI_HS_D_TO_D_D_STRE,
PS_SWI_D_D_TO_HS_D_STRE) PS_SWI_D_D_TO_HS_D_STRE,
PS_SWI_D_D_TO_HS_E_STRE) PS_SWI_D_D_TO_HS_E_STRE,
PS_REL_NORM_HS_E_STRE) PS_REL_NORM_HS_E_STRE,
PS_REL_NORM_HS_D_STRE) PS_REL_NORM_HS_D_STRE,
PS_REL_NORM_D_D_STRE) PS_REL_NORM_D_D_STRE,
PS_REL_RL_FAIL_HS_E_STRE) PS_REL_RL_FAIL_HS_E_STRE,
PS_REL_RL_FAIL_HS_D_STRE) PS_REL_RL_FAIL_HS_D_STRE,
PS_REL_RL_FAIL_D_D_STRE) PS_REL_RL_FAIL_D_D_STRE,

Page 66
 Report Execution

PS_REL_OTH_FAIL_HS_E_STRE) PS_REL_OTH_FAIL_HS_E_STRE,
PS_REL_OTH_FAIL_HS_D_STRE) PS_REL_OTH_FAIL_HS_D_STRE,
PS_REL_OTH_FAIL_D_D_STRE) PS_REL_OTH_FAIL_D_D_STRE

( p.period_start_time, 'dd' ) period_start_time,

o_gid rnc_gid,
co_gid wbts_gid,
co_gid wcel_gid,
PS_SWI_HS_E_TO_HS_D_INT) PS_SWI_HS_E_TO_HS_D_INT,
PS_SWI_HS_E_TO_HS_D_BGR) PS_SWI_HS_E_TO_HS_D_BGR,
PS_SWI_HS_E_TO_D_D_INT) PS_SWI_HS_E_TO_D_D_INT,
PS_SWI_HS_E_TO_D_D_BGR) PS_SWI_HS_E_TO_D_D_BGR,
PS_SWI_HS_D_TO_D_D_INT) PS_SWI_HS_D_TO_D_D_INT,
PS_SWI_HS_D_TO_D_D_BGR) PS_SWI_HS_D_TO_D_D_BGR,
PS_SWI_D_D_TO_HS_D_INT) PS_SWI_D_D_TO_HS_D_INT,
PS_SWI_D_D_TO_HS_D_BGR) PS_SWI_D_D_TO_HS_D_BGR,
PS_SWI_D_D_TO_HS_E_INT) PS_SWI_D_D_TO_HS_E_INT,
PS_SWI_D_D_TO_HS_E_BGR) PS_SWI_D_D_TO_HS_E_BGR,
PS_REL_NORM_HS_E_INT) PS_REL_NORM_HS_E_INT,
PS_REL_NORM_HS_E_BGR) PS_REL_NORM_HS_E_BGR,
PS_REL_NORM_HS_D_INT) PS_REL_NORM_HS_D_INT,
PS_REL_NORM_HS_D_BGR) PS_REL_NORM_HS_D_BGR,
PS_REL_NORM_D_D_INT) PS_REL_NORM_D_D_INT,
PS_REL_NORM_D_D_BGR) PS_REL_NORM_D_D_BGR,
PS_REL_RL_FAIL_HS_E_INT) PS_REL_RL_FAIL_HS_E_INT,
PS_REL_RL_FAIL_HS_E_BGR) PS_REL_RL_FAIL_HS_E_BGR,
PS_REL_RL_FAIL_HS_D_INT) PS_REL_RL_FAIL_HS_D_INT,
PS_REL_RL_FAIL_HS_D_BGR) PS_REL_RL_FAIL_HS_D_BGR,
PS_REL_RL_FAIL_D_D_INT) PS_REL_RL_FAIL_D_D_INT,
PS_REL_RL_FAIL_D_D_BGR) PS_REL_RL_FAIL_D_D_BGR,
PS_REL_OTH_FAIL_HS_E_INT) PS_REL_OTH_FAIL_HS_E_INT,
PS_REL_OTH_FAIL_HS_E_BGR) PS_REL_OTH_FAIL_HS_E_BGR,
PS_REL_OTH_FAIL_HS_D_INT) PS_REL_OTH_FAIL_HS_D_INT,
PS_REL_OTH_FAIL_HS_D_BGR) PS_REL_OTH_FAIL_HS_D_BGR,
PS_REL_OTH_FAIL_D_D_INT) PS_REL_OTH_FAIL_D_D_INT,
PS_REL_OTH_FAIL_D_D_BGR) PS_REL_OTH_FAIL_D_D_BGR,
PS_SWI_HS_E_TO_HS_D_STRE) PS_SWI_HS_E_TO_HS_D_STRE,
PS_SWI_HS_E_TO_D_D_STRE) PS_SWI_HS_E_TO_D_D_STRE,
PS_SWI_HS_D_TO_D_D_STRE) PS_SWI_HS_D_TO_D_D_STRE,
PS_SWI_D_D_TO_HS_D_STRE) PS_SWI_D_D_TO_HS_D_STRE,
PS_SWI_D_D_TO_HS_E_STRE) PS_SWI_D_D_TO_HS_E_STRE,
PS_REL_NORM_HS_E_STRE) PS_REL_NORM_HS_E_STRE,
PS_REL_NORM_HS_D_STRE) PS_REL_NORM_HS_D_STRE,
PS_REL_NORM_D_D_STRE) PS_REL_NORM_D_D_STRE,
PS_REL_RL_FAIL_HS_E_STRE) PS_REL_RL_FAIL_HS_E_STRE,
PS_REL_RL_FAIL_HS_D_STRE) PS_REL_RL_FAIL_HS_D_STRE,
PS_REL_RL_FAIL_D_D_STRE) PS_REL_RL_FAIL_D_D_STRE,
PS_REL_OTH_FAIL_HS_E_STRE) PS_REL_OTH_FAIL_HS_E_STRE,

Page 67
 Report Execution

PS_REL_OTH_FAIL_HS_D_STRE) PS_REL_OTH_FAIL_HS_D_STRE,
PS_REL_OTH_FAIL_D_D_STRE) PS_REL_OTH_FAIL_D_D_STRE

common_objects "plmn",
common_objects "rnc",
common_objects "wbts",
common_objects "wcel",
ww_ps_pktcall_wcel_day p

l".co_gid in ( '485633' )
eriod_start_time >= to_date('2018/03/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
eriod_start_time < to_date('2018/03/30 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
plmn".co_oc_id = 16
rnc".co_gid = p.rnc_id
rnc".co_parent_gid = "plmn".co_gid
rnc".co_oc_id = 811
wbts".co_gid = p.wbts_id
wbts".co_parent_gid = "rnc".co_gid
wbts".co_oc_id = 812
wcel".co_gid = p.wcel_id
wcel".co_parent_gid = "wbts".co_gid
wcel".co_oc_id = 813

( p.period_start_time, 'dd' ),

ERVLEV_3086513947
al temporary table jf_SERVLEV_3086513947 on commit preserve rows as

( p.period_start_time, 'dd' ) period_start_time,

co_gid wcel_gid,
rrc_conn_acc_comp) rnc_334a,
rc_conn_acc_comp) rrc_conn_acc_comp,
rc_conn_act_comp) rrc_conn_act_comp,
rc_conn_act_rel_srnc) rrc_conn_act_rel_srnc,
rc_conn_act_rel_p_emp) rrc_conn_act_rel_p_emp,
rc_conn_act_fail_iu) rrc_conn_act_fail_iu,
rc_conn_act_fail_radio) rrc_conn_act_fail_radio,
rc_conn_act_fail_bts) rrc_conn_act_fail_bts,
rc_conn_act_fail_iur) rrc_conn_act_fail_iur,
rc_conn_act_fail_ciph) rrc_conn_act_fail_ciph,
rc_conn_act_fail_rnc) rrc_conn_act_fail_rnc,
all_re_estab_atts) call_re_estab_atts,
ab_acc_comp_cs_voice) rab_acc_comp_cs_voice,

Page 68
 Report Execution

ab_acc_comp_cs_conv) rab_acc_comp_cs_conv,
ab_acc_comp_ps_strea) rab_acc_comp_ps_strea,
ab_acc_comp_ps_inter) rab_acc_comp_ps_inter,
ab_acc_comp_ps_backg) rab_acc_comp_ps_backg,
ab_act_comp_cs_voice) rab_act_comp_cs_voice,
ab_act_comp_cs_conv) rab_act_comp_cs_conv,
ab_act_comp_ps_strea) rab_act_comp_ps_strea,
ab_act_comp_ps_inter) rab_act_comp_ps_inter,
ab_act_comp_ps_backg) rab_act_comp_ps_backg,
ab_act_rel_cs_voice_srnc) rab_act_rel_cs_voice_srnc,
ab_act_rel_cs_voice_p_emp) rab_act_rel_cs_voice_p_emp,
ab_act_fail_cs_voice_iu) rab_act_fail_cs_voice_iu,
ab_act_fail_cs_voice_radio) rab_act_fail_cs_voice_radio,
ab_act_fail_cs_voice_bts) rab_act_fail_cs_voice_bts,
ab_act_fail_cs_voice_iur) rab_act_fail_cs_voice_iur,
ab_act_fail_cs_voice_rnc) rab_act_fail_cs_voice_rnc,
ab_act_rel_cs_conv_srnc) rab_act_rel_cs_conv_srnc,
ab_act_rel_cs_conv_p_emp) rab_act_rel_cs_conv_p_emp,
ab_act_fail_cs_conv_iu) rab_act_fail_cs_conv_iu,
ab_act_fail_cs_conv_radio) rab_act_fail_cs_conv_radio,
ab_act_fail_cs_conv_bts) rab_act_fail_cs_conv_bts,
ab_act_fail_cs_conv_iur) rab_act_fail_cs_conv_iur,
ab_act_fail_cs_conv_rnc) rab_act_fail_cs_conv_rnc,
ab_act_rel_ps_strea_srnc) rab_act_rel_ps_strea_srnc,
ab_act_rel_ps_strea_p_emp) rab_act_rel_ps_strea_p_emp,
ab_act_rel_ps_inter_srnc) rab_act_rel_ps_inter_srnc,
ab_act_rel_ps_backg_srnc) rab_act_rel_ps_backg_srnc,
ab_act_fail_ps_strea_iu) rab_act_fail_ps_strea_iu,
ab_act_fail_ps_strea_radio) rab_act_fail_ps_strea_radio,
ab_act_fail_ps_strea_bts) rab_act_fail_ps_strea_bts,
ab_act_fail_ps_strea_iur) rab_act_fail_ps_strea_iur,
ab_act_fail_ps_strea_rnc) rab_act_fail_ps_strea_rnc,
ab_act_fail_ps_inter_iu) rab_act_fail_ps_inter_iu,
ab_act_fail_ps_inter_radio) rab_act_fail_ps_inter_radio,
ab_act_fail_ps_inter_bts) rab_act_fail_ps_inter_bts,
ab_act_fail_ps_inter_iur) rab_act_fail_ps_inter_iur,
ab_act_fail_ps_inter_rnc) rab_act_fail_ps_inter_rnc,
ab_act_fail_ps_backg_iu) rab_act_fail_ps_backg_iu,
ab_act_fail_ps_backg_radio) rab_act_fail_ps_backg_radio,
ab_act_fail_ps_backg_bts) rab_act_fail_ps_backg_bts,
ab_act_fail_ps_backg_iur) rab_act_fail_ps_backg_iur,
ab_act_fail_ps_backg_rnc) rab_act_fail_ps_backg_rnc,
RRC_CONN_ACT_FAIL_UE) RRC_CONN_ACT_FAIL_UE,
RAB_ACT_FAIL_CS_VOICE_UE) RAB_ACT_FAIL_CS_VOICE_UE,
RAB_ACT_FAIL_CS_CONV_UE) RAB_ACT_FAIL_CS_CONV_UE,
RAB_ACT_FAIL_PS_STREA_UE) RAB_ACT_FAIL_PS_STREA_UE,
RAB_ACT_FAIL_PS_INTER_UE) RAB_ACT_FAIL_PS_INTER_UE,
RAB_ACT_FAIL_PS_BACKG_UE) RAB_ACT_FAIL_PS_BACKG_UE,
RRC_CONN_ACT_REL_INTRA_HHO) RRC_CONN_ACT_REL_INTRA_HHO,
RRC_CONN_ACT_REL_GANHO) RRC_CONN_ACT_REL_GANHO,

Page 69
 Report Execution

RRC_CONN_ACT_REL_HHO) RRC_CONN_ACT_REL_HHO,
RRC_CONN_ACT_REL_ISHO) RRC_CONN_ACT_REL_ISHO,
RAB_ACT_REL_CS_VOICE_HHO) RAB_ACT_REL_CS_VOICE_HHO,
RAB_ACT_REL_CS_CONV_HHO) RAB_ACT_REL_CS_CONV_HHO,
RAB_ACT_REL_CS_VOICE_ISHO) RAB_ACT_REL_CS_VOICE_ISHO,
RAB_ACT_REL_CS_CONV_ISHO) RAB_ACT_REL_CS_CONV_ISHO,
RAB_ACT_REL_CS_VOICE_GANHO) RAB_ACT_REL_CS_VOICE_GANHO,
RRC_CONN_ACT_FAIL_TRANS) RRC_CONN_ACT_FAIL_TRANS,
RAB_ACT_FAIL_CS_VOICE_TRANS) RAB_ACT_FAIL_CS_VOICE_TRANS,
RAB_ACT_FAIL_CS_CONV_TRANS) RAB_ACT_FAIL_CS_CONV_TRANS,
RAB_ACT_FAIL_PS_STREA_TRANS) RAB_ACT_FAIL_PS_STREA_TRANS,
RAB_ACT_FAIL_PS_INTER_TRANS) RAB_ACT_FAIL_PS_INTER_TRANS,
RAB_ACT_FAIL_PS_BACKG_TRANS) RAB_ACT_FAIL_PS_BACKG_TRANS,
RAB_ACC_COMP_AMR_PSNRT) RAB_ACC_COMP_AMR_PSNRT,
RAB_ACT_REL_PS_INTER_HHO) RAB_ACT_REL_PS_INTER_HHO,
RAB_ACT_REL_PS_BACKG_HHO) RAB_ACT_REL_PS_BACKG_HHO,
RAB_ACT_REL_PS_INTER_ISHO) RAB_ACT_REL_PS_INTER_ISHO,
RAB_ACT_REL_PS_BGR_ISHO) RAB_ACT_REL_PS_BGR_ISHO,
RAB_ACT_REL_PS_STREA_HHO) RAB_ACT_REL_PS_STREA_HHO,
RAB_ACT_REL_PS_STREA_ISHO) RAB_ACT_REL_PS_STREA_ISHO

common_objects "plmn",
common_objects "rnc",
common_objects "wbts",
common_objects "wcel",
ww_ps_servlev_wcel_day p

l".co_gid in ( '485633' )
eriod_start_time >= to_date('2018/03/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
eriod_start_time < to_date('2018/03/30 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
plmn".co_oc_id = 16
rnc".co_gid = p.rnc_id
rnc".co_parent_gid = "plmn".co_gid
rnc".co_oc_id = 811
wbts".co_gid = p.wbts_id
wbts".co_parent_gid = "rnc".co_gid
wbts".co_oc_id = 812
wcel".co_gid = p.wcel_id
wcel".co_parent_gid = "wbts".co_gid
wcel".co_oc_id = 813

( p.period_start_time, 'dd' ),

NTSYSHO_3080758564
al temporary table jf_INTSYSHO_3080758564 on commit preserve rows as

( p.period_start_time, 'dd' ) period_start_time,

co_gid wcel_gid,
scc_started_cpich_ecno+scc_started_ul_sir_error+scc_started_active_set_upd+scc_started_other_reason) rnc_906a,

Page 70
 Report Execution

SCC_STARTED_CPICH_ECNO) SCC_STARTED_CPICH_ECNO,
SCC_STARTED_UL_SIR_ERROR) SCC_STARTED_UL_SIR_ERROR,
SCC_STARTED_ACTIVE_SET_UPD) SCC_STARTED_ACTIVE_SET_UPD,
SCC_STARTED_OTHER_REASON) SCC_STARTED_OTHER_REASON,
SCC_FAILED_DUE_TO_UE) SCC_FAILED_DUE_TO_UE,
SCC_FAILED_DUE_TO_BTS) SCC_FAILED_DUE_TO_BTS,
SCC_FAILED_DUE_TO_TRANSM) SCC_FAILED_DUE_TO_TRANSM,
SCC_FAILED_DUE_TO_AC) SCC_FAILED_DUE_TO_AC,
SCC_FAILED_DUE_TO_OTHER) SCC_FAILED_DUE_TO_OTHER,
EDCH_SCC_STARTED) EDCH_SCC_STARTED,
EDCH_SCC_INTRA_BTS_SUCCESS) EDCH_SCC_INTRA_BTS_SUCCESS,
EDCH_SCC_INTER_BTS_SUCCESS) EDCH_SCC_INTER_BTS_SUCCESS,
NTER_RNC_HHO_ATT_HSPA_SCC) INTER_RNC_HHO_ATT_HSPA_SCC,
UNSUCC_INTER_RNC_HHO_SCC) UNSUCC_INTER_RNC_HHO_SCC,
NTER_RNC_HHO_DROP_SCC) INTER_RNC_HHO_DROP_SCC

common_objects "plmn",
common_objects "rnc",
common_objects "wbts",
common_objects "wcel",
ww_ps_intsysho_wcel_day p

l".co_gid in ( '485633' )
eriod_start_time >= to_date('2018/03/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
eriod_start_time < to_date('2018/03/30 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
plmn".co_oc_id = 16
rnc".co_gid = p.rnc_id
rnc".co_parent_gid = "plmn".co_gid
rnc".co_oc_id = 811
wbts".co_gid = p.wbts_id
wbts".co_parent_gid = "rnc".co_gid
wbts".co_oc_id = 812
wcel".co_gid = p.wcel_id
wcel".co_parent_gid = "wbts".co_gid
wcel".co_oc_id = 813

( p.period_start_time, 'dd' ),

RC_307295514
al temporary table jf_RRC_307295514 on commit preserve rows as

pdate_att_r_link_fail) cell_update_att_r_link_fail,
ell_update_att_rlc_err) cell_update_att_rlc_err,
RRC_RE_EST_SUCC_NRT) RRC_RE_EST_SUCC_NRT,
RRC_RE_EST_FAIL_UE_NRT) RRC_RE_EST_FAIL_UE_NRT,
RRC_RE_EST_FAIL_NOREPLY_NRT) RRC_RE_EST_FAIL_NOREPLY_NRT,
RRC_RE_EST_SUCC_RT) RRC_RE_EST_SUCC_RT,

Page 71
 Report Execution

RRC_RE_EST_FAIL_UE_RT) RRC_RE_EST_FAIL_UE_RT,
RRC_RE_EST_FAIL_NOREPLY_RT) RRC_RE_EST_FAIL_NOREPLY_RT,
RRC_RE_EST_SUCC_MR) RRC_RE_EST_SUCC_MR,
RRC_RE_EST_FAIL_UE_MR) RRC_RE_EST_FAIL_UE_MR,
RRC_RE_EST_FAIL_NOREPLY_MR) RRC_RE_EST_FAIL_NOREPLY_MR,
RRC_REL_LTE_REDIR_INACT) RRC_REL_LTE_REDIR_INACT,
RRC_REL_LTE_REDIR_CH_SWI) RRC_REL_LTE_REDIR_CH_SWI,
TE_REDIR_PREV_TIMER) LTE_REDIR_PREV_TIMER,
CS_CALL_TERM_RE_EST) CS_CALL_TERM_RE_EST,
RRC_REL_LTE_REDIR_CS_REL) RRC_REL_LTE_REDIR_CS_REL,
RRC_REL_LTE_REDIR_DCH) RRC_REL_LTE_REDIR_DCH

( p.period_start_time, 'dd' ) period_start_time,

o_gid rnc_gid,
co_gid wbts_gid,
co_gid wcel_gid,
cell_update_att_r_link_fail) cell_update_att_r_link_fail,
ell_update_att_rlc_err) cell_update_att_rlc_err,
RRC_RE_EST_SUCC_NRT) RRC_RE_EST_SUCC_NRT,
RRC_RE_EST_FAIL_UE_NRT) RRC_RE_EST_FAIL_UE_NRT,
RRC_RE_EST_FAIL_NOREPLY_NRT) RRC_RE_EST_FAIL_NOREPLY_NRT,
RRC_RE_EST_SUCC_RT) RRC_RE_EST_SUCC_RT,
RRC_RE_EST_FAIL_UE_RT) RRC_RE_EST_FAIL_UE_RT,
RRC_RE_EST_FAIL_NOREPLY_RT) RRC_RE_EST_FAIL_NOREPLY_RT,
RRC_RE_EST_SUCC_MR) RRC_RE_EST_SUCC_MR,
RRC_RE_EST_FAIL_UE_MR) RRC_RE_EST_FAIL_UE_MR,
RRC_RE_EST_FAIL_NOREPLY_MR) RRC_RE_EST_FAIL_NOREPLY_MR,
RRC_REL_LTE_REDIR_INACT) RRC_REL_LTE_REDIR_INACT,
RRC_REL_LTE_REDIR_CH_SWI) RRC_REL_LTE_REDIR_CH_SWI,
TE_REDIR_PREV_TIMER) LTE_REDIR_PREV_TIMER,
CS_CALL_TERM_RE_EST) CS_CALL_TERM_RE_EST,
RRC_REL_LTE_REDIR_CS_REL) RRC_REL_LTE_REDIR_CS_REL,
RRC_REL_LTE_REDIR_DCH) RRC_REL_LTE_REDIR_DCH

common_objects "plmn",
common_objects "rnc",
common_objects "wbts",
common_objects "wcel",
ww_ps_rrc_wcel_day p

l".co_gid in ( '485633' )
eriod_start_time >= to_date('2018/03/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
eriod_start_time < to_date('2018/03/30 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
plmn".co_oc_id = 16
rnc".co_gid = p.rnc_id
rnc".co_parent_gid = "plmn".co_gid
rnc".co_oc_id = 811

Page 72
 Report Execution

wbts".co_gid = p.wbts_id
wbts".co_parent_gid = "rnc".co_gid
wbts".co_oc_id = 812
wcel".co_gid = p.wcel_id
wcel".co_parent_gid = "wbts".co_gid
wcel".co_oc_id = 813

( p.period_start_time, 'dd' ),

RAFFIC_3023811760
al temporary table jf_TRAFFIC_3023811760 on commit preserve rows as

ALLO_NORM_HS_DSCH_INT) REL_ALLO_NORM_HS_DSCH_INT,
REL_ALLO_OTH_FAIL_HSDSCH_INT) REL_ALLO_OTH_FAIL_HSDSCH_INT,
REL_ALLO_HS_DSCH_MOB_DCH_INT) REL_ALLO_HS_DSCH_MOB_DCH_INT,
REL_ALLO_NORM_HS_DSCH_BGR) REL_ALLO_NORM_HS_DSCH_BGR,
REL_ALLO_OTH_FAIL_HSDSCH_BGR) REL_ALLO_OTH_FAIL_HSDSCH_BGR,
REL_ALLO_HS_DSCH_MOB_DCH_BGR) REL_ALLO_HS_DSCH_MOB_DCH_BGR,
REL_ALLO_HS_DSCH_OTH_DCH_INT) REL_ALLO_HS_DSCH_OTH_DCH_INT,
REL_ALLO_HS_DSCH_PRE_EMP_INT) REL_ALLO_HS_DSCH_PRE_EMP_INT,
REL_ALLO_RL_FAIL_HS_DSCH_INT) REL_ALLO_RL_FAIL_HS_DSCH_INT,
REL_ALLO_HS_DSCH_OTH_DCH_BGR) REL_ALLO_HS_DSCH_OTH_DCH_BGR,
REL_ALLO_HS_DSCH_PRE_EMP_BGR) REL_ALLO_HS_DSCH_PRE_EMP_BGR,
REL_ALLO_RL_FAIL_HS_DSCH_BGR) REL_ALLO_RL_FAIL_HS_DSCH_BGR,
REL_EDCH_NORM_INT) REL_EDCH_NORM_INT,
REL_EDCH_NORM_BGR) REL_EDCH_NORM_BGR,
REL_EDCH_HSDSCH_SCC_INT) REL_EDCH_HSDSCH_SCC_INT,
REL_EDCH_HSDSCH_SCC_BGR) REL_EDCH_HSDSCH_SCC_BGR,
REL_EDCH_RL_FAIL_INT) REL_EDCH_RL_FAIL_INT,
REL_EDCH_RL_FAIL_BGR) REL_EDCH_RL_FAIL_BGR,
REL_EDCH_OTHER_FAIL_INT) REL_EDCH_OTHER_FAIL_INT,
REL_EDCH_OTHER_FAIL_BGR) REL_EDCH_OTHER_FAIL_BGR,
REL_ALLO_NORM_HS_DSCH_STR) REL_ALLO_NORM_HS_DSCH_STR,
REL_ALLO_OTH_FAIL_HSDSCH_STR) REL_ALLO_OTH_FAIL_HSDSCH_STR,
REL_ALLO_HS_DSCH_MOB_DCH_STR) REL_ALLO_HS_DSCH_MOB_DCH_STR,
REL_ALLO_HS_DSCH_OTH_DCH_STR) REL_ALLO_HS_DSCH_OTH_DCH_STR,
REL_ALLO_HS_DSCH_PRE_EMP_STR) REL_ALLO_HS_DSCH_PRE_EMP_STR,
REL_ALLO_RL_FAIL_HS_DSCH_STR) REL_ALLO_RL_FAIL_HS_DSCH_STR,
REL_EDCH_NORM_STR) REL_EDCH_NORM_STR,
REL_EDCH_HSDSCH_SCC_STR) REL_EDCH_HSDSCH_SCC_STR,
REL_EDCH_RL_FAIL_STR) REL_EDCH_RL_FAIL_STR,
REL_EDCH_OTHER_FAIL_STR) REL_EDCH_OTHER_FAIL_STR

Page 73
 Report Execution

( p.period_start_time, 'dd' ) period_start_time,

o_gid rnc_gid,
co_gid wbts_gid,
co_gid wcel_gid,
REL_ALLO_NORM_HS_DSCH_INT) REL_ALLO_NORM_HS_DSCH_INT,
REL_ALLO_OTH_FAIL_HSDSCH_INT) REL_ALLO_OTH_FAIL_HSDSCH_INT,
REL_ALLO_HS_DSCH_MOB_DCH_INT) REL_ALLO_HS_DSCH_MOB_DCH_INT,
REL_ALLO_NORM_HS_DSCH_BGR) REL_ALLO_NORM_HS_DSCH_BGR,
REL_ALLO_OTH_FAIL_HSDSCH_BGR) REL_ALLO_OTH_FAIL_HSDSCH_BGR,
REL_ALLO_HS_DSCH_MOB_DCH_BGR) REL_ALLO_HS_DSCH_MOB_DCH_BGR,
REL_ALLO_HS_DSCH_OTH_DCH_INT) REL_ALLO_HS_DSCH_OTH_DCH_INT,
REL_ALLO_HS_DSCH_PRE_EMP_INT) REL_ALLO_HS_DSCH_PRE_EMP_INT,
REL_ALLO_RL_FAIL_HS_DSCH_INT) REL_ALLO_RL_FAIL_HS_DSCH_INT,
REL_ALLO_HS_DSCH_OTH_DCH_BGR) REL_ALLO_HS_DSCH_OTH_DCH_BGR,
REL_ALLO_HS_DSCH_PRE_EMP_BGR) REL_ALLO_HS_DSCH_PRE_EMP_BGR,
REL_ALLO_RL_FAIL_HS_DSCH_BGR) REL_ALLO_RL_FAIL_HS_DSCH_BGR,
REL_EDCH_NORM_INT) REL_EDCH_NORM_INT,
REL_EDCH_NORM_BGR) REL_EDCH_NORM_BGR,
REL_EDCH_HSDSCH_SCC_INT) REL_EDCH_HSDSCH_SCC_INT,
REL_EDCH_HSDSCH_SCC_BGR) REL_EDCH_HSDSCH_SCC_BGR,
REL_EDCH_RL_FAIL_INT) REL_EDCH_RL_FAIL_INT,
REL_EDCH_RL_FAIL_BGR) REL_EDCH_RL_FAIL_BGR,
REL_EDCH_OTHER_FAIL_INT) REL_EDCH_OTHER_FAIL_INT,
REL_EDCH_OTHER_FAIL_BGR) REL_EDCH_OTHER_FAIL_BGR,
REL_ALLO_NORM_HS_DSCH_STR) REL_ALLO_NORM_HS_DSCH_STR,
REL_ALLO_OTH_FAIL_HSDSCH_STR) REL_ALLO_OTH_FAIL_HSDSCH_STR,
REL_ALLO_HS_DSCH_MOB_DCH_STR) REL_ALLO_HS_DSCH_MOB_DCH_STR,
REL_ALLO_HS_DSCH_OTH_DCH_STR) REL_ALLO_HS_DSCH_OTH_DCH_STR,
REL_ALLO_HS_DSCH_PRE_EMP_STR) REL_ALLO_HS_DSCH_PRE_EMP_STR,
REL_ALLO_RL_FAIL_HS_DSCH_STR) REL_ALLO_RL_FAIL_HS_DSCH_STR,
REL_EDCH_NORM_STR) REL_EDCH_NORM_STR,
REL_EDCH_HSDSCH_SCC_STR) REL_EDCH_HSDSCH_SCC_STR,
REL_EDCH_RL_FAIL_STR) REL_EDCH_RL_FAIL_STR,
REL_EDCH_OTHER_FAIL_STR) REL_EDCH_OTHER_FAIL_STR

common_objects "plmn",
common_objects "rnc",
common_objects "wbts",
common_objects "wcel",
ww_ps_traffic_wcel_day p

l".co_gid in ( '485633' )
eriod_start_time >= to_date('2018/03/23 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
eriod_start_time < to_date('2018/03/30 00:00:00', 'yyyy/mm/dd hh24:mi:ss')
plmn".co_oc_id = 16
rnc".co_gid = p.rnc_id

Page 74
 Report Execution

rnc".co_parent_gid = "plmn".co_gid
rnc".co_oc_id = 811
wbts".co_gid = p.wbts_id
wbts".co_parent_gid = "rnc".co_gid
wbts".co_oc_id = 812
wcel".co_gid = p.wcel_id
wcel".co_parent_gid = "wbts".co_gid
wcel".co_oc_id = 813

( p.period_start_time, 'dd' ),

LLTABLES_3098631933
al temporary table jf_ALLTABLES_3098631933 on commit preserve rows as

_start_time, TO_CHAR(wcel_gid) wcel_gid

ERSHO_3062159142

_start_time, TO_CHAR(wcel_gid) wcel_gid

SYSHO_3080758564

_start_time, TO_CHAR(wcel_gid) wcel_gid

UB_3019096004

_start_time, TO_CHAR(wcel_gid) wcel_gid

CALL_3016743234

Page 75
 Report Execution

_start_time, TO_CHAR(wcel_gid) wcel_gid

C_307295514

_start_time, TO_CHAR(wcel_gid) wcel_gid

VLEV_3086513947

_start_time, TO_CHAR(wcel_gid) wcel_gid

FFIC_3023811760

BLES.period_start_time period_start_time,
mn".co_name, nvl("plmn".co_object_instance, 'NN('||"plmn".co_gid||')')) "PLMN name",
c".co_name, nvl("rnc".co_object_instance, 'NN('||"rnc".co_gid||')')) "RNC name",
bts".co_name, nvl("wbts".co_object_instance, 'NN('||"wbts".co_gid||')')) "WBTS name",
co_object_instance "WBTS ID",
cel".co_name, nvl("wcel".co_object_instance, 'NN('||"wcel".co_gid||')')) "WCEL name",
co_object_instance "WCEL ID",
BLES.wcel_gid, nvl("wcel".co_ext_dn, "wcel".co_dn) "DN",
mber(decode( (servlev.rrc_conn_act_comp + servlev.rrc_conn_act_rel_srnc + servlev.rrc_conn_act_rel_ganho + servlev.rrc_con
mber((servlev.rrc_conn_acc_comp)) RNC_334a,
mber(decode((servlev.rnc_334a),0,null,(100*(servlev.rrc_conn_act_fail_iu)/servlev.rnc_334a))) RNC_339b,
mber(servlev.rrc_conn_act_fail_iu) RNC_2226a,
mber(decode((servlev.rnc_334a),0,null,(100*(servlev.rrc_conn_act_fail_radio)/servlev.rnc_334a))) RNC_340b,
mber(servlev.rrc_conn_act_fail_radio) RNC_2227a,
mber(decode((servlev.rnc_334a),0,null,(100*(servlev.rrc_conn_act_fail_bts)/servlev.rnc_334a))) RNC_341b,
mber(servlev.rrc_conn_act_fail_bts) RNC_2228a,
mber(decode((servlev.rnc_334a),0,null,(100*(servlev.rrc_conn_act_fail_iur)/servlev.rnc_334a))) RNC_342b,
mber(servlev.rrc_conn_act_fail_iur) RNC_2229a,
mber(decode((servlev.rnc_334a),0,null,(100*(servlev.rrc_conn_act_fail_ciph)/servlev.rnc_334a))) RNC_343b,
mber(servlev.rrc_conn_act_fail_ciph) RNC_2230a,
mber(decode((servlev.rnc_334a),0,null,(100*(servlev.rrc_conn_act_fail_rnc)/servlev.rnc_334a))) RNC_345b,
mber(servlev.rrc_conn_act_fail_rnc) RNC_2231a,
mber(decode((servlev.rnc_334a),0,null,(100*(servlev.rrc_conn_act_fail_ue)/servlev.rnc_334a))) RNC_1069a,
mber(servlev.rrc_conn_act_fail_ue) M1001C391,
mber(100*decode( ((SERVLEV.rrc_conn_acc_comp)),0,null, ((servlev.rrc_conn_act_fail_trans)) / ((SERVLEV.rrc_conn_acc_com

Page 76
 Report Execution

mber((servlev.rrc_conn_act_fail_trans)) M1001C689,
mber(100 - 100*decode( (servlev.rab_act_comp_cs_voice + servlev.rab_act_rel_cs_voice_srnc + servlev.rab_act_rel_cs_voice_
mber(100 - 100*decode( (servlev.rab_act_comp_cs_conv + servlev.rab_act_rel_cs_conv_srnc + servlev.rab_act_rel_cs_conv_h
mber(100 - 100*decode( ((servlev.rab_act_comp_ps_strea + servlev.rab_act_comp_ps_backg + servlev.rab_act_comp_ps_inter
mber(servlev.rab_acc_comp_cs_voice) RNC_390a,
mber((servlev.rab_act_comp_cs_voice)) M1001C136,
mber((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_voice_p_emp +
mber(100*decode( ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_vo
mber(servlev.rab_act_fail_cs_voice_iu) RNC_2239a,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_vo
mber(servlev.rab_act_fail_cs_voice_radio) RNC_2240a,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_vo
mber(servlev.rab_act_fail_cs_voice_bts) RNC_2241a,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_vo
mber(servlev.rab_act_fail_cs_voice_iur) RNC_2242a,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_vo
mber(servlev.rab_act_fail_cs_voice_rnc) RNC_2243a,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_vo
mber(servlev.rab_act_fail_cs_voice_ue) M1001C392,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_vo
mber((servlev.rab_act_fail_cs_voice_trans)) M1001C690,
mber(servlev.rab_acc_comp_cs_conv) M1001C116,
mber(servlev.rab_act_comp_cs_conv) M1001C137,
mber((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_conv_p_emp + se
mber(100*decode( ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_con
mber(servlev.rab_act_fail_cs_conv_iu) M1001C155,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_con
mber(servlev.rab_act_fail_cs_conv_radio) M1001C156,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_con
mber(servlev.rab_act_fail_cs_conv_bts) M1001C157,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_con
mber(servlev.rab_act_fail_cs_conv_iur) M1001C158,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_con
mber(servlev.rab_act_fail_cs_conv_rnc) M1001C160,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_con
mber(servlev.rab_act_fail_cs_conv_ue) M1001C393,
mber(100*decode( ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_con
mber((servlev.rab_act_fail_cs_conv_trans)) M1001C691,
mber(servlev.rab_acc_comp_ps_strea + servlev.rab_acc_comp_ps_inter + servlev.rab_acc_comp_ps_backg) RNC_1978a,
mber(servlev.rab_act_comp_ps_backg + servlev.rab_act_comp_ps_inter + servlev.rab_act_comp_ps_strea) RNC_1957a,
mber((SERVLEV.rab_act_comp_ps_strea + SERVLEV.rab_act_comp_ps_backg + SERVLEV.rab_act_comp_ps_inter + SERVLE
mber(100*decode( ((SERVLEV.rab_act_comp_ps_strea + SERVLEV.rab_act_comp_ps_backg + SERVLEV.rab_act_comp_ps_i
mber(servlev.rab_act_fail_ps_strea_iu + servlev.rab_act_fail_ps_inter_iu + servlev.rab_act_fail_ps_backg_iu) RNC_1964a,
mber(100*decode( ((SERVLEV.rab_act_comp_ps_strea + SERVLEV.rab_act_comp_ps_backg + SERVLEV.rab_act_comp_ps_i
mber(servlev.rab_act_fail_ps_strea_radio + servlev.rab_act_fail_ps_inter_radio + servlev.rab_act_fail_ps_backg_radio) RNC_19
mber(100*decode( ((SERVLEV.rab_act_comp_ps_strea + SERVLEV.rab_act_comp_ps_backg + SERVLEV.rab_act_comp_ps_i
mber(servlev.rab_act_fail_ps_strea_bts + servlev.rab_act_fail_ps_inter_bts + servlev.rab_act_fail_ps_backg_bts) RNC_1966a,
mber(100*decode( ((SERVLEV.rab_act_comp_ps_strea + SERVLEV.rab_act_comp_ps_backg + SERVLEV.rab_act_comp_ps_i
mber(servlev.rab_act_fail_ps_strea_iur + servlev.rab_act_fail_ps_inter_iur + servlev.rab_act_fail_ps_backg_iur) RNC_1967a,
mber(100*decode( ((SERVLEV.rab_act_comp_ps_strea + SERVLEV.rab_act_comp_ps_backg + SERVLEV.rab_act_comp_ps_i

Page 77
 Report Execution

mber(servlev.rab_act_fail_ps_strea_rnc + servlev.rab_act_fail_ps_inter_rnc + servlev.rab_act_fail_ps_backg_rnc) RNC_1968a,

mber(100*decode( ((SERVLEV.rab_act_comp_ps_strea + SERVLEV.rab_act_comp_ps_backg + SERVLEV.rab_act_comp_ps_i
mber(servlev.rab_act_fail_ps_strea_ue + servlev.rab_act_fail_ps_inter_ue + servlev.rab_act_fail_ps_backg_ue) RNC_1969a,
mber(100*decode( ((SERVLEV.rab_act_comp_ps_strea + SERVLEV.rab_act_comp_ps_backg + SERVLEV.rab_act_comp_ps_i
mber((SERVLEV.rab_act_fail_ps_backg_trans + SERVLEV.rab_act_fail_ps_inter_trans + SERVLEV.rab_act_fail_ps_strea_trans
mber((pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_oth_fail
mber((pktcall.ps_rel_rl_fail_hs_d_int + pktcall.ps_rel_rl_fail_hs_d_bgr + pktcall.ps_rel_rl_fail_hs_d_stre + pktcall.ps_rel_oth_fail
mber((pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcall.ps_rel_rl_fail_d_d_stre + pktcall.ps_rel_oth_fail_d_
mber(decode( (pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_d_int + pktcall.ps_rel_
mber(decode( (pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel
mber(100 - 100*decode( (pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pkt
mber(100 - 100*decode( (pktcall.ps_rel_rl_fail_d_d_stre + pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcal
mber(100*decode( pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps
mber(pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_e_stre) RNC_1839a,
mber(100*decode( pktcall.ps_rel_rl_fail_hs_d_int + pktcall.ps_rel_rl_fail_hs_d_bgr + pktcall.ps_rel_rl_fail_hs_d_stre + pktcall.ps
mber(pktcall.ps_rel_rl_fail_hs_d_int + pktcall.ps_rel_rl_fail_hs_d_bgr + pktcall.ps_rel_rl_fail_hs_d_stre) RNC_1840a,
mber(100*decode( pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcall.ps_rel_rl_fail_d_d_stre + pktcall.ps_re
mber(pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcall.ps_rel_rl_fail_d_d_stre) RNC_1841a,
mber(100*decode( pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps
mber(pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre) RNC_1842a,
mber(100*decode( pktcall.ps_rel_rl_fail_hs_d_int + pktcall.ps_rel_rl_fail_hs_d_bgr + pktcall.ps_rel_rl_fail_hs_d_stre + pktcall.ps
mber(pktcall.ps_rel_oth_fail_hs_d_int + pktcall.ps_rel_oth_fail_hs_d_bgr + pktcall.ps_rel_oth_fail_hs_d_stre) RNC_1843a,
mber(100*decode( pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcall.ps_rel_rl_fail_d_d_stre + pktcall.ps_re
mber(pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_bgr + pktcall.ps_rel_oth_fail_d_d_stre) RNC_1844a,
mber((traffic.rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo
mber(100*decode( (traffic.rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str +
mber((traffic.rel_allo_rl_fail_hs_dsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr)) RNC_2660a
mber(100*decode( (traffic.rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str +
mber((traffic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr)) RNC_2659
mber(100*decode( (traffic.rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str +
mber((traffic.rel_allo_hs_dsch_mob_dch_str + traffic.rel_allo_hs_dsch_mob_dch_int + traffic.rel_allo_hs_dsch_mob_dch_bgr)) R
mber(100*decode( (traffic.rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str +
mber((traffic.rel_allo_hs_dsch_pre_emp_str + traffic.rel_allo_hs_dsch_pre_emp_int + traffic.rel_allo_hs_dsch_pre_emp_bgr)) R
mber(100*decode( (traffic.rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str +
mber((traffic.rel_allo_hs_dsch_oth_dch_str + traffic.rel_allo_hs_dsch_oth_dch_int + traffic.rel_allo_hs_dsch_oth_dch_bgr)) RNC
mber((traffic.rel_edch_norm_int + traffic.rel_edch_norm_bgr + traffic.rel_edch_norm_str + traffic.rel_edch_rl_fail_int + traffic.rel_
mber(100*decode( (traffic.rel_edch_norm_int + traffic.rel_edch_norm_bgr + traffic.rel_edch_norm_str + traffic.rel_edch_rl_fail_in
mber((TRAFFIC.rel_edch_rl_fail_int + TRAFFIC.rel_edch_rl_fail_bgr + traffic.rel_edch_rl_fail_str)) RNC_2012a,
mber(100*decode( (traffic.rel_edch_norm_int + traffic.rel_edch_norm_bgr + traffic.rel_edch_norm_str + traffic.rel_edch_rl_fail_in
mber((TRAFFIC.rel_edch_hsdsch_scc_int + TRAFFIC.rel_edch_hsdsch_scc_bgr + traffic.rel_edch_hsdsch_scc_str)) RNC_201
mber(100*decode( (traffic.rel_edch_norm_int + traffic.rel_edch_norm_bgr + traffic.rel_edch_norm_str + traffic.rel_edch_rl_fail_in
mber((TRAFFIC.rel_edch_other_fail_int + TRAFFIC.rel_edch_other_fail_bgr + traffic.rel_edch_other_fail_str)) RNC_2014a,
mber(( intsysho.scc_started_cpich_ecno + intsysho.scc_started_ul_sir_error + intsysho.scc_started_active_set_upd + intsysho.
mber(decode((intsysho.rnc_906a),0,null,(100*(intsysho.scc_failed_due_to_ue)/intsysho.rnc_906a))) RNC_1110a,
mber((intsysho.scc_failed_due_to_ue)) M1008C217,
mber(decode((intsysho.rnc_906a),0,null,(100*(intsysho.scc_failed_due_to_bts)/intsysho.rnc_906a))) RNC_1111a,
mber((intsysho.scc_failed_due_to_bts)) M1008C218,
mber(decode((intsysho.rnc_906a),0,null,(100*(intsysho.scc_failed_due_to_transm)/intsysho.rnc_906a))) RNC_1112a,
mber((intsysho.scc_failed_due_to_transm)) M1008C219,
mber(decode((intsysho.rnc_906a),0,null,(100*(intsysho.scc_failed_due_to_ac)/intsysho.rnc_906a))) RNC_1113a,

Page 78
 Report Execution

mber((intsysho.scc_failed_due_to_ac)) M1008C220,
mber(decode((intsysho.rnc_906a),0,null,(100*(intsysho.scc_failed_due_to_other)/intsysho.rnc_906a))) RNC_1114a,
mber((intsysho.scc_failed_due_to_other)) M1008C221,
mber(intsysho.edch_scc_started) RNC_929a,
mber(decode( (intsysho.edch_scc_started),0,null, (100*(intsysho.edch_scc_intra_bts_success + intsysho.edch_scc_inter_bts_s
mber((intsysho.inter_rnc_hho_att_hspa_scc)) M1008C243,
mber(decode( (intsysho.inter_rnc_hho_att_hspa_scc),0,null, (100*(intsysho.unsucc_inter_rnc_hho_scc) / (intsysho.inter_rnc_hh
mber((intsysho.unsucc_inter_rnc_hho_scc)) M1008C245,
mber(decode( (intsysho.inter_rnc_hho_att_hspa_scc),0,null, (100*(intsysho.inter_rnc_hho_drop_scc) / (intsysho.inter_rnc_hho_
mber((intsysho.inter_rnc_hho_drop_scc)) M1008C246,
mber(decode( ((SERVLEV.rab_acc_comp_cs_voice + SERVLEV.rab_acc_comp_cs_conv)),0,NULL,((RRC.RRC_RE_EST_SUC
mber((rrc.rrc_re_est_succ_rt)) M1006C186,
mber((rrc.rrc_re_est_fail_ue_rt)) M1006C187,
mber((rrc.rrc_re_est_fail_noreply_rt)) M1006C188,
mber((rrc.cs_call_term_re_est)) M1006C270,
mber(decode( (rrc.rrc_re_est_succ_rt + rrc.rrc_re_est_fail_ue_rt + rrc.rrc_re_est_fail_noreply_rt),0,null, (100*(rrc.rrc_re_est_suc
mber(decode( ((SERVLEV.rab_acc_comp_ps_strea + SERVLEV.rab_acc_comp_ps_inter + SERVLEV.rab_acc_comp_ps_backg
mber((rrc.rrc_re_est_succ_nrt)) M1006C118,
mber((rrc.rrc_re_est_fail_ue_nrt)) M1006C119,
mber((rrc.rrc_re_est_fail_noreply_nrt)) M1006C120,
mber(decode( (rrc.rrc_re_est_succ_nrt + rrc.rrc_re_est_fail_ue_nrt + rrc.rrc_re_est_fail_noreply_nrt),0,null, (100*(rrc.rrc_re_est_
mber(decode( ((SERVLEV.RAB_ACC_COMP_AMR_PSNRT)),0,NULL,((RRC.RRC_RE_EST_SUCC_MR + RRC.RRC_RE_EST
mber((rrc.rrc_re_est_succ_mr)) M1006C189,
mber((rrc.rrc_re_est_fail_ue_mr)) M1006C190,
mber((rrc.rrc_re_est_fail_noreply_mr)) M1006C191,
mber(decode( (rrc.rrc_re_est_succ_mr + rrc.rrc_re_est_fail_ue_mr + rrc.rrc_re_est_fail_noreply_mr),0,null, (100*(rrc.rrc_re_est_
mber((l3iub.rl_fail_srnc_rnl)) M1005C204,
mber((rrc.cell_update_att_r_link_fail)) M1006C39,
mber((rrc.cell_update_att_rlc_err)) M1006C40,
mber((rrc.rrc_rel_lte_redir_inact)) M1006C262,
mber((rrc.rrc_rel_lte_redir_ch_swi)) M1006C263,
mber((rrc.rrc_rel_lte_redir_cs_rel)) M1006C291,
mber((rrc.lte_redir_prev_timer)) M1006C264,
mber(servlev.call_re_estab_atts) M1001C58,
mber(RRC.RRC_REL_LTE_REDIR_DCH) RRC_REL_LTE_REDIR_DCH,
mber(INTERSHO.LTE_NOT_FOUND_REDIR) LTE_NOT_FOUND_REDIR,
mber(INTERSHO.LTE_REDIR_START_AFTER_MEAS) LTE_REDIR_START_AFTER_MEAS,
mber(INTERSHO.DURATION_LTE_MEASUREMENT) DURATION_LTE_MEASUREMENT

mmon_objects "plmn",
mmon_objects "rnc",
mmon_objects "wbts",
mmon_objects "wcel"

ABLES_3098631933 ALLTABLES,
RSHO_3062159142 INTERSHO,
YSHO_3080758564 INTSYSHO,
B_3019096004 L3IUB,
CALL_3016743234 PKTCALL,
_307295514 RRC,

Page 79
 Report Execution

VLEV_3086513947 SERVLEV,
FIC_3023811760 TRAFFIC

o_parent_gid = "plmn".co_gid and

co_parent_gid = "rnc".co_gid and
co_parent_gid = "wbts".co_gid and
BLES.wcel_gid = "wcel".co_gid
LTABLES.period_start_time = INTERSHO.period_start_time (+) and ALLTABLES.wcel_gid = INTERSHO.wcel_gid (+)
LTABLES.period_start_time = INTSYSHO.period_start_time (+) and ALLTABLES.wcel_gid = INTSYSHO.wcel_gid (+)
LTABLES.period_start_time = L3IUB.period_start_time (+) and ALLTABLES.wcel_gid = L3IUB.wcel_gid (+)
LTABLES.period_start_time = PKTCALL.period_start_time (+) and ALLTABLES.wcel_gid = PKTCALL.wcel_gid (+)
LTABLES.period_start_time = RRC.period_start_time (+) and ALLTABLES.wcel_gid = RRC.wcel_gid (+)
LTABLES.period_start_time = SERVLEV.period_start_time (+) and ALLTABLES.wcel_gid = SERVLEV.wcel_gid (+)
LTABLES.period_start_time = TRAFFIC.period_start_time (+) and ALLTABLES.wcel_gid = TRAFFIC.wcel_gid (+)

Page 80
 Report Execution

other_reason) rnc_906a,

Page 81
 Report Execution

_act_rel_ganho + servlev.rrc_conn_act_rel_hho + servlev.rrc_conn_act_rel_intra_hho + servlev.rrc_conn_act_rel_isho + servlev

RNC_339b,

))) RNC_340b,

) RNC_341b,

RNC_342b,

)) RNC_343b,

) RNC_345b,

RNC_1069a,

/ ((SERVLEV.rrc_conn_acc_comp)))) RNC_2015a,

Page 82
 Report Execution

+ servlev.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servlev.rab

+ servlev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + servlev.rab_act_rel_cs_conv_p_emp + servlev.rab_a
+ servlev.rab_act_comp_ps_inter + servlev.rab_act_rel_ps_strea_p_emp + servlev.rab_act_rel_ps_strea_srnc + servlev.rab_ac

.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_ganho + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_re

c + SERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servle

c + SERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servle

c + SERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servle

c + SERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servle

c + SERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servle

c + SERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servle

c + SERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servle

rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLEV.rab_act_fail_

c + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLE

c + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLE

c + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLE

c + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLE

c + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLE

c + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLE

c + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLE

mp_ps_backg) RNC_1978a,
mp_ps_strea) RNC_1957a,
ab_act_comp_ps_inter + SERVLEV.rab_act_rel_ps_strea_p_emp + SERVLEV.rab_act_rel_ps_strea_srnc + SERVLEV.rab_act
+ SERVLEV.rab_act_comp_ps_inter + SERVLEV.rab_act_rel_ps_strea_p_emp + SERVLEV.rab_act_rel_ps_strea_srnc + SER
_ps_backg_iu) RNC_1964a,
+ SERVLEV.rab_act_comp_ps_inter + SERVLEV.rab_act_rel_ps_strea_p_emp + SERVLEV.rab_act_rel_ps_strea_srnc + SER
ct_fail_ps_backg_radio) RNC_1965a,
+ SERVLEV.rab_act_comp_ps_inter + SERVLEV.rab_act_rel_ps_strea_p_emp + SERVLEV.rab_act_rel_ps_strea_srnc + SER
ail_ps_backg_bts) RNC_1966a,
+ SERVLEV.rab_act_comp_ps_inter + SERVLEV.rab_act_rel_ps_strea_p_emp + SERVLEV.rab_act_rel_ps_strea_srnc + SER
il_ps_backg_iur) RNC_1967a,
+ SERVLEV.rab_act_comp_ps_inter + SERVLEV.rab_act_rel_ps_strea_p_emp + SERVLEV.rab_act_rel_ps_strea_srnc + SER

Page 83
 Report Execution

ail_ps_backg_rnc) RNC_1968a,
+ SERVLEV.rab_act_comp_ps_inter + SERVLEV.rab_act_rel_ps_strea_p_emp + SERVLEV.rab_act_rel_ps_strea_srnc + SER
il_ps_backg_ue) RNC_1969a,
+ SERVLEV.rab_act_comp_ps_inter + SERVLEV.rab_act_rel_ps_strea_p_emp + SERVLEV.rab_act_rel_ps_strea_srnc + SER
VLEV.rab_act_fail_ps_strea_trans)) RNC_2009a,
s_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_r
s_d_stre + pktcall.ps_rel_oth_fail_hs_d_int + pktcall.ps_rel_oth_fail_hs_d_bgr + pktcall.ps_rel_oth_fail_hs_d_stre + pktcall.ps_r
_stre + pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_bgr + pktcall.ps_rel_oth_fail_d_d_stre + pktcall.ps_rel_nor
_rl_fail_hs_d_int + pktcall.ps_rel_rl_fail_hs_d_bgr + pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcall.ps_re
_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_d_stre + pktcall.ps_rel_rl_fail_hs_d_int + pktcall.ps_rel_rl_fail_hs_d_bgr + pktcall.p
call.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_
ll.ps_rel_rl_fail_d_d_bgr + pktcall.ps_rel_oth_fail_d_d_stre + pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_bgr +
_rel_rl_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre +
_e_stre) RNC_1839a,
_rel_rl_fail_hs_d_stre + pktcall.ps_rel_oth_fail_hs_d_int + pktcall.ps_rel_oth_fail_hs_d_bgr + pktcall.ps_rel_oth_fail_hs_d_stre +
_d_stre) RNC_1840a,
l_rl_fail_d_d_stre + pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_bgr + pktcall.ps_rel_oth_fail_d_d_stre + pktca
stre) RNC_1841a,
_rel_rl_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre +
ail_hs_e_stre) RNC_1842a,
_rel_rl_fail_hs_d_stre + pktcall.ps_rel_oth_fail_hs_d_int + pktcall.ps_rel_oth_fail_hs_d_bgr + pktcall.ps_rel_oth_fail_hs_d_stre +
ail_hs_d_stre) RNC_1843a,
l_rl_fail_d_d_stre + pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_bgr + pktcall.ps_rel_oth_fail_d_d_stre + pktca
_d_d_stre) RNC_1844a,
orm_hs_dsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_s
ffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_
_fail_hs_dsch_bgr)) RNC_2660a,
ffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_
oth_fail_hsdsch_bgr)) RNC_2659a,
ffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_
l_allo_hs_dsch_mob_dch_bgr)) RNC_2661a,
ffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_
_allo_hs_dsch_pre_emp_bgr)) RNC_2662a,
ffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_
allo_hs_dsch_oth_dch_bgr)) RNC_2663a,
c.rel_edch_rl_fail_int + traffic.rel_edch_rl_fail_bgr + traffic.rel_edch_rl_fail_str + traffic.rel_edch_other_fail_int + traffic.rel_edch_
rm_str + traffic.rel_edch_rl_fail_int + traffic.rel_edch_rl_fail_bgr + traffic.rel_edch_rl_fail_str + traffic.rel_edch_other_fail_int + tra
tr)) RNC_2012a,
rm_str + traffic.rel_edch_rl_fail_int + traffic.rel_edch_rl_fail_bgr + traffic.rel_edch_rl_fail_str + traffic.rel_edch_other_fail_int + tra
dch_hsdsch_scc_str)) RNC_2013a,
rm_str + traffic.rel_edch_rl_fail_int + traffic.rel_edch_rl_fail_bgr + traffic.rel_edch_rl_fail_str + traffic.rel_edch_other_fail_int + tra
other_fail_str)) RNC_2014a,
arted_active_set_upd + intsysho.scc_started_other_reason)) RNC_906a,
6a))) RNC_1110a,

06a))) RNC_1111a,

c_906a))) RNC_1112a,

6a))) RNC_1113a,

Page 84
 Report Execution

906a))) RNC_1114a,

+ intsysho.edch_scc_inter_bts_success) / (intsysho.edch_scc_started)))) RNC_918b,

hho_scc) / (intsysho.inter_rnc_hho_att_hspa_scc)))) RNC_1163a,

p_scc) / (intsysho.inter_rnc_hho_att_hspa_scc)))) RNC_1164a,

NULL,((RRC.RRC_RE_EST_SUCC_RT + RRC.RRC_RE_EST_FAIL_UE_RT + RRC.RRC_RE_EST_FAIL_NOREPLY_RT)) / ((

t),0,null, (100*(rrc.rrc_re_est_succ_rt) / (rrc.rrc_re_est_succ_rt + rrc.rrc_re_est_fail_ue_rt + rrc.rrc_re_est_fail_noreply_rt)))) RN

RVLEV.rab_acc_comp_ps_backg)),0,NULL,((RRC.RRC_RE_EST_SUCC_NRT + RRC.RRC_RE_EST_FAIL_UE_NRT + RRC.

y_nrt),0,null, (100*(rrc.rrc_re_est_succ_nrt) / (rrc.rrc_re_est_succ_nrt + rrc.rrc_re_est_fail_ue_nrt + rrc.rrc_re_est_fail_noreply_

SUCC_MR + RRC.RRC_RE_EST_FAIL_UE_MR + RRC.RRC_RE_EST_FAIL_NOREPLY_MR)) / ((SERVLEV.RAB_ACC_COM

y_mr),0,null, (100*(rrc.rrc_re_est_succ_mr) / (rrc.rrc_re_est_succ_mr + rrc.rrc_re_est_fail_ue_mr + rrc.rrc_re_est_fail_noreply_

Page 85
 Report Execution

NTERSHO.wcel_gid (+)
NTSYSHO.wcel_gid (+)
.wcel_gid (+)
KTCALL.wcel_gid (+)

ERVLEV.wcel_gid (+)
AFFIC.wcel_gid (+)

Page 86
 Report Execution

v.rrc_conn_act_rel_isho + servlev.rrc_conn_act_rel_p_emp + servlev.rrc_conn_act_fail_iu + servlev.rrc_conn_act_fail_radio + s

Page 87
 Report Execution

t_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + servlev.rab_act_fail_cs_voice_iu + servlev.rab_act_fail_cs_voice_

_cs_conv_p_emp + servlev.rab_act_fail_cs_conv_iu + servlev.rab_act_fail_cs_conv_radio + servlev.rab_act_fail_cs_conv_bts +
l_ps_strea_srnc + servlev.rab_act_rel_ps_backg_srnc + servlev.rab_act_rel_ps_inter_srnc + servlev.rab_act_rel_ps_strea_hho

s_voice_hho + servlev.rab_act_rel_cs_voice_isho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fail_cs_voice_iu

b_act_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fa

b_act_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fa

b_act_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fa

b_act_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fa

b_act_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fa

b_act_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fa

b_act_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fa

nv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_cs_conv_bts +

act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_

act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_

act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_

act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_

act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_

act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_

act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_

_strea_srnc + SERVLEV.rab_act_rel_ps_backg_srnc + SERVLEV.rab_act_rel_ps_inter_srnc + servlev.rab_act_rel_ps_strea_hh

ab_act_rel_ps_strea_srnc + SERVLEV.rab_act_rel_ps_backg_srnc + SERVLEV.rab_act_rel_ps_inter_srnc + servlev.rab_act_re

ab_act_rel_ps_strea_srnc + SERVLEV.rab_act_rel_ps_backg_srnc + SERVLEV.rab_act_rel_ps_inter_srnc + servlev.rab_act_re

ab_act_rel_ps_strea_srnc + SERVLEV.rab_act_rel_ps_backg_srnc + SERVLEV.rab_act_rel_ps_inter_srnc + servlev.rab_act_re

ab_act_rel_ps_strea_srnc + SERVLEV.rab_act_rel_ps_backg_srnc + SERVLEV.rab_act_rel_ps_inter_srnc + servlev.rab_act_re

ab_act_rel_ps_strea_srnc + SERVLEV.rab_act_rel_ps_backg_srnc + SERVLEV.rab_act_rel_ps_inter_srnc + servlev.rab_act_re

Page 88
 Report Execution

ab_act_rel_ps_strea_srnc + SERVLEV.rab_act_rel_ps_backg_srnc + SERVLEV.rab_act_rel_ps_inter_srnc + servlev.rab_act_re

ab_act_rel_ps_strea_srnc + SERVLEV.rab_act_rel_ps_backg_srnc + SERVLEV.rab_act_rel_ps_inter_srnc + servlev.rab_act_re

_oth_fail_hs_e_stre + pktcall.ps_rel_norm_hs_e_int + pktcall.ps_rel_norm_hs_e_bgr + pktcall.ps_rel_norm_hs_e_stre)) RNC_2

_oth_fail_hs_d_stre + pktcall.ps_rel_norm_hs_d_int + pktcall.ps_rel_norm_hs_d_bgr + pktcall.ps_rel_norm_hs_d_stre)) RNC_2
ail_d_d_stre + pktcall.ps_rel_norm_d_d_int + pktcall.ps_rel_norm_d_d_bgr + pktcall.ps_rel_norm_d_d_stre)) RNC_2206a,
el_rl_fail_d_d_bgr + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_d_int + pkt
s_rel_rl_fail_hs_d_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr
_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_norm_hs_e_stre + pktcall.ps_rel_norm_hs_e_int + pktcall.ps_rel_norm_
pktcall.ps_rel_oth_fail_d_d_bgr + pktcall.ps_rel_norm_d_d_stre + pktcall.ps_rel_norm_d_d_int + pktcall.ps_rel_norm_d_d_bgr
ktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_norm_hs_e_int + pktcall.ps_rel_norm_hs_e_bgr + pktcall.ps_rel_norm_hs_e_s

ktcall.ps_rel_oth_fail_hs_d_stre + pktcall.ps_rel_norm_hs_d_int + pktcall.ps_rel_norm_hs_d_bgr + pktcall.ps_rel_norm_hs_d_s

ps_rel_oth_fail_d_d_stre + pktcall.ps_rel_norm_d_d_int + pktcall.ps_rel_norm_d_d_bgr + pktcall.ps_rel_norm_d_d_stre,0,null,

ktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_norm_hs_e_int + pktcall.ps_rel_norm_hs_e_bgr + pktcall.ps_rel_norm_hs_e_s

ktcall.ps_rel_oth_fail_hs_d_stre + pktcall.ps_rel_norm_hs_d_int + pktcall.ps_rel_norm_hs_d_bgr + pktcall.ps_rel_norm_hs_d_s

ps_rel_oth_fail_d_d_stre + pktcall.ps_rel_norm_d_d_int + pktcall.ps_rel_norm_d_d_bgr + pktcall.ps_rel_norm_d_d_stre,0,null,

traffic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_

hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traf

hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traf

hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traf

hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traf

hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traf

_other_fail_int + traffic.rel_edch_other_fail_bgr + traffic.rel_edch_other_fail_str)) RNC_2669a,

raffic.rel_edch_other_fail_int + traffic.rel_edch_other_fail_bgr + traffic.rel_edch_other_fail_str),0,null, (traffic.rel_edch_rl_fail_int

raffic.rel_edch_other_fail_int + traffic.rel_edch_other_fail_bgr + traffic.rel_edch_other_fail_str),0,null, (traffic.rel_edch_hsdsch_s

raffic.rel_edch_other_fail_int + traffic.rel_edch_other_fail_bgr + traffic.rel_edch_other_fail_str),0,null, (traffic.rel_edch_other_fail

Page 89
 Report Execution

_EST_FAIL_NOREPLY_RT)) / ((SERVLEV.rab_acc_comp_cs_voice + SERVLEV.rab_acc_comp_cs_conv)))) RNC_2719b,

c.rrc_re_est_fail_noreply_rt)))) RNC_1295a,
RE_EST_FAIL_UE_NRT + RRC.RRC_RE_EST_FAIL_NOREPLY_NRT)) / ((SERVLEV.rab_acc_comp_ps_strea + SERVLEV.ra

nrt + rrc.rrc_re_est_fail_noreply_nrt)))) RNC_1294a,

R)) / ((SERVLEV.RAB_ACC_COMP_AMR_PSNRT)))) RNC_2721b,

mr + rrc.rrc_re_est_fail_noreply_mr)))) RNC_1296a,

Page 90
 Report Execution

ervlev.rrc_conn_act_fail_radio + servlev.rrc_conn_act_fail_bts + servlev.rrc_conn_act_fail_iur + servlev.rrc_conn_act_fail_rnc +

Page 91
 Report Execution

+ servlev.rab_act_fail_cs_voice_radio + servlev.rab_act_fail_cs_voice_bts + servlev.rab_act_fail_cs_voice_iur + servlev.rab_ac

ervlev.rab_act_fail_cs_conv_bts + servlev.rab_act_fail_cs_conv_rnc + servlev.rab_act_fail_cs_conv_iur + servlev.rab_act_fail_c
ervlev.rab_act_rel_ps_strea_hho + servlev.rab_act_rel_ps_backg_hho + servlev.rab_act_rel_ps_inter_hho + servlev.rab_act_re

RVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio + SERVLEV.r

voice_bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio

voice_bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio

voice_bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio

voice_bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio

voice_bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio

voice_bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio

voice_bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio

VLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + SERVLEV.rab_a

_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + S

_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + S

_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + S

_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + S

_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + S

_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + S

_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + S

+ servlev.rab_act_rel_ps_strea_hho + servlev.rab_act_rel_ps_backg_hho + servlev.rab_act_rel_ps_inter_hho + servlev.rab_act_

ps_inter_srnc + servlev.rab_act_rel_ps_strea_hho + servlev.rab_act_rel_ps_backg_hho + servlev.rab_act_rel_ps_inter_hho + se

ps_inter_srnc + servlev.rab_act_rel_ps_strea_hho + servlev.rab_act_rel_ps_backg_hho + servlev.rab_act_rel_ps_inter_hho + se

ps_inter_srnc + servlev.rab_act_rel_ps_strea_hho + servlev.rab_act_rel_ps_backg_hho + servlev.rab_act_rel_ps_inter_hho + se

ps_inter_srnc + servlev.rab_act_rel_ps_strea_hho + servlev.rab_act_rel_ps_backg_hho + servlev.rab_act_rel_ps_inter_hho + se

ps_inter_srnc + servlev.rab_act_rel_ps_strea_hho + servlev.rab_act_rel_ps_backg_hho + servlev.rab_act_rel_ps_inter_hho + se

Page 92
 Report Execution

ps_inter_srnc + servlev.rab_act_rel_ps_strea_hho + servlev.rab_act_rel_ps_backg_hho + servlev.rab_act_rel_ps_inter_hho + se

ps_inter_srnc + servlev.rab_act_rel_ps_strea_hho + servlev.rab_act_rel_ps_backg_hho + servlev.rab_act_rel_ps_inter_hho + se

ps_rel_norm_hs_e_stre)) RNC_2202a,
ps_rel_norm_hs_d_stre)) RNC_2198a,
orm_d_d_stre)) RNC_2206a,
all.ps_rel_oth_fail_hs_d_int + pktcall.ps_rel_oth_fail_hs_d_bgr + pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_b
pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_d_stre + pktcall.ps_rel_oth_fail_hs_d_int + pktcall.ps_rel_oth_fai
_hs_e_int + pktcall.ps_rel_norm_hs_e_bgr + pktcall.ps_swi_hs_e_to_d_d_stre + pktcall.ps_swi_hs_e_to_d_d_int + pktcall.ps_
t + pktcall.ps_rel_norm_d_d_bgr + pktcall.ps_swi_d_d_to_hs_e_bgr + pktcall.ps_swi_d_d_to_hs_e_int + pktcall.ps_swi_d_d_to
bgr + pktcall.ps_rel_norm_hs_e_stre,0,null, (pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_

bgr + pktcall.ps_rel_norm_hs_d_stre,0,null, (pktcall.ps_rel_rl_fail_hs_d_int + pktcall.ps_rel_rl_fail_hs_d_bgr + pktcall.ps_rel_rl_

call.ps_rel_norm_d_d_stre,0,null, (pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcall.ps_rel_rl_fail_d_d_stre

bgr + pktcall.ps_rel_norm_hs_e_stre,0,null, (pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel

bgr + pktcall.ps_rel_norm_hs_d_stre,0,null, (pktcall.ps_rel_oth_fail_hs_d_int + pktcall.ps_rel_oth_fail_hs_d_bgr + pktcall.ps_rel

call.ps_rel_norm_d_d_stre,0,null, (pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_bgr + pktcall.ps_rel_oth_fail_d_

_hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsch_str)) RNC_2664a,

el_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsch_str),0,null, (traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fa

el_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsch_str),0,null, (traffic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_oth

el_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsch_str),0,null, (traffic.rel_allo_hs_dsch_mob_dch_str + traffic.rel_allo_

el_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsch_str),0,null, (traffic.rel_allo_hs_dsch_pre_emp_int + traffic.rel_allo_h

el_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsch_str),0,null, (traffic.rel_allo_hs_dsch_oth_dch_int + traffic.rel_allo_h

0,null, (traffic.rel_edch_rl_fail_int + traffic.rel_edch_rl_fail_bgr + traffic.rel_edch_rl_fail_str) / (traffic.rel_edch_norm_int + traffic.r

0,null, (traffic.rel_edch_hsdsch_scc_int + traffic.rel_edch_hsdsch_scc_bgr + traffic.rel_edch_hsdsch_scc_str) / (traffic.rel_edch_

0,null, (traffic.rel_edch_other_fail_int + traffic.rel_edch_other_fail_bgr + traffic.rel_edch_other_fail_str) / (traffic.rel_edch_norm_

Page 93
 Report Execution

mp_cs_conv)))) RNC_2719b,

c_comp_ps_strea + SERVLEV.rab_acc_comp_ps_inter + SERVLEV.rab_acc_comp_ps_backg)))) RNC_2720b,

Page 94
 Report Execution

+ servlev.rrc_conn_act_fail_rnc + servlev.rrc_conn_act_fail_ue + servlev.rrc_conn_act_fail_trans + servlev.rrc_conn_act_fail_cip

Page 95
 Report Execution

ail_cs_voice_iur + servlev.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_ue + servlev.rab_act_fail_cs_voice_trans

conv_iur + servlev.rab_act_fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans),0,null, (servlev.rab_act_fail_cs_conv_iu + se
ps_inter_hho + servlev.rab_act_rel_ps_strea_isho + servlev.rab_act_rel_ps_bgr_isho + servlev.rab_act_rel_ps_inter_isho + ser

fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.rab_act_fail_cs_

VLEV.rab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.ra

VLEV.rab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.ra

VLEV.rab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.ra

VLEV.rab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.ra

VLEV.rab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.ra

VLEV.rab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.ra

VLEV.rab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.ra

il_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)) RNC_415b,

EV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)),0,null, ((SERVLEV.r

EV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)),0,null, ((SERVLEV.r

EV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)),0,null, ((SERVLEV.r

EV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)),0,null, ((SERVLEV.r

EV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)),0,null, ((SERVLEV.r

EV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)),0,null, ((SERVLEV.r

EV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)),0,null, ((servlev.rab_

_ps_inter_hho + servlev.rab_act_rel_ps_strea_isho + servlev.rab_act_rel_ps_bgr_isho + servlev.rab_act_rel_ps_inter_isho + S

ev.rab_act_rel_ps_inter_hho + servlev.rab_act_rel_ps_strea_isho + servlev.rab_act_rel_ps_bgr_isho + servlev.rab_act_rel_ps_

ev.rab_act_rel_ps_inter_hho + servlev.rab_act_rel_ps_strea_isho + servlev.rab_act_rel_ps_bgr_isho + servlev.rab_act_rel_ps_

ev.rab_act_rel_ps_inter_hho + servlev.rab_act_rel_ps_strea_isho + servlev.rab_act_rel_ps_bgr_isho + servlev.rab_act_rel_ps_

ev.rab_act_rel_ps_inter_hho + servlev.rab_act_rel_ps_strea_isho + servlev.rab_act_rel_ps_bgr_isho + servlev.rab_act_rel_ps_

ev.rab_act_rel_ps_inter_hho + servlev.rab_act_rel_ps_strea_isho + servlev.rab_act_rel_ps_bgr_isho + servlev.rab_act_rel_ps_

Page 96
 Report Execution

ev.rab_act_rel_ps_inter_hho + servlev.rab_act_rel_ps_strea_isho + servlev.rab_act_rel_ps_bgr_isho + servlev.rab_act_rel_ps_

ev.rab_act_rel_ps_inter_hho + servlev.rab_act_rel_ps_strea_isho + servlev.rab_act_rel_ps_bgr_isho + servlev.rab_act_rel_ps_

nt + pktcall.ps_rel_oth_fail_d_d_bgr + pktcall.ps_rel_norm_hs_e_int + pktcall.ps_rel_norm_hs_e_bgr + pktcall.ps_rel_norm_hs_

hs_d_int + pktcall.ps_rel_oth_fail_hs_d_bgr + pktcall.ps_rel_norm_hs_e_stre + pktcall.ps_rel_norm_hs_e_int + pktcall.ps_rel_n
wi_hs_e_to_d_d_int + pktcall.ps_swi_hs_e_to_d_d_bgr + pktcall.ps_swi_hs_e_to_hs_d_bgr + pktcall.ps_swi_hs_e_to_hs_d_int
hs_e_int + pktcall.ps_swi_d_d_to_hs_e_stre + pktcall.ps_swi_d_d_to_hs_d_bgr + pktcall.ps_swi_d_d_to_hs_d_int + pktcall.ps
ail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_e_stre) / (pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_r

ail_hs_d_bgr + pktcall.ps_rel_rl_fail_hs_d_stre) / (pktcall.ps_rel_rl_fail_hs_d_int + pktcall.ps_rel_rl_fail_hs_d_bgr + pktcall.ps_r

r + pktcall.ps_rel_rl_fail_d_d_stre) / (pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcall.ps_rel_rl_fail_d_d_s

th_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre) / (pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktca

th_fail_hs_d_bgr + pktcall.ps_rel_oth_fail_hs_d_stre) / (pktcall.ps_rel_rl_fail_hs_d_int + pktcall.ps_rel_rl_fail_hs_d_bgr + pktca

_bgr + pktcall.ps_rel_oth_fail_d_d_stre) / (pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcall.ps_rel_rl_fail_

hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsch_str) / (traffic.rel_allo_norm_hs_dsch_int + traf

_hsdsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr) / (traffic.rel_allo_norm_hs_dsch_int + tr

h_mob_dch_str + traffic.rel_allo_hs_dsch_mob_dch_int + traffic.rel_allo_hs_dsch_mob_dch_bgr) / (traffic.rel_allo_norm_hs_ds

h_pre_emp_int + traffic.rel_allo_hs_dsch_pre_emp_bgr + traffic.rel_allo_hs_dsch_pre_emp_str) / (traffic.rel_allo_norm_hs_dsc

h_oth_dch_int + traffic.rel_allo_hs_dsch_oth_dch_bgr + traffic.rel_allo_hs_dsch_oth_dch_str) / (traffic.rel_allo_norm_hs_dsch_

affic.rel_edch_norm_int + traffic.rel_edch_norm_bgr + traffic.rel_edch_norm_str + traffic.rel_edch_rl_fail_int + traffic.rel_edch_rl

sdsch_scc_str) / (traffic.rel_edch_norm_int + traffic.rel_edch_norm_bgr + traffic.rel_edch_norm_str + traffic.rel_edch_rl_fail_int

fail_str) / (traffic.rel_edch_norm_int + traffic.rel_edch_norm_bgr + traffic.rel_edch_norm_str + traffic.rel_edch_rl_fail_int + traffic

Page 97
 Report Execution

g)))) RNC_2720b,

Page 98
 Report Execution

s + servlev.rrc_conn_act_fail_ciph),0,null, (100 - 100*(servlev.rrc_conn_act_rel_p_emp + servlev.rrc_conn_act_fail_iu + servlev

Page 99
 Report Execution

vlev.rab_act_fail_cs_voice_trans),0,null, (servlev.rab_act_rel_cs_voice_p_emp + servlev.rab_act_fail_cs_voice_iu + servlev.rab

vlev.rab_act_fail_cs_conv_iu + servlev.rab_act_fail_cs_conv_radio + servlev.rab_act_fail_cs_conv_bts + servlev.rab_act_fail_cs
.rab_act_rel_ps_inter_isho + servlev.rab_act_fail_ps_strea_iu + servlev.rab_act_fail_ps_strea_radio + servlev.rab_act_fail_ps_

ans + SERVLEV.rab_act_fail_cs_voice_ue)) RNC_2008a,

il_cs_voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)),0,null, ((SERVLEV.rab_act_fail_cs_voice_iu)) / ((SERVLEV.rab_act_

il_cs_voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)),0,null, ((SERVLEV.rab_act_fail_cs_voice_radio)) / ((SERVLEV.rab_a

il_cs_voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)),0,null, ((SERVLEV.rab_act_fail_cs_voice_bts)) / ((SERVLEV.rab_act

il_cs_voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)),0,null, ((SERVLEV.rab_act_fail_cs_voice_iur)) / ((SERVLEV.rab_act_

il_cs_voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)),0,null, ((SERVLEV.rab_act_fail_cs_voice_rnc)) / ((SERVLEV.rab_act

il_cs_voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)),0,null, ((SERVLEV.rab_act_fail_cs_voice_ue)) / ((SERVLEV.rab_act_

il_cs_voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)),0,null, ((servlev.rab_act_fail_cs_voice_trans)) / ((SERVLEV.rab_act_

conv_trans)),0,null, ((SERVLEV.rab_act_fail_cs_conv_iu)) / ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_c

conv_trans)),0,null, ((SERVLEV.rab_act_fail_cs_conv_radio)) / ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_c

conv_trans)),0,null, ((SERVLEV.rab_act_fail_cs_conv_bts)) / ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_

conv_trans)),0,null, ((SERVLEV.rab_act_fail_cs_conv_iur)) / ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_c

conv_trans)),0,null, ((SERVLEV.rab_act_fail_cs_conv_rnc)) / ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_

conv_trans)),0,null, ((SERVLEV.rab_act_fail_cs_conv_ue)) / ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_c

conv_trans)),0,null, ((servlev.rab_act_fail_cs_conv_trans)) / ((SERVLEV.rab_act_comp_cs_conv + SERVLEV.rab_act_rel_cs_c

ev.rab_act_rel_ps_inter_isho + SERVLEV.rab_act_fail_ps_strea_iu + SERVLEV.rab_act_fail_ps_strea_radio + SERVLEV.rab_a

gr_isho + servlev.rab_act_rel_ps_inter_isho + SERVLEV.rab_act_fail_ps_strea_iu + SERVLEV.rab_act_fail_ps_strea_radio + S

gr_isho + servlev.rab_act_rel_ps_inter_isho + SERVLEV.rab_act_fail_ps_strea_iu + SERVLEV.rab_act_fail_ps_strea_radio + S

gr_isho + servlev.rab_act_rel_ps_inter_isho + SERVLEV.rab_act_fail_ps_strea_iu + SERVLEV.rab_act_fail_ps_strea_radio + S

gr_isho + servlev.rab_act_rel_ps_inter_isho + SERVLEV.rab_act_fail_ps_strea_iu + SERVLEV.rab_act_fail_ps_strea_radio + S

gr_isho + servlev.rab_act_rel_ps_inter_isho + SERVLEV.rab_act_fail_ps_strea_iu + SERVLEV.rab_act_fail_ps_strea_radio + S

Page 100
 Report Execution

gr_isho + servlev.rab_act_rel_ps_inter_isho + SERVLEV.rab_act_fail_ps_strea_iu + SERVLEV.rab_act_fail_ps_strea_radio + S

gr_isho + servlev.rab_act_rel_ps_inter_isho + SERVLEV.rab_act_fail_ps_strea_iu + SERVLEV.rab_act_fail_ps_strea_radio + S

_e_bgr + pktcall.ps_rel_norm_hs_d_int + pktcall.ps_rel_norm_hs_d_bgr + pktcall.ps_rel_norm_d_d_int + pktcall.ps_rel_norm_d

_norm_hs_e_int + pktcall.ps_rel_norm_hs_e_bgr + pktcall.ps_rel_norm_hs_d_stre + pktcall.ps_rel_norm_hs_d_int + pktcall.ps_
pktcall.ps_swi_hs_e_to_hs_d_int + pktcall.ps_swi_hs_e_to_hs_d_stre),0,null, (pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_
swi_d_d_to_hs_d_int + pktcall.ps_swi_d_d_to_hs_d_stre),0,null, (pktcall.ps_rel_rl_fail_d_d_stre + pktcall.ps_rel_rl_fail_d_d_int
el_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pk

el_rl_fail_hs_d_bgr + pktcall.ps_rel_rl_fail_hs_d_stre + pktcall.ps_rel_oth_fail_hs_d_int + pktcall.ps_rel_oth_fail_hs_d_bgr + pk

bgr + pktcall.ps_rel_rl_fail_d_d_stre + pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_bgr + pktcall.ps_rel_oth_fai

l.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bg

l.ps_rel_rl_fail_hs_d_bgr + pktcall.ps_rel_rl_fail_hs_d_stre + pktcall.ps_rel_oth_fail_hs_d_int + pktcall.ps_rel_oth_fail_hs_d_bg

_d_d_bgr + pktcall.ps_rel_rl_fail_d_d_stre + pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_bgr + pktcall.ps_rel_o

rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo_oth_fail_h

ic.rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo_oth_fail_

bgr) / (traffic.rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo

tr) / (traffic.rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo

/ (traffic.rel_allo_norm_hs_dsch_int + traffic.rel_allo_norm_hs_dsch_bgr + traffic.rel_allo_norm_hs_dsch_str + traffic.rel_allo_ot

dch_rl_fail_int + traffic.rel_edch_rl_fail_bgr + traffic.rel_edch_rl_fail_str + traffic.rel_edch_other_fail_int + traffic.rel_edch_other_f

m_str + traffic.rel_edch_rl_fail_int + traffic.rel_edch_rl_fail_bgr + traffic.rel_edch_rl_fail_str + traffic.rel_edch_other_fail_int + traff

raffic.rel_edch_rl_fail_int + traffic.rel_edch_rl_fail_bgr + traffic.rel_edch_rl_fail_str + traffic.rel_edch_other_fail_int + traffic.rel_e

Page 101
 Report Execution

lev.rrc_conn_act_fail_iu + servlev.rrc_conn_act_fail_radio + servlev.rrc_conn_act_fail_bts + servlev.rrc_conn_act_fail_iur + serv

Page 102
 Report Execution

act_fail_cs_voice_iu + servlev.rab_act_fail_cs_voice_radio + servlev.rab_act_fail_cs_voice_bts + servlev.rab_act_fail_cs_voice_

onv_bts + servlev.rab_act_fail_cs_conv_rnc + servlev.rab_act_fail_cs_conv_iur + servlev.rab_act_fail_cs_conv_ue + servlev.ra
_radio + servlev.rab_act_fail_ps_strea_bts + servlev.rab_act_fail_ps_strea_iur + servlev.rab_act_fail_ps_strea_rnc + servlev.rab

voice_iu)) / ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_voice_p_

voice_radio)) / ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_voice

voice_bts)) / ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_voice_p

voice_iur)) / ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_voice_p

voice_rnc)) / ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_voice_p

voice_ue)) / ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_voice_p

ce_trans)) / ((SERVLEV.rab_act_comp_cs_voice + SERVLEV.rab_act_rel_cs_voice_srnc + SERVLEV.rab_act_rel_cs_voice_p_

nv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + serv

_conv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho +

onv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + se

onv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + ser

onv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + se

onv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + ser

nv + SERVLEV.rab_act_rel_cs_conv_srnc + SERVLEV.rab_act_rel_cs_conv_p_emp + servlev.rab_act_rel_cs_conv_hho + ser

ps_strea_radio + SERVLEV.rab_act_fail_ps_strea_bts + SERVLEV.rab_act_fail_ps_strea_iur + SERVLEV.rab_act_fail_ps_strea

.rab_act_fail_ps_strea_radio + SERVLEV.rab_act_fail_ps_strea_bts + SERVLEV.rab_act_fail_ps_strea_iur + SERVLEV.rab_ac

.rab_act_fail_ps_strea_radio + SERVLEV.rab_act_fail_ps_strea_bts + SERVLEV.rab_act_fail_ps_strea_iur + SERVLEV.rab_ac

.rab_act_fail_ps_strea_radio + SERVLEV.rab_act_fail_ps_strea_bts + SERVLEV.rab_act_fail_ps_strea_iur + SERVLEV.rab_ac

.rab_act_fail_ps_strea_radio + SERVLEV.rab_act_fail_ps_strea_bts + SERVLEV.rab_act_fail_ps_strea_iur + SERVLEV.rab_ac

.rab_act_fail_ps_strea_radio + SERVLEV.rab_act_fail_ps_strea_bts + SERVLEV.rab_act_fail_ps_strea_iur + SERVLEV.rab_ac

Page 103
 Report Execution

.rab_act_fail_ps_strea_radio + SERVLEV.rab_act_fail_ps_strea_bts + SERVLEV.rab_act_fail_ps_strea_iur + SERVLEV.rab_ac

.rab_act_fail_ps_strea_radio + SERVLEV.rab_act_fail_ps_strea_bts + SERVLEV.rab_act_fail_ps_strea_iur + SERVLEV.rab_ac

_d_d_int + pktcall.ps_rel_norm_d_d_bgr + pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_d_stre + pktcall.ps_rel_rl_

_rel_norm_hs_d_int + pktcall.ps_rel_norm_hs_d_bgr + pktcall.ps_swi_hs_e_to_d_d_stre + pktcall.ps_swi_hs_e_to_d_d_int + p
l_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.
e + pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcall.ps_rel_oth_fail_d_d_stre + pktcall.ps_rel_oth_fail_d_
all.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_norm_hs_e_int + pktcall.ps_rel_norm_hs_e_b

all.ps_rel_oth_fail_hs_d_bgr + pktcall.ps_rel_oth_fail_hs_d_stre + pktcall.ps_rel_norm_hs_d_int + pktcall.ps_rel_norm_hs_d_b

_d_d_bgr + pktcall.ps_rel_oth_fail_d_d_stre + pktcall.ps_rel_norm_d_d_int + pktcall.ps_rel_norm_d_d_bgr + pktcall.ps_rel_norm

+ pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_norm_hs_e_int + pktcall.ps_rel_norm_hs

+ pktcall.ps_rel_oth_fail_hs_d_bgr + pktcall.ps_rel_oth_fail_hs_d_stre + pktcall.ps_rel_norm_hs_d_int + pktcall.ps_rel_norm_hs

h_fail_d_d_bgr + pktcall.ps_rel_oth_fail_d_d_stre + pktcall.ps_rel_norm_d_d_int + pktcall.ps_rel_norm_d_d_bgr + pktcall.ps_re

ch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_str + traffic.re

dsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_str + traffic

orm_hs_dsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_s

orm_hs_dsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_st

m_hs_dsch_str + traffic.rel_allo_oth_fail_hsdsch_int + traffic.rel_allo_oth_fail_hsdsch_bgr + traffic.rel_allo_oth_fail_hsdsch_str +

_fail_int + traffic.rel_edch_other_fail_bgr + traffic.rel_edch_other_fail_str))) RNC_2671a,

ffic.rel_edch_other_fail_int + traffic.rel_edch_other_fail_bgr + traffic.rel_edch_other_fail_str))) RNC_2675a,

edch_other_fail_int + traffic.rel_edch_other_fail_bgr + traffic.rel_edch_other_fail_str))) RNC_2673a,

Page 104
 Report Execution

rvlev.rrc_conn_act_fail_iur + servlev.rrc_conn_act_fail_rnc + servlev.rrc_conn_act_fail_ue + servlev.rrc_conn_act_fail_trans + s

Page 105
 Report Execution

s + servlev.rab_act_fail_cs_voice_iur + servlev.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_ue + servlev.rab_act_

act_fail_cs_conv_ue + servlev.rab_act_rel_cs_conv_p_emp + servlev.rab_act_fail_cs_conv_trans) / (servlev.rab_act_comp_cs
ct_fail_ps_strea_rnc + servlev.rab_act_fail_ps_strea_ue + servlev.rab_act_fail_ps_strea_trans + servlev.rab_act_fail_ps_inter_i

RVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servlev.rab_a

SERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servlev.ra

ERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servlev.rab_

ERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servlev.rab_

ERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servlev.rab_

ERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servlev.rab_

ERVLEV.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servlev.rab_a

.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail_

vlev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_f

ev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fai

v.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail

ev.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fai

v.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail

v.rab_act_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + SERVLEV.rab_act_fail_cs_conv_iu + SERVLEV.rab_act_fail_

+ SERVLEV.rab_act_fail_ps_strea_rnc + SERVLEV.rab_act_fail_ps_strea_ue + servlev.rab_act_fail_ps_strea_trans + SERVLEV

ps_strea_iur + SERVLEV.rab_act_fail_ps_strea_rnc + SERVLEV.rab_act_fail_ps_strea_ue + servlev.rab_act_fail_ps_strea_tra

ps_strea_iur + SERVLEV.rab_act_fail_ps_strea_rnc + SERVLEV.rab_act_fail_ps_strea_ue + servlev.rab_act_fail_ps_strea_tra

ps_strea_iur + SERVLEV.rab_act_fail_ps_strea_rnc + SERVLEV.rab_act_fail_ps_strea_ue + servlev.rab_act_fail_ps_strea_tra

ps_strea_iur + SERVLEV.rab_act_fail_ps_strea_rnc + SERVLEV.rab_act_fail_ps_strea_ue + servlev.rab_act_fail_ps_strea_tra

ps_strea_iur + SERVLEV.rab_act_fail_ps_strea_rnc + SERVLEV.rab_act_fail_ps_strea_ue + servlev.rab_act_fail_ps_strea_tra

Page 106
 Report Execution

ps_strea_iur + SERVLEV.rab_act_fail_ps_strea_rnc + SERVLEV.rab_act_fail_ps_strea_ue + servlev.rab_act_fail_ps_strea_tra

ps_strea_iur + SERVLEV.rab_act_fail_ps_strea_rnc + SERVLEV.rab_act_fail_ps_strea_ue + servlev.rab_act_fail_ps_strea_tra

ail_hs_d_stre + pktcall.ps_rel_rl_fail_d_d_stre + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_d_stre + pktcall.

tcall.ps_swi_hs_e_to_d_d_int + pktcall.ps_swi_hs_e_to_d_d_bgr + pktcall.ps_swi_hs_d_to_d_d_stre + pktcall.ps_swi_hs_d_to
_rel_oth_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr) / (pktcall.ps_rel_rl_fail_hs_e_stre
_stre + pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_bgr) / (pktcall.ps_rel_rl_fail_d_d_stre + pktcall.ps_rel_rl_fa
nt + pktcall.ps_rel_norm_hs_e_bgr + pktcall.ps_rel_norm_hs_e_stre))) RNC_2210a,

nt + pktcall.ps_rel_norm_hs_d_bgr + pktcall.ps_rel_norm_hs_d_stre))) RNC_2208a,

rm_d_d_bgr + pktcall.ps_rel_norm_d_d_stre))) RNC_2204a,

s_e_int + pktcall.ps_rel_norm_hs_e_bgr + pktcall.ps_rel_norm_hs_e_stre))) RNC_2200a,

s_d_int + pktcall.ps_rel_norm_hs_d_bgr + pktcall.ps_rel_norm_hs_d_stre))) RNC_2196a,

el_norm_d_d_bgr + pktcall.ps_rel_norm_d_d_stre))) RNC_1100d,

llo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsc

_allo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_d

traffic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_

raffic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_f

fic.rel_allo_oth_fail_hsdsch_str + traffic.rel_allo_rl_fail_hs_dsch_int + traffic.rel_allo_rl_fail_hs_dsch_bgr + traffic.rel_allo_rl_fail

RNC_2675a,

Page 107
 Report Execution

ervlev.rrc_conn_act_fail_trans + servlev.rrc_conn_act_fail_ciph) / (servlev.rrc_conn_act_comp + servlev.rrc_conn_act_rel_srnc +

Page 108
 Report Execution

l_cs_voice_ue + servlev.rab_act_fail_cs_voice_trans) / (servlev.rab_act_comp_cs_voice + servlev.rab_act_rel_cs_voice_srnc +

ans) / (servlev.rab_act_comp_cs_conv + servlev.rab_act_rel_cs_conv_srnc + servlev.rab_act_rel_cs_conv_hho + servlev.rab_a
+ servlev.rab_act_fail_ps_inter_iu + servlev.rab_act_fail_ps_inter_radio + servlev.rab_act_fail_ps_inter_bts + servlev.rab_act_f

el_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fail_cs_v

ct_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fail_c

_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fail_cs_

rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fail_cs_

_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fail_cs_

rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fail_cs_

el_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + SERVLEV.rab_act_fail_cs_voice_bts + SERVLEV.rab_act_fail_cs_v

onv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc

s_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_r

_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc

conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc

_conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc

conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc

conv_iu + SERVLEV.rab_act_fail_cs_conv_radio + SERVLEV.rab_act_fail_cs_conv_bts + SERVLEV.rab_act_fail_cs_conv_rnc

t_fail_ps_strea_trans + SERVLEV.rab_act_fail_ps_inter_iu + SERVLEV.rab_act_fail_ps_inter_radio + SERVLEV.rab_act_fail_p

servlev.rab_act_fail_ps_strea_trans + SERVLEV.rab_act_fail_ps_inter_iu + SERVLEV.rab_act_fail_ps_inter_radio + SERVLEV.

servlev.rab_act_fail_ps_strea_trans + SERVLEV.rab_act_fail_ps_inter_iu + SERVLEV.rab_act_fail_ps_inter_radio + SERVLEV.

servlev.rab_act_fail_ps_strea_trans + SERVLEV.rab_act_fail_ps_inter_iu + SERVLEV.rab_act_fail_ps_inter_radio + SERVLEV.

servlev.rab_act_fail_ps_strea_trans + SERVLEV.rab_act_fail_ps_inter_iu + SERVLEV.rab_act_fail_ps_inter_radio + SERVLEV.

servlev.rab_act_fail_ps_strea_trans + SERVLEV.rab_act_fail_ps_inter_iu + SERVLEV.rab_act_fail_ps_inter_radio + SERVLEV.

Page 109
 Report Execution

servlev.rab_act_fail_ps_strea_trans + SERVLEV.rab_act_fail_ps_inter_iu + SERVLEV.rab_act_fail_ps_inter_radio + SERVLEV.

servlev.rab_act_fail_ps_strea_trans + SERVLEV.rab_act_fail_ps_inter_iu + SERVLEV.rab_act_fail_ps_inter_radio + SERVLEV.

_rel_oth_fail_hs_d_stre + pktcall.ps_rel_oth_fail_d_d_stre + pktcall.ps_rel_norm_hs_e_stre + pktcall.ps_rel_norm_hs_d_stre +

_d_stre + pktcall.ps_swi_hs_d_to_d_d_int + pktcall.ps_swi_hs_d_to_d_d_bgr),0,null, (100 - 100*(pktcall.ps_rel_rl_fail_hs_e_str
/ (pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_oth_fail_hs_
ail_d_d_stre + pktcall.ps_rel_rl_fail_d_d_int + pktcall.ps_rel_rl_fail_d_d_bgr + pktcall.ps_rel_oth_fail_d_d_stre + pktcall.ps_rel_o

gr + traffic.rel_allo_rl_fail_hs_dsch_str))) RNC_2666a,

_bgr + traffic.rel_allo_rl_fail_hs_dsch_str))) RNC_2676a,

_hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsch_str))) RNC_2678a,

hs_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsch_str))) RNC_2680a,

_dsch_bgr + traffic.rel_allo_rl_fail_hs_dsch_str))) RNC_2682a,

Page 110
 Report Execution

+ servlev.rrc_conn_act_rel_srnc + servlev.rrc_conn_act_rel_ganho + servlev.rrc_conn_act_rel_hho + servlev.rrc_conn_act_rel_

Page 111
 Report Execution

vlev.rab_act_rel_cs_voice_srnc + servlev.rab_act_rel_cs_voice_p_emp + servlev.rab_act_rel_cs_voice_hho + servlev.rab_act_

_rel_cs_conv_hho + servlev.rab_act_rel_cs_conv_isho + servlev.rab_act_rel_cs_conv_p_emp + servlev.rab_act_fail_cs_conv_i
_ps_inter_bts + servlev.rab_act_fail_ps_inter_iur + servlev.rab_act_fail_ps_inter_rnc + servlev.rab_act_fail_ps_inter_ue + servle

ts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio + SER

e_bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio + S

bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio + SE

bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio + SE

bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio + SE

bts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio + SE

ts + SERVLEV.rab_act_fail_cs_voice_iu + SERVLEV.rab_act_fail_cs_voice_iur + SERVLEV.rab_act_fail_cs_voice_radio + SER

VLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_act

ERVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_

RVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_ac

RVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_ac

RVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_ac

RVLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_ac

VLEV.rab_act_fail_cs_conv_rnc + SERVLEV.rab_act_fail_cs_conv_iur + SERVLEV.rab_act_fail_cs_conv_ue + servlev.rab_act

radio + SERVLEV.rab_act_fail_ps_inter_bts + SERVLEV.rab_act_fail_ps_inter_iur + SERVLEV.rab_act_fail_ps_inter_rnc + SER

_fail_ps_inter_radio + SERVLEV.rab_act_fail_ps_inter_bts + SERVLEV.rab_act_fail_ps_inter_iur + SERVLEV.rab_act_fail_ps_i

_fail_ps_inter_radio + SERVLEV.rab_act_fail_ps_inter_bts + SERVLEV.rab_act_fail_ps_inter_iur + SERVLEV.rab_act_fail_ps_i

_fail_ps_inter_radio + SERVLEV.rab_act_fail_ps_inter_bts + SERVLEV.rab_act_fail_ps_inter_iur + SERVLEV.rab_act_fail_ps_i

_fail_ps_inter_radio + SERVLEV.rab_act_fail_ps_inter_bts + SERVLEV.rab_act_fail_ps_inter_iur + SERVLEV.rab_act_fail_ps_i

_fail_ps_inter_radio + SERVLEV.rab_act_fail_ps_inter_bts + SERVLEV.rab_act_fail_ps_inter_iur + SERVLEV.rab_act_fail_ps_i

Page 112
 Report Execution

_fail_ps_inter_radio + SERVLEV.rab_act_fail_ps_inter_bts + SERVLEV.rab_act_fail_ps_inter_iur + SERVLEV.rab_act_fail_ps_i

_fail_ps_inter_radio + SERVLEV.rab_act_fail_ps_inter_bts + SERVLEV.rab_act_fail_ps_inter_iur + SERVLEV.rab_act_fail_ps_i

pktcall.ps_rel_norm_hs_d_stre + pktcall.ps_rel_norm_d_d_stre),0,null, (100 - 100*(pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_r

0*(pktcall.ps_rel_rl_fail_hs_e_stre + pktcall.ps_rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall.ps_rel_rl_fail_hs_
_bgr + pktcall.ps_rel_oth_fail_hs_e_stre + pktcall.ps_rel_oth_fail_hs_e_int + pktcall.ps_rel_oth_fail_hs_e_bgr + pktcall.ps_rel_n
h_fail_d_d_stre + pktcall.ps_rel_oth_fail_d_d_int + pktcall.ps_rel_oth_fail_d_d_bgr + pktcall.ps_rel_norm_d_d_stre + pktcall.ps_

Page 113
 Report Execution

_hho + servlev.rrc_conn_act_rel_intra_hho + servlev.rrc_conn_act_rel_isho + ser...

Page 114
 Report Execution

cs_voice_hho + servlev.rab_act_rel_cs_voice_isho + servlev.rab_act_rel_cs_voice_ganho + ser...

+ servlev.rab_act_fail_cs_conv_iu + servlev.rab_act_fail_cs_conv_radio + servlev.rab_act_fail_cs_conv_bt...
rab_act_fail_ps_inter_ue + servlev.rab_act_fail_ps_inter_trans + servlev.rab_act_fail_ps...

ab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.rab_act_

V.rab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.rab_a

rab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.rab_act

ab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.rab_act_

rab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.rab_act

ab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.rab_act_

ab_act_fail_cs_voice_radio + SERVLEV.rab_act_fail_cs_voice_rnc + servlev.rab_act_fail_cs_voice_trans + SERVLEV.rab_act_

ail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)))) RNC_1972b,

t_fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)))) RNC_1973b,

fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)))) RNC_1974b,

ail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)))) RNC_1975b,

fail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)))) RNC_1976b,

ail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)))) RNC_1977b,

ail_cs_conv_ue + servlev.rab_act_fail_cs_conv_trans)))) RNC_2002a,

V.rab_act_fail_ps_inter_rnc + SERVLEV.rab_act_fail_ps_inter_ue + servlev.rab_act_fail_ps_inter_trans + SERVLEV.rab_act_fa

ur + SERVLEV.rab_act_fail_ps_inter_rnc + SERVLEV.rab_act_fail_ps_inter_ue + servlev.rab_act_fail_ps_inter_trans + SERVL

ur + SERVLEV.rab_act_fail_ps_inter_rnc + SERVLEV.rab_act_fail_ps_inter_ue + servlev.rab_act_fail_ps_inter_trans + SERVL

ur + SERVLEV.rab_act_fail_ps_inter_rnc + SERVLEV.rab_act_fail_ps_inter_ue + servlev.rab_act_fail_ps_inter_trans + SERVL

ur + SERVLEV.rab_act_fail_ps_inter_rnc + SERVLEV.rab_act_fail_ps_inter_ue + servlev.rab_act_fail_ps_inter_trans + SERVL

ur + SERVLEV.rab_act_fail_ps_inter_rnc + SERVLEV.rab_act_fail_ps_inter_ue + servlev.rab_act_fail_ps_inter_trans + SERVL

Page 115
 Report Execution

ur + SERVLEV.rab_act_fail_ps_inter_rnc + SERVLEV.rab_act_fail_ps_inter_ue + servlev.rab_act_fail_ps_inter_trans + SERVL

ur + SERVLEV.rab_act_fail_ps_inter_rnc + SERVLEV.rab_act_fail_ps_inter_ue + servlev.rab_act_fail_ps_inter_trans + SERVL

rel_rl_fail_hs_e_int + pktcall.ps_rel_rl_fail_hs_e_bgr + pktcall...

e_bgr + pktcall.ps_rel_rl_fail_hs_d_stre + pktcall.ps_rel_rl_fail_hs_d_int...
h_fail_hs_e_bgr + pktcall.ps_rel_norm_hs_e_stre + pktcall.ps_rel_nor...
_rel_norm_d_d_stre + pktcall.ps_rel_norm_d_d_int + pktcall.ps_re...

Page 116
 Report Execution

_cs_conv_bt...

oice_trans + SERVLEV.rab_act_fail_cs_voice_ue)))) RNC_...

s_voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)))) R...

voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)))) RNC...

voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)))) RNC...

voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)))) RNC...

voice_trans + SERVLEV.rab_act_fail_cs_voice_ue)))) RNC_...

oice_trans + SERVLEV.rab_act_fail_cs_voice_ue)))) R...

er_trans + SERVLEV.rab_act_fail_ps_backg_iu + SERVLEV...

act_fail_ps_inter_trans + SERVLEV.rab_act_fail_ps_backg...

act_fail_ps_inter_trans + SERVLEV.rab_act_fail_ps_backg...

act_fail_ps_inter_trans + SERVLEV.rab_act_fail_ps_backg...

act_fail_ps_inter_trans + SERVLEV.rab_act_fail_ps_backg...

act_fail_ps_inter_trans + SERVLEV.rab_act_fail_ps_backg...

Page 117
 Report Execution

act_fail_ps_inter_trans + SERVLEV.rab_act_fail_ps_backg...

act_fail_ps_inter_trans + SERVLEV.rab_act_fail_ps_backg...

Page 118