[go: up one dir, main page]
Scribd
Upload
264 views23 pages

LTE Interference Report

The document is an LTE interference analysis report that summarizes key performance indicator (KPI) metrics for signal quality like RSSI and SINR collected from an LTE network cluster over a period of time. It includes tables of average RSSI and SINR values for different channels as well as percentages of samples that fell within different quality categories. The report describes the data sources, time period analyzed, and SQL queries used to aggregate the KPI measurements.

Uploaded by

hery_bruce
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
264 views23 pages

LTE Interference Report

The document is an LTE interference analysis report that summarizes key performance indicator (KPI) metrics for signal quality like RSSI and SINR collected from an LTE network cluster over a period of time. It includes tables of average RSSI and SINR values for different channels as well as percentages of samples that fell within different quality categories. The report describes the data sources, time period analyzed, and SQL queries used to aggregate the KPI measurements.

Uploaded by

hery_bruce
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 23

PERIOD_STMRBTS na LNBTS typ LNBTS namLNCEL name Avg RSSI f Avg RSSI f

02.12.201 L_ADIHUS MacroBTS L_ADIHUS L_ADIHUSADA1 -110.61 -105.48


Interferenc

Category 2
Guideline
Category
e power

Propose
Avg SINR f Avg SINR f Perc GoodPerc Accp Perc Bad
3.95 9.21 36.33 37.11 26.56 -114.69 Clear Clear
Documentation

Report Title LTE Interference Analysis


NOP Report Release Version none
RS Report Release Version none
Report ID PM_12560
Report Description none
Start Time 02.25.2016 16:30:00
End Time 03.03.2016 16:30:00
Objects Level: WS_RSLTE-LNCEL; LTE_CLUSTER_2B_4_7 ('LTE_CLUSTER_2B_4_7')
Object Aggregation Level PLMN/MRBTS/LNBTS/LNCEL
Time Aggregation Level whole_period
Threshold none
Sorting null
Data Source pmrPool
Advanced Filter none

KPI ID KPI Alias


LTE_5441b Avg RSSI for PUCCH
LTE_5444b Avg RSSI for PUSCH
LTE_5541b Avg SINR for PUCCH
LTE_5544b Avg SINR for PUSCH
LTE_592a Perc Good SINR Lev PUSCH
LTE_593a Perc Accpt SINR Lev PUSCH
LTE_594a Perc Bad SINR Lev PUSCH

Page 3
Documentation

; LTE_CLUSTER_2B_4_7 ('LTE_CLUSTER_2B_4_7')

KPI Title
E-UTRAN Average RSSI for PUCCH
E-UTRAN Average RSSI for PUSCH
E-UTRAN Average SINR for PUCCH
E-UTRAN Average SINR for PUSCH
Perc Good SINR Lev PUSCH
Perc Accpt SINR Lev PUSCH
Perc Bad SINR Lev PUSCH

Page 4
Documentation

TER_2B_4_7')

KPI Formula
decode( ((lpqul.rssi_pucch_level_01) + (lpqul.rssi_pucch_level_02) + (lpqul.rssi_pucch_level_03) + (lpqul.rssi_pucch_level
decode( ((lpqul.rssi_pusch_level_01) + (lpqul.rssi_pusch_level_02) + (lpqul.rssi_pusch_level_03) + (lpqul.rssi_pusch_level
decode( ((lpqul.sinr_pucch_level_1) + (lpqul.sinr_pucch_level_2) + (lpqul.sinr_pucch_level_3) + (lpqul.sinr_pucch_level_4)
decode( ((lpqul.sinr_pusch_level_1) + (lpqul.sinr_pusch_level_2) + (lpqul.sinr_pusch_level_3) + (lpqul.sinr_pusch_level_4)
decode( (lpqul.sinr_pusch_level_1 + lpqul.sinr_pusch_level_2 + lpqul.sinr_pusch_level_3 + lpqul.sinr_pusch_level_4 + lpq
decode( (lpqul.sinr_pusch_level_1 + lpqul.sinr_pusch_level_2 + lpqul.sinr_pusch_level_3 + lpqul.sinr_pusch_level_4 + lpq
decode( (lpqul.sinr_pusch_level_1 + lpqul.sinr_pusch_level_2 + lpqul.sinr_pusch_level_3 + lpqul.sinr_pusch_level_4 + lpq

Page 5
Documentation

Unit
[dBm]
[dBm]
[dB]
[dB]
[%]
[%]
[%]

Page 6
Report Execution

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


Evaluation method tmp tables(1)
Init duration 0.081
Sql generation 0.0090
Execution duration 1.835
Load from cache none
Create tmp Tables 1.772
Drop tmp Tables none
Load data db none
Load data and write to cache none

Start Time End Time


2016-03-03 16:30:04.405 2016-03-03 16:30:06.176

Page 7
Report Execution

2016-03-03 16:30:06.177 2016-03-03 16:30:06.240

Page 8
Report Execution

Note Sql
creating tmp table: jf_LPQUL_0359136119
create global temporary table jf_LPQUL_0359136119 on commit preserve rows as
select
a.period_start_time,
a.lncel_gid,
SUM(RSSI_PUCCH_LEVEL_01) RSSI_PUCCH_LEVEL_01,
SUM(RSSI_PUCCH_LEVEL_02) RSSI_PUCCH_LEVEL_02,
SUM(RSSI_PUCCH_LEVEL_03) RSSI_PUCCH_LEVEL_03,
SUM(RSSI_PUCCH_LEVEL_04) RSSI_PUCCH_LEVEL_04,
SUM(RSSI_PUCCH_LEVEL_05) RSSI_PUCCH_LEVEL_05,
SUM(RSSI_PUCCH_LEVEL_06) RSSI_PUCCH_LEVEL_06,
SUM(RSSI_PUCCH_LEVEL_07) RSSI_PUCCH_LEVEL_07,
SUM(RSSI_PUCCH_LEVEL_08) RSSI_PUCCH_LEVEL_08,
SUM(RSSI_PUCCH_LEVEL_09) RSSI_PUCCH_LEVEL_09,
SUM(RSSI_PUCCH_LEVEL_10) RSSI_PUCCH_LEVEL_10,
SUM(RSSI_PUCCH_LEVEL_11) RSSI_PUCCH_LEVEL_11,
SUM(RSSI_PUCCH_LEVEL_12) RSSI_PUCCH_LEVEL_12,
SUM(RSSI_PUCCH_LEVEL_13) RSSI_PUCCH_LEVEL_13,
SUM(RSSI_PUCCH_LEVEL_14) RSSI_PUCCH_LEVEL_14,
SUM(RSSI_PUCCH_LEVEL_15) RSSI_PUCCH_LEVEL_15,
SUM(RSSI_PUCCH_LEVEL_16) RSSI_PUCCH_LEVEL_16,
SUM(RSSI_PUCCH_LEVEL_17) RSSI_PUCCH_LEVEL_17,
SUM(RSSI_PUCCH_LEVEL_18) RSSI_PUCCH_LEVEL_18,
SUM(RSSI_PUCCH_LEVEL_19) RSSI_PUCCH_LEVEL_19,
SUM(RSSI_PUCCH_LEVEL_20) RSSI_PUCCH_LEVEL_20,
SUM(RSSI_PUCCH_LEVEL_21) RSSI_PUCCH_LEVEL_21,
SUM(RSSI_PUCCH_LEVEL_22) RSSI_PUCCH_LEVEL_22,
SUM(RSSI_PUSCH_LEVEL_01) RSSI_PUSCH_LEVEL_01,
SUM(RSSI_PUSCH_LEVEL_02) RSSI_PUSCH_LEVEL_02,
SUM(RSSI_PUSCH_LEVEL_03) RSSI_PUSCH_LEVEL_03,
SUM(RSSI_PUSCH_LEVEL_04) RSSI_PUSCH_LEVEL_04,
SUM(RSSI_PUSCH_LEVEL_05) RSSI_PUSCH_LEVEL_05,
SUM(RSSI_PUSCH_LEVEL_06) RSSI_PUSCH_LEVEL_06,
SUM(RSSI_PUSCH_LEVEL_07) RSSI_PUSCH_LEVEL_07,
SUM(RSSI_PUSCH_LEVEL_08) RSSI_PUSCH_LEVEL_08,
SUM(RSSI_PUSCH_LEVEL_09) RSSI_PUSCH_LEVEL_09,
SUM(RSSI_PUSCH_LEVEL_10) RSSI_PUSCH_LEVEL_10,
SUM(RSSI_PUSCH_LEVEL_11) RSSI_PUSCH_LEVEL_11,
SUM(RSSI_PUSCH_LEVEL_12) RSSI_PUSCH_LEVEL_12,
SUM(RSSI_PUSCH_LEVEL_13) RSSI_PUSCH_LEVEL_13,

Page 9
Report Execution

SUM(RSSI_PUSCH_LEVEL_14) RSSI_PUSCH_LEVEL_14,
SUM(RSSI_PUSCH_LEVEL_15) RSSI_PUSCH_LEVEL_15,
SUM(RSSI_PUSCH_LEVEL_16) RSSI_PUSCH_LEVEL_16,
SUM(RSSI_PUSCH_LEVEL_17) RSSI_PUSCH_LEVEL_17,
SUM(RSSI_PUSCH_LEVEL_18) RSSI_PUSCH_LEVEL_18,
SUM(RSSI_PUSCH_LEVEL_19) RSSI_PUSCH_LEVEL_19,
SUM(RSSI_PUSCH_LEVEL_20) RSSI_PUSCH_LEVEL_20,
SUM(RSSI_PUSCH_LEVEL_21) RSSI_PUSCH_LEVEL_21,
SUM(RSSI_PUSCH_LEVEL_22) RSSI_PUSCH_LEVEL_22,
SUM(SINR_PUCCH_LEVEL_1) SINR_PUCCH_LEVEL_1,
SUM(SINR_PUCCH_LEVEL_2) SINR_PUCCH_LEVEL_2,
SUM(SINR_PUCCH_LEVEL_3) SINR_PUCCH_LEVEL_3,
SUM(SINR_PUCCH_LEVEL_4) SINR_PUCCH_LEVEL_4,
SUM(SINR_PUCCH_LEVEL_5) SINR_PUCCH_LEVEL_5,
SUM(SINR_PUCCH_LEVEL_6) SINR_PUCCH_LEVEL_6,
SUM(SINR_PUCCH_LEVEL_7) SINR_PUCCH_LEVEL_7,
SUM(SINR_PUCCH_LEVEL_8) SINR_PUCCH_LEVEL_8,
SUM(SINR_PUCCH_LEVEL_9) SINR_PUCCH_LEVEL_9,
SUM(SINR_PUCCH_LEVEL_10) SINR_PUCCH_LEVEL_10,
SUM(SINR_PUCCH_LEVEL_11) SINR_PUCCH_LEVEL_11,
SUM(SINR_PUCCH_LEVEL_12) SINR_PUCCH_LEVEL_12,
SUM(SINR_PUCCH_LEVEL_13) SINR_PUCCH_LEVEL_13,
SUM(SINR_PUCCH_LEVEL_14) SINR_PUCCH_LEVEL_14,
SUM(SINR_PUCCH_LEVEL_15) SINR_PUCCH_LEVEL_15,
SUM(SINR_PUCCH_LEVEL_16) SINR_PUCCH_LEVEL_16,
SUM(SINR_PUCCH_LEVEL_17) SINR_PUCCH_LEVEL_17,
SUM(SINR_PUCCH_LEVEL_18) SINR_PUCCH_LEVEL_18,
SUM(SINR_PUCCH_LEVEL_19) SINR_PUCCH_LEVEL_19,
SUM(SINR_PUCCH_LEVEL_20) SINR_PUCCH_LEVEL_20,
SUM(SINR_PUCCH_LEVEL_21) SINR_PUCCH_LEVEL_21,
SUM(SINR_PUCCH_LEVEL_22) SINR_PUCCH_LEVEL_22,
SUM(SINR_PUSCH_LEVEL_1) SINR_PUSCH_LEVEL_1,
SUM(SINR_PUSCH_LEVEL_2) SINR_PUSCH_LEVEL_2,
SUM(SINR_PUSCH_LEVEL_3) SINR_PUSCH_LEVEL_3,
SUM(SINR_PUSCH_LEVEL_4) SINR_PUSCH_LEVEL_4,
SUM(SINR_PUSCH_LEVEL_5) SINR_PUSCH_LEVEL_5,
SUM(SINR_PUSCH_LEVEL_6) SINR_PUSCH_LEVEL_6,
SUM(SINR_PUSCH_LEVEL_7) SINR_PUSCH_LEVEL_7,
SUM(SINR_PUSCH_LEVEL_8) SINR_PUSCH_LEVEL_8,
SUM(SINR_PUSCH_LEVEL_9) SINR_PUSCH_LEVEL_9,
SUM(SINR_PUSCH_LEVEL_10) SINR_PUSCH_LEVEL_10,
SUM(SINR_PUSCH_LEVEL_11) SINR_PUSCH_LEVEL_11,
SUM(SINR_PUSCH_LEVEL_12) SINR_PUSCH_LEVEL_12,
SUM(SINR_PUSCH_LEVEL_13) SINR_PUSCH_LEVEL_13,
SUM(SINR_PUSCH_LEVEL_14) SINR_PUSCH_LEVEL_14,
SUM(SINR_PUSCH_LEVEL_15) SINR_PUSCH_LEVEL_15,
SUM(SINR_PUSCH_LEVEL_16) SINR_PUSCH_LEVEL_16,
SUM(SINR_PUSCH_LEVEL_17) SINR_PUSCH_LEVEL_17,
SUM(SINR_PUSCH_LEVEL_18) SINR_PUSCH_LEVEL_18,
SUM(SINR_PUSCH_LEVEL_19) SINR_PUSCH_LEVEL_19,
SUM(SINR_PUSCH_LEVEL_20) SINR_PUSCH_LEVEL_20,
SUM(SINR_PUSCH_LEVEL_21) SINR_PUSCH_LEVEL_21,
SUM(SINR_PUSCH_LEVEL_22) SINR_PUSCH_LEVEL_22
from

Page 10
Report Execution

(
select
to_date('2016/02/25 16:30:00', 'yyyy/mm/dd hh24:mi:ss') period_start_time,
"mrbts".co_gid mrbts_gid,
"lnbts".co_gid lnbts_gid,
"lncel".co_gid lncel_gid,
g.ws ws,
SUM(RSSI_PUCCH_LEVEL_01) RSSI_PUCCH_LEVEL_01,
SUM(RSSI_PUCCH_LEVEL_02) RSSI_PUCCH_LEVEL_02,
SUM(RSSI_PUCCH_LEVEL_03) RSSI_PUCCH_LEVEL_03,
SUM(RSSI_PUCCH_LEVEL_04) RSSI_PUCCH_LEVEL_04,
SUM(RSSI_PUCCH_LEVEL_05) RSSI_PUCCH_LEVEL_05,
SUM(RSSI_PUCCH_LEVEL_06) RSSI_PUCCH_LEVEL_06,
SUM(RSSI_PUCCH_LEVEL_07) RSSI_PUCCH_LEVEL_07,
SUM(RSSI_PUCCH_LEVEL_08) RSSI_PUCCH_LEVEL_08,
SUM(RSSI_PUCCH_LEVEL_09) RSSI_PUCCH_LEVEL_09,
SUM(RSSI_PUCCH_LEVEL_10) RSSI_PUCCH_LEVEL_10,
SUM(RSSI_PUCCH_LEVEL_11) RSSI_PUCCH_LEVEL_11,
SUM(RSSI_PUCCH_LEVEL_12) RSSI_PUCCH_LEVEL_12,
SUM(RSSI_PUCCH_LEVEL_13) RSSI_PUCCH_LEVEL_13,
SUM(RSSI_PUCCH_LEVEL_14) RSSI_PUCCH_LEVEL_14,
SUM(RSSI_PUCCH_LEVEL_15) RSSI_PUCCH_LEVEL_15,
SUM(RSSI_PUCCH_LEVEL_16) RSSI_PUCCH_LEVEL_16,
SUM(RSSI_PUCCH_LEVEL_17) RSSI_PUCCH_LEVEL_17,
SUM(RSSI_PUCCH_LEVEL_18) RSSI_PUCCH_LEVEL_18,
SUM(RSSI_PUCCH_LEVEL_19) RSSI_PUCCH_LEVEL_19,
SUM(RSSI_PUCCH_LEVEL_20) RSSI_PUCCH_LEVEL_20,
SUM(RSSI_PUCCH_LEVEL_21) RSSI_PUCCH_LEVEL_21,
SUM(RSSI_PUCCH_LEVEL_22) RSSI_PUCCH_LEVEL_22,
SUM(RSSI_PUSCH_LEVEL_01) RSSI_PUSCH_LEVEL_01,
SUM(RSSI_PUSCH_LEVEL_02) RSSI_PUSCH_LEVEL_02,
SUM(RSSI_PUSCH_LEVEL_03) RSSI_PUSCH_LEVEL_03,
SUM(RSSI_PUSCH_LEVEL_04) RSSI_PUSCH_LEVEL_04,
SUM(RSSI_PUSCH_LEVEL_05) RSSI_PUSCH_LEVEL_05,
SUM(RSSI_PUSCH_LEVEL_06) RSSI_PUSCH_LEVEL_06,
SUM(RSSI_PUSCH_LEVEL_07) RSSI_PUSCH_LEVEL_07,
SUM(RSSI_PUSCH_LEVEL_08) RSSI_PUSCH_LEVEL_08,
SUM(RSSI_PUSCH_LEVEL_09) RSSI_PUSCH_LEVEL_09,
SUM(RSSI_PUSCH_LEVEL_10) RSSI_PUSCH_LEVEL_10,
SUM(RSSI_PUSCH_LEVEL_11) RSSI_PUSCH_LEVEL_11,
SUM(RSSI_PUSCH_LEVEL_12) RSSI_PUSCH_LEVEL_12,
SUM(RSSI_PUSCH_LEVEL_13) RSSI_PUSCH_LEVEL_13,
SUM(RSSI_PUSCH_LEVEL_14) RSSI_PUSCH_LEVEL_14,
SUM(RSSI_PUSCH_LEVEL_15) RSSI_PUSCH_LEVEL_15,
SUM(RSSI_PUSCH_LEVEL_16) RSSI_PUSCH_LEVEL_16,
SUM(RSSI_PUSCH_LEVEL_17) RSSI_PUSCH_LEVEL_17,
SUM(RSSI_PUSCH_LEVEL_18) RSSI_PUSCH_LEVEL_18,
SUM(RSSI_PUSCH_LEVEL_19) RSSI_PUSCH_LEVEL_19,
SUM(RSSI_PUSCH_LEVEL_20) RSSI_PUSCH_LEVEL_20,
SUM(RSSI_PUSCH_LEVEL_21) RSSI_PUSCH_LEVEL_21,
SUM(RSSI_PUSCH_LEVEL_22) RSSI_PUSCH_LEVEL_22,
SUM(SINR_PUCCH_LEVEL_1) SINR_PUCCH_LEVEL_1,
SUM(SINR_PUCCH_LEVEL_2) SINR_PUCCH_LEVEL_2,
SUM(SINR_PUCCH_LEVEL_3) SINR_PUCCH_LEVEL_3,

Page 11
Report Execution

SUM(SINR_PUCCH_LEVEL_4) SINR_PUCCH_LEVEL_4,
SUM(SINR_PUCCH_LEVEL_5) SINR_PUCCH_LEVEL_5,
SUM(SINR_PUCCH_LEVEL_6) SINR_PUCCH_LEVEL_6,
SUM(SINR_PUCCH_LEVEL_7) SINR_PUCCH_LEVEL_7,
SUM(SINR_PUCCH_LEVEL_8) SINR_PUCCH_LEVEL_8,
SUM(SINR_PUCCH_LEVEL_9) SINR_PUCCH_LEVEL_9,
SUM(SINR_PUCCH_LEVEL_10) SINR_PUCCH_LEVEL_10,
SUM(SINR_PUCCH_LEVEL_11) SINR_PUCCH_LEVEL_11,
SUM(SINR_PUCCH_LEVEL_12) SINR_PUCCH_LEVEL_12,
SUM(SINR_PUCCH_LEVEL_13) SINR_PUCCH_LEVEL_13,
SUM(SINR_PUCCH_LEVEL_14) SINR_PUCCH_LEVEL_14,
SUM(SINR_PUCCH_LEVEL_15) SINR_PUCCH_LEVEL_15,
SUM(SINR_PUCCH_LEVEL_16) SINR_PUCCH_LEVEL_16,
SUM(SINR_PUCCH_LEVEL_17) SINR_PUCCH_LEVEL_17,
SUM(SINR_PUCCH_LEVEL_18) SINR_PUCCH_LEVEL_18,
SUM(SINR_PUCCH_LEVEL_19) SINR_PUCCH_LEVEL_19,
SUM(SINR_PUCCH_LEVEL_20) SINR_PUCCH_LEVEL_20,
SUM(SINR_PUCCH_LEVEL_21) SINR_PUCCH_LEVEL_21,
SUM(SINR_PUCCH_LEVEL_22) SINR_PUCCH_LEVEL_22,
SUM(SINR_PUSCH_LEVEL_1) SINR_PUSCH_LEVEL_1,
SUM(SINR_PUSCH_LEVEL_2) SINR_PUSCH_LEVEL_2,
SUM(SINR_PUSCH_LEVEL_3) SINR_PUSCH_LEVEL_3,
SUM(SINR_PUSCH_LEVEL_4) SINR_PUSCH_LEVEL_4,
SUM(SINR_PUSCH_LEVEL_5) SINR_PUSCH_LEVEL_5,
SUM(SINR_PUSCH_LEVEL_6) SINR_PUSCH_LEVEL_6,
SUM(SINR_PUSCH_LEVEL_7) SINR_PUSCH_LEVEL_7,
SUM(SINR_PUSCH_LEVEL_8) SINR_PUSCH_LEVEL_8,
SUM(SINR_PUSCH_LEVEL_9) SINR_PUSCH_LEVEL_9,
SUM(SINR_PUSCH_LEVEL_10) SINR_PUSCH_LEVEL_10,
SUM(SINR_PUSCH_LEVEL_11) SINR_PUSCH_LEVEL_11,
SUM(SINR_PUSCH_LEVEL_12) SINR_PUSCH_LEVEL_12,
SUM(SINR_PUSCH_LEVEL_13) SINR_PUSCH_LEVEL_13,
SUM(SINR_PUSCH_LEVEL_14) SINR_PUSCH_LEVEL_14,
SUM(SINR_PUSCH_LEVEL_15) SINR_PUSCH_LEVEL_15,
SUM(SINR_PUSCH_LEVEL_16) SINR_PUSCH_LEVEL_16,
SUM(SINR_PUSCH_LEVEL_17) SINR_PUSCH_LEVEL_17,
SUM(SINR_PUSCH_LEVEL_18) SINR_PUSCH_LEVEL_18,
SUM(SINR_PUSCH_LEVEL_19) SINR_PUSCH_LEVEL_19,
SUM(SINR_PUSCH_LEVEL_20) SINR_PUSCH_LEVEL_20,
SUM(SINR_PUSCH_LEVEL_21) SINR_PUSCH_LEVEL_21,
SUM(SINR_PUSCH_LEVEL_22) SINR_PUSCH_LEVEL_22
from
( select distinct g.ws_gid, g.ws from (select
w.setname ws, leg.la_co_gid ws_gid
from
w_manual_sets w,
utp_legacy leg
where
w.int_id = leg.la_int_id) g ) g ,
utp_common_objects "plmn",
utp_common_objects "mrbts",
utp_common_objects "lnbts",
utp_common_objects "lncel",
noklte_ps_lpqul_lncel_hour p

Page 12
Report Execution

where
g.ws_gid = "lncel".co_gid and g.ws in ( 'LTE_CLUSTER_2B_4_7' )
and period_start_time >= to_date('2016/02/25 16:30:00', 'yyyy/mm/dd hh24:mi:ss')
and period_start_time < to_date('2016/03/03 16:30:00', 'yyyy/mm/dd hh24:mi:ss')
and "plmn".co_oc_id = 16
and "mrbts".co_gid = p.mrbts_id
and "mrbts".co_parent_gid = "plmn".co_gid
and "mrbts".co_oc_id = 3128
and "lnbts".co_gid = p.lnbts_id
and "lnbts".co_parent_gid = "mrbts".co_gid
and "lnbts".co_oc_id = 3129
and "lncel".co_gid = p.lncel_id
and "lncel".co_parent_gid = "lnbts".co_gid
and "lncel".co_oc_id = 3130
group by
to_date('2016/02/25 16:30:00', 'yyyy/mm/dd hh24:mi:ss'),
"mrbts".co_gid,
"lnbts".co_gid,
"lncel".co_gid,
g.ws
)a
group by
a.period_start_time,
a.lncel_gid
report from tmp tables
select
LPQUL.period_start_time period_start_time,
nvl("mrbts".co_name, nvl("mrbts".co_object_instance, 'NN('||"mrbts".co_gid||')')) "MRBTS name",
nvl("lnbts".co_name, nvl("lnbts".co_object_instance, 'NN('||"lnbts".co_gid||')')) "LNBTS name",
nvl("lncel".co_name, nvl("lncel".co_object_instance, 'NN('||"lncel".co_gid||')')) "LNCEL name",
LPQUL.lncel_gid, nvl("lncel".co_ext_dn, "lncel".co_dn) "DN",
to_number(decode( ((lpqul.rssi_pucch_level_01) + (lpqul.rssi_pucch_level_02) + (lpqul.rssi_pucch_level_0
to_number(decode( ((lpqul.rssi_pusch_level_01) + (lpqul.rssi_pusch_level_02) + (lpqul.rssi_pusch_level_0
to_number(decode( ((lpqul.sinr_pucch_level_1) + (lpqul.sinr_pucch_level_2) + (lpqul.sinr_pucch_level_3)
to_number(decode( ((lpqul.sinr_pusch_level_1) + (lpqul.sinr_pusch_level_2) + (lpqul.sinr_pusch_level_3)
to_number(decode( (lpqul.sinr_pusch_level_1 + lpqul.sinr_pusch_level_2 + lpqul.sinr_pusch_level_3 + lpq
to_number(decode( (lpqul.sinr_pusch_level_1 + lpqul.sinr_pusch_level_2 + lpqul.sinr_pusch_level_3 + lpq
to_number(decode( (lpqul.sinr_pusch_level_1 + lpqul.sinr_pusch_level_2 + lpqul.sinr_pusch_level_3 + lpq
from
utp_common_objects "mrbts",
utp_common_objects "lnbts",
utp_common_objects "lncel"
,
jf_LPQUL_0359136119 LPQUL
where
"lnbts".co_parent_gid = "mrbts".co_gid and
"lncel".co_parent_gid = "lnbts".co_gid and
LPQUL.lncel_gid = "lncel".co_gid

order by
2,1,3,4,5

Page 13
Report Execution

id||')')) "MRBTS name",


|')')) "LNBTS name",
')')) "LNCEL name",

el_02) + (lpqul.rssi_pucch_level_03) + (lpqul.rssi_pucch_level_04) + (lpqul.rssi_pucch_level_05) + (lpqul.rssi_pucch_level_06) + (lpqul.r


el_02) + (lpqul.rssi_pusch_level_03) + (lpqul.rssi_pusch_level_04) + (lpqul.rssi_pusch_level_05) + (lpqul.rssi_pusch_level_06) + (lpqul.r
_2) + (lpqul.sinr_pucch_level_3) + (lpqul.sinr_pucch_level_4) + (lpqul.sinr_pucch_level_5) + (lpqul.sinr_pucch_level_6) + (lpqul.sinr_pu
_2) + (lpqul.sinr_pusch_level_3) + (lpqul.sinr_pusch_level_4) + (lpqul.sinr_pusch_level_5) + (lpqul.sinr_pusch_level_6) + (lpqul.sinr_pu
+ lpqul.sinr_pusch_level_3 + lpqul.sinr_pusch_level_4 + lpqul.sinr_pusch_level_5 + lpqul.sinr_pusch_level_6 + lpqul.sinr_pusch_level_
+ lpqul.sinr_pusch_level_3 + lpqul.sinr_pusch_level_4 + lpqul.sinr_pusch_level_5 + lpqul.sinr_pusch_level_6 + lpqul.sinr_pusch_level_
+ lpqul.sinr_pusch_level_3 + lpqul.sinr_pusch_level_4 + lpqul.sinr_pusch_level_5 + lpqul.sinr_pusch_level_6 + lpqul.sinr_pusch_level_

Page 14
Report Execution

ul.rssi_pucch_level_06) + (lpqul.rssi_pucch_level_07) + (lpqul.rssi_pucch_level_08) + (lpqul.rssi_pucch_level_09) + (lpqul.rssi_pucch_le


ul.rssi_pusch_level_06) + (lpqul.rssi_pusch_level_07) + (lpqul.rssi_pusch_level_08) + (lpqul.rssi_pusch_level_09) + (lpqul.rssi_pusch_le
_pucch_level_6) + (lpqul.sinr_pucch_level_7) + (lpqul.sinr_pucch_level_8) + (lpqul.sinr_pucch_level_9) + (lpqul.sinr_pucch_level_10) +
_pusch_level_6) + (lpqul.sinr_pusch_level_7) + (lpqul.sinr_pusch_level_8) + (lpqul.sinr_pusch_level_9) + (lpqul.sinr_pusch_level_10) +
_level_6 + lpqul.sinr_pusch_level_7 + lpqul.sinr_pusch_level_8 + lpqul.sinr_pusch_level_9 + lpqul.sinr_pusch_level_10 + lpqul.sinr_pus
_level_6 + lpqul.sinr_pusch_level_7 + lpqul.sinr_pusch_level_8 + lpqul.sinr_pusch_level_9 + lpqul.sinr_pusch_level_10 + lpqul.sinr_pus
_level_6 + lpqul.sinr_pusch_level_7 + lpqul.sinr_pusch_level_8 + lpqul.sinr_pusch_level_9 + lpqul.sinr_pusch_level_10 + lpqul.sinr_pus

Page 15
Report Execution

h_level_09) + (lpqul.rssi_pucch_level_10) + (lpqul.rssi_pucch_level_11) + (lpqul.rssi_pucch_level_12) + (lpqul.rssi_pucch_level_13) + (l


h_level_09) + (lpqul.rssi_pusch_level_10) + (lpqul.rssi_pusch_level_11) + (lpqul.rssi_pusch_level_12) + (lpqul.rssi_pusch_level_13) + (l
) + (lpqul.sinr_pucch_level_10) + (lpqul.sinr_pucch_level_11) + (lpqul.sinr_pucch_level_12) + (lpqul.sinr_pucch_level_13) + (lpqul.sinr_
) + (lpqul.sinr_pusch_level_10) + (lpqul.sinr_pusch_level_11) + (lpqul.sinr_pusch_level_12) + (lpqul.sinr_pusch_level_13) + (lpqul.sinr_
_pusch_level_10 + lpqul.sinr_pusch_level_11 + lpqul.sinr_pusch_level_12 + lpqul.sinr_pusch_level_13 + lpqul.sinr_pusch_level_14 + lp
_pusch_level_10 + lpqul.sinr_pusch_level_11 + lpqul.sinr_pusch_level_12 + lpqul.sinr_pusch_level_13 + lpqul.sinr_pusch_level_14 + lp
_pusch_level_10 + lpqul.sinr_pusch_level_11 + lpqul.sinr_pusch_level_12 + lpqul.sinr_pusch_level_13 + lpqul.sinr_pusch_level_14 + lp

Page 16
Report Execution

+ (lpqul.rssi_pucch_level_13) + (lpqul.rssi_pucch_level_14) + (lpqul.rssi_pucch_level_15) + (lpqul.rssi_pucch_level_16) + (lpqul.rssi_pu


+ (lpqul.rssi_pusch_level_13) + (lpqul.rssi_pusch_level_14) + (lpqul.rssi_pusch_level_15) + (lpqul.rssi_pusch_level_16) + (lpqul.rssi_pu
nr_pucch_level_13) + (lpqul.sinr_pucch_level_14) + (lpqul.sinr_pucch_level_15) + (lpqul.sinr_pucch_level_16) + (lpqul.sinr_pucch_level
nr_pusch_level_13) + (lpqul.sinr_pusch_level_14) + (lpqul.sinr_pusch_level_15) + (lpqul.sinr_pusch_level_16) + (lpqul.sinr_pusch_level
+ lpqul.sinr_pusch_level_14 + lpqul.sinr_pusch_level_15 + lpqul.sinr_pusch_level_16 + lpqul.sinr_pusch_level_17 + lpqul.sinr_pusch_l
+ lpqul.sinr_pusch_level_14 + lpqul.sinr_pusch_level_15 + lpqul.sinr_pusch_level_16 + lpqul.sinr_pusch_level_17 + lpqul.sinr_pusch_l
+ lpqul.sinr_pusch_level_14 + lpqul.sinr_pusch_level_15 + lpqul.sinr_pusch_level_16 + lpqul.sinr_pusch_level_17 + lpqul.sinr_pusch_l

Page 17
Report Execution

pucch_level_16) + (lpqul.rssi_pucch_level_17) + (lpqul.rssi_pucch_level_18) + (lpqul.rssi_pucch_level_19) + (lpqul.rssi_pucch_level_20


pusch_level_16) + (lpqul.rssi_pusch_level_17) + (lpqul.rssi_pusch_level_18) + (lpqul.rssi_pusch_level_19) + (lpqul.rssi_pusch_level_20
vel_16) + (lpqul.sinr_pucch_level_17) + (lpqul.sinr_pucch_level_18) + (lpqul.sinr_pucch_level_19) + (lpqul.sinr_pucch_level_20) + (lpqu
vel_16) + (lpqul.sinr_pusch_level_17) + (lpqul.sinr_pusch_level_18) + (lpqul.sinr_pusch_level_19) + (lpqul.sinr_pusch_level_20) + (lpqu
ch_level_17 + lpqul.sinr_pusch_level_18 + lpqul.sinr_pusch_level_19 + lpqul.sinr_pusch_level_20 + lpqul.sinr_pusch_level_21 + lpqul.s
ch_level_17 + lpqul.sinr_pusch_level_18 + lpqul.sinr_pusch_level_19 + lpqul.sinr_pusch_level_20 + lpqul.sinr_pusch_level_21 + lpqul.s
ch_level_17 + lpqul.sinr_pusch_level_18 + lpqul.sinr_pusch_level_19 + lpqul.sinr_pusch_level_20 + lpqul.sinr_pusch_level_21 + lpqul.s

Page 18
Report Execution

_19) + (lpqul.rssi_pucch_level_20) + (lpqul.rssi_pucch_level_21) + (lpqul.rssi_pucch_level_22)),0,null, ( - 120*(lpqul.rssi_pucch_level_0


_19) + (lpqul.rssi_pusch_level_20) + (lpqul.rssi_pusch_level_21) + (lpqul.rssi_pusch_level_22)),0,null, ( - 120*(lpqul.rssi_pusch_level_0
pqul.sinr_pucch_level_20) + (lpqul.sinr_pucch_level_21) + (lpqul.sinr_pucch_level_22)),0,null, (-10*(lpqul.sinr_pucch_level_1) - 9*(lpqul
pqul.sinr_pusch_level_20) + (lpqul.sinr_pusch_level_21) + (lpqul.sinr_pusch_level_22)),0,null, (-10*(lpqul.sinr_pusch_level_1) - 9*(lpqul
qul.sinr_pusch_level_21 + lpqul.sinr_pusch_level_22),0,null, 100*(lpqul.sinr_pusch_level_14 + lpqul.sinr_pusch_level_15 + lpqul.sinr_p
qul.sinr_pusch_level_21 + lpqul.sinr_pusch_level_22),0,null, 100*(lpqul.sinr_pusch_level_8 + lpqul.sinr_pusch_level_9 + lpqul.sinr_pus
qul.sinr_pusch_level_21 + lpqul.sinr_pusch_level_22),0,null, (100*(lpqul.sinr_pusch_level_1 + lpqul.sinr_pusch_level_2 + lpqul.sinr_pu

Page 19
Report Execution

( - 120*(lpqul.rssi_pucch_level_01) - 119*(lpqul.rssi_pucch_level_02) - 117*(lpqul.rssi_pucch_level_03) - 115*(lpqul.rssi_pucch_level_0


( - 120*(lpqul.rssi_pusch_level_01) - 119*(lpqul.rssi_pusch_level_02) - 117*(lpqul.rssi_pusch_level_03) - 115*(lpqul.rssi_pusch_level_0
qul.sinr_pucch_level_1) - 9*(lpqul.sinr_pucch_level_2) - 7*(lpqul.sinr_pucch_level_3) - 5*(lpqul.sinr_pucch_level_4) - 3*(lpqul.sinr_pucch
qul.sinr_pusch_level_1) - 9*(lpqul.sinr_pusch_level_2) - 7*(lpqul.sinr_pusch_level_3) - 5*(lpqul.sinr_pusch_level_4) - 3*(lpqul.sinr_pusch
nr_pusch_level_15 + lpqul.sinr_pusch_level_16 + lpqul.sinr_pusch_level_17 + lpqul.sinr_pusch_level_18 + lpqul.sinr_pusch_level_19 +
r_pusch_level_9 + lpqul.sinr_pusch_level_10 + lpqul.sinr_pusch_level_11 + lpqul.sinr_pusch_level_12 + lpqul.sinr_pusch_level_13 ) / (
nr_pusch_level_2 + lpqul.sinr_pusch_level_3 + lpqul.sinr_pusch_level_4 + lpqul.sinr_pusch_level_5 + lpqul.sinr_pusch_level_6 + lpqul.

Page 20
Report Execution

) - 115*(lpqul.rssi_pucch_level_04) - 113*(lpqul.rssi_pucch_level_05) - 111*(lpqul.rssi_pucch_level_06) - 109*(lpqul.rssi_pucch_level_07


) - 115*(lpqul.rssi_pusch_level_04) - 113*(lpqul.rssi_pusch_level_05) - 111*(lpqul.rssi_pusch_level_06) - 109*(lpqul.rssi_pusch_level_07
cch_level_4) - 3*(lpqul.sinr_pucch_level_5) - 1*(lpqul.sinr_pucch_level_6) + 1*(lpqul.sinr_pucch_level_7) + 3*(lpqul.sinr_pucch_level_8)
sch_level_4) - 3*(lpqul.sinr_pusch_level_5) - 1*(lpqul.sinr_pusch_level_6) + 1*(lpqul.sinr_pusch_level_7) + 3*(lpqul.sinr_pusch_level_8)
_18 + lpqul.sinr_pusch_level_19 + lpqul.sinr_pusch_level_20 + lpqul.sinr_pusch_level_21 + lpqul.sinr_pusch_level_22) / (lpqul.sinr_pus
2 + lpqul.sinr_pusch_level_13 ) / (lpqul.sinr_pusch_level_1 + lpqul.sinr_pusch_level_2 + lpqul.sinr_pusch_level_3 + lpqul.sinr_pusch_lev
lpqul.sinr_pusch_level_6 + lpqul.sinr_pusch_level_7)) / (lpqul.sinr_pusch_level_1 + lpqul.sinr_pusch_level_2 + lpqul.sinr_pusch_level_3

Page 21
Report Execution

) - 109*(lpqul.rssi_pucch_level_07) - 107*(lpqul.rssi_pucch_level_08) - 105*(lpqul.rssi_pucch_level_09) - 103*(lpqul.rssi_p...


) - 109*(lpqul.rssi_pusch_level_07) - 107*(lpqul.rssi_pusch_level_08) - 105*(lpqul.rssi_pusch_level_09) - 103*(lpqul.rssi_p...
7) + 3*(lpqul.sinr_pucch_level_8) + 5*(lpqul.sinr_pucch_level_9) + 7*(lpqul.sinr_pucch_level_10) + 9*(lpqul.sinr_pucch_le...
7) + 3*(lpqul.sinr_pusch_level_8) + 5*(lpqul.sinr_pusch_level_9) + 7*(lpqul.sinr_pusch_level_10) + 9*(lpqul.sinr_pusch_le...
pusch_level_22) / (lpqul.sinr_pusch_level_1 + lpqul.sinr_pusch_level_2 + lpqul.sinr_pusch_level_3 + lpqul.sinr_pusch_level_4 + lpqul.s
ch_level_3 + lpqul.sinr_pusch_level_4 + lpqul.sinr_pusch_level_5 + lpqul.sinr_pusch_level_6 + lpqul.sinr_pusch_level_7 + lpqul.sinr_pu
evel_2 + lpqul.sinr_pusch_level_3 + lpqul.sinr_pusch_level_4 + lpqul.sinr_pusch_level_5 + lpqul.sinr_pusch_level_6 + lpqul.sinr_pusch

Page 22
Report Execution

) - 103*(lpqul.rssi_p...
) - 103*(lpqul.rssi_p...
pqul.sinr_pucch_le...
pqul.sinr_pusch_le...
pqul.sinr_pusch_level_4 + lpqul.sinr_pu...
nr_pusch_level_7 + lpqul.sinr_pusch_...
pusch_level_6 + lpqul.sinr_pusch_lev...

Page 23

You might also like