MapInfo _(Plot IEs_) « Share It!!!

MapInfo (Plot IEs) « Share It!!!

1 of 19

http://orinaica.wordpress.com/2009/05/22/mapinfo-plot-ies/

Share It!!! Blog Search

« RAN Tuning | Home | 2G Frequency Scanning »

MapInfo (Plot IEs) 5 Votes Before post process in mapinfo, created *.tab file from logfile in TEMS : 1. Export logfile : Menu Bar Logfile -> Export Logfile 2. Click Add Order 3. Choose Format : MapInfo Tab-file 4. Setup IEs (Info Elements) for GSM Dedicated or Idle : - RxLev Full (dBm) - RxLev Sub (dBm) - RxQual Full - RxQual Sub - SQI - TA - Cell Id - Frequncy Band - Latitude - Longitude for WCDMA Dedicated / Idle / Scanner :

3/31/2012 9:59 AM


2 of 19


- AS Cell Name - AS CPICH Ec/No - AS CPICH RSCP - SAN CPICH Ec/No - SAN CPICH RSCP - SAN Cell Id (CI Part) - Sc 1st Aggr Ec (dBm) -> Scanner - Sc 1st Aggr EcIo (dB) -> Scanner - Sc Best SC -> Scanner - Latitude - Longitude 5. Configure Options Tab

6. Save *.mex 7. Choose Logfile : Click Browse file 8. If there are more than one logfile we can merge it by Merge Output 9. Choose Output directory : Click Browse dir

3/31/2012 9:59 AM


3 of 19


10. Give Prefix : Ded if Dedicated and Idle if Idle

11. Start process, click start

12. If done, status Success 13. There were created four files for each action (*.dat, *.id, *.map, *.tab)

14. Open the exported file into MapInfo : Menu Tab File -> Open

3/31/2012 9:59 AM


4 of 19


15. Create Thematic Map : Menu Tab Map -> Create Thematic Map 16. Choose Type -> Range 17. Template Name -> Region Ranges

18. Choose Table and Field (ie. Plotting RXQUAL_SUB from Dedicated mode)

3/31/2012 9:59 AM


5 of 19


19. Customize Ranges, Style and Legend.

20. Example Dedicated by RXQUAL_SUB

3/31/2012 9:59 AM


6 of 19


EVENTS on RXQUAL_SUB 21. Create Events on RXQUAL_SUB 22. Open again the exported file (Ded_orinaica) 23. Create Thematic Map : Menu Tab Map -> Create Thematic Map 24. Choose Type -> Individual 25. Template Name -> Region IndValue Default 26. Choose Table and Field

27. Customize Style and Legend

3/31/2012 9:59 AM


7 of 19


28. Example Events on RXQUAL_SUB

SPIDER GRAPH 29. Activate spider graph : Menu Tab Tools -> Tool Manager 30. Spider Graph Load and Autoload

3/31/2012 9:59 AM


8 of 19


31. See table structure of cell in MCOM Site : Menu Tab Table -> Maintenance -> Table Structure -> View/Modify Table choose MCOM Site

32. See table structure of CI in exported file : Manu Tab Table -> Maintenance -> Table Structure -> View/Modify Table choose exported file (ie. Ded_orinaica) -> Change type structure of CI

33. Click OK 34. Create Spider Graph : Tools -> Spider Graph -> Spider Graph 35. Choose Origin and Destination table

36. Save the Spider Graph table : Save Copy As -> (ie. orinaica) 37. From Spider Graph, We can analyze : - Dominant Cells - Overshoot Cells - Swap Feeder

3/31/2012 9:59 AM


9 of 19


Like this:

Be the first to like this post.

Comments 1.

Phuong says: Hi all, Pls help me about to export logfile from Tems to Mapinfo. Can you show detail the step by step such as:each command, to what doing it now, set up parameter in Tems and mapinfo,..so that i can make good a Cat report file. Thanks and Best regards | Reply Posted 2 years, 6 months ago orinaica says: Hi Phuong, I’m Sorry berfore, i think the articel that i’ve post is step by step to export TEMS logfile into MapInfo tab-file. Maybe i can give more detail point by point : Point 1 : to export logfile we need to th export logfile window Point 2 : to add order logfile will be export

3/31/2012 9:59 AM


10 of 19


Point 3 : in this example logfile will export into MapInfo tab-file Point 4 : Choose info elements that will be export. In the articel there are examples info element for GSM and WCDMA. This info elements will be plot in mapinfo. Point 5 : The Option tab is to configure suc as massage info from layer 2 & layer 3 messages (more detail of call process). Point 6 : to save the configuration that we have made in *.mex format. So that, if we want to export log file with same configuration, we just need to “load” the themeplate that saved. Point 7 : to choose logfile will be export Point 8 : merge or no merge. If we choose merge, all log files that exported will create one *.tab file. But, if we don’t check the field merge, there will create one *.tab file for one logfile. So, if we have 5 logfile, there will be created 5 *.tab files. Point 9 : to choose output directory where the exported files will be placed Point 10 : to give prefix and suffix in *.tab will be created Point 11 : Expot process Point 12 : If the process done and succeed, there is a notification in status “success”, if failed the notification status is “failed” Point 13 : There several files that created when the export process done There’s no difference between TEMS 8 and TEMS 6 to export logfile into tab-file. For process *.tab files in mapinfo, i think you can directly try the steps on point 14 to 37. I hope this can answer your good question. Thanks for your attention Phuong. Best Regards, isa | Reply Posted 2 years, 6 months ago

3/31/2012 9:59 AM


11 of 19

2.


Phuong says: Hi ISA, Thanks for reply but i still anything unclearly. Thus, pls help me to explain to step by step at point ( How do setup IEs? and how does the configure options tabs?) Thanks and Best regards, NAP | Reply Posted 2 years, 6 months ago orinaica says: Hi Phuong, Here are step by step to setup IEs that you want to export : 1. Choose in field available IEs, GSM or WCDMA. – If you you choose GSM, there will be show available IEs in GSM. – If you you choose WCDMA, there will be show available IEs in WCDMA. 2. Then select IEs that you want to export . In example on GSM : - RxLev Sub(dBm) : Signal level that MS reach -> range value between “-40″ – “-120″ - RxQual Sub : Quality of the signal that MS reach -> range index between 0-7 - SQI : Speech Quality Index is Index quality of speech like MOS. This value is calculate from BER, FER - TA : Timing Advance, this value give us information about distance between MS to BTS. TA = 1 mean the distance between MS to BTS approx 550meter, TA=2 mean 1.1meters TA usually used to analyze the overshoot cell. If there are TA value > 10 mean the distance between MS to BTS more than 5.5 Kilometers. There could be overshoot cells. - FrequencyBand : Frequency Band that used in current channel (900MHz or 1800MHz) In example on WCDMA : - SAN CPICH RSCP : Serving Active Set/Neighbour Receive Signal Code Power. This Info Elements appear only on UE not on scanner. On Idle mode, cell that served, called Active Set (AS). There can be more than one AS. On Dedicated mode, cell that served, called Serving Cell (SC). There can be more one SC handled MS. This info element give us info about Signal Power Level that MS reach (like RxLevel in GSM). - SAN CPICH Ec/No : Serving Active Set/Neighbour Energy Chip per Noise. This Info Elements appear only on UE not on scanner. This info element give us info about Quality of Signal that MS reach (like RxQual in GSM). if you use WCDMA scanner : - Sc 1st Aggr Ec (dBm) : Scanner 1st Aggregate Energy Chip

3/31/2012 9:59 AM


12 of 19


Sc 1st means value of the first UARFCN that we scan. If we scanning more than one UARFCN (10663, 10688, 10713), mean Sc 1st is 10663; Sc 2nd is 10688 and Sc 3rd is 10713. Sc 1st Aggr Ec (dBm) give us information about Signal Level that MS reach (like CPICH RSCP on UE) for first UARFCN. - Sc 1st Aggr Ec/Io (dB) give us information about Quality of Signal that MS reach (like CPICH Ec//No on UE) for first UARFCN (10663). - Sc 2nd Aggr Ec (dBm) give us information about Signal Level that MS reach (like CPICH RSCP on UE) for second UARFCN (10688). - Sc 2nd Aggr Ec/Io (dB) give us information about Quality of Signal that MS reach (like CPICH Ec//No on UE) for second UARFCN (10688). - Sc 3rd Aggr Ec (dBm) give us information about Signal Level that MS reach (like CPICH RSCP on UE) for third UARFCN (10713). - Sc 3rd Aggr Ec/Io (dB) give us information about Quality of Signal that MS reach (like CPICH Ec//No on UE) for third UARFCN (10713). In option tab, if you want to export data from all reports just click “Export data from all reports”, if you want to export only from layer 3 so that, click “Export data only from layer 3 reports”. Check Export message information only from layer 3 and layer 2 if you want to export the message info. If you want to export event directly, choose “Export Events and Plot events in MapInfo” with unix symbol. If you want to plot events later, click “Export events but do not plot in MapInfo”. Maybe that was all my explanations. I hope it could be useful for you. Best Regards, Isa | Reply Posted 2 years, 6 months ago Raj says: Hi orainaca Above topic is really helpful for me , really great effort.. I will really appreciate if anybody will write or give me the link of procedure to generate the reports after collecting log files for UMTS or LTE. I mean , I want to know which parameters optimization engineer consider before declaring a site on Air. Any help regarding this topic will be really helpful to me. Thanks .Again best effort. Posted 1 year, 5 months ago

orinaica says: In this blog, i’ve wrote several post processing for GSM/UMTS using Report Generator, RAN Tuning and MapInfo. I don’t have any example of LTE post processing or Report. Hopefully, anyone that read your comment will share it to you…

3/31/2012 9:59 AM


13 of 19


Thank You Posted 1 year, 4 months ago

3.

nghia says: Hi orainaca, I also make driving test. But I don’t understand how to configure TEMS and my mobile:k800i to test GPRS, get data. Can you give me more information about that? Thanks a lots! | Reply Posted 2 years, 5 months ago orinaica says: Hi nghia, how are u? Herewith step by step to configure dial up connection and ftp download in TEMS 8.1.3 using K800i. I hope can answer your qustion. BR, orinaica | Reply Posted 2 years, 5 months ago raka says:

4.

hi orinaica…. please help me about query?? thanx… | Reply Posted 2 years, 1 month ago orinaica says: Hi raka, from query we can select columns from each table. From SQL select, we can filter column by condition that you’ve defined in a certain table. | Reply Posted 2 years, 1 month ago 5.

kariansy says:

3/31/2012 9:59 AM


14 of 19


mas orinaica… Terima Kasih banyak atas tutorialnya …. jarang bahkan hampir gak ada yang mau sharing ilmu DT Seperti anda… Semoga semakin sukses and semakin memberi banyak manfaat untuk orang lain. amin | Reply Posted 2 years, 1 month ago orinaica says: Terima Kasih juga untuk doanya mas kariansy,… semoga bermanfaat… -orinaica| Reply Posted 2 years, 1 month ago 6.

Ali says: Good descriptions. Could you please help me understand the following regarding TEMs Drive Tests. 1. Do you need to load the cell files before starting the DT 2. when I attach the GPS tracker the same way as MS, what do I need to do with the maps so that I can use the laptop for tracing my route as I drive? – like using say a stand alone TomTom or Garmin sat nav Many thanks Ali | Reply Posted 2 years ago orinaica says: Hi Ali, Answering your qustions : 1. When drive test, i need to load cell file to know who is the serving cell. Then we can analyze if there is an overshoot cell or swap sector in a site. 2. After you get connect the gps, in map window you should edit theme settings. For 2G drive test choose RxLevSub (dBm) and for 3G drive test choose SAN CPICH RSCP.

3/31/2012 9:59 AM


15 of 19


BR, -orinaica| Reply Posted 2 years ago 7.

Ali says: Hi Orinaica, thanks for the quick feedback. So basically before I start the drive tests, you mean I should have Cell files loaded ofcourse with the map? How do I load the cell files in TEMs Investigation data collection then? Atleast I know how to do it in TEMS Route Analysis during post processing Also When you generate the Mapinfo TAB files to export to TEMS (answer 13 and 14 above), do they contain the cells file information OR you separately upload the cell files in Mapinfo. The diagram in your answer 14 – when you open the exported TAB logs, it suggests the cell files info is contained in there Thanks Ali | Reply Posted 2 years ago

8.

ahmad says: dear pak, saya dah coba jalanin spider graph sesuai dengan urutan di atas kok pada akhir proses tidak muncul apa2. saat saya view all layer muncul message “no object on the layer”..mohon pencerahan trims | Reply Posted 1 year, 9 months ago orinaica says: Hi Zaki,… Dah di ubah format table pada kolom CI di *.tab yang telah di export ke format character 10? Selamat mencoba, dan thanks dah berkunjung,… orinaica | Reply Posted 1 year, 9 months ago

3/31/2012 9:59 AM


16 of 19

9.


rajesh kumar says: very very nice and thanks its great…… | Reply Posted 1 year, 9 months ago orinaica says: Thanks you mr. kumar,… | Reply Posted 1 year, 9 months ago

10.

Eko says: Pak Isa, Wah Tulisan Ente bermanfaat banget bagi saya yang lagi belajar DT,,saya mohon izin download tulisanya yah Pak Isa, sekalian saya upload ke blog probadi saya biar bisa tak bawa dan tak ingat kemana2….. Semoga dengan kesediaan berbagi ilmu seperti ini, Pak Isa selalu ditambahkan lagi Ilmu-ilmu baru yang belum diketahui Pak Isa Oleh Allah SWT amiin… Thanks Ilmunya Pak Isa | Reply Posted 1 year, 5 months ago orinaica says: Sama2 mas,… semoga bermanfaat. | Reply Posted 1 year, 5 months ago

11.

Reza says: Wah, very much appreciated Pak Isa / Orinaica for ur articles, these help me a lot.. klo liat2 brkeliling, byak sekali blog yg menyadur dari artikel sumber ini.. wanna ask some question if u don’t mind, kalo orang2 pengin data lengkap, sya pngin menyederhanakan data , khususnya stlh tampil di thematic map, hehe. tjuannya utk memudahkan aja, soalnya kbnyakan titik mmpunyai nilai yg sama,, apakah nanti pengolahannya sebelum di eksport ke Mapinfo? atau di filter setelah di Mapinfonya? dan bagaimana caranya? segitu dulu Pak.. oya, sya msh belajar mslah bginian, cuz I’m still student who is trying to analyze RF matters, jadi masi cupu, hehe.

3/31/2012 9:59 AM


17 of 19


thank you very much. regards | Reply Posted 1 year, 1 month ago orinaica says: Hi Reza, coba kamu cari tahu tentang “binning” mungkin itu yang kamu maksud. Di RAN TUNING pada TEMS 8 ada feature Binning. Biasanya saya pakai binning by distance. Saya juga pernah lihat ada tools “macro” ericsson (TIPP-G & TIPP-W) untuk proses binning dan kalkulasi statistik drivetest. coba cati di http://www.finetopix.com semoga membantu | Reply Posted 1 year, 1 month ago Reza says: waahh… did’t expect u to give such a quick respond Mr. Orinaica yea, binning or whatever the name is, hehe. but i’ve just checked the TEMS Help Contents, and Binning is exactly what I mean, and Distance Binning more likely what I need but I got no luck, since using TEMS Route Analysis needs HASL key, and that green little USB thing was carried away, again, by its owner, cuz i was just borrowing, hehe :p hm, can it possibly be done in MapInfo? i have exported the log files into *.TAB, and can it (binning) be done there ? I’ve been looking for the setting but can’t find it anywhere oya , does binning change the overall value of measurements? for example, if without binning, we get mean of measured RXLev sub at -70dBm, and after binning, will it be still at -70dBm or perhaps will be change? (ikut2an latian english, sorry if my english’s mbelghedes ora nggenah, heheh) Thx Mr Orinaica.. Posted 1 year, 1 month ago

orinaica says: Hi reza,… sorry for very long late response, bcause there’s no email notification bout ur comment on my inbox. Yeah, u should have HASL key (dongle) to run RAN Tuning. 3/31/2012 9:59 AM



18 of 19

Actually, binning is an algorithm to get max or average (i’m forget) value in specific range that u set (if u use binning distance). Ie, if u set binning distance 5 meters, that will be take 1 value (max or average) from much sample u have, on 5×5 meters. So if u can implement that algorithm into the mapinfo query, u’ll get what u want As i said on my previous reply, u can use TIPP-G (for GSM) and TIPP-W (for WCDMA) to binning ur logfile. First step, u’ve to export ur logfile into *.fmt then go to process on TIPP-G or TIPP-W macro. Try to search the macro on my sites reference (I’ve wrote on my previous reply). “Don’t ever satisfied if u’ve success on this, bcause there was long journey to discover technical skill and telecommunication concept , keep ur spirit to explore urself reza,… Don’t forget to pray. Goodluck man!!!” note : If u interest to be an optimization engineer, try to explore ur skill on ms. excell and ms.access, such as pivot, any formula. creating macro and query. Posted 1 year, 1 month ago

12.

Jellf says: Hi Bro, thanks ni sharingnya, tp di saya kok ndak ada linenya ya… hanya blank kosong ketika di save tablenya … | Reply Posted 10 months ago

13.

ridwan says: note : If u interest to be an optimization engineer, try to explore ur skill on ms. excell and ms.access, such as pivot, any formula. creating macro and query. Dear pak orinaica: menanggapi catatan anda diatas, bersediakah anda memberikan contoh atau tutorial mengenai ms.exell,ms.acces,pivot and any formula, creating macro and query, saya masih baru di bidang telco ini, saya yakin anda sudah sangat famliar sekali dengan tools tersebut diatas, Regards Ridwan | Reply Posted 5 months, 3 weeks ago

14.

Kayode says:

3/31/2012 9:59 AM


19 of 19


how can i show data throughput from the exported log files in map info during analysis. | Reply Posted 3 months, 1 week ago orinaica says: Just export the rlc throughput than make the range for thematic map in mapinfo. | Reply Posted 3 months, 1 week ago

Leave a Reply

Notify me of follow-up comments via email.

Post Comment

This Entry "MapInfo (Plot IEs)" was written May 22nd, 2009 by orinaica, and filed under Telco Practice There are 29 responses. ↓ Read comments, respond or follow responses via RSS. Trackback this entry. Entries RSS | Comments RSS | Blog at WordPress.com. | Theme: Fauna by Noscope.

3/31/2012 9:59 AM

MapInfo _(Plot IEs_) « Share It!!!

Recommend Documents