We are using a directional antenna on a rotator which feeds into a Cell Signal analyzer. The dashboard we created shows the trend of the rotator angle and the readings from the analyzer. The final part of the dashboard shows the correlated analyzer to the rotator angle. When on a site with limited RF interference this worked great. However, when we got a site with more cell towers and PCI readings being returned the dashboard is taking an extended time (over 3 minutes) to load if it displays at all. Is there a better way to correlate data between two elements trend results than what is shown below?
At the moment we are using the following GQI with the join function:
Step 1 - AngleToRSRP collects the Trend Data from the rotator and sets the Start time to hh:mm to avoid mismatch on seconds. Thought about taking this further to group at 10-minute intervals.
Step 2: AngleToRotator2, joins the rotator trend with the CellScanner trend data
Resulting display, the center table shows time, angle and analyzer reading based on PCI selected from left table. The two side shapes take 3 minutes to populate, then the center table takes another 5 minutes to populate.
I think the main performance hit will be the following:
Currently the filter on ElementID won't get executed efficiently, since it will apply postfiltering. We have following task on our backlog to make it more efficient: https://collaboration.dataminer.services/task/193453
In order to better understand what takes most time during the execution of these queries, we would need to have a GQI recording: https://docs.dataminer.services/user-guide/Troubleshooting/Troubleshooting_Flowcharts/Troubleshooting_Process_Identification/Other_processes/Troubleshooting_SLHelper_exe.html#recording-a-gqi-session
Feel free to provide the recording to us through email@example.com
Best regards, Ward