Example of Query Power 3G Data ENIQ with Vector INDEX

The following is an example of an Ericsson ENIQ SQL Query for finding the daily aggregated Power Average in Watts and dBm.
  SELECT Date_ID,RNC,RBS,Sector,Carrier,
cast((SUM(A_0)+SUM(A_1)+SUM(A_2)+SUM(A_3)+SUM(A_4)+SUM(A_5)+SUM(A_6)+SUM(A_7)+SUM(A_8)+SUM(A_9)+SUM(A_10)+SUM(A_11)+SUM(A_12)+SUM(A_13)+SUM(A_14)+SUM(A_15)+SUM(A_16)+SUM(A_17)+SUM(A_18)+SUM(A_19)+SUM(A_20)+SUM(A_21)+SUM(A_22)+SUM(A_23)+SUM(A_24)+SUM(A_25)+SUM(A_26)+SUM(A_27)+SUM(A_28)+SUM(A_29)+SUM(A_30)+SUM(A_31)+SUM(A_32)+SUM(A_33)+SUM(A_34)+SUM(A_35)+SUM(A_36)+SUM(A_37)+SUM(A_38)+SUM(A_39)+SUM(A_40)+SUM(A_41)+SUM(A_42)+SUM(A_43)+SUM(A_44)+SUM(A_45)+SUM(A_46)+SUM(A_47)+SUM(A_48)+SUM(A_49)+SUM(A_50)+SUM(A_51)) as float) as TS,

 cast (((SUM(A_0) * 0) +(SUM(A_1) * 0.5) +(SUM(A_2) * 1.5) +(SUM(A_3) * 2.5) +(SUM(A_4) * 3.5) +(SUM(A_5) * 4.5) +(SUM(A_6) * 5.5) +(SUM(A_7) * 6.5) +(SUM(A_8) * 7.5) +(SUM(A_9) * 8.5) +(SUM(A_10) * 9.5) +(SUM(A_11) * 10.5) +(SUM(A_12) * 11.5) +(SUM(A_13) * 12.5) +(SUM(A_14) * 13.5) +(SUM(A_15) * 14.5) +(SUM(A_16) * 15.5) +(SUM(A_17) * 16.5) +(SUM(A_18) * 17.5) +(SUM(A_19) * 18.5) +(SUM(A_20) * 19.5) +(SUM(A_21) * 20.5) +(SUM(A_22) * 21.5) +(SUM(A_23) * 22.5) +(SUM(A_24) * 23.5) +(SUM(A_25) * 24.5) +(SUM(A_26) * 25.5) +(SUM(A_27) * 26.5) +(SUM(A_28) * 27.5) +(SUM(A_29) * 28.5) +(SUM(A_30) * 29.5) +(SUM(A_31) * 30.5) +(SUM(A_32) * 31.5) +(SUM(A_33) * 32.5) +(SUM(A_34) * 33.5) +(SUM(A_35) * 34.5) +(SUM(A_36) * 35.5) +(SUM(A_37) * 36.5) +(SUM(A_38) * 37.5) +(SUM(A_39) * 38.5) +(SUM(A_40) * 39.5) +(SUM(A_41) * 40.5) +(SUM(A_42) * 41.5) +(SUM(A_43) * 42.5) +(SUM(A_44) * 43.5) +(SUM(A_45) * 44.5) +(SUM(A_46) * 45.5) +(SUM(A_47) * 46.5) +(SUM(A_48) * 47.5) +(SUM(A_49) * 48.5) +(SUM(A_50) * 49.5) +(SUM(A_51) * 50)) as float) as Wgtd ,

cast((Wgtd/TS) as dec (19,2)) as Power_Total_avg_dBm,
cast(((POWER(10,(Power_Total_avg_dBm/10)))/1000) as dec(19,2)) as Power_Total_avg_Watt, 

 SUM(A_0) as pm_0, SUM(A_1) as pm_1, SUM(A_2) as pm_2, SUM(A_3) as pm_3, SUM(A_4) as pm_4, SUM(A_5) as pm_5, SUM(A_6) as pm_6, SUM(A_7) as pm_7, SUM(A_8) as pm_8, SUM(A_9) as pm_9, SUM(A_10) as pm_10, SUM(A_11) as pm_11, SUM(A_12) as pm_12, SUM(A_13) as pm_13, SUM(A_14) as pm_14, SUM(A_15) as pm_15, SUM(A_16) as pm_16, SUM(A_17) as pm_17, SUM(A_18) as pm_18, SUM(A_19) as pm_19, SUM(A_20) as pm_20, SUM(A_21) as pm_21, SUM(A_22) as pm_22, SUM(A_23) as pm_23, SUM(A_24) as pm_24, SUM(A_25) as pm_25, SUM(A_26) as pm_26, SUM(A_27) as pm_27, SUM(A_28) as pm_28, SUM(A_29) as pm_29, SUM(A_30) as pm_30, SUM(A_31) as pm_31, SUM(A_32) as pm_32, SUM(A_33) as pm_33, SUM(A_34) as pm_34, SUM(A_35) as pm_35, SUM(A_36) as pm_36, SUM(A_37) as pm_37, SUM(A_38) as pm_38, SUM(A_39) as pm_39, SUM(A_40) as pm_40, SUM(A_41) as pm_41, SUM(A_42) as pm_42, SUM(A_43) as pm_43, SUM(A_44) as pm_44, SUM(A_45) as pm_45, SUM(A_46) as pm_46, SUM(A_47) as pm_47, SUM(A_48) as pm_48, SUM(A_49) as pm_49, SUM(A_50) as pm_50, SUM(A_51) as pm_51 

 FROM
 ( SELECT Date_ID,RNC,RBS,Sector,Carrier, 
 CASE WHEN (DCVECTOR_INDEX =0) THEN (pmTransmittedCarrierPower) END AS A_0, 
 CASE WHEN (DCVECTOR_INDEX =1) THEN (pmTransmittedCarrierPower) END AS A_1, 
 CASE WHEN (DCVECTOR_INDEX =2) THEN (pmTransmittedCarrierPower) END AS A_2, 
 CASE WHEN (DCVECTOR_INDEX =3) THEN (pmTransmittedCarrierPower) END AS A_3, 
 CASE WHEN (DCVECTOR_INDEX =4) THEN (pmTransmittedCarrierPower) END AS A_4, 
 CASE WHEN (DCVECTOR_INDEX =5) THEN (pmTransmittedCarrierPower) END AS A_5, 
 CASE WHEN (DCVECTOR_INDEX =6) THEN (pmTransmittedCarrierPower) END AS A_6, 
 CASE WHEN (DCVECTOR_INDEX =7) THEN (pmTransmittedCarrierPower) END AS A_7, 
 CASE WHEN (DCVECTOR_INDEX =8) THEN (pmTransmittedCarrierPower) END AS A_8, 
 CASE WHEN (DCVECTOR_INDEX =9) THEN (pmTransmittedCarrierPower) END AS A_9, 
 CASE WHEN (DCVECTOR_INDEX =10) THEN (pmTransmittedCarrierPower) END AS A_10, 
 CASE WHEN (DCVECTOR_INDEX =11) THEN (pmTransmittedCarrierPower) END AS A_11, 
 CASE WHEN (DCVECTOR_INDEX =12) THEN (pmTransmittedCarrierPower) END AS A_12, 
 CASE WHEN (DCVECTOR_INDEX =13) THEN (pmTransmittedCarrierPower) END AS A_13, 
 CASE WHEN (DCVECTOR_INDEX =14) THEN (pmTransmittedCarrierPower) END AS A_14, 
 CASE WHEN (DCVECTOR_INDEX =15) THEN (pmTransmittedCarrierPower) END AS A_15, 
 CASE WHEN (DCVECTOR_INDEX =16) THEN (pmTransmittedCarrierPower) END AS A_16, 
 CASE WHEN (DCVECTOR_INDEX =17) THEN (pmTransmittedCarrierPower) END AS A_17, 
 CASE WHEN (DCVECTOR_INDEX =18) THEN (pmTransmittedCarrierPower) END AS A_18, 
 CASE WHEN (DCVECTOR_INDEX =19) THEN (pmTransmittedCarrierPower) END AS A_19, 
 CASE WHEN (DCVECTOR_INDEX =20) THEN (pmTransmittedCarrierPower) END AS A_20, 
 CASE WHEN (DCVECTOR_INDEX =21) THEN (pmTransmittedCarrierPower) END AS A_21, 
 CASE WHEN (DCVECTOR_INDEX =22) THEN (pmTransmittedCarrierPower) END AS A_22, 
 CASE WHEN (DCVECTOR_INDEX =23) THEN (pmTransmittedCarrierPower) END AS A_23, 
 CASE WHEN (DCVECTOR_INDEX =24) THEN (pmTransmittedCarrierPower) END AS A_24, 
 CASE WHEN (DCVECTOR_INDEX =25) THEN (pmTransmittedCarrierPower) END AS A_25, 
 CASE WHEN (DCVECTOR_INDEX =26) THEN (pmTransmittedCarrierPower) END AS A_26, 
 CASE WHEN (DCVECTOR_INDEX =27) THEN (pmTransmittedCarrierPower) END AS A_27, 
 CASE WHEN (DCVECTOR_INDEX =28) THEN (pmTransmittedCarrierPower) END AS A_28, 
 CASE WHEN (DCVECTOR_INDEX =29) THEN (pmTransmittedCarrierPower) END AS A_29, 
 CASE WHEN (DCVECTOR_INDEX =30) THEN (pmTransmittedCarrierPower) END AS A_30, 
 CASE WHEN (DCVECTOR_INDEX =31) THEN (pmTransmittedCarrierPower) END AS A_31, 
 CASE WHEN (DCVECTOR_INDEX =32) THEN (pmTransmittedCarrierPower) END AS A_32, 
 CASE WHEN (DCVECTOR_INDEX =33) THEN (pmTransmittedCarrierPower) END AS A_33, 
 CASE WHEN (DCVECTOR_INDEX =34) THEN (pmTransmittedCarrierPower) END AS A_34, 
 CASE WHEN (DCVECTOR_INDEX =35) THEN (pmTransmittedCarrierPower) END AS A_35, 
 CASE WHEN (DCVECTOR_INDEX =36) THEN (pmTransmittedCarrierPower) END AS A_36, 
 CASE WHEN (DCVECTOR_INDEX =37) THEN (pmTransmittedCarrierPower) END AS A_37, 
 CASE WHEN (DCVECTOR_INDEX =38) THEN (pmTransmittedCarrierPower) END AS A_38, 
 CASE WHEN (DCVECTOR_INDEX =39) THEN (pmTransmittedCarrierPower) END AS A_39, 
 CASE WHEN (DCVECTOR_INDEX =40) THEN (pmTransmittedCarrierPower) END AS A_40, 
 CASE WHEN (DCVECTOR_INDEX =41) THEN (pmTransmittedCarrierPower) END AS A_41, 
 CASE WHEN (DCVECTOR_INDEX =42) THEN (pmTransmittedCarrierPower) END AS A_42, 
 CASE WHEN (DCVECTOR_INDEX =43) THEN (pmTransmittedCarrierPower) END AS A_43, 
 CASE WHEN (DCVECTOR_INDEX =44) THEN (pmTransmittedCarrierPower) END AS A_44, 
 CASE WHEN (DCVECTOR_INDEX =45) THEN (pmTransmittedCarrierPower) END AS A_45, 
 CASE WHEN (DCVECTOR_INDEX =46) THEN (pmTransmittedCarrierPower) END AS A_46, 
 CASE WHEN (DCVECTOR_INDEX =47) THEN (pmTransmittedCarrierPower) END AS A_47, 
 CASE WHEN (DCVECTOR_INDEX =48) THEN (pmTransmittedCarrierPower) END AS A_48, 
 CASE WHEN (DCVECTOR_INDEX =49) THEN (pmTransmittedCarrierPower) END AS A_49, 
 CASE WHEN (DCVECTOR_INDEX =50) THEN (pmTransmittedCarrierPower) END AS A_50, 
 CASE WHEN (DCVECTOR_INDEX =51) THEN (pmTransmittedCarrierPower) END AS A_51 
 from DC_E_RBS_CARRIER_V_DAY where date_id = '2016-06-17' AND RNC IN 'RNBKTX1' AND DCVECTOR_INDEX <=51 ) STEP2 GROUP BY Date_ID,RNC,RBS,Sector,Carrier;

Explanation:
1. Query STEP2: Transpose from single column to multiple column according to DCVECTOR_INDEX.
2. The results of the STEP2 Query are performed Queries by entering weighted values for each DCVECTOR_INDEX
3. So that the result is the average power value with the loading value.

For ROP / RAW data source, just change _DAY to _RAW.

Thanks

Comments

Post a Comment

Popular posts from this blog

Decimal Auto Dash Number To HEX

Image
Decimal Number To Hexadecimal Converter Tools This is the code calculator for the dashboard in Kilometres. The resulting code is one of the 5 codes that appear below. Please discuss in the comments column if there are difficulties. Edit EEPROM at spesific memory address acording to type of device, for example shown in picture below honda with EEPROM 93C76 Disclaimer : The use of this software is intended for repair purposes only or experimental, we are not responsible for the misuse of this software resulting in criminal acts according to applicable state laws. Thank you for reading. This tools maybe save your live, so please donate to support me through my paypal https://www.paypal.me/aesixnet Note Please enter a description USD Please enter a price Please enter an Invoice ID
Read more

Example of Query 3G Cell Propagation Data ENIQ with Vector INDEX

Image
The following is an example of an Ericsson ENIQ SQL Query for finding the range of radio signal propagation in average Kilometres by method of Weighted Average. S ELECT Date_ID,RNC,RBS,Sector,Carrier, cast((SUM(A_1)+SUM(A_2)+SUM(A_3)+SUM(A_4)+SUM(A_5)+SUM(A_6)+SUM(A_7)+SUM(A_8)+SUM(A_9)+SUM(A_10)+SUM(A_11)+SUM(A_12)+SUM(A_13)+SUM(A_14)+SUM(A_15)+SUM(A_16)+SUM(A_17)+SUM(A_18)+SUM(A_19)+SUM(A_20)+SUM(A_21)+SUM(A_22)+SUM(A_23)+SUM(A_24)+SUM(A_25)+SUM(A_26)+SUM(A_27)+SUM(A_28)+SUM(A_29)+SUM(A_30)+SUM(A_31)+SUM(A_32)+SUM(A_33)+SUM(A_34)+SUM(A_35)+SUM(A_36)+SUM(A_37)+SUM(A_38)+SUM(A_39)+SUM(A_40)) as float) as TS, cast (((SUM(A_1) * 0.175) + (SUM(A_2) * 0.525) + (SUM(A_3) * 0.875) + (SUM(A_4) * 1.23) + (SUM(A_5) * 1.585) + (SUM(A_6) * 1.935) + (SUM(A_7) * 2.285) + (SUM(A_8) * 2.635) + (SUM(A_9) * 2.985) + (SUM(A_10) * 3.34) + (SUM(A_11) * 3.87) + (SUM(A_12) * 4.57) + (SUM(A_13) * 5.275) + (SUM(A_14) * 5.98) + (SUM(A_15) * 6.68) + (SUM(A_16) * 7.38) + (SUM(A_17...
Read more

JAVA Script Parser Ericsson CEDH and STRT Log

 /*  * To change this license header, choose License Headers in Project Properties.  * To change this template file, choose Tools | Templates  * and open the template in the editor.  */ package strt; import java.io.BufferedReader; import java.sql.*; import java.io.File; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Scanner; import java.util.logging.Level; import java.util.logging.Logger; /**  *  * @author aessa  */ public class STRT {     String dbnn;     String TT;     String locoutfile;     String usreniq;     String pwdeniq;     String ipeniq;     String porteniq;     String dbeniq;     String stsregion;     String maxrowv;     String dtt = null;     private Connection connx;   ...
Read more