2 DEFINE{ query_name 'rrcx_pdf_neigh_cell_csi';
3 max_lfta_disorder '1'; max_hfta_disorder '1';
6 // rsrp, rsrq, sinr ranges are 0 .. 127
7 // for now divide into 5 bins.
9 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
10 physCellId as CELL_ID,
12 sum(GEQ(rsrp, 0)*LEQ(rsrp,37)) as rsrp_vbad,
13 sum(GEQ(rsrp,38)*LEQ(rsrp,52)) as rsrp_bad,
14 sum(GEQ(rsrp,52)*LEQ(rsrp,67)) as rsrp_medium,
15 sum(GEQ(rsrp,68)*LEQ(rsrp,82)) as rsrp_good,
16 sum(GEQ(rsrp,83)*LEQ(rsrp,127)) as rsrp_vgood
17 from RRCXFER.neighbor_beam_csi
19 group by timestamp_ms/$window as tb, physCellId
22 DEFINE{ query_name 'rrcx_pdf_neigh_gnb_csi';
23 max_lfta_disorder '1'; max_hfta_disorder '1';
26 // rsrp, rsrq, sinr ranges are 0 .. 127
27 // for now divide into 5 bins.
29 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
32 sum(GEQ(rsrp, 0)*LEQ(rsrp,37)) as rsrp_vbad,
33 sum(GEQ(rsrp,38)*LEQ(rsrp,52)) as rsrp_bad,
34 sum(GEQ(rsrp,52)*LEQ(rsrp,67)) as rsrp_medium,
35 sum(GEQ(rsrp,68)*LEQ(rsrp,82)) as rsrp_good,
36 sum(GEQ(rsrp,83)*LEQ(rsrp,127)) as rsrp_vgood
37 from RRCXFER.neighbor_beam_csi
39 group by timestamp_ms/$window as tb, gnb_id
43 DEFINE{ query_name 'rrcx_pdf_neigh_cell_ssb';
44 max_lfta_disorder '1'; max_hfta_disorder '1';
47 // rsrp, rsrq, sinr ranges are 0 .. 127
48 // for now divide into 5 bins.
50 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
51 physCellId as CELL_ID,
53 sum(GEQ(rsrp, 0)*LEQ(rsrp,37)) as rsrp_vbad,
54 sum(GEQ(rsrp,38)*LEQ(rsrp,52)) as rsrp_bad,
55 sum(GEQ(rsrp,52)*LEQ(rsrp,67)) as rsrp_medium,
56 sum(GEQ(rsrp,68)*LEQ(rsrp,82)) as rsrp_good,
57 sum(GEQ(rsrp,83)*LEQ(rsrp,127)) as rsrp_vgood
58 from RRCXFER.neighbor_beam_ssb
60 group by timestamp_ms/$window as tb, physCellId
63 DEFINE{ query_name 'rrcx_pdf_neigh_gnb_ssb';
64 max_lfta_disorder '1'; max_hfta_disorder '1';
67 // rsrp, rsrq, sinr ranges are 0 .. 127
68 // for now divide into 5 bins.
70 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
73 sum(GEQ(rsrp, 0)*LEQ(rsrp,37)) as rsrp_vbad,
74 sum(GEQ(rsrp,38)*LEQ(rsrp,52)) as rsrp_bad,
75 sum(GEQ(rsrp,52)*LEQ(rsrp,67)) as rsrp_medium,
76 sum(GEQ(rsrp,68)*LEQ(rsrp,82)) as rsrp_good,
77 sum(GEQ(rsrp,83)*LEQ(rsrp,127)) as rsrp_vgood
78 from RRCXFER.neighbor_beam_ssb
80 group by timestamp_ms/$window as tb, gnb_id
85 DEFINE{ query_name 'rrcx_pdf_serv_cell';
86 max_lfta_disorder '1'; max_hfta_disorder '1';
89 // rsrp, rsrq, sinr ranges are 0 .. 127
90 // for now divide into 5 bins.
92 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
93 physCellId as CELL_ID,
95 sum(GEQ(rsrp, 0)*LEQ(rsrp,21)) as rsrp_vbad,
96 sum(GEQ(rsrp,22)*LEQ(rsrp,36)) as rsrp_bad,
97 sum(GEQ(rsrp,37)*LEQ(rsrp,51)) as rsrp_medium,
98 sum(GEQ(rsrp,52)*LEQ(rsrp,66)) as rsrp_good,
99 sum(GEQ(rsrp,67)*LEQ(rsrp,127)) as rsrp_vgood
100 from RRCXFER.serv_nr_cell
102 group by timestamp_ms/$window as tb, physCellId
105 DEFINE{ query_name 'rrcx_pdf_neighbor_cell';
106 max_lfta_disorder '1'; max_hfta_disorder '1';
109 // rsrp, rsrq, sinr ranges are 0 .. 127
110 // for now divide into 5 bins.
112 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
113 physCellId as CELL_ID,
115 sum(GEQ(rsrp, 0)*LEQ(rsrp,21)) as rsrp_vbad,
116 sum(GEQ(rsrp,22)*LEQ(rsrp,36)) as rsrp_bad,
117 sum(GEQ(rsrp,37)*LEQ(rsrp,51)) as rsrp_medium,
118 sum(GEQ(rsrp,52)*LEQ(rsrp,66)) as rsrp_good,
119 sum(GEQ(rsrp,67)*LEQ(rsrp,127)) as rsrp_vgood
120 from RRCXFER.nr_neighbor
122 group by timestamp_ms/$window as tb, physCellId
126 DEFINE{ query_name 'rrcx_pdf_serv_gnb';
127 max_lfta_disorder '1'; max_hfta_disorder '1';
130 // rsrp, rsrq, sinr ranges are 0 .. 127
131 // for now divide into 5 bins.
133 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
136 sum(GEQ(rsrp, 0)*LEQ(rsrp,21)) as rsrp_vbad,
137 sum(GEQ(rsrp,22)*LEQ(rsrp,36)) as rsrp_bad,
138 sum(GEQ(rsrp,37)*LEQ(rsrp,51)) as rsrp_medium,
139 sum(GEQ(rsrp,52)*LEQ(rsrp,66)) as rsrp_good,
140 sum(GEQ(rsrp,67)*LEQ(rsrp,127)) as rsrp_vgood
141 from RRCXFER.serv_nr_cell
143 group by timestamp_ms/$window as tb, gnb_id
146 DEFINE{ query_name 'rrcx_pdf_neighbor_gnb';
147 max_lfta_disorder '1'; max_hfta_disorder '1';
150 // rsrp, rsrq, sinr ranges are 0 .. 127
151 // for now divide into 5 bins.
153 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
156 sum(GEQ(rsrp, 0)*LEQ(rsrp,21)) as rsrp_vbad,
157 sum(GEQ(rsrp,22)*LEQ(rsrp,36)) as rsrp_bad,
158 sum(GEQ(rsrp,37)*LEQ(rsrp,51)) as rsrp_medium,
159 sum(GEQ(rsrp,52)*LEQ(rsrp,66)) as rsrp_good,
160 sum(GEQ(rsrp,67)*LEQ(rsrp,127)) as rsrp_vgood
161 from RRCXFER.nr_neighbor
163 group by timestamp_ms/$window as tb, gnb_id