2 DEFINE{ query_name 'rrcx_pdf_neigh_cell_csi'; }
4 // rsrp, rsrq, sinr ranges are 0 .. 127
5 // for now divide into 5 bins.
7 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
10 sum(GEQ(rsrp, 0)*LEQ(rsrp,37)) as rsrp_vbad,
11 sum(GEQ(rsrp,38)*LEQ(rsrp,52)) as rsrp_bad,
12 sum(GEQ(rsrp,52)*LEQ(rsrp,67)) as rsrp_medium,
13 sum(GEQ(rsrp,68)*LEQ(rsrp,82)) as rsrp_good,
14 sum(GEQ(rsrp,83)*LEQ(rsrp,127)) as rsrp_vgood
15 from RRCXFER.neighbor_beam_csi
17 group by timestamp_ms/$window as tb, physCellId
20 DEFINE{ query_name 'rrcx_pdf_neigh_gnb_csi'; }
22 // rsrp, rsrq, sinr ranges are 0 .. 127
23 // for now divide into 5 bins.
25 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
28 sum(GEQ(rsrp, 0)*LEQ(rsrp,37)) as rsrp_vbad,
29 sum(GEQ(rsrp,38)*LEQ(rsrp,52)) as rsrp_bad,
30 sum(GEQ(rsrp,52)*LEQ(rsrp,67)) as rsrp_medium,
31 sum(GEQ(rsrp,68)*LEQ(rsrp,82)) as rsrp_good,
32 sum(GEQ(rsrp,83)*LEQ(rsrp,127)) as rsrp_vgood
33 from RRCXFER.neighbor_beam_csi
35 group by timestamp_ms/$window as tb, gnb_id
39 DEFINE{ query_name 'rrcx_pdf_neigh_cell_ssb'; }
41 // rsrp, rsrq, sinr ranges are 0 .. 127
42 // for now divide into 5 bins.
44 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
45 physCellId as CELL_ID,
47 sum(GEQ(rsrp, 0)*LEQ(rsrp,37)) as rsrp_vbad,
48 sum(GEQ(rsrp,38)*LEQ(rsrp,52)) as rsrp_bad,
49 sum(GEQ(rsrp,52)*LEQ(rsrp,67)) as rsrp_medium,
50 sum(GEQ(rsrp,68)*LEQ(rsrp,82)) as rsrp_good,
51 sum(GEQ(rsrp,83)*LEQ(rsrp,127)) as rsrp_vgood
52 from RRCXFER.neighbor_beam_ssb
54 group by timestamp_ms/$window as tb, physCellId
57 DEFINE{ query_name 'rrcx_pdf_neigh_gnb_ssb'; }
59 // rsrp, rsrq, sinr ranges are 0 .. 127
60 // for now divide into 5 bins.
62 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
65 sum(GEQ(rsrp, 0)*LEQ(rsrp,37)) as rsrp_vbad,
66 sum(GEQ(rsrp,38)*LEQ(rsrp,52)) as rsrp_bad,
67 sum(GEQ(rsrp,52)*LEQ(rsrp,67)) as rsrp_medium,
68 sum(GEQ(rsrp,68)*LEQ(rsrp,82)) as rsrp_good,
69 sum(GEQ(rsrp,83)*LEQ(rsrp,127)) as rsrp_vgood
70 from RRCXFER.neighbor_beam_ssb
72 group by timestamp_ms/$window as tb, gnb_id
77 DEFINE{ query_name 'rrcx_pdf_serv_cell'; }
79 // rsrp, rsrq, sinr ranges are 0 .. 127
80 // for now divide into 5 bins.
82 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
83 physCellId as CELL_ID,
85 sum(GEQ(rsrp, 0)*LEQ(rsrp,21)) as rsrp_vbad,
86 sum(GEQ(rsrp,22)*LEQ(rsrp,36)) as rsrp_bad,
87 sum(GEQ(rsrp,37)*LEQ(rsrp,51)) as rsrp_medium,
88 sum(GEQ(rsrp,52)*LEQ(rsrp,66)) as rsrp_good,
89 sum(GEQ(rsrp,67)*LEQ(rsrp,127)) as rsrp_vgood
90 from RRCXFER.serv_nr_cell
92 group by timestamp_ms/$window as tb, physCellId
95 DEFINE{ query_name 'rrcx_pdf_serv_gnb'; }
97 // rsrp, rsrq, sinr ranges are 0 .. 127
98 // for now divide into 5 bins.
100 select ($window*(tb+1))/1000 as TS, $window/1000.0 as measurementInterval,
103 sum(GEQ(rsrp, 0)*LEQ(rsrp,21)) as rsrp_vbad,
104 sum(GEQ(rsrp,22)*LEQ(rsrp,36)) as rsrp_bad,
105 sum(GEQ(rsrp,37)*LEQ(rsrp,51)) as rsrp_medium,
106 sum(GEQ(rsrp,52)*LEQ(rsrp,66)) as rsrp_good,
107 sum(GEQ(rsrp,67)*LEQ(rsrp,127)) as rsrp_vgood
108 from RRCXFER.serv_nr_cell
110 group by timestamp_ms/$window as tb, gnb_id