【资料名称】：Analyzer Queries

【资料作者】：actix

【资料日期】：未知

【资料语言】：英文

【资料格式】：PDF

【资料目录和简介】：

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

[ 本帖最后由 laomaoyixin 于 2011-11-20 21:52 编辑 ]