150668866 Ericsson Kpi Formulas

304
Network Statistics, Analyzer  1/1553-APR 102 64/1A Uen G1 Network Statistics, Analyzer Copyright © Ericsson AB 2002, 2004 - All Rights Reserved Disclaimer The contents of this document are subject to revision without notice due to continued progress in methodology, design and manufacturing. Ericsson shall have no liability for any errors or damages of any kind resulting from the use of this document. Trademark List Acrobat is a trademark of Adobe Systems Inc. BusinessObjects is a trademarks of Business Objects SA All other trademarks and registered trademarks mentioned are the property of their respective owners. Contents 1 Introduction 1.1 Prerequisites 1.2 Typographic Conventions 1.3 Getting Help 2  Overview Reports 2.1 Performance Overview, MSC 2.2 Performance Overview, BSC and Cell Set  2.3 Radio Overview, MSC 2.4 Radio Overview, BSC and Cell Set 3  Planning Reports 3.1 Call Rejection Exceptions 3.2 Call Setup Performance Overview, BSC and Cell Set  3.3 Calls and Answers 3.4 Congestion 3.5 CP Load file:///C|/D OCUME~1/a/LOCALS~1/ Temp/ALEX_TMP/1031/al ex0278.htm (1 of 152)10/18/2 009 1:58:41 PM

Transcript of 150668866 Ericsson Kpi Formulas

  • Network Statistics, Analyzer

    1/1553-APR 102 64/1A Uen G1

    Network Statistics, Analyzer

    Copyright

    Ericsson AB 2002, 2004 - All Rights Reserved

    Disclaimer

    The contents of this document are subject to revision without notice due to continued progress in methodology, design and manufacturing.

    Ericsson shall have no liability for any errors or damages of any kind resulting from the use of this document.

    Trademark List

    Acrobat is a trademark of Adobe Systems Inc. BusinessObjects is a trademarks of Business Objects SA All other trademarks and registered trademarks mentioned are the property of their respective owners.

    Contents

    1 Introduction 1.1 Prerequisites 1.2 Typographic Conventions 1.3 Getting Help 2

    Overview Reports

    2.1 Performance Overview, MSC 2.2 Performance Overview, BSC and Cell Set 2.3 Radio Overview, MSC 2.4 Radio Overview, BSC and Cell Set 3

    Planning Reports

    3.1 Call Rejection Exceptions 3.2 Call Setup Performance Overview, BSC and Cell Set 3.3 Calls and Answers 3.4 Congestion 3.5 CP Load

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (1 of 152)10/18/2009 1:58:41 PM

  • Network Statistics, Analyzer

    3.6 Hardware Dimensioning, BSC and Cell Set 3.7 Location Update, MSC 3.8 Paging Statistics, MSC 3.9 Paging Statistics and Location Updating 3.10 OL/UL Subcells, BSC and Cell Sets 3.11 Random Access, BSC 3.12 Subscriber Activity Profile 3.13 System Performance Charts 3.14 Through Connect Calls 3.15 Traffic 3.16 Traffic Dispersion 3.17 Traffic Measurement on Routes, MSC and Route Sets 3.18 Traffic Profile, Routes 3.19 Traffic Trend Normal, BSC and Cell Set 3.20 Traffic Trend PEAK, BSC 3.21 Unsuccessful Calls 4

    Dropped Calls Reports

    4.1 Dropped Calls Overview 4.2 Dropped Calls Cell, BSC and Cell Set 4.3 Dropped Calls Trend BSC, Cell Set and Cell 5

    Handover Reports

    5.1 Handover Activity, BSC and Cell Set 5.2 Handover Performance Overview, Cell Set 5.3 Handover Performance Per Cell, BSC and Cell Set 5.4 Handover Performance Per Cell Relation, BSC and Cell Set 5.5 Handover Performance OL/UL, BSC and Cell Set 5.6 Inter BSC Handover Performance 5.7 Intra-Cell Handover Overview 5.8 Intra-Cell Handover, BSC and Cell Set 6

    Management Report

    6.1 Infrastructure 6.2 Radio Network Performance 6.3 Route Performance 6.4 Subscriber Info 6.5 Switch Performance

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (2 of 152)10/18/2009 1:58:41 PM

  • Network Statistics, Analyzer

    6.6 Peak Hour Traffic and Subscribers 6.7 Peak Hour Performance 7

    Speech Quality Supervision

    7.1 Speech Quality Cell, BSC 7.2 Speech Quality Chart, BSC and Cell 8

    Dual Band Reports

    8.1 Dual Band Mobile Performance Cell, BSC and Cell Set 8.2 Dual Band Mobile Performance Trend Cell, BSC and Cell

    Set 9

    GPRS BSC Reports

    9.1 GPRS Performance, BSC 9.2 GPRS Performance, Cell 9.3 GPRS Traffic Load, Cell 9.4 CCCH Capacity 9.5 GPRS Radio Link Quality BSC 9.6 GPRS Quality of Service, BSC 9.7 GPRS Quality of Service Cell, BSC 10

    GPRS GSN Reports

    10.1 GPRS Mobility Management Overview 10.2 GPRS Mobility Management Overview, GSM 12.04 10.3 GPRS Session Management Overview 10.4 GPRS Session Management Overview, GSM 12.04 10.5 GPRS Session Management per GGSN, GSM 12.04 10.6 Packet Switched Paging Performance Overview, GSM

    12.04 11

    Glossary

    12

    Reference List

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (3 of 152)10/18/2009 1:58:41 PM

  • Network Statistics, Analyzer

    1 Introduction

    This document is intended for users of the Operations Support System (OSS) NWS Analyzer Application (NWS-A).

    It describes the formulas used for calculating the statistics in the reports provided with NWS-A, including:

    which counters that are used, and to which STS or OMS object types they belong

    from which tables and columns in the SDM databases the values are retrieved

    The reports are divided into the following groups:

    Overview reports

    Planning reports

    Dropped Calls reports

    Handover reports

    Management reports

    Speech Quality Supervision reports

    Dual Band reports

    GPRS reports

    Reports that are almost identical are described in the same section, for example when a report is available for both BSCs and cell sets.

    If a report has several sheets, each sheet is described in a table of its own. If a report contains sheets with graphs, these sheets are normally not described, since the measurements in the graphs are usually available in a table elsewhere in the report.

    1.1 Prerequisites

    It is assumed that the user of this document:

    has common knowledge of GSM systems

    is familiar with telecom network statistics

    is familiar with the NWS-A application

    1.2 Typographic Conventions

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (4 of 152)10/18/2009 1:58:41 PM

  • Network Statistics, Analyzer

    OSS documents follow a set of typographic rules that make the documentation consistent and easy to read.

    System Element Names

    System element names, such as names of typed commands, programs, files, paths and URLs are shown as below.

    Programs and files: system_config.xml

    Variable parts of system element names are shown as below.

    program_name

    Object Types and Database Table Names

    Names of STS and OMS object types, counters, database tables and columns are shown as below:

    STS and OMS object types CELTCHFCounter names THTRALACCBSDDB database tables (BSC_CELL_MAIN)Database columns C_TTRALACC

    The following table contains an annotated example of the column descriptions:

    Table 1 Example of Object Names and Database Table Names

    Column Formula Comment

    ... ...

    TCH Traffic (Erlang) CELTCHF, CELTCHH:

    (TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)

    Counters from the object types CELTCHF and CELTCHH are used.

    (BSC_CELL_MAIN / CELL_MAIN):

    C_TTRALACC

    Either the table BSC_CELL_MAIN or CELL_MAIN in the BSDDB database is used, depending on whether the value in the report is for a BSC or for a cell.

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (5 of 152)10/18/2009 1:58:41 PM

  • Network Statistics, Analyzer

    No. of TCHs CLTCH

    (BSC_CELL_MAIN / CELL_MAIN):

    TNUCHCNT

    The same formula is used both for STS and OMS object types and for BSDDB tables.

    1.3 Getting Help

    To get information on how to use the reports provided with NWS-A, see Network Statistics Analyzer, User Guide.

    To get detailed information on how to create own reports, and how to add more data to reports in NWS-A, refer to the documentation for BusinessObjects and Designer.

    Documentation for BusinessObjects is available from the Help menu in BusinessObjects. There is both online help and a user's guide in Adobe Acrobat (or PDF) format. This help contains general information on the report generator, and detailed information on how to modify and create new reports. However, it does not contain any information specific for the NWS-A reports.

    Documentation for Designer is available from the Help menu in Designer. Similar to the help for BusinessObjects, this help contains detailed information on how to build and modify universes, but does not contain any information specific for the NWS-A universes.

    To get detailed information on the contents of the universes provided with NWS-A, see Network Statistics Analyzer, Universe Description.

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (6 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    2 Overview Reports

    2.1 Performance Overview, MSC

    File Name: Shows statistics for: Performance_Overview_MSC.rep Each MSC in the networkUses Universe: BSDR81.unv Table 2 Performance Overview MSC

    Column Formula

    MSC -

    Channel Assignment Success, Originating and Terminating (%)

    CHASSIGNT

    (MSC_DATA):

    100 * (NCHATOMSUCC + NCHAFRMSUCC) / (NCHAFRMTOT + NCHATOMTOT)

    Location Update Success, Registered and Non-Registered (%)

    UPDLOCAT

    (MSC_DATA):

    100 * (NLOCOLDSUCC + NLOCNRGSUCC) / (NLOCOLDTOT + NLOCNRGTOT)

    Paging Success (%) LOCAREAST

    (MSC_DATA):

    100 * (NPAG1RESUCC + NPAG2RESUCC) / (NPAG1GLTOT + NPAG1LOTOT)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (7 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Inter MSC Incoming Handover Success (%)

    NBRMSCLST

    (MSC_DATA):

    100 * (NNBRHINASUCC + NNBRHSANSUCC) / (NNBRHINATOT + NNBRHSANTOT)

    Inter MSC Outgoing Handover Success (%)

    NBRMSCLST

    (MSC_DATA):

    100 * (NNBRHBANSUCC + NNBRHSNASUCC) / (NNBRHSNATOT + NNBRHBANTOT)

    Inter BSC Incoming Handover Success (%)

    BSCSTAT

    (MSC_BSC_DATA):

    100 * NBSTIHBSUCC / NBSTSHRTOTInter BSC Outgoing Handover Success (%)

    BSCSTAT

    (MSC_BSC_DATA):

    100 * NBSTOHBSUCC / NBSTRHRTOT

    2.2 Performance Overview, BSC and Cell Set

    File Name: Shows statistics for: Performance_Overview_BSC.rep Each BSC in the network Performance_Overview_CellSet.rep Selected cell setsUses Universe: BSDR81.unv Table 3 Performance Overview BSC and Cell Set, Sheet 1: BSC / Cell Set

    Column Formula

    BSC or Cell Set -

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (8 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Random Access Success (%)

    RANDOMACC

    (BSC_CELL_MAIN / CELL_MAIN):

    100 * CNROCNT / (CNROCNT + RAACCFA)Discarded Paging due to Congestion (%)

    (BSC only)

    BSC

    (BSC_DATA):

    100 * TOTCONGPAG / TOTPAGSDCCH Traffic in OL/UL Cells (Erlang)

    CLSDCCH:

    CTRALACC / CNSCAN(BSC_CELL_MAIN / CELL_MAIN):

    C_CTRALACC

    SDCCH Time Congestion UL (%)

    CLSDCCH:

    100 * CTCONGS / (RPL * 60)(BSC_CELL_MAIN, BSC_CELL_OL / CELL_MAIN, CELL_OL ):

    100 * (CTCONGS- CTCONGS_OL) / ( RPL * 60)

    TCH Traffic (Erlang) CELTCHF, CELTCHH:

    (TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)(BSC_CELL_MAIN / CELL_MAIN):

    C_TTRALACC

    No. of TCHs CLTCH

    (BSC_CELL_MAIN / CELL_MAIN):

    TNUCHCNT

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (9 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    TCH Erlang Minutes per Drop

    CELTCHF, CELTCHH:

    RPL * ((TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN):

    RPL * C_TTRALACC / TNDROPTCH Drop (%) CELTCHF, CELTCHH, NCELLREL, NICELASS:

    100 * (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) / ((TFCASSALL + THCASSALL + TFCASSALLSUB + THCASSALLSUB) + [sum incomming HO (HOVERSUC - HOSUCBCL - HOSUCWCL)] - [sum outgoing HO (HOVERSUC - HOSUCBCL - HOSUCWCL)])(BSC_CELL_MAIN, BSC_CELL_HO / CELL_MAIN, CELL_HO):

    100 * TNDROP / (TCASSALL + (SUMIHOSUCC - SUMIABSUCC - SUMIAWSUCC) - (SUMOHOSUCC - SUMOABSUCC - SUMOAWSUCC))

    Subscriber Perceived TCH Congestion (%)

    CELTCHF, CELTCHH, CLTCH, CLSDCCH:

    100 * (CNRELCONG + (TFNRELCONG + THNRELCONG + TFNRELCONGSUB + THNRELCONGSUB)) / TASSALL(BSC_CELL_MAIN / CELL_MAIN):

    100 * (CNRELCONG + TNRELCONG) / TASSALLHandover Success (%) NCELLREL, NECELLREL:

    100 * (HOVERSUC + HOVERSUC) / (HOVERCNT + HOVERCNT)(BSC_CELL_HO / CELL_HO):

    100 * (SUMOHOSUCC + SUMEOHOSUCC) / (SUMOHOATT + SUMEOHOATT)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (10 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Handover Reversion (%) NCELLRE, NECELLREL:

    100 * (HORTTOCH + HORTTOCH) / (HOVERCNT + HOVERCNT)(BSC_CELL_HO / CELL_HO):

    100 * (SUMOHOREV + SUMEOHOREV) / (SUMOHOATT + SUMEOHOATT)

    Processor Load (%)

    (BSC only)

    LOAS:

    ACCLOAD / NSCAN(BSC_DATA):

    PROCLOAD

    2.3 Radio Overview, MSC

    File Name: Shows statistics for: Radio_Overview_MSC.rep Each MSC in the networkUses Universe: BSDR81.unv Table 4 Radio Overview MSC, Sheet 1: Channel Assignment

    Column Formula

    MSC -

    Total Channel Assignments CHASSIGNT

    (MSC_DATA):

    NCHAFRMTOT + NCHATOMTOT

    Originating Mobile Traffic (%)

    CHASSIGNT

    (MSC_DATA):

    100 * NCHAFRMTOT / (NCHAFRMTOT + NCHATOMTOT)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (11 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Terminating Mobile Traffic (%)

    CHASSIGNT

    (MSC_DATA):

    100 * NCHATOMTOT / (NCHAFRMTOT + NCHATOMTOT)

    Channel Assignment Success, Originating (%)

    CHASSIGNT

    (MSC_DATA):

    100 * NCHAFRMSUCC / NCHAFRMTOTChannel Assignment Success, Terminating (%)

    CHASSIGNT

    (MSC_DATA):

    100 * NCHATOMSUCC / NCHATOMTOTChannel Assignment Success, Originating and Terminating (%)

    CHASSIGNT

    (MSC_DATA):

    100 * (NCHATOMSUCC + NCHAFRMSUCC) / (NCHAFRMTOT + NCHATOMTOT)

    Table 5 Radio Overview MSC, Sheet 2: Location Updating

    Column Formula

    MSC -

    Location Update Success, Registered and Non-Registered (%)

    UPDLOCAT

    (MSC_DATA):

    100 * (NLOCOLDSUCC + NLOCNRGSUCC) / (NLOCOLDTOT + NLOCNRGTOT)

    Location Update Success, Registered (%)

    UPDLOCAT

    (MSC_DATA):

    100 * NLOCOLDSUCC / NLOCOLDTOT

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (12 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Location Update Success, Non-Registered (%)

    UPDLOCAT

    (MSC_DATA):

    100 * NLOCNRGSUCC / NLOCNRGTOTNo. of Location Update Attempts

    UPDLOCAT

    (MSC_DATA):

    NLOCOLDTOT + NLOCNRGTOT

    Location Update, Registered (%)

    UPDLOCAT

    (MSC_DATA):

    100 * NLOCOLDTOT / (NLOCOLDTOT + NLOCNRGTOT)

    Location Update, Non-Registered (%)

    UPDLOCAT

    (MSC_DATA):

    100 * NLOCNRGTOT / (NLOCOLDTOT + NLOCNRGTOT)

    Location Update Distribution Registered, Normal (%)

    UPDLOCAT

    (MSC_DATA):

    100 * (NLOCOLDTOT - NLOCPERTOT - NLOCATTTOT) / NLOCOLDTOT

    Location Update Distribution Registered, Periodic (%)

    UPDLOCAT

    (MSC_DATA):

    100 * NLOCPERTOT / NLOCOLDTOTIMSI Attach of Total Location Update from Registered (%)

    UPDLOCAT

    (MSC_DATA):

    100 * NLOCATTTOT / NLOCOLDTOT

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (13 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    IMSI Detach of Received IMSI Attach (%)

    UPDLOCAT

    (MSC_DATA):

    100 * NLOCDETTOT / NLOCATTTOT Table 6 Radio Overview MSC, Sheet 3: Paging Statistics

    Column Formula

    MSC -

    Total First Page Attempts PAGING

    (MSC_DATA):

    NPAG1GLTOT + NPAG1LOTOT

    Global First Page of Total First Page Attempts (%)

    PAGING

    (MSC_DATA):

    100 * NPAG1GLTOT / (NPAG1GLTOT + NPAG1LOTOT)

    First Page to Location Area of Total First Page Attempts (%)

    PAGING

    (MSC_DATA):

    100 * NPAG1LOTOT / (NPAG1GLTOT + NPAG1LOTOT)

    Success First Page of Total First Page Attempts (%)

    PAGING

    (MSC_DATA):

    100 * NPAG1RESUCC / (NPAG1GLTOT + NPAG1LOTOT)

    Success First + Repeated Pages of Total First Page Attempts (%)

    PAGING

    (MSC_DATA):

    100 * (NPAG1RESUCC + NPAG2RESUCC) / (NPAG1GLTOT + NPAG1LOTOT)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (14 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Total Repeated Page Attempts

    PAGING

    (MSC_DATA):

    NPAG2GLTOT + NPAG2LOTOT

    Repeated Pages of Total First Page Attempts (%)

    PAGING

    (MSC_DATA):

    100 * (NPAG2GLTOT + NPAG2LOTOT) / (NPAG1GLTOT + NPAG1LOTOT)

    Success Repeated Page (%)

    PAGING

    (MSC_DATA):

    100 * NPAG2RESUCC / (NPAG2GLTOT + NPAG2LOTOT)

    2.4 Radio Overview, BSC and Cell Set

    File Name: Shows statistics for: Radio_Overview_BSC.rep Each BSC in the network Radio_Overview_CellSet.rep Selected cell setsUses Universe: BSDR81.unv Table 7 Radio Overview BSC and Cell Set, Sheet 1: Random Access

    Column Formula

    BSC or Cell Set -

    Random Access Attempts RANDOMACC

    (BSC_CELL_MAIN / CELL_MAIN):

    CNROCNT + RAACCFA

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (15 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Random Access Success (%)

    RANDOMACC

    (BSC_CELL_MAIN / CELL_MAIN):

    100 * CNROCNT / (CNROCNT + RAACCFA)Answer to Paging of Total Random Access (%)

    RNDACCEXT, RANDOMACC:

    100 * (RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) / ((RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) + (RAOSREQ + RAORSPE + RAORDAT) + RAOTHER + RAEMCAL + (RACALRE + RACALR1 + RACALR2))(BSC_CELL_MAIN / CELL_MAIN )

    100 * RAAPAG / (RAAPAG + RAOTHER + RAEMCAL + RACAL + RAOREQ)

    Mobile Originated Random Access of Total Random Access (%)

    RNDACCEXT, RANDOMACC:

    100 * (RAOSREQ + RAORSPE + RAORDAT) / ((RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) + (RAOSREQ + RAORSPE + RAORDAT) + RAOTHER + RAEMCAL + (RACALRE + RACALR1 + RACALR2))(BSC_CELL_MAIN / CELL_MAIN ):

    100 * RAOREQ / (RAAPAG + RAOTHER + RAEMCAL + RACAL + RAOREQ)

    All Other Cases of Random Access of Total Random Access (%)

    RNDACCEXT, RANDOMACC:

    100 * RAOTHER / ((RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) + (RAOSREQ + RAORSPE + RAORDAT) + RAOTHER + RAEMCAL + (RACALRE + RACALR1 + RACALR2))(BSC_CELL_MAIN / CELL_MAIN ):

    100 * RAOTHER / (RAAPAG + RAOTHER + RAEMCAL + RACAL + RAOREQ)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (16 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Emergency Calls of Total Random Access (%)

    RNDACCEXT, RANDOMACC:

    100 * RAEMCAL / ((RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) + (RAOSREQ + RAORSPE + RAORDAT) + RAOTHER + RAEMCAL + (RACALRE + RACALR1 + RACALR2))(BSC_CELL_MAIN / CELL_MAIN ):

    100 * RAEMCAL/ (RAAPAG + RAOTHER + RAEMCAL + RACAL + RAOREQ)

    Call Reestablishment of Total Random Access (%)

    RNDACCEXT, RANDOMACC:

    100 * (RACALRE + RACALR1 + RACALR2) / ((RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) + (RAOSREQ + RAORSPE + RAORDAT) + RAOTHER + RAEMCAL + (RACALRE + RACALR1 + RACALR2))(BSC_CELL_MAIN / CELL_MAIN ):

    100 * RACAL / (RAAPAG + RAOTHER + RAEMCAL + RACAL + RAOREQ)

    Table 8 Radio Overview BSC and Cell Set, Sheet 2: SDCCH

    Column Object Types (SDM Tables):

    Formula

    BSC or Cell Set -

    SDCCH Traffic in OL/UL Cells (Erlang)

    CLSDCCH:

    CTRALACC / CNSCAN(BSC_CELL_MAIN / CELL_MAIN ):

    C_CTRALACC

    No. of SDCCHs CLSDCCH

    (BSC_CELL_MAIN / CELL_MAIN):

    CNUCHCNT

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (17 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    SDCCH Availability OL/UL (%)

    CLSDCCH:

    100 * (CAVAACC / CAVASCAN) / CNUCHCNT(BSC_CELL_MAIN / CELL_MAIN ):

    100 * C_CAVAACC / CNUCHCNTNumber of SDCCH Seizure Attempts

    CLSDCCH

    (BSC_CELL_MAIN / CELL_MAIN):

    CCALLS

    SDCCH Establishments OL/UL No Congestion (%)

    CLSDCCH, CLSDCCHO:

    100 * CMSESTAB / (CCALLS - (CCONGS + CCONGSSUB))(BSC_CELL_MAIN / CELL_MAIN ):

    100 * CMSESTAB / (CCALLS - CCONGS)SDCCH Time Congestion UL (%)

    CLSDCCH:

    100 * CTCONGS / (RPL * 60)(BSC_CELL_MAIN / CELL_MAIN ):

    100 * (CTCONGS - CTCONGS_OL) / (RPL * 60)

    SDCCH Mean Holding Time OL/UL (Sec.)

    CLSDCCH:

    RPL * 60 * (CTRALACC / CNSCAN) / CMSESTAB

    (BSC_CELL_MAIN / CELL_MAIN ):

    RPL * 60 * C_CTRALACC / CMSESTABTotal No. of Dropped SDCCH Connections

    CLSDCCH

    (BSC_CELL_MAIN / CELL_MAIN):

    CNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (18 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    SDCCH Drop (%) CLSDCCH

    (BSC_CELL_MAIN / CELL_MAIN):

    100 * CNDROP / CMSESTABSDCCH Erlang Minutes per Drop

    CLSDCCH:

    RPL * (CTRALACC / CNSCAN) / CNDROP (BSC_CELL_MAIN / CELL_MAIN ):

    RPL * C_CTRALACC / CNDROPSDCCH Drop Reason, Low SS (%)

    CELLCCHDR, CLSDCCH:

    100 * (CDISSS + CDISSSSUB) / CNDROP(BSC_CELL_MAIN / CELL_MAIN ):

    100 * CDISSS / CNDROPSDCCH Drop Reason, Bad Quality (%)

    CELLCCHDR, CLSDCCH:

    100 * (CDISQA + CDISQASUB) / CNDROP(BSC_CELL_MAIN / CELL_MAIN ):

    100 * CDISQA / CNDROPSDCCH Drop Reason, Excessive TA (%)

    CELLCCHDR, CLSDCCH:

    (BSC_CELL_MAIN / CELL_MAIN):

    100 * CDISTA / CNDROPSDCCH Drop Reason, Other (%)

    CLSDCCH, CELLCCHDR:

    100 * (CNDROP - ((CDISSS + CDISSSSUB) + (CDISQA + CDISQASUB) + CDISTA)) / CNDROP(BSC_CELL_MAIN / CELL_MAIN ):

    100 * (CNDROP - (CDISSS + CDISQA + CDISTA)) / CNDROP

    Table 9 Radio Overview BSC and Cell Set, Sheet 3: TCH

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (19 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Column Formula

    BSC or Cell Set -

    TCH Traffic (Erlang) CELTCHF, CELTCHH:

    (TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)(BSC_CELL_MAIN / CELL_MAIN ):

    C_TTRALACC

    No. of TCHs CLTCH

    (BSC_CELL_MAIN / CELL_MAIN):

    TNUCHCNT

    TCH Availability (%) CLTCH:

    100 * (TAVAACC / TAVASCAN) / TNUCHCNT(BSC_CELL_MAIN / CELL_MAIN ):

    100 * C_TAVA / TNUCHCNTTotal Assignment Attempts CLTCH

    (BSC_CELL_MAIN / CELL_MAIN):

    TASSALL

    TCH Assignment Success (%)

    CELTCHF, CELTCHH, CLTCH:

    100 * (TFCASSALL + THCASSALL + TFCASSALLSUB + THCASSALLSUB) / TASSALL(BSC_CELL_MAIN / CELL_MAIN ):

    100 * TCASSALL / TASSALLSubscriber Perceived TCH Congestion(%)

    CLSDCCH, CELTCHF, CELTCHH, CLTCH:

    100 * (CNRELCONG + (TFNRELCONG + THNRELCONG + TFNRELCONGSUB + THNRELCONGSUB)) / TASSALL

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (20 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (BSC_CELL_MAIN / CELL_MAIN ):

    100 * (CNRELCONG + TNRELCONG) / TASSALLTCH Mean Holding Time (Sec.)

    CELTCHF, CELTCHH:

    RPL * 60 * ((TFTRALACC / TFNSCAN) + THTRALACC / THNSCAN)) / (TFMSESTB + THMSESTB)(BSC_CELL_MAIN / CELL_MAIN ):

    RPL * 60 * C_TTRALACC / TMSESTBTotal No. of Dropped TCH Connections

    CELTCHF, CELTCHH:

    TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB

    (BSC_CELL_MAIN / CELL_MAIN ):

    TNDROP

    TCH Drop (%) CELTCHF, CELTCHH, NCELLREL, NICELASS:

    100 * (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) / ((TFCASSALL + THCASSALL + TFCASSALLSUB + THCASSALLSUB) + [sum incoming HO(HOVERSUC - HOSUCBCL - HOSUCWCL)] - [sum outgoing HO(HOVERSUC - HOSUCBCL - HOSUCWCL)])(BSC_CELL_MAIN, BSC_CELL_HO / CELL_MAIN, CELL_HO):

    100 * TNDROP / (TCASSALL + (SUMIHOSUCC - SUMIABSUCC - SUMIAWSUCC) - (SUMOHOSUCC - SUMOABSUCC - SUMOAWSUCC))

    TCH Erlang Minutes per Drop

    CELTCHF, CELTCHH:

    RPL * ((TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN ):

    RPL * C_TTRALACC / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (21 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    TCH Drop Reason, Low SS (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * ((TFDISSDL + THDISSDL + TFDISSDLSUB + THDISSDLSUB) + (TFDISSUL + THDISSUL + TFDISSULSUB + THDISSULSUB) + (TFDISSBL + THDISSBL + TFDISSBLSUB + THDISSBLSUB)) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN ):

    100 * (TDISSDL + TDISSUL + TDISSBL) / TNDROP

    TCH Drop Reason, Bad Quality (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * ((TFDISQADL + THDISQADL + TFDISQADLSUB + THDISQADLSUB) + (TFDISQAUL + THDISQAUL + TFDISQAULSUB + THDISQAULSUB) + (TFDISQABL + THDISQABL + TFDISQABLSUB + THDISQABLSUB)) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN ):

    100 * (TDISQADL + TDISQAUL + TDISQABL) / TNDROP

    TCH Drop Reason, Suddenly Lost Connection (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFSUDLOS + THSUDLOS + TFSUDLOSSUB + THSUDLOSSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN ):

    100 * TSUDLOS / TNDROPTCH Drop Reason, Excessive TA (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISTA + THDISTA) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN ):

    100 * TDISTA / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (22 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    TCH Drop Reason, Other (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * ((TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) - ((TFDISSDL + THDISSDL + TFDISSDLSUB + THDISSDLSUB) + (TFDISSUL + THDISSUL + TFDISSULSUB + THDISSULSUB) + (TFDISSBL + THDISSBL + TFDISSBLSUB + THDISSBLSUB) + (TFDISQADL + THDISQADL + TFDISQADLSUB + THDISQADLSUB) + (TFDISQAUL + THDISQAUL + TFDISQAULSUB + THDISQAULSUB) + (TFDISQABL + THDISQABL + TFDISQABLSUB + THDISQABLSUB) + (TFDISTA + THDISTA) + (TFSUDLOS + THSUDLOS + TFSUDLOSSUB + THSUDLOSSUB))) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN ):

    100 * (TNDROP - (TDISSDL + TDISSUL + TDISSBL +TDISQADL + TDISQAUL + TDISQABL + TDISTA + TSUDLOS)) / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (23 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    3 Planning Reports

    3.1 Call Rejection Exceptions

    File Name: Shows statistics for: Call_Rejection_Exceptions.rep Each MSC Uses Universe: BSDR81.unv Table 10 Call Rejection Exceptions, Sheet 1: Call Rejection Exceptions

    Column Formula

    MSC -

    Call Rejection (%) MTRAFTYPE:

    100 * (NUNSUCC[ORG] + NUNSUCC[UEX] + NUNSUCC[SOT]) / (NCALLS[ORG] + NCALLS[IEX] + NCALLS[SOT])(MSC_TRAFFTYPE):

    100 * (ORG_NUNSUCC + IEX_NUNSUCC + SOT_NUNSUCC) / (ORG_NCALLS + IEX_NCALLS + SOT_NCALLS)

    Lost Traffic (%) MTRAFTYPE:

    100 * ((NCALLS[ORG] + NCALLS[IEX] + NCALLS[SOT]) - (NCALLS[OEX] + NCALLS[STT] + NCALLS[TE])) / (NCALLS[ORG] + NCALLS[IEX] + NCALLS[SOT])(MSC_TRAFFTYPE):

    100 * ((ORG_NCALLS + IEX_NCALLS + SOT_NCALLS) - (OEX_NCALLS + TE_NCALLS + STT_CALLS)) / (ORG_NCALLS + IEX_NCALLS + SOT_NCALLS)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (24 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Offered Traffic (Erlang) MTRAFTYPE:

    (NTRALACC[ORG] / NSCAN[ORG]) + (NTRALACC[IEX] / NSCAN[IEX]) + (NTRALACC[SOT] / NSCAN[SOT])(MSC_TRAFFTYPE):

    ORG_TRAFFIC + IEX_TRAFFIC + SOT_TRAFFIC

    Measured Traffic (Erlang) MTRAFTYPE:

    (NTRALACC[OEX] / NSCAN[OEX]) + (NTRALACC[TE] / NSCAN[TE]) + (NTRALACC[STT] / NSCAN[STT])(MSC_TRAFFTYPE):

    OEX_TRAFFIC + TE_TRAFFIC + STT_TRAFFIC

    Answered Calls (%) MTRAFTYPE:

    100 * (NANSW[ORG] + NANSW[IEX] + NANSW[SOT]) / (NCALLS[ORG] + NCALLS[IEX] + NCALLS[SOT])(MSC_TRAFFTYPE):

    100 * (ORG_NANSW + IEX_NANSW + SOT_NANSW) / (ORG_NCALLS + IEX_NCALLS + SOT_NCALLS)

    Internal Congestion (%) MTRAFTYPE:

    100 * (NICONG[ORG] + NICONG[IEX] + NICONG[SOT] / (NCALLS[ORG] + NCALLS[IEX] + NCALLS[SOT])(MSC_TRAFFTYPE):

    100 * (ORG_NICONG + IEX_NICONG + SOT_NICONG) / (ORG_NCALLS + IEX_NCALLS + SOT_NCALLS)

    External Congestion (%) MTRAFTYPE:

    100 * (NECONG[ORG] + NECONG[IEX] + NECONG[SOT]) / (NCALLS[ORG] + NCALLS[IEX] + NCALLS[SOT])

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (25 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (MSC_TRAFFTYPE):

    100 * (ORG_NECONG + IEX_NECONG + SOT_NECONG) / (ORG_NCALLS + IEX_NCALLS + SOT_NCALLS)

    Through Connect Calls (%) MTRAFTYPE:

    100 * (NSUEOS[ORG] + NSUEOS[IEX] + NSUEOS[SOT]) / (NCALLS[ORG] + NCALLS[IEX] + NCALLS[SOT])(MSC_TRAFFTYPE):

    100 * (ORG_NSEUOS + IEX_NSEUOS + SOT_NSEUOS) / (ORG_NCALLS + IEX_NCALLS + SOT_NCALLS)

    3.2 Call Setup Performance Overview, BSC and Cell Set

    File Name: Shows statistics for: Call_Setup_Performance_Overview.rep Each MSC and BSC Call_Setup_Performance_BSC.rep Each cell in a BSC Call_Setup_Performance_CellSet.rep Each cell in a cell setUses Universe: BSDR81.unv Table 11 Call Setup Performance Overview, Sheet 1: Call Setup, MSC and Sheet 2: Call Setup BSC. Call Setup Performance BSC and Cell Set, Sheet 1: Call Setup

    Column Formula

    MSC, BSC or Cell Name -

    No. of SDCCH Seizure Attempts CLSDCCH

    (MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

    CCALLS

    Congestion Based on Seizure Attempts (%) CLSDCCH, CLSDCCHO:

    100 * (CCONGS + CCONGSSUB) / CCALLS

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (26 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

    100 * CCONGS / CCALLSNo. of SDCCH Connections CLSDCCH

    (MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

    CMSESTAB

    SDCCH Establishments OL/UL No Congestion (%) CLSDCCH, CLSDCCHO:

    100 * CMSESTAB / (CCALLS - (CCONGS + CCONGSSUB))(MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

    100 * CMSESTAB / (CCALLS - CCONGS)SDCCH Time Congestion UL (%) CLSDCCH:

    100 * CTCONGS / (RPL * 60)(MSC_CELL_MAIN, MSC_CELL_OL / BSC_CELL_MAIN, BSC_CELL_OL / CELL_MAIN / CELL_OL):

    100 * (CTCONGS - CTCONGS_OL) / (RPL * 60)Total Dropped SDCCH Connections CLSDCCH

    (MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

    CNDROP

    SDCCH Drop (%) CLSDCCH

    (MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

    100 * CNDROP / CMSESTABSDCCH Mean Holding Time OL/UL (Sec.) CLSDCCH:

    RPL * 60 * (CTRALACC / CNSCAN) / CMSESTAB(MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

    RPL * 60 * C_CTRALACC / CMSESTAB

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (27 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Total Assignment Attempts CLTCH

    (MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

    TASSALL

    TCH Assignment Success (%) CELTCHF, CELTCHH, CLTCH:

    100 * (TFCASSALL + THCASSALL + TFCASSALLSUB + THCASSALLSUB) / TASSALL(MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

    100 * TCASSALL / TASSALL

    3.3 Calls and Answers

    File Name: Shows statistics for: Calls_and_Answers.rep Each MSCUses Universe: BSDR81.unv Table 12 Calls and Answers, Sheet 1 & 2: Number of Calls

    Column Formula

    MSC -

    No. of Calls MTRAFTYPE:

    NCALLS[ ](MSC_TRAFFTYPE):

    _NCALLS Table 13 Calls and Answers, Sheet 3 & 4: Number of Answers

    Column Formula

    MSC -

    No. of Answers MTRAFTYPE:

    NANSW[ ]

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (28 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (MSC_TRAFFTYPE):

    _NANSW Table 14 Calls and Answers, Sheet 5: Answer Rate

    Column Formula

    MSC -

    Answers (%) MTRAFTYPE:

    100 * NANSW[ ] / NCALLS[ ](MSC_TRAFFTYPE):

    100 * _NANSW / _NCALLS

    3.4 Congestion

    File Name: Shows statistics for: Congestion.rep Each MSCUses Universe: BSDR81.unv Table 15 Congestion, Sheet 1: External Congestion

    Column Formula

    MSC -

    External Congestion (%) MTRAFTYPE:

    100 * NECONG[ ] / NCALLS[ ](MSC_TRAFFTYPE):

    100 * _NECONG / _NCALLS

    Table 16 Congestion, Sheet 2: Internal Congestion

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (29 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Column Formula

    MSC -

    Internal Congestion (%) MTRAFTYPE:

    100 * NICONG[ ] / NCALLS[ ](MSC_TRAFFTYPE):

    100 * _NICONG / _NCALLS

    3.5 CP Load

    File Name: Shows statistics for: CP_Load.rep Each MSC and BSCUses Universe: BSDR81.unv Table 17 CP Load, Sheet 1: CP Load, MSC

    Column Formula

    MSC -

    Processor Load, MSC (%) LOAS:

    ACCLOAD / NSCAN(MSC_PEAK):

    PROCLOAD

    Traffic (Erlang) MTRAFTYPE:

    (NTRALACC[ORG] / NSCAN[ORG]) + (NTRALACC[IEX] / NSCAN[IEX]) + (NTRALACC[SOT] / NSCAN[SOT])(MSC_TRAFFTYPE_PEAK):

    TRAFFIC_TRAFFIC

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (30 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Table 18 CP Load, Sheet 3: CP Load, BSC

    Column Formula

    MSC -

    BSC -

    Processor Load, BSC (%) LOAS:

    ACCLOAD / NSCAN(BSC_PEAK):

    PROCLOAD

    TCH Traffic (Erlang) CELTCHF, CELTCHH:

    (TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)(BSC_CELL_MAIN_PEAK):

    C_TTRALACC

    3.6 Hardware Dimensioning, BSC and Cell Set

    File Name: Shows statistics for: Hardware_Dimensioning_BSC.rep Each cell in a BSC Hardware_Dimensioning_CellSet.rep Each cell in a cell setUses Universe: BSDR81.unv Table 19 HW Dimensioning, BSC and Cell Set, Sheet 1

    Column Formula

    Cell Name -

    Average No. of Available SDCCH OL/UL

    CLSDCCH:

    CAVAACC / CAVASCAN(CELL_MAIN_PEAK):

    C_CAVAACC

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (31 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    SDCCH Availability OL/UL (%)

    CLSDCCH:

    100 * (CAVAACC / CAVASCAN) / CNUCHCNT(CELL_MAIN_PEAK):

    100 * C_CAVAACC / CNUCHCNTSDCCH Traffic in OL/UL Cells (Erlang)

    CLSDCCH:

    CTRALACC / CNSCAN(CELL_MAIN_PEAK):

    C_CTRALACC

    SDCCH Time Congestion UL (%)

    CLSDCCH:

    100 * CTCONGS / (RPL * 60)(CELL_MAIN_PEAK, CELL_OL_PEAK):

    100 * (CTCONGS - CTCONGS_OL) / (RPL * 60)

    SDCCH/TCH Ratio CLSDCCH, CELTCHF, CELTCHH:

    (CTRALACC / CNSCAN) / ((TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN))(CELL_MAIN_PEAK):

    C_CTRALACC / C_TTRALACCReconfiguration Attempts TCH=>SDCCH (%)

    CELLCONF

    (CELL_MAIN_PEAK):

    100 * CONFATTC / (CONFATTC + CONFATTT)Reconfiguration Attempts SDCCH=>TCH (%)

    CELLCONF

    (CELL_MAIN_PEAK):

    100 * CONFATTT / (CONFATTC + CONFATTT)Band -

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (32 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Layer -

    Cell Peak Hour - Table 20 HW Dimensioning, BSC and Cell Set, Sheet 2

    Column Formula

    Cell Name -

    Average No. of Available TCH

    CLTCH:

    TAVAACC / TAVASCAN(CELL_MAIN_PEAK):

    C_TAVA

    TCH Availability (%) CLTCH:

    100 * (TAVAACC / TAVASCAN) / TNUCHCNT(CELL_MAIN_PEAK):

    100 * C_TAVA / TNUCHCNTTCH Traffic (Erlang) CELTCHF, CELTCHH:

    (TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)(CELL_MAIN_PEAK):

    C_TTRALACC

    No. of Required Devices (erlang table)

    Erlang B Traffic (Erlang) (erlang table)

    Erlang B Capacity (%) (erlang table)

    Subscriber Perceived TCH Congestion(%)

    CLSDCCH, CELTCHF, CELTCHH, CLTCH:

    100 * ((CNRELCONG + (TFNRELCONG + THNRELCONG + TFNRELCONGSUB + THNRELCONGSUB)) / TASSALL)(CELL_MAIN_PEAK):

    100 * (CNRELCONG + TNRELCONG) / TASSALLCell Peak Hour -

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (33 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    3.7 Location Update, MSC

    File Name: Shows statistics for: Location_Update_MSC.rep Each MSCUses Universe: BSDR81.unv Table 21 Location Update MSC, Sheet 1: Location Updating

    Column Formula

    MSC -

    Location Update

    Attempts (Registered and Non-Registered)

    UPDLOCAT

    (MSC_DATA):

    NLOCOLDTOT + NLOCNRGTOT

    Registered (%) UPDLOCAT

    (MSC_DATA):

    100 * NLOCOLDTOT / (NLOCOLDTOT + NLOCNRGTOT)

    Non-Registered (%) UPDLOCAT

    (MSC_DATA):

    100 * NLOCNRGTOT / (NLOCOLDTOT + NLOCNRGTOT)

    Location Update Success

    Registered + Non-Registered (%)

    UPDLOCAT

    (MSC_DATA):

    100 * (NLOCOLDSUCC + NLOCNRGSUCC) / (NLOCOLDTOT + NLOCNRGTOT)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (34 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Registered (%) UPDLOCAT

    (MSC_DATA):

    100 * NLOCOLDSUCC / NLOCOLDTOT Non -Registered (%) UPDLOCAT

    (MSC_DATA):

    100 * NLOCNRGSUCC / NLOCNRGTOTLocation Update Distribution

    Registered Subscribers, Normal (%)

    UPDLOCAT

    (MSC_DATA):

    100 * (NLOCOLDTOT - NLOCPERTOT - NLOCATTTOT) / NLOCOLDTOT

    Registered Subscribers, Periodic (%)

    UPDLOCAT

    (MSC_DATA):

    100 * NLOCPERTOT / NLOCOLDTOTIMSI Attach of Total Location Update from Registered (%)

    UPDLOCAT

    (MSC_DATA):

    100 * NLOCATTTOT / NLOCOLDTOTNo. of IMSI Detach (%) UPDLOCAT

    (MSC_DATA):

    100 * NLOCDETTOT / NLOCATTTOTAuthentication Requests Sent

    SECHAND

    (MSC_DATA):

    NAUTREQTOT

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (35 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Successful Authentication Including SRES (%)

    SECHAND

    (MSC_DATA):

    100 * NAUTREQSUCC / NAUTREQTOT

    3.8 Paging Statistics, MSC

    File Name: Shows statistics for: Paging_Statistics_MSC.rep Each MSC and BSCUses Universe: BSDR81.unv Table 22 Paging Statistics MSC, Sheet 1: Paging, MSC

    Column Formula

    MSC -

    Total First Page Attempts PAGING

    (MSC_DATA):

    NPAG1GLTOT + NPAG1LOTOT

    Global First Page of Total First Page Attempts (%)

    PAGING

    (MSC_DATA):

    100 * NPAG1GLTOT / (NPAG1LOTOT + NPAG1GLTOT)

    First Page to Location Area of Total First Page Attempts (%)

    PAGING

    (MSC_DATA):

    100 * NPAG1LOTOT / (NPAG1LOTOT + NPAG1GLTOT)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (36 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Success First Page of Total First Page Attempts (%)

    PAGING

    (MSC_DATA):

    100 * NPAG1RESUCC / (NPAG1GLTOT + NPAG1LOTOT)

    Paging Success (%) PAGING

    (MSC_DATA):

    100 * (NPAG1RESUCC + NPAG2RESUCC ) / (NPAG1LOTOT + NPAG1GLTOT)

    Total Repeated Page Attempts

    PAGING

    (MSC_DATA):

    NPAG2GLTOT + NPAG2LOTOT

    Repeated Pages of Total First Page Attempts (%)

    PAGING

    (MSC_DATA):

    100 * (NPAG2GLTOT + NPAG2LOTOT) / (NPAG1GLOTOT + NPAG1LOTOT)

    Success Repeated Page (%)

    PAGING

    (MSC_DATA):

    100 * NPAG2RESUCC / (NPAG2LOTOT + NPAG2GLOTOT)

    Table 23 Paging Statistics MSC, Sheet 3: BSC Paging Congestion

    Column Formula

    BSC -

    No. of Received Paging Messages

    BSC

    (BSC_DATA):

    TOTPAG

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (37 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Discarded Paging due to Congestion (%)

    BSC

    (BSC_DATA):

    100 * TOTCONGPAG / TOTPAG

    3.9 Paging Statistics and Location Updating

    File Name: Shows statistics for: Paging_Statistics_and_Location_Updating.rep Each Location Area in

    an MSCUses Universe: BSDR81.unv Table 24 Paging and Location Updating, Sheet 1: Paging and Location Updating

    Column Formula

    Location Area -

    Total First Page Attempts LOCAREAST

    (LA_DATA):

    NLAPAG1LOTOT

    Paging Success (%) LOCAREAST

    (LA_DATA):

    100 * (NLAPAG1RESUCC + NLAPAG2RESUCC) / NLAPAG1LOTOT

    Successful First Page of Total First Page Attempts (%)

    LOCAREAST

    (LA_DATA):

    100 * NLAPAG1RESUCC / NLAPAG1LOTOTRepeated Pages of Total First Page Attempts (%)

    LOCAREAST

    (LA_DATA):

    100 * NLAPAG2LOTOT / NLAPAG1LOTOTfile:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (38 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Successful Repeated Page (%)

    LOCAREAST

    (LA_DATA):

    100 * NLAPAG2RESUCC / NLPAG2LOTOTLocation Update Success (%)

    LOCAREAST

    (LA_DATA):

    100 * NLALOCSUCC / NLALOCTOTTotal Location Updates LOCAREAST

    (LA_DATA):

    NLALOCTOT

    3.10 OL/UL Subcells, BSC and Cell Sets

    File Name: Shows statistics for: OL_UL_Subcells_BSC.rep Each cell in a BSC OL_UL_Subcells_CellSet.rep Each cell in a cell setUses Universe: BSDR81.unv Table 25 OL/UL Subcells, BSC and Cell Sets

    Column Formula

    Cell Name -

    Band -

    Layer -

    Cell Peak Hour -

    TCH Traffic UL FullRate (Erlang)

    CELTCHF:

    (TFTRALACC / TFNSCAN) - (TFTRALSUB / TFNSCAN)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (39 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (CELL_MAIN_PEAK, CELL_HR_PEAK, CELL_OL_PEAK):

    C_TTRALACC - C_TTRALACC_HR - C_TTRAL_FR_ OL

    TCH Traffic UL HalfRate (Erlang)

    CELTCHH:

    (THTRALACC / THNSCAN) - (THTRALSUB / THNSCAN)(CELL_HR_PEAK, CELL_OL_PEAK):

    C_TTRALACC_HR - C_TTRAL_HR_OL

    TCH Traffic OL FullRate (Erlang)

    CELTCHF:

    TFTRALSUB / TFNSCAN(CELL_OL_PEAK):

    C_TTRAL_FR_OL

    TCH Traffic OL HalfRate (Erlang)

    CELTCHH:

    THTRALSUB / THNSCAN(CELL_OL_PEAK):

    C_TTRAL_HR_OL

    TCH Time Congestion FullRate UL (%)

    CELTCHF:

    100 * TFTCONGS / (RPL * 60)(CELL_MAIN_PEAK, CELL_OL_PEAK, CELL_HR_PEAK):

    100 * (TTCONGS - TTCONGS_FR_OL - TTCONGS_HR) / (RPL * 60)

    TCH Time Congestion HalfRate UL (%)

    CELTCHH:

    100 * THTCONGS / (RPL * 60)(CELL_HR_PEAK, CELL_OL_PEAK):

    100 * ( TTCONGS_HR - TTCONGS_HR_ OL) / (RPL * 60)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (40 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Subscriber Perceived TCH Congestion (%)

    CLSDCCH, CELTCHF, CELTCHH, CLTCH:

    100 * (CNRELCONG + (TFNRELCONG + THNRELCONG + TFNRELCONGSUB + THNRELCONGSUB)) / TASSALL(CELL_MAIN_PEAK):

    100 * (CNRELCONG + TNRELCONG) / TASSALL

    3.11 Random Access, BSC

    File Name: Shows statistics for: Random_Access_BSC.rep Each MSC and BSCUses Universe: BSDR81.unv Table 26 Random Access BSC, Sheet 1: Random Access BSC

    Column Formula

    Cell Name -

    Random Access Attempts RANDOMACC

    (CELL_MAIN):

    CNROCNT + RAACCFA

    Random Access Success (%)

    RANDOMACC

    (CELL_MAIN):

    100 * CNROCNT / (CNROCNT + RAACCFA)SDCCH Establishments OL/UL No Congestion (%)

    CLSDCCH, CLSDCCHO:

    100 * CMSESTAB / (CCALLS - (CCONGS + CCONGSSUB))(CELL_MAIN):

    100 * CMSESTAB / (CCALLS - CCONGS )

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (41 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Answer to Paging of Total Random Access (%)

    RNDACCEXT, RANDOMACC:

    100 * (RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) / ((RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) + (RAOSREQ + RAORSPE + RAORDAT) + RAOTHER + RAEMCAL + (RACALRE + RACALR1 + RACALR2))(CELL_MAIN):

    100 * RAAPAG / (RAAPAG + RAOREQ + RAOTHER + RAEMCAL + RACAL)

    Mobile Originated Random Access of Total Random Access (%)

    RNDACCEXT, RANDOMACC:

    100 * (RAOSREQ + RAORSPE + RAORDAT) / ((RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) + (RAOSREQ + RAORSPE + RAORDAT) + RAOTHER + RAEMCAL + (RACALRE + RACALR1 + RACALR2))(CELL_MAIN):

    100 * RAOREQ / (RAAPAG + RAOREQ + RAOTHER + RAEMCAL + RACAL)

    All Other Cases of Random Access of Total Random Access (%)

    RNDACCEXT, RANDOMACC:

    100 * RAOTHER / ((RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) + (RAOSREQ + RAORSPE + RAORDAT) + RAOTHER + RAEMCAL + (RACALRE + RACALR1 + RACALR2))(CELL_MAIN):

    100 * RAOTHER / (RAAPAG + RAOREQ + RAOTHER + RAEMCAL + RACAL)

    Emergency Calls of Total Random Access (%)

    RNDACCEXT, RANDOMACC:

    100 * RAEMCAL / ((RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) + (RAOSREQ + RAORSPE + RAORDAT) + RAOTHER + RAEMCAL + (RACALRE + RACALR1 + RACALR2))(CELL_MAIN):

    100 * RAEMCAL / (RAAPAG + RAOREQ + RAOTHER + RAEMCAL + RACAL)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (42 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Call Reestablishment of Total Random Access (%)

    RNDACCEXT, RANDOMACC:

    100 * (RACALRE + RACALR1 + RACALR2) / ((RAANPAG + RAAPAG1 + RAAPAG2 + RAAPOPS) + (RAOSREQ + RAORSPE + RAORDAT) + RAOTHER + RAEMCAL + (RACALRE + RACALR1 + RACALR2))(CELL_MAIN):

    100 * RACAL / (RAAPAG + RAOREQ + RAOTHER + RAEMCAL + RACAL)

    3.12 Subscriber Activity Profile

    File Name: Shows statistics for: Subscriber_Activity_Profile.rep Each MSCUses Universe: BSDR81.unv Table 27 Subscriber Activity Profile, Sheet 1: Subscriber Activity

    Column Formula

    Time/Day -

    Average No. of VLR Subscribers

    (VLR_DATA):

    ACTSUB

    Average No. o Attached VLR Subscribers

    (VLR_DATA):

    ATTSUB

    3.13 System Performance Charts

    File Name: Shows statistics for: System_Performance_Charts.rep All BSCUses Universe: BSDR81.unv Table 28 System Performance Charts, Sheet 1: SDCCH Trend

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (43 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Axis/Legend Formula

    Category (X) axis

    Measurement Period and BSC

    -

    Left value (Y) axis

    Failed Random Access (%)

    RANDOMACC

    (BSC_CELL_MAIN):

    100 * RAACCFA / (RAACCFA + CNROCNT)Left value (Y) axis

    SDCCH Drop (%)

    CLSDCCH

    (BSC_CELL_MAIN):

    100 * CNDROP / CMSESTABLeft value (Y) axis

    SDCCH Congestion (%)

    CLSDCCH, CLSDCCHO:

    100 * (CCONGS + CCONGSSUB) / CCALLS(BSC_CELL_MAIN):

    100 * CCONGS / CCALLS

    3.14 Through Connect Calls

    File Name: Shows statistics for: Through_Connect_Calls.rep Each MSCUses Universe: BSDR81.unv Table 29 Through Connect Calls, Sheet 1: Through Connect Calls

    Column Formula

    MSC -

    Through Connect Calls (%)

    MTRAFTYPE:

    100 * NSUEOS[ ] / NCALLS[ ]

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (44 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (MSC_TRAFFTYPE):

    100 * _NSUEOS / _NCALLS

    3.15 Traffic

    File Name: Shows statistics for: Traffic.rep Each MSCUses Universe: BSDR81.unv Table 30 Traffic, Sheet 1: Traffic

    Column Formula

    MSC -

    Traffic (Erlang) MTRAFTYPE:

    NTRALACC[ ] / NSCAN[ ](MSC_TRAFFTYPE):

    _TRAFFIC Table 31 Traffic, Sheet 2: Traffic Distribution

    Column Formula

    MSC -

    Traffic Distribution (%)

    IEX of (ORG+IEX+SOT) MTRAFTYPE:

    100 * (NTRALACC[IEX] / NSCAN[IEX]) / ((NTRALACC[ORG] / NSCAN[ORG]) + (NTRALACC[IEX] / NSCAN[IEX]) + (NTRALACC[SOT] / NSCAN[SOT]))

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (45 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (MSC_TRAFFTYPE):

    100 * IEX_TRAFFIC / TRAFFIC_TRAFFIC IEXSTT of (IEX) MTRAFTYPE:

    100 * (NTRALACC[IEXSTT] / NSCAN[IEXSTT]) / (NTRALACC[IEX] / NSCAN[IEX])(MSC_TRAFFTYPE):

    100 * IEXSTT_TRAFFIC / IEX_TRAFFIC IEXTE of (IEX) MTRAFTYPE:

    100 * (NTRALACC[IEXTE] / NSCAN[IEXTE]) / (NTRALACC[IEX] / NSCAN[IEX])(MSC_TRAFFTYPE):

    100 * IEXTE_TRAFFIC / IEX_TRAFFIC INT of (ORG) MTRAFTYPE:

    100 * (NTRALACC[INT] / NSCAN[INT]) / (NTRALACC[ORG] / NSCAN[ORG])(MSC_TRAFFTYPE):

    100 * INT_TRAFFIC / ORG_TRAFFIC OEX of

    (ORG+IEX+SOT)MTRAFTYPE:

    100 * (NTRALACC[OEX] / NSCAN[OEX]) / ((NTRALACC[ORG] / NSCAN[ORG]) + (NTRALACC[IEX] / NSCAN[IEX]) + (NTRALACC[SOT] / NSCAN[SOT]))(MSC_TRAFFTYPE):

    100 * OEX_TRAFFIC / TRAFFIC_TRAFFIC

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (46 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    ORG of (ORG+IEX+SOT)

    MTRAFTYPE:

    100 * (NTRALACC[ORG] / NSCAN[ORG]) / ((NTRALACC[ORG] / NSCAN[ORG]) + (NTRALACC[IEX] / NSCAN[IEX]) + (NTRALACC[SOT] / NSCAN[SOT]))(MSC_TRAFFTYPE):

    100 * ORG_TRAFFIC / TRAFFIC_TRAFFIC ORGOEX of (ORG) MTRAFTYPE:

    100 * (NTRALACC[ORGOEX] / NSCAN[ORGOEX]) / (NTRALACC[ORG] / NSCAN[ORG])(MSC_TRAFFTYPE):

    100 * ORGOEX_TRAFFIC / ORG_TRAFFIC ORGSTT of (ORG) MTRAFTYPE:

    100 * (NTRALACC[ORGSTT] / NSCAN[ORGSTT]) / (NTRALACC[ORG] / NSCAN[ORG])(MSC_TRAFFTYPE):

    100 * ORGSTT_TRAFFIC / ORG_TRAFFIC SOSTT of (SOT) MTRAFTYPE:

    100 * (NTRALACC[SOSTT] / NSCAN[SOSTT]) / (NTRALACC[SOT] / NSCAN[SOT])(MSC_TRAFFTYPE):

    100 * SOSTT_TRAFFIC / SOT_TRAFFIC

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (47 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    SOT of (ORG+IEX+SOT)

    MTRAFTYPE:

    100 * (NTRALACC[SOT] / NSCAN[SOT]) / ((NTRALACC[ORG] / NSCAN[ORG]) + (NTRALACC[IEX] / NSCAN[IEX]) + (NTRALACC[SOT] / NSCAN[SOT]))(MSC_TRAFFTYPE):

    100 * SOT_TRAFFIC / TRAFFIC_TRAFFIC SOTOEX of (SOT) MTRAFTYPE:

    100 * (NTRALACC[SOTOEX] / NSCAN[SOTOEX]) / (NTRALACC[SOT] / NSCAN[SOT])(MSC_TRAFFTYPE):

    100 * SOTOEX_TRAFFIC / SOT_TRAFFIC SOTTE of (SOT) MTRAFTYPE:

    100 * (NTRALACC[SOTTE] / NSCAN[SOTTE]) / (NTRALACC[SOT] / NSCAN[SOT])(MSC_TRAFFTYPE):

    100 * SOTTE_TRAFFIC / SOT_TRAFFIC STT of (ORG+IEX+SOT) MTRAFTYPE:

    100 * (NTRALACC[STT] / NSCAN[STT]) / ((NTRALACC[ORG] / NSCAN[ORG]) + (NTRALACC[IEX] / NSCAN[IEX]) + (NTRALACC[SOT] / NSCAN[SOT]))(MSC_TRAFFTYPE):

    100 * STT_TRAFFIC / TRAFFIC_TRAFFIC

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (48 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    TE of (ORG+IEX+SOT) MTRAFTYPE:

    100 * (NTRALACC[TE] / NSCAN[TE]) / ((NTRALACC[ORG] / NSCAN[ORG]) + (NTRALACC[IEX] / NSCAN[IEX]) + (NTRALACC[SOT] / NSCAN[SOT]))(MSC_TRAFFTYPE):

    100 * TE_TRAFFIC / TRAFFIC_TRAFFIC TRA of (IEX) MTRAFTYPE:

    100 * (NTRALACC[TRA] / NSCAN[TRA]) / (NTRALACC[IEX] / NSCAN[IEX])(MSC_TRAFFTYPE):

    100 * TRA_TRAFFIC / IEX_TRAFFIC

    3.16 Traffic Dispersion

    File Name: Shows statistics for: Traffic_Dispersion.rep All destinations and

    routes in an MSCUses Universe: BSDR81.unv Table 32 Traffic Dispersion

    Column Formula

    Destination -

    Route -

    No. of Outgoing Calls OMS_TRDIP:

    NCC + NDO

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (49 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (DEST_DATA):

    NOUTGS

    No. of Rejected Calls OMS_TRDIP

    (DEST_DATA):

    NRC

    B-answers OMS_TRDIP

    (DEST_DATA):

    NBA

    Answer to Seizure Ratio (%)

    OMS_TRDIP:

    100 * NBA / (NCC + NDO)(DEST_DATA):

    100 * NBA / NCALLSRejected Calls (%) OMS_TRDIP:

    100 * NRC / (NCC + NDO)(DEST_DATA):

    100 * NRC / NCALLSTraffic (Erlang) OMS_TRDIP:

    ATC / NSCS + AST / (SCI * NSCS)(DEST_DATA):

    TRAFFIC

    Mean Conversation Time (Sec.)

    OMS_TRDIP

    (DEST_DATA):

    ATB * SCI / NBAMean Holding Time (Sec.) OMS_TRDIP

    (ATC * SCI + AST) / (NCC + NDO)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (50 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (DEST_DATA):

    (ATC * SCI + AST) / NCALLS

    3.17 Traffic Measurement on Routes, MSC and Route Sets

    File Name: Shows statistics for: Traffic_Measurements_On_Routes_MSC.rep Each route on an MSC Traffic_Measurement_On_Routes_Route_Set.rep Each route in a route

    set Uses Universe: BSDR81.unv Table 33 Traffic Measurement on Routes MSC and Route Sets, Sheet 1: Traffic Measurements

    Column Formula

    Route Name -

    Route Peak Hour -

    Route Traffic (Erlang) OMS_TRAR:

    STL / ATLC(ROUTE_PEAK):

    TRAFFIC

    Route Congestion (%) OMS_TRAR

    (ROUTE_PEAK):

    100 * NUB / NBRoute Mean Holding Time (Sec.) OMS_TRAR:

    RPL * 60 * (STL / ATLC) / (NB - NUB)(ROUTE_PEAK):

    RPL * 60 * TRAFFIC / (NB-NUB)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (51 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    No. of Devices OMS_TRAR

    (ROUTE_PEAK):

    ND

    No. of Blocked Devices OMS_TRAR:

    SBD / ABLC(ROUTE_PEAK):

    NOBLOCKDEV

    Bids OMS_TRAR

    (ROUTE_PEAK):

    NB

    3.18 Traffic Profile, Routes

    File Name: Shows statistics for: Traffic_Profile_Routes.rep All routes in a route set Uses Universe: BSDR81.unv Table 34 Traffic Profile Routes, Sheet 1: Traffic

    Column Formula

    Time/Day -

    Minimum Traffic (Erlang) OMS_TRAR:

    STL / ATLCAverage Traffic (Erlang)

    (ROUTE_DATA):

    TRAFFIC

    Maximum Traffic (Erlang)

    3.19 Traffic Trend Normal, BSC and Cell Set

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (52 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    File Name: Shows statistics for: Traffic_Trend_BSC_Normal.rep Normal traffic in each

    BSC Traffic_Trend_CellSet_Normal.rep Normal traffic in each

    cell setUses Universe: BSDR81.unv Table 35 Traffic Trend Normal BSC and Cell Set

    Axis/Legend Formula

    Category (X) axis

    Measurement Period and BSC or Cell Set

    -

    Left value (Y) axis

    TCH Traffic (Erlang)

    CELTCHF, CELTCH:

    (TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)(BSC_CELL_MAIN / CELL_MAIN):

    C_TTRALACC

    Right value (Y) axis

    Subscriber Perceived TCH Congestion (%)

    CLSDCCH, CELTCHF, CELTCHH, CLTCH:

    100 * (CNRELCONG + (TFNRELCONG + THNRELCONG + TFNRELCONGSUB + THNRELCONGSUB)) / TASSALL

    (BSC_CELL_MAIN / CELL_MAIN):

    100 * (CNRELCONG + TNRELCONG) / TASSALL

    3.20 Traffic Trend PEAK, BSC

    File Name: Shows statistics for: Traffic_Trend_BSC_PEAK.rep Peak hour traffic in each

    BSCUses Universe:

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (53 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    BSDR81.unv Table 36 Traffic Trend BSC PEAK

    Axis/Legend Formula

    Category (X) axis

    Peak Hour and BSC

    -

    Left value (Y) axis

    TCH Traffic (Erlang)

    CELTCHF, CELTCH:

    (TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)(BSC_CELL_MAIN_PEAK):

    C_TTRALACC

    Right value (Y) axis

    Subscriber Perceived TCH Congestion (%)

    CLSDCCH, CELTCHF, CELTCHH, CLTCH:

    100 * (CNRELCONG + (TFNRELCONG + THNRELCONG + TFNRELCONGSUB + THNRELCONGSUB)) / TASSALL

    (BSC_CELL_MAIN_PEAK):

    100 * (CNRELCONG + TNRELCONG) / TASSALL

    3.21 Unsuccessful Calls

    File Name: Shows statistics for: Unsuccessful_Calls.rep Each MSCUses Universe: BSDR81.unv Table 37 Unsuccessful Calls, Sheet 1: Unsuccessful Calls

    Column Formula

    MSC -

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (54 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Unsuccessful Calls (%) MTRAFTYPE:

    100 * NUNSUCC[ ] / NCALLS[ ](MSC_TRAFFTYPE):

    100 * _NUNSUCC / _NCALLS

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (55 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    4 Dropped Calls Reports

    4.1 Dropped Calls Overview

    File Name: Shows statistics for: Dropped_Calls_Overview.rep Each MSC and BSC in

    the network Uses Universe: BSDR81.unv Table 38 Dropped Calls Overview, Sheet 1: SDCCH Overview and Sheet 3: SDCCH BSC

    Column Formula

    MSC or BSC -

    Total No.of Dropped SDCCH Connections

    CLSDCCH

    (MSC_CELL_MAIN / BSC_CELL_MAIN):

    CNDROP

    SDCCH Drop (%) CLSDCCH

    (MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * CNDROP / CMSESTABSDCCH Erlang Minutes per Drop

    CLSDCCH:

    RPL * (CTRALACC / CNSCAN) / CNDROP(MSC_CELL_MAIN / BSC_CELL_MAIN):

    RPL * C_CTRALACC / CNDROP Drop Reason, Low SS (%) CELLCCHDR, CLSDCCH:

    100 * (CDISSS + CDISSSSUB) / CNDROP(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * CDISSS / CNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (56 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Drop Reason, Bad Quality (%) CELLCCHDR, CLSDCCH:

    100 * (CDISQA + CDISQASUB) / CNDROP(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * CDISQA / CNDROPDrop Reason, Excessive TA (%)

    CELLCCHDR, CLSDCCH:

    (MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * CDISTA / CNDROPDrop Reason, Other (%) CLSDCCH, CELLCCHDR:

    100 * (CNDROP - ((CDISSS + CDISSSSUB) + (CDISQA + CDISQASUB) + CDISTA)) / CNDROP(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * (CNDROP - (CDISSS + CDISQA + CDISTA)) / CNDROP

    Table 39 Dropped Calls Overview, Sheet 2: TCH Overview and Sheet 4: TCH BSC

    Column Formula

    MSC or BSC -

    Total No. of Dropped TCH Connections

    CELTCHF, CELTCHH:

    TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB

    (MSC_CELL_MAIN / BSC_CELL_MAIN):

    TNDROP

    TCH Drop (%) CELTCHF, CELTCHH, NCELLREL, NICELASS:

    100 * (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) / ((TFCASSALL + THCASSALL + TFCASSALLSUB + THCASSALLSUB) + [sum incoming HO(HOVERSUC - HOSUCBCL - HOSUCWCL)] - [sum outgoing HO(HOVERSUC - HOSUCBCL - HOSUCWCL)])

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (57 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (MSC_CELL_MAIN, MSC_CELL_HO / BSC_CELL_MAIN, BSC_CELL_HO):

    100 * TNDROP / (TCASSALL + (SUMIHOSUCC - SUMIABSUCC - SUMIAWSUCC) - (SUMOHOSUCC - SUMOABSUCC - SUMOAWSUCC))

    TCH Erlang Minutes per Drop

    CELTCHF, CELTCHH:

    RPL * ((TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(MSC_CELL_MAIN / BSC_CELL_MAIN ):

    RPL * C_TTRALACC / TNDROPDrop Reason, Low SS DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISSDL + THDISSDL + TFDISSDLSUB + THDISSDLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * TDISSDL / TNDROPDrop Reason, Low SS UL(%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISSUL + THDISSUL + TFDISSULSUB + THDISSULSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * TDISSUL / TNDROPDrop Reason, Low SS UL/DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISSBL + THDISSBL + TFDISSBLSUB + THDISSBLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * TDISSBL / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (58 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Drop Reason, Bad Quality DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISQADL + THDISQADL + TFDISQADLSUB + THDISQADLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * TDISQADL / TNDROPDrop Reason, Bad Quality UL(%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISQAUL + THDISQAUL + TFDISQAULSUB + THDISQAULSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * TDISQAUL / TNDROPDrop Reason, Bad Quality UL/DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISQABL + THDISQABL + TFDISQABLSUB + THDISQABLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * TDISQABL / TNDROPDrop Reason, Suddenly Lost Connections (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFSUDLOS + THSUDLOS + TFSUDLOSSUB + THSUDLOSSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * TSUDLOS / TNDROPDrop Reason, Excessive TA (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISTA + THDISTA) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * TDISTA / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (59 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Drop Reason, Other (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * ((TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) - ((TFDISSDL + THDISSDL + TFDISSDLSUB + THDISSDLSUB) + (TFDISSUL + THDISSUL + TFDISSULSUB + THDISSULSUB) + (TFDISSBL + THDISSBL + TFDISSBLSUB + THDISSBLSUB) + (TFDISQADL + THDISQADL + TFDISQADLSUB + THDISQADLSUB) + (TFDISQAUL + THDISQAUL + TFDISQAULSUB + THDISQAULSUB) + (TFDISQABL + THDISQABL + TFDISQABLSUB + THDISQABLSUB) + (TFDISTA + THDISTA) + (TFSUDLOS + THSUDLOS + TFSUDLOSSUB + THSUDLOSSUB))) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(MSC_CELL_MAIN / BSC_CELL_MAIN):

    100 * (TNDROP - (TDISSDL + TDISSUL + TDISSBL + TDISQADL + TDISQAUL + TDISQABL + TDISTA + TSUDLOS)) / TNDROP

    4.2 Dropped Calls Cell, BSC and Cell Set

    File Name: Shows statistics for: Dropped_Calls_Cell_BSC.rep Each cell in a selected

    BSC Dropped_Calls_Cell_CellSet.rep Each cell in a selected

    cell setUses Universe: BSDR81.unv Table 40 Dropped Calls Cell BSC and Cell Set, Sheet 1: SDCCH

    Column Formula

    Cell Name -

    Band -

    Layer -

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (60 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Total No.of Dropped SDCCH Connections

    CLSDCCH

    (CELL_MAIN):

    CNDROP

    SDCCH Drop (%) CLSDCCH

    (CELL_MAIN):

    100 * CNDROP / CMSESTABSDCCH Erlang Minutes per Drop

    CLSDCCH:

    RPL * (CTRALACC / CNSCAN) / CNDROP(CELL_MAIN):

    RPL * C_CTRALACC / CNDROP Drop Reason, Low SS (%) CELLCCHDR, CLSDCCH:

    100 * (CDISSS + CDISSSSUB) / CNDROP(CELL_MAIN):

    100 * CDISSS / CNDROPDrop Reason, Bad Quality (%)

    CELLCCHDR, CLSDCCH:

    100 * (CDISQA + CDISQASUB) / CNDROP(CELL_MAIN):

    100 * CDISQA / CNDROPDrop Reason, Excessive TA (%)

    CELLCCHDR, CLSDCCH:

    (CELL_MAIN):

    100 * CDISTA / CNDROPDrop Reason, Other (%) CELLCCHDR, CLSDCCH:

    100 * (CNDROP - ((CDISSS + CDISSSSUB) + (CDISQA + CDISQASUB) + CDISTA)) / CNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (61 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (CELL_MAIN):

    100 * (CNDROP - (CDISSS + CDISQA + CDISTA)) / CNDROP

    Handover Lost of all SDCCH Drop (%)

    CELLCCHHO, CLSDCCH

    (CELL_HO, CELL_MAIN):

    100 * (CCHHOCNT - CCHHOSUC - CCHHOTOCH) / CNDROP

    Table 41 Dropped Calls Cell BSC and Cell Set, Sheet 2: TCH

    Column Formula

    Cell Name -

    Band -

    Layer -

    Total No. of Dropped TCH Connections

    CELTCHF, CELTCHH:

    TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB

    (CELL_MAIN):

    TNDROP

    TCH Drop (%) CELTCHF, CELTCHH, NCELLREL, NICELASS:

    100 * (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) / ((TFCASSALL + THCASSALL + TFCASSALLSUB + THCASSALLSUB) + [sum incoming HO(HOVERSUC - HOSUCBCL - HOSUCWCL)] - [sum outgoing HO(HOVERSUC - HOSUCBCL - HOSUCWCL)])

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (62 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (CELL_MAIN, CELL_HO):

    100 * TNDROP / (TCASSALL + (SUMIHOSUCC - SUMIABSUCC - SUMIAWSUCC) - (SUMOHOSUCC - SUMOABSUCC - SUMOAWSUCC))

    TCH Erlang Minutes per Drop

    CELTCHF, CELTCHH:

    RPL * ((TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    RPL * C_TTRALACC / TNDROPDrop Reason, Low SS DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISSDL + THDISSDL + TFDISSDLSUB + THDISSDLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * TDISSDL / TNDROPDrop Reason, Low SS UL(%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISSUL + THDISSUL + TFDISSULSUB + THDISSULSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * TDISSUL / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (63 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Drop Reason, Low SS UL/DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISSBL + THDISSBL + TFDISSBLSUB + THDISSBLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * TDISSBL / TNDROPDrop Reason, Bad Quality DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISQADL + THDISQADL + TFDISQADLSUB + THDISQADLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * TDISQADL / TNDROPDrop Reason, Bad Quality UL(%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISQAUL + THDISQAUL + TFDISQAULSUB + THDISQAULSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * TDISQAUL / TNDROPDrop Reason, Bad Quality UL/DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISQABL + THDISQABL + TFDISQABLSUB + THDISQABLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * TDISQABL / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (64 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Drop Reason, Suddenly Lost Connections (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFSUDLOS + THSUDLOS + TFSUDLOSSUB + THSUDLOSSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * TSUDLOS / TNDROPDrop Reason, Excessive TA (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISTA + THDISTA) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * TDISTA / TNDROPDrop Reason, Other (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * ((TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) - ((TFDISSDL + THDISSDL + TFDISSDLSUB + THDISSDLSUB) + (TFDISSUL + THDISSUL + TFDISSULSUB + THDISSULSUB) + (TFDISSBL + THDISSBL + TFDISSBLSUB + THDISSBLSUB) + (TFDISQADL + THDISQADL + TFDISQADLSUB + THDISQADLSUB) + (TFDISQAUL + THDISQAUL + TFDISQAULSUB + THDISQAULSUB) + (TFDISQABL + THDISQABL + TFDISQABLSUB + THDISQABLSUB) + (TFDISTA + THDISTA) + (TFSUDLOS + THSUDLOS + TFSUDLOSSUB + THSUDLOSSUB))) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (65 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (CELL_MAIN):

    100 * (TNDROP - (TDISSDL + TDISSUL + TDISSBL + TDISQADL + TDISQAUL + TDISQABL + TDISTA + TSUDLOS)) / TNDROP

    Table 42 Dropped Calls Cell BSC and Cell Set, Sheet 3: Reasons for TCH Drop Chart

    Axis/Legend Formula

    Category (X) axis

    Cell Name -

    Left value (Y) axis

    TCH Drop Reason, Low SS (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (((TFDISSDL + THDISSDL + TFDISSDLSUB + THDISSDLSUB) + (TFDISSUL + THDISSUL + TFDISSULSUB + THDISSULSUB) + (TFDISSBL + THDISSBL + TFDISSBLSUB + THDISSBLSUB)) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * (TDISSDL + TDISSUL + TDISSBL) / TNDROP

    Left value (Y) axis

    TCH Drop Reason, Bad Quality (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * ((TFDISQADL + THDISQADL + TFDISQADLSUB + THDISQADLSUB) + (TFDISQAUL + THDISQAUL + TFDISQAULSUB + THDISQAULSUB) + (TFDISQABL + THDISQABL + TFDISQABLSUB + THDISQABLSUB)) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * (TDISQADL + TDISQAUL + TDISQABL) / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (66 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Left value (Y) axis

    TCH Drop Reason, Suddenly Lost Connections (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFSUDLOS + THSUDLOS + TFSUDLOSSUB + THSUDLOSSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * TSUDLOS / TNDROPLeft value (Y) axis

    TCH Drop Reason, Excessive TA (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISTA + THDISTA) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * TDISTA / TNDROPLeft value (Y) axis

    TCH Drop Reason, Other (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * ((TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) - ((TFDISSDL + THDISSDL + TFDISSDLSUB + THDISSDLSUB) + (TFDISSUL + THDISSUL + TFDISSULSUB + THDISSULSUB) + (TFDISSBL + THDISSBL + TFDISSBLSUB + THDISSBLSUB) + (TFDISQADL + THDISQADL + TFDISQADLSUB + THDISQADLSUB) + (TFDISQAUL + THDISQAUL + TFDISQAULSUB + THDISQAULSUB) + (TFDISQABL + THDISQABL + TFDISQABLSUB + THDISQABLSUB) + (TFDISTA + THDISTA) + (TFSUDLOS + THSUDLOS + TFSUDLOSSUB + THSUDLOSSUB))) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(CELL_MAIN):

    100 * (TNDROP - (TDISSDL + TDISSUL + TDISSBL + TDISQADL + TDISQAUL + TDISQABL + TDISTA + TSUDLOS)) / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (67 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Right value (Y) axis

    TCH Drop (%) CELTCHF, CELTCHH, NCELLREL, NICELASS:

    100 * (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) / ((TFCASSALL + THCASSALL + TFCASSALLSUB + THCASSALLSUB) + [sum incoming HO(HOVERSUC - HOSUCBCL - HOSUCWCL)] - [sum outgoing HO(HOVERSUC - HOSUCBCL - HOSUCWCL)])(CELL_MAIN, CELL_HO):

    100 * TNDROP / (TCASSALL + (SUMIHOSUCC - SUMIABSUCC - SUMIAWSUCC) - (SUMOHOSUCC - SUMOABSUCC - SUMOAWSUCC))

    4.3 Dropped Calls Trend BSC, Cell Set and Cell

    File Name: Shows statistics for: Dropped_Calls_Trend_BSC.rep Each BSC Dropped_Calls_Trend_CellSet.rep Each cell set Dropped_Calls_Trend_Cell.rep Each cell in a selected

    BSC Uses Universe: BSDR81.unv Table 43 Dropped Calls Trend BSC, Cell Set and Cell, Sheet 1: SDCCH

    Column Formula

    BSC, Cell Set or Cell -

    Time -

    SDCCH Traffic in OL/UL Cells (Erlang)

    CLSDCCH:

    CTRALACC / CNSCAN(BSC_CELL_MAIN / CELL_MAIN):

    C_CTRALACC

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (68 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    SDCCH Drop due to TCH Congestion (%)

    CLSDCCH, CELLCCHHO

    (BSC_CELL_MAIN, BSC_CELL_HO / CELL_MAIN, CELL_HO)

    100 * CNRELCONG / (CMESTAB-CCHHOSUC)Total No. of Dropped SDCCH Connections

    CLSDCCH

    (BSC_CELL_MAIN / CELL_MAIN):

    CNDROP

    SDCCH Drop (%) CLSDCCH

    (BSC_CELL_MAIN / CELL_MAIN):

    100 * CNDROP / CMSESTABSDCCH Erlang Minutes per Drop

    CLSDCCH:

    RPL * (CTRALACC / CNSCAN) / CNDROP(BSC_CELL_MAIN / CELL_MAIN):

    RPL * C_CTRALACC / CNDROPDrop Reason, Low SS (%) CELLCCHDR, CLSDCCH:

    100 * (CDISSS + CDISSSSUB) / CNDROP(BSC_CELL_MAIN / CELL_MAIN):

    100 * CDISSS / CNDROPDrop Reason, Bad Quality (%)

    CELLCCHDR, CLSDCCH:

    100 * (CDISQA + CDISQASUB) / CNDROP(BSC_CELL_MAIN / CELL_MAIN):

    100 * CDISQA / CNDROPDrop Reason, Excessive TA (%)

    CELLCCHDR, CLSDCCH

    (BSC_CELL_MAIN / CELL_MAIN):

    100 * CDISTA / CNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (69 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Drop Reason, Other (%) CELLCCHDR, CLSDCCH:

    100 * (CNDROP - ((CDISSS + CDISSSSUB) + (CDISQA + CDISQASUB) + CDISTA)) / CNDROP(BSC_CELL_MAIN / CELL_MAIN):

    100 * (CNDROP - (CDISSS + CDISQA + CDISTA)) / CNDROP

    Handover Lost of all SDCCH Drop (%)

    CLSDCCH, CELLCCHHO

    (BSC_CELL_MAIN, BSC_CELL_HO / CELL_MAIN, CELL_HO)

    100 * (CCHHOCNT - CCHHOSUC - CCHHOTOCH) / CNDROP

    Table 44 Dropped Calls Trend BSC, Cell Set and Cell, Sheet 2: TCH

    Column Formula

    BSC, Cell Set or Cell Name -

    Time -

    TCH Traffic (Erlang) CELTCHF, CELTCHH:

    (TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)(BSC_CELL_MAIN / CELL_MAIN):

    C_TTRALACC

    Total No. of Dropped TCH Connections

    CELTCHF, CELTCHH:

    TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB

    (BSC_CELL_MAIN / CELL_MAIN):

    TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (70 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    TCH Drop (%) CELTCHF, CELTCHH, NCELLREL, NICELASS:

    100 * (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) / ((TFCASSALL + THCASSALL + TFCASSALLSUB + THCASSALLSUB) + [sum incoming HO(HOVERSUC - HOSUCBCL - HOSUCWCL)] - [sum outgoing HO(HOVERSUC - HOSUCBCL - HOSUCWCL)])(BSC_CELL_MAIN, BSC_CELL_HO / CELL_MAIN, CELL_HO):

    100 * TNDROP / (TCASSALL + (SUMIHOSUCC - SUMIABSUCC - SUMIAWSUCC) - (SUMOHOSUCC - SUMOABSUCC - SUMOAWSUCC))

    TCH Erlang Minutes per Drop

    CELTCHF, CELTCHH:

    RPL * ((TFTRALACC / TFNSCAN) + (THTRALACC / THNSCAN)) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN ):

    RPL * C_TTRALACC / TNDROPDrop Reason, Low SS DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISSDL + THDISSDL + TFDISSDLSUB + THDISSDLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN):

    100 * TDISSDL / TNDROPDrop Reason, Low SS UL(%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISSUL + THDISSUL + TFDISSULSUB + THDISSULSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN):

    100 * TDISSUL / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (71 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Drop Reason, Low SS UL/DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISSBL + THDISSBL + TFDISSBLSUB + THDISSBLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN):

    100 * TDISSBL / TNDROPDrop Reason, Bad Quality DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISQADL + THDISQADL + TFDISQADLSUB + THDISQADLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN):

    100 * TDISQADL / TNDROPDrop Reason, Bad Quality UL(%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISQAUL + THDISQAUL + TFDISQAULSUB + THDISQAULSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN):

    100 * TDISQAUL / TNDROPDrop Reason, Bad Quality UL/DL (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISQABL + THDISQABL + TFDISQABLSUB + THDISQABLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN):

    100 * TDISQABL / TNDROPDrop Reason, Suddenly Lost Connections (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFSUDLOS + THSUDLOS + TFSUDLOSSUB + THSUDLOSSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (72 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (BSC_CELL_MAIN / CELL_MAIN):

    100 * TSUDLOS / TNDROPDrop Reason, Excessive TA (%)

    CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * (TFDISTA + THDISTA) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN):

    100 * TDISTA / TNDROPDrop Reason, Other (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

    100 * ((TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) - ((TFDISSDL + THDISSDL + TFDISSDLSUB + THDISSDLSUB) + (TFDISSUL + THDISSUL + TFDISSULSUB + THDISSULSUB) + (TFDISSBL + THDISSBL + TFDISSBLSUB + THDISSBLSUB) + (TFDISQADL + THDISQADL + TFDISQADLSUB + THDISQADLSUB) + (TFDISQAUL + THDISQAUL + TFDISQAULSUB + THDISQAULSUB) + (TFDISQABL + THDISQABL + TFDISQABLSUB + THDISQABLSUB) + (TFDISTA + THDISTA) + (TFSUDLOS + THSUDLOS + TFSUDLOSSUB + THSUDLOSSUB))) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)(BSC_CELL_MAIN / CELL_MAIN):

    100 * (TNDROP - (TDISSDL + TDISSUL + TDISSBL + TDISQADL + TDISQAUL + TDISQABL + TDISTA + TSUDLOS)) / TNDROP

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (73 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    5 Handover Reports

    5.1 Handover Activity, BSC and Cell Set

    File Name: Shows statistics for: Handover_Activity_BSC.rep Each cell relation in a

    selected BSC Handover_Activity_CellSet.rep Each cell relation in a

    selected cell setUses Universe: BSDR81.unv Table 45 Handover Activity BSC and Cell Set

    Column Formula

    Serving Cell -

    Target Cell -

    Relation Type -

    No. of Handover Attempts NCELLREL, NECELLREL

    (CELLREL_DATA):

    HOVERCNT

    No. of Handover Decisions NICELHO, NECELHO, NICELASS, NECELASS, NICELHOEX, NECELHOEX(CELLREL_DATA):

    HOTOKCL + HOTOLCL + HODWNQA + HOUPLQA + HOEXCTA + HOASWCL + HOATTLSS + HOATTHSS + HOTOHCS

    5.2 Handover Performance Overview, Cell Set

    File Name: Shows statistics for: Handover_Performance_Overview_CellSet.rep Selected cell setUses Universe:

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (74 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    BSDR81.unv Table 46 Handover Performance Overview Cell Set

    Column Formula

    Cell Set -

    No. of Handover Attempts NCELLREL, NECELLREL:

    HOVERCNT + HOVERCNT

    (CELL_HO):

    SUMOHOATT + SUMEOHOATT

    Handover Success (%) NCELLREL, NECELLREL:

    100 * (HOVERSUC + HOVERSUC) / (HOVERCNT + HOVERCNT)(CELL_HO):

    100 * (SUMOHOSUCC + SUMEOHOSUCC) / (SUMOHOATT + SUMEOHOATT)

    Handover Reversion (%) NCELLREL, NECELLREL:

    100 * (HORTTOCH + HORTTOCH) / (HOVERCNT + HOVERCNT)(CELL_HO):

    100 * (SUMOHOREV + SUMEOHOREV) / (SUMOHOATT + SUMEOHOATT)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (75 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Handover Lost (%) NCELLREL, NECELLREL:

    100 * ((HOVERCNT - HORTTOCH - HOVERSUC) + (HOVERCNT - HORTTOCH - HOVERSUC)) / (HOVERCNT + HOVERCNT)(CELL_HO):

    100 * (SUMOHOLOST + SUMEOHOLOST) / (SUMOHOATT + SUMEOHOATT)

    5.3 Handover Performance Per Cell, BSC and Cell Set

    File Name: Shows statistics for: Handover_Performance_Per_Cell_BSC.rep Each cell in a selected

    BSC Handover_Performance_Per_Cell_CellSet.rep Each cell in a selected

    cell setUses Universe: BSDR81.unv Table 47 Handover Performance Per Cell BSC and Cell Set, Sheet 1: HO per Cell, BSC or Cell Set

    Column Formula

    Cell Name -

    Band -

    Layer -

    No. of Handover Attempts NCELLREL, NECELLREL:

    HOVERCNT + HOVERCNT

    (CELL_HO):

    SUMOHOATT + SUMEOHOATT

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (76 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Handover Success (%) NCELLREL, NECELLREL:

    100 * (HOVERSUC + HOVERSUC) / (HOVERCNT + HOVERCNT)(CELL_HO):

    100 * (SUMOHOSUCC + SUMEOHOSUCC) / (SUMOHOATT + SUMEOHOATT)

    Handover Reversion (%) NCELLREL, NECELLREL:

    100 * (HOVERTOCH + HOVERTOCH) / (HOVERCNT + HOVERCNT)(CELL_HO):

    100 * (SUMOHOREV + SUMEOHOREV) / (SUMOHOATT + SUMEOHOATT)

    Handover Lost (%) NCELLREL, NECELLREL:

    100 * ((HOVERCNT - HORTTOCH - HOVERSUC) + (HOVERCNT - HORTTOCH - HOVERSUC)) / (HOVERCNT + HOVERCNT)(CELL_HO):

    100 * (SUMOHOLOST + SUMEOHOLOST) / (SUMOHOATT + SUMEOHOATT)

    Table 48 Handover Performance Per Cell BSC and Cell Set, Sheet 2: HO per Cell - SDCCH

    Column Formula

    Cell Name -

    Band -

    Layer -

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (77 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    No. of Handover Attempts on SDCCH

    CELLCCHHO

    (CELL_HO):

    CCHHOCNT

    Handover Success on SDCCH (%)

    CELLCCHHO

    (CELL_HO):

    100 * CCHHOSUC / CCHHOCNTHandover Reversion on SDCCH (%)

    CELLCCHHO

    (CELL_HO):

    100 * CCHHOTOCH / CCHHOCNTHandover Lost on SDCCH (%) CELLCCHHO

    (CELL_HO):

    100 * (CCHHOCNT - CCHHOSUC - CCHHOTOCH) / CCHHOCNT

    Table 49 Handover Performance Per Cell BSC and Cell Set, Sheet 3: Incoming & Outgoing HO

    Column Formula

    Cell Name -

    Band -

    Layer -

    Total Number of Outgoing (Int. + Ext.) Handover Attempts

    NCELLREL, NECELLREL:

    HOVERCNT + HOVERCNT

    (CELL_HO):

    SUMOHOATT + SUMEOHOATT

    Outgoing (Int. + Ext.) Handover Success (%)

    NCELLREL, NECELLREL:

    100 * (HOVERSUC + HOVERSUC) / (HOVERCNT + HOVERCNT)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (78 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (CELL_HO):

    100 * (SUMOHOSUCC + SUMEOHOSUCC) / (SUMOHOATT + SUMEOHOATT)

    Outgoing (Int. + Ext.) Handover MS Reversion (%)

    NCELLREL, NECELLREL:

    100 * (HORTTOCH + HORTTOCH) / (HOVERCNT + HOVERCNT)(CELL_HO):

    100 * (SUMOHOREV + SUMEOHOREV) / (SUMOHOATT + SUMEOHOATT)

    Outgoing (Int. + Ext.) Handover MS Lost (%)

    NCELLREL, NECELLREL:

    100 * ((HOVERCNT - HORTTOCH - HOVERSUC) + (HOVERCNT - HORTTOCH - HOVERSUC)) / (HOVERCNT + HOVERCNT)(CELL_HO):

    100 * (SUMOHOLOST + SUMEOHOLOST) / (SUMOHOATT + SUMEOHOATT)

    Total Number of Incoming (Int. + Ext.) Handover Attempts

    (1)NCELLREL, NECELLREL:

    HOVERCNT + HOVERCNT

    (CELL_HO):

    SUMIHOATT + SUMEIHOATT

    Incoming (Int. + Ext.) Handover Success (%) (1)

    NCELLREL, NECELLREL:

    100 * (HOVERSUC + HOVERSUC) / (HOVERCNT + HOVERCNT)(CELL_HO):

    100 * (SUMIHOSUCC + SUMEIHOSUCC) / (SUMIHOATT + SUMEIHOATT)

    Incoming (Int. + Ext.) Handover MS Reversion (%) (1)

    NCELLREL, NECELLREL:

    100 * (HORTTOCH + HORTTOCH) / (HOVERCNT + HOVERCNT)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (79 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (CELL_HO):

    100 * (SUMIHOREV + SUMEIHOREV) / (SUMIHOATT + SUMEIHOATT)

    Incoming (Int. + Ext.) Handover MS Lost (%) (1)

    NCELLREL, NECELLREL:

    100 * ((HOVERCNT - HORTTOCH - HOVERSUC) + (HOVERCNT - HORTTOCH - HOVERSUC)) / (HOVERCNT + HOVERCNT)(CELL_HO):

    100 * (SUMIHOLOST + SUMEIHOLOST) / (SUMIHOATT + SUMEIHOATT)

    (1) Incoming Handover is calculated as the sum of all handovers (internal and external) where the specified cell (Cell Name) is the target cell.

    5.4 Handover Performance Per Cell Relation, BSC and Cell Set

    File Name: Shows statistics for: Handover_Performance_Per_Cell_Relation_BSC.rep Each cell relation in a

    selected BSC Handover_Performance_Per_Cell_Relation_CellSet.rep Each cell relation in a

    selected cell setUses Universe: BSDR81.unv Table 50 Handover Performance Per Cell Relation BSC and Cell Set, Sheet 1: HO per Cell Relation (1)

    Column Formula

    Serving Cell -

    Band of the Serving Cell -

    Layer of the Serving Cell -

    Target Cell -

    Band of the Target Cell -

    Layer of the Target Cell -

    Relation Type -

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (80 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    No. of Handover Attempts NCELLREL, NECELLREL

    (CELLREL_DATA):

    HOVERCNT

    Handover Success (%) NCELLREL, NECELLREL

    (CELLREL_DATA):

    100 * HOVERSUC / HOVERCNTHandover Reversion (%) NCELLREL, NECELLREL

    (CELLREL_DATA):

    100 * HORTTOCH / HOVERCNTHandover Lost (%) NCELLREL, NECELLREL

    (CELLREL_DATA):

    100 * (HOVERCNT - (HOVERSUC + HORTTOCH)) / HOVERCNTPing Pong Handover (%) NCELLREL, NECELLREL, NICELHO, NECELHO

    (CELLREL_DATA):

    100 * HODUPFT / HOVERSUC Table 51 Handover Performance Per Cell Relation BSC and Cell Set, Sheet 2: HO per Cell Relation (2)

    Column Formula

    Serving Cell -

    Target Cell -

    Handover Decisions

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (81 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    No. of NICELHO, NECELHO, NICELHOEX, NECELHOEX, NICELASS, NECELASS

    (CELLREL_DATA):

    HOTOLCL + HOTOKCL + HOUPLQA + HODWNQA + HOEXCTA + HOASWCL + HOATTLSS + HOATTHSS + HOTOHCS

    Bad Quality UL (%) NICELHO, NECELHO, NICELHOEX, NECELHOEX, NICELASS, NECELASS

    (CELLREL_DATA):

    100 * HOUPLQA / (HOTOLCL + HOTOKCL + HOUPLQA + HODWNQA + HOEXCTA + HOASWCL + HOATTLSS + HOATTHSS + HOTOHCS)

    Bad Quality DL (%) NICELHO, NECELHO, NICELHOEX, NECELHOEX, NICELASS, NECELASS

    (CELLREL_DATA):

    100 * HODWNQA / (HOTOLCL + HOTOKCL + HOUPLQA + HODWNQA + HOEXCTA + HOASWCL + HOATTLSS + HOATTHSS + HOTOHCS)

    Better L-Cell (%) NICELHO, NECELHO, NICELHOEX, NECELHOEX, NICELASS, NECELASS

    (CELLREL_DATA):

    100 * HOTOLCL / (HOTOLCL + HOTOKCL + HOUPLQA + HODWNQA + HOEXCTA + HOASWCL + HOATTLSS + HOATTHSS + HOTOHCS)

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (82 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Better K-Cell (%) NICELHO, NECELHO, NICELHOEX, NECELHOEX, NICELASS, NECELASS

    (CELLREL_DATA):

    100 * HOTOKCL / (HOTOLCL + HOTOKCL + HOUPLQA + HODWNQA + HOEXCTA + HOASWCL + HOATTLSS + HOATTHSS + HOTOHCS)

    Excessive TA (%) NICELHO, NECELHO, NICELHOEX, NECELHOEX, NICELASS, NECELASS

    (CELLREL_DATA):

    100 * HOEXCTA / (HOTOLCL + HOTOKCL + HOUPLQA + HODWNQA + HOEXCTA + HOASWCL + HOATTLSS + HOATTHSS + HOTOHCS)

    No. of Assignment Worse Cell NICELASS, NECELASS

    (CELLREL_DATA):

    HOASWCL

    Assignment to Worse Cell Success (%)

    NICELASS, NECELASS:

    (CELLREL_DATA):

    100 * HOSUCWCL / HOASWCL No. of Assignment Better Cell NICELASS, NECELASS:

    (CELLREL_DATA):

    HOASBCL

    Assignment to Better Cell Success (%)

    NICELASS, NECELASS:

    (CELLREL_DATA):

    100 * HOSUCBCL / HOASBCL

    5.5 Handover Performance OL/UL, BSC and Cell Set

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (83 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    File Name: Shows statistics for: Handover_Performance_OL_UL_BSC.rep Each cell in a selected

    BSC Handover_Performance_OL_UL_CellSet.rep Each cell in a selected

    cell setUses Universe: BSDR81.unv Table 52 Handover Performance OL/UL BSC and Cell Set, Sheet 1

    Column Formula

    Cell Name -

    No. of Handover Attempts to UL

    CELEVENTS:

    HOAATUL

    (CELL_OL):

    HOAATUL _OL

    Handover OL to UL Success (%)

    CELEVENTS:

    100 * HOSUCUL / HOAATUL(CELL_OL):

    100 * HOSUCUL_OL / HOAATUL_OLNo. of Handover Attempts to UL (BQ)

    CELEVENTS:

    R8: HOATTULBQ

    R9: HOATTULMAXIHO

    (CELL_OL):

    R8: HOATTULBQ_OL

    R9: HOATTULMAXIHO_OL

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (84 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    Handover OL to UL Success (BQ) (%)

    CELEVENTS:

    R8: 100 * HOSUCULBQ / HOATTULBQ

    R9: 100 * HOSUCULMAXIHO / HOATTULMAXIHO

    (CELL_OL):

    R8: 100 * HOSUCULBQ_OL / HOATTULBQ_OL

    R9: 100 * HOSUCULMAXIHO_OL / HOATTULMAXIHO_OL

    No. of Handover Attempts to OL

    CELEVENTS:

    HOAATOL

    (CELL_OL):

    HOAATOL_OL

    Handover UL to OL Success (%)

    CELEVENTS:

    100 * HOSUCOL / HOAATOL(CELL_OL):

    100 * HOSUCOL_OL / HOAATOL_OLNo. of Handover Attempts to OL (BQ)

    CELEVENTS:

    R9: HOATTOLMAXIHO

    (CELL_OL):

    R9: HOATTOLMAXIHO_OL

    Handover UL to OL Success (BQ) (%)

    CELEVENTS:

    R9: 100 * HOSUCOLMAXIHO / HOATTOLMAXIHO

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (85 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    (CELL_OL):

    R9: 100 * HOSUCOLMAXIHO_OL / HOATTOLMAXIHO_OL

    5.6 Inter BSC Handover Performance

    File Name: Shows statistics for: Inter_BSC_Handover_Performance.rep Each BSCUses Universe: BSDR81.unv Table 53 Inter BSC Handover Performance

    Column Formula

    MSC -

    BSC -

    Incoming HO Attempts BSCSTAT

    (BSC_DATA):

    NBSTSHRTOT

    Incoming HO Success (%) BSCSTAT

    (BSC_DATA):

    100 * NBSTIHBSUCC / NBSTSHRTOT Outgoing HO Attempts BSCSTAT

    (BSC_DATA):

    NBSTRHRTOT

    Outgoing HO Success (%) BSCSTAT

    (BSC_DATA):

    100 * NBSTOHBSUCC / NBSTRHRTOT

    file:///C|/DOCUME~1/a/LOCALS~1/Temp/ALEX_TMP/1031/alex0278.htm (86 of 152)10/18/2009 1:58:42 PM

  • Network Statistics, Analyzer

    5.7 Intra-Cell Handover Overview

    File Name: Shows statistics for: Intra-Cell_Handover_Overview.rep Each MSC and BSCUses Universe: BSDR81.unv Table 54 Intra-Cell Handover Overview, Sheet 1: Intra-Cell HO Ov. and Sheet 2: Intra-Cell HO BSC

    Column Formula

    MSC or BSC -

    Intra-Cell Handover Decisions CLEVENTI

    (MSC_CELL_HO / BSC_CELL_HO):

    HOINDQA + HOINUQA + H