ManuelBelgrano
2011-11-15, 05:55 PM
Actix Analyzer Query Training UMTS.
I would appreciate reputation and thanks!
Below the index:
1 About this course..................................................................................... 4
1.1 Objectives of the course................................................................ 4
1.2 Course pre-requisites..................................................................... 4
1.3 Course structure............................................................................ 4
2 What are queries?.................................................................................... 6
2.1 Query types....................................................................................... 6
2.2 Filter queries.................................................................................... 6
2.3 Histograms........................................................................................ 8
2.4 Statistics........................................................................................... 8
2.5 Binned................................................................................................ 9
2.6 Crosstab......................................................................................... 10
2.7 Event................................................................................................ 11
3 Introduction to the Analysis Manager................................................ 12
4 Configuration......................................................................................... 14
5 Query Design........................................................................................... 17
5.1 Coverage Holes – filter................................................................ 17
5.2 Coverage Holes – binned.............................................................. 21
5.3 Pilot Pollution 1 – binned............................................................. 25
5.4 Exercise: Binned Query (Pilot Pollution).................................. 28
5.5 Solution: Binned Query (Pilot Pollution).................................. 29
5.6 Exercise: Binned Query (Inbound Pilot Pollution per SC)....... 31
5.7 Solution: Binned Query (Inbound Pilot Pollution per SC)....... 32
5.8 Call Setup Time Analysis – histogram......................................... 33
5.9 Dropped Call Statistics – statistics........................................... 36
5.10 UE Analysis Statistics – crosstab............................................. 37
5.11 Scanner and UE Analysis at Call Setup – event...................... 44
5.12 Dropped Call Analysis – event................................................... 48
5.13 Call Setup Sequence Analysis – Crosstab.............................. 52
6 Report Templates................................................................................... 57
6.1 Single File Report Template......................................................... 57
6.2 Multiple File Report Template..................................................... 60
7 Appendix................................................................................................... 63
7.1 “state()” vs. “prev_state()”............................................................. 63
7.2 Little-known query commands...................................................... 64
7.2.1 abstime( rounding_factor )....................................................... 64
7.2.2 delta( parameter )..................................................................... 64
7.2.3 get( parameter, index, message_number )............................. 65
7.2.4 default( primary_ expression, secondary_ expression ).......... 65
7.3 Setting a timer statistics using crosstab queries..................... 65
7.4 Cell Lookup Query Functions...................................................... 66
7.5 CellHandle Lookup Function....................................................... 68
7.6 Example........................................................................................... 68
7.7 Editing existing report templates................................................ 69
7.8 Useful Format Groups (for frequent use)................................. 70
7.9 Parameters Used............................................................................ 71
I would appreciate reputation and thanks!
Below the index:
1 About this course..................................................................................... 4
1.1 Objectives of the course................................................................ 4
1.2 Course pre-requisites..................................................................... 4
1.3 Course structure............................................................................ 4
2 What are queries?.................................................................................... 6
2.1 Query types....................................................................................... 6
2.2 Filter queries.................................................................................... 6
2.3 Histograms........................................................................................ 8
2.4 Statistics........................................................................................... 8
2.5 Binned................................................................................................ 9
2.6 Crosstab......................................................................................... 10
2.7 Event................................................................................................ 11
3 Introduction to the Analysis Manager................................................ 12
4 Configuration......................................................................................... 14
5 Query Design........................................................................................... 17
5.1 Coverage Holes – filter................................................................ 17
5.2 Coverage Holes – binned.............................................................. 21
5.3 Pilot Pollution 1 – binned............................................................. 25
5.4 Exercise: Binned Query (Pilot Pollution).................................. 28
5.5 Solution: Binned Query (Pilot Pollution).................................. 29
5.6 Exercise: Binned Query (Inbound Pilot Pollution per SC)....... 31
5.7 Solution: Binned Query (Inbound Pilot Pollution per SC)....... 32
5.8 Call Setup Time Analysis – histogram......................................... 33
5.9 Dropped Call Statistics – statistics........................................... 36
5.10 UE Analysis Statistics – crosstab............................................. 37
5.11 Scanner and UE Analysis at Call Setup – event...................... 44
5.12 Dropped Call Analysis – event................................................... 48
5.13 Call Setup Sequence Analysis – Crosstab.............................. 52
6 Report Templates................................................................................... 57
6.1 Single File Report Template......................................................... 57
6.2 Multiple File Report Template..................................................... 60
7 Appendix................................................................................................... 63
7.1 “state()” vs. “prev_state()”............................................................. 63
7.2 Little-known query commands...................................................... 64
7.2.1 abstime( rounding_factor )....................................................... 64
7.2.2 delta( parameter )..................................................................... 64
7.2.3 get( parameter, index, message_number )............................. 65
7.2.4 default( primary_ expression, secondary_ expression ).......... 65
7.3 Setting a timer statistics using crosstab queries..................... 65
7.4 Cell Lookup Query Functions...................................................... 66
7.5 CellHandle Lookup Function....................................................... 68
7.6 Example........................................................................................... 68
7.7 Editing existing report templates................................................ 69
7.8 Useful Format Groups (for frequent use)................................. 70
7.9 Parameters Used............................................................................ 71