BAB III PENGUMPULAN DATA PERFORMANCE
3.1 Diagram Alir Implementasi 3rd Carrier
Planning
Update Site Basic
Validasi Script konfigurasi
Implementasi
Pengumpulan data setelah aktivasi
Ambil raw data
Y target pass (end)
KPI Reporting
N Analisa parameter KPI
Eksekusi script sebagai langkah optimasi
N Update report KPI
Y selesai
Gambar 3.1 Diagram Alir Implementasi 3rd Carrier [2]
27
27
3.2 Proses pengambilan data Berikut adalah langkah-langkah proses pengambilan raw data KPI Node B yang terimplementasi 3rd carrier dalam penelitian ini: 1. Lihat cellname dan data-data Node B pada site basic list dari customer Tabel 3.1 Tabel Site Basic RNMDN06 RNC 717 RNC ID PC254G_3G_MEDAN_FAIR_PLAZA Node B 3G Cell ID 3G Cell Name ARFCN Remark 62544 MD3G62544 10763 F1 62545 MD3G62545 10763 F1 36207 MD3G2_36207 10788 F2 36208 MD3G2_36208 10788 F2 62540 MD3G3_62540 10738 F3 62541 MD3G3_62541 10738 F3 2. Buka NMS Server M2000 Huawei
Gambar 3.1 Login M2000 3. Login dengan user dan password ke server RNMDN06 4. Setelah login, counter-counter raw data dimasukkan ke query data M2000 sesuai tabel formula di bawah ini: Tabel 3.2 Tabel Counter & Formula
28
KPI
Formula
Counter Level
[RRC SR (nom)]
([RRCSuccConnEstabOrgConvCall]+[RRCSuccConnEstabOrgStrCall]+[RRCSuccConn EstabOrgInterCall]+[RRCSuccConnEstabOrgBkgCall]+[RRCSuccConnEstabOrgSubCa ll]+[RRCSuccConnEstabTmConvCall]+[RRCSuccConnEstabTmStrCall]+[RRCSuccCo nnEstabTmItrCall]+[RRCSuccConnEstabTmBkgCall]+[RRCSuccConnEstabOrgHhPrSi g]+[RRCSuccConnEstabOrgLwPrSig]+[RRCSuccConnEstabCallReEst]+[RRCSuccCon nEstabTmHhPrSig]+[RRCSuccConnEstabTmLwPrSig])
Cell
[RRC SR (denom)]
([RRCAttConnEstabOrgConvCall]+[RRCAttConnEstabOrgStrCall]+[RRCAttConnEsta bOrgInterCall]+[RRCAttConnEstabOrgBkgCall]+[RRCAttConnEstabOrgSubCall]+[RR CAttConnEstabTmConvCall]+[RRCAttConnEstabTmStrCall]+[RRCAttConnEstabTmI nterCall]+[RRCAttConnEstabTmBkgCall]+[RRCAttConnEstabOrgHhPrSig]+[RRCAtt ConnEstabOrgLwPrSig]+[RRCAttConnEstabCallReEst]+[RRCAttConnEstabTmHhPrSi g]+[RRCAttConnEstabTmLwPrSig])
Cell
[VSRABSuccEstabCSAMR]
Cell
[VSRABAttEstabAMR]
Cell
[RAB SR PS (nom)]
[VSRABSuccEstabPSInt]+[VSRABSuccEstabPSBkg]+[VSRABSuccEstabPSStr]+[VSR ABSuccEstabPSConv]
Cell
[RAB SR PS (denom)]
[VSRABAttEstabPSInt]+[VSRABAttEstabPSBkg]+[VSRABAttEstabPSStr]+[VSRAB AttEstabPSConv]
Cell
[VSHSDPARABSuccEstab]
Cell
[VSHSDPARABAttEstab]
Cell
[VSRABAbnormRelAMR]
Cell
[VSRABAbnormRelAMR]+[VSRABNormRelAMR]
Cell
[SHO SR (nom)]
[VSSHOSuccRLAdd]+[VSSHOSuccRLDel]
Cell
[SHO SR (denom)]
[VSSHOAttRLAdd]+[VSSHOAttRLDel]
Cell
[ISHO SR (nom)]
[IRATHOSuccOutCS]
Cell
[IRATHOAttOutCS]
Cell
[VSRABSuccEstCSConv64]
Cell
[VSRABAttEstCSConv64]
Cell
[VSRABAbnormRelCS64]
Cell
[VSRABAbnormRelCS64]+[VSRABNormRelCS64]
Cell
[IRATHOSuccOutPSUTRAN]
Cell
[IRATHOAttOutPSUTRAN]
Cell
[RAB SR Voice (nom)] [RAB SR Voice (denom)]
[RAB SR HSDPA (nom)] [RAB SR HSDPA (denom)] [CDR Voice (nom)] [CDR Voice (denom)]
[ISHO SR (denom)] [RAB SR Video (nom)] [RAB SR Video (denom)] [CDR Video (nom)] [CDR Video (denom)] [ISHO PS SR (nom)] [ISHO PS SR (denom)]
29
[HSDPAUEMean Cell] [Cell Unavailable Time(m)]
[VSHSDPAUEMeanCell]
Cell
[VSCellUnavailTime]/60
Cell
[PS DL Payload(Mb)]
([VSPSBkgDL16Traffic]+[VSPSBkgDL32Traffic]+[VSPSBkgDL64Traffic]+[VSPSBk gDL128Traffic]+[VSPSBkgDL144Traffic]+[VSPSBkgDL256Traffic]+[VSPSBkgDL38 4Traffic]+[VSPSIntDL8Traffic]+[VSPSIntDL16Traffic]+[VSPSIntDL32Traffic]+[VSP SIntDL64Traffic]+[VSPSIntDL128Traffic]+[VSPSIntDL144Traffic]+[VSPSIntDL256T raffic]+[VSPSIntDL384Traffic]+[VSPSStrDL32Traffic]+[VSPSStrDL64Traffic]+[VSP SStrDL128Traffic]+[VSPSStrDL144Traffic])/(1024*1024)
Cell
[PS UL Payload(Mb)]
([VSPSBkgUL16Traffic]+[VSPSBkgUL32Traffic]+[VSPSBkgUL64Traffic]+[VSPSBk gUL128Traffic]+[VSPSBkgUL144Traffic]+[VSPSBkgUL256Traffic]+[VSPSBkgUL38 4Traffic]+[VSPSIntUL8Traffic]+[VSPSIntUL16Traffic]+[VSPSIntUL32Traffic]+[VSP SIntUL64Traffic]+[VSPSIntUL128Traffic]+[VSPSIntUL144Traffic]+[VSPSIntUL256T raffic]+[VSPSIntUL384Traffic]+[VSPSStrUL16Traffic]+[VSPSStrUL32Traffic]+[VSP SStrUL64Traffic])/(1024*1024)
Cell
[HSPDA DL Payload(Mb)]
([VSHSDPAMeanChThroughputTotalBytes]*8)/(1024*1024)
Cell
[IFHO SR (nom)]
[VSHHOSuccInterFreqOut]
Cell
[IFHO SR (denom)]
[VSHHOAttInterFreqOut]
Cell
[DRD SR (nom)]
[VSDRDRBSetupSuccOut]
Cell
[VSDRDRBSetupAttOut]
Cell
[VSRABSuccEstabCSAMR]+[VSRABSuccEstCSConv64]
Cell
[RAB SR CS (denom)]
[VSRABAttEstabAMR]+[VSRABAttEstCSConv64]
Cell
[CDR CS (nom)]
[VSRABAbnormRelAMR]+[VSRABAbnormRelCS64]
Cell
[CDR CS (denom)]
[VSRABAbnormRelAMR]+[VSRABNormRelAMR]+[VSRABAbnormRelCS64]+[VS RABNormRelCS64]
Cell
[CDR HSDPA (nom)]
[VSHSDPARABAbnormRel]
Cell
[CDR HSDPA (denom)]
[VSHSDPARABAbnormRel]+[VSHSDPARABnormRel]+[VSHSDPARABNormRelUs rInact])+[VSHSDPAH2DSucc])+[VSHSDPAHHOH2DSuccOutIntraFreq])+[VSHSDP AHHOH2DSuccOutInterFreq])
Cell
[CDR PS (nom)]
[VSRABAbnormRelPS]
Cell
[CDR PS (denom)]
[VSRABAbnormRelPS]+[VSRABNormRelPS]
Cell
[DRD SR (denom)] [RAB SR CS (nom)]
30
5. Formula tersebut dimasukkan juga ke tools Ms. Access untuk diolah
Gambar 3.2 Input formula di tools 6. Setelah selesai memasukkan counter-counter tersebut lalu query data berdasarkan tanggal yang diiinginkan. Dalam implementasi ini saya mulai ambil data dari H-3, kemudian save data dari server ke komputer/laptop.
Gambar 3.3 Raw data dari server
31
3.3 Proses pengolahan data 1. Buka tools Ms. Access kemudian klik Browse File untuk memilih raw data yang akan diolah
Gambar 3.4 Browse File 2. Klik import setelah file yang terpilih sudah ada di list
Gambar 3.5 Import
32
3. Setelah selesai import kemudian Compile Raw untuk menggabungkan antar raw data 4. Setelah itu ctrl+F pada tools, lalu ketik 3G_KPI_Cell_Hourly, klik kanan di query 3G_KPI_Cell_Hourly_Selected pilih design view.
Gambar 3.6 Query data 5. Klik View / Run untuk menampilkan data kpi yang sudah diproses
Gambar 3.7 Hasil olahan data 6. Copy data tersebut ke Ms. Excel untuk dianalisa lebih lanjut
33
