Ericsson Kpis Formulas

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

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

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

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

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

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 CELTCHF

Counter names THTRALACC

BSDDB 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.

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.

2

Overview Reports

2.1

Performance Overview, MSC

File Name: Shows statistics for:

Performance_Overview_MSC.rep Each MSC in the network

Uses 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)

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 / NBSTSHRTOT

Inter 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 sets

Uses Universe:

BSDR81.unv

Table 3 Performance Overview BSC and Cell Set, Sheet 1: BSC / Cell Set

Column Formula

-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 / TOTPAG SDCCH 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

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

TCH 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) / TASSALL

Handover Success (%) NCELLREL, NECELLREL:

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

(BSC_CELL_HO / CELL_HO):

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

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 network

Uses 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)

Terminating Mobile Traffic (%) CHASSIGNT (MSC_DATA): 100 * NCHATOMTOT / (NCHAFRMTOT + NCHATOMTOT) Channel Assignment

Success, Originating (%) CHASSIGNT (MSC_DATA):

100 * NCHAFRMSUCC / NCHAFRMTOT

Channel Assignment

Success, Terminating (%) CHASSIGNT (MSC_DATA):

100 * NCHATOMSUCC / NCHATOMTOT

Channel 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):

Location Update Success,

Non-Registered (%) UPDLOCAT (MSC_DATA):

100 * NLOCNRGSUCC / NLOCNRGTOT

No. 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 / NLOCOLDTOT

IMSI Attach of Total Location Update from Registered (%)

UPDLOCAT (MSC_DATA):

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)

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 sets

Uses 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):

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)

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

SDCCH Availability OL/UL

(%) CLSDCCH:

100 * (CAVAACC / CAVASCAN) / CNUCHCNT

(BSC_CELL_MAIN / CELL_MAIN ): 100 * C_CAVAACC / CNUCHCNT Number 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 / CMSESTAB

Total No. of Dropped

SDCCH Connections CLSDCCH

(BSC_CELL_MAIN / CELL_MAIN):

SDCCH Drop (%) CLSDCCH

(BSC_CELL_MAIN / CELL_MAIN):

100 * CNDROP / CMSESTAB

SDCCH Erlang Minutes

per Drop CLSDCCH:

RPL * (CTRALACC / CNSCAN) / CNDROP

(BSC_CELL_MAIN / CELL_MAIN ):

RPL * C_CTRALACC / CNDROP

SDCCH Drop Reason, Low

SS (%) CELLCCHDR, CLSDCCH:

100 * (CDISSS + CDISSSSUB) / CNDROP

(BSC_CELL_MAIN / CELL_MAIN ):

100 * CDISSS / CNDROP

SDCCH Drop Reason, Bad

Quality (%) CELLCCHDR, CLSDCCH:

100 * (CDISQA + CDISQASUB) / CNDROP

(BSC_CELL_MAIN / CELL_MAIN ): 100 * CDISQA / CNDROP SDCCH Drop Reason, Excessive TA (%) CELLCCHDR, CLSDCCH: (BSC_CELL_MAIN / CELL_MAIN): 100 * CDISTA / CNDROP SDCCH Drop Reason, Other (%) CLSDCCH, CELLCCHDR:

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

(BSC_CELL_MAIN / CELL_MAIN ):

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

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 / TNUCHCNT

Total 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 / TASSALL

Subscriber Perceived TCH

Congestion(%) CLSDCCH, CELTCHF, CELTCHH, CLTCH:

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

(BSC_CELL_MAIN / CELL_MAIN ):

100 * (CNRELCONG + TNRELCONG) / TASSALL

TCH Mean Holding Time

(Sec.) CELTCHF, CELTCHH:

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

(BSC_CELL_MAIN / CELL_MAIN ):

RPL * 60 * C_TTRALACC / TMSESTB

Total 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 ):

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 / TNDROP

TCH Drop Reason,

Excessive TA (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

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

(BSC_CELL_MAIN / CELL_MAIN ):

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

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)

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])

(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 set

Uses 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:

(MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

100 * CCONGS / CCALLS

No. 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 / CMSESTAB

SDCCH Mean Holding Time OL/UL (Sec.) CLSDCCH:

RPL * 60 * (CTRALACC / CNSCAN) / CMSESTAB

(MSC_CELL_MAIN / BSC_CELL_MAIN / CELL_MAIN):

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 MSC

Uses Universe:

BSDR81.unv

Table 12 Calls and Answers, Sheet 1 & 2: Number of Calls

Column Formula

MSC

-No. of Calls MTRAFTYPE:

NCALLS[ <traffic type>]

(MSC_TRAFFTYPE): <traffic type>_NCALLS

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

Column Formula

MSC

-No. of Answers MTRAFTYPE:

(MSC_TRAFFTYPE): <traffic type>_NANSW

Table 14 Calls and Answers, Sheet 5: Answer Rate

Column Formula

MSC

-Answers (%) MTRAFTYPE:

100 * NANSW[ <traffic type> ] / NCALLS[

<traffic type>] (MSC_TRAFFTYPE):

100 * <traffic type>_NANSW / <traffic type>_NCALLS

3.4

Congestion

File Name: Shows statistics for:

Congestion.rep Each MSC

Uses Universe:

BSDR81.unv

Table 15 Congestion, Sheet 1: External Congestion

Column Formula

MSC

-External Congestion (%) MTRAFTYPE:

100 * NECONG[ <traffic type> ] / NCALLS[ <traffic type>]

(MSC_TRAFFTYPE):

100 * <traffic type>_NECONG / <traffic type>_NCALLS

Column Formula

MSC

-Internal Congestion (%) MTRAFTYPE:

100 * NICONG[ <traffic type> ] / NCALLS[ <traffic type>]

(MSC_TRAFFTYPE):

100 * <traffic type>_NICONG / <traffic type>_NCALLS

3.5

CP Load

File Name: Shows statistics for:

CP_Load.rep Each MSC and BSC

Uses 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):

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 set

Uses 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):

SDCCH Availability OL/UL

(%) CLSDCCH:

100 * (CAVAACC / CAVASCAN) / CNUCHCNT

(CELL_MAIN_PEAK): 100 * C_CAVAACC / CNUCHCNT SDCCH 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_TTRALACC Reconfiguration Attempts TCH=>SDCCH (%) CELLCONF (CELL_MAIN_PEAK):

100 * CONFATTC / (CONFATTC + CONFATTT)

Reconfiguration Attempts

SDCCH=>TCH (%) CELLCONF

(CELL_MAIN_PEAK):

100 * CONFATTT / (CONFATTC + CONFATTT)

-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 / TNUCHCNT

TCH 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) / TASSALL

-3.7

Location Update, MSC

File Name: Shows statistics for:

Location_Update_MSC.rep Each MSC

Uses 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)

Registered (%) UPDLOCAT (MSC_DATA):

100 * NLOCOLDSUCC / NLOCOLDTOT

Non -Registered (%) UPDLOCAT (MSC_DATA): 100 * NLOCNRGSUCC / NLOCNRGTOT Location Update Distribution Registered Subscribers, Normal (%) UPDLOCAT (MSC_DATA): 100 * (NLOCOLDTOT - NLOCPERTOT - NLOCATTTOT) / NLOCOLDTOT Registered Subscribers, Periodic (%) UPDLOCAT (MSC_DATA): 100 * NLOCPERTOT / NLOCOLDTOT

IMSI Attach of Total Location Update from Registered (%)

UPDLOCAT (MSC_DATA):

100 * NLOCATTTOT / NLOCOLDTOT

No. of IMSI Detach (%) UPDLOCAT (MSC_DATA): 100 * NLOCDETTOT / NLOCATTTOT Authentication Requests Sent SECHAND (MSC_DATA): NAUTREQTOT

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 BSC

Uses 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)

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):

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 MSC Uses 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 / NLAPAG1LOTOT

Repeated Pages of Total

First Page Attempts (%) LOCAREAST (LA_DATA):

Successful Repeated Page

(%) LOCAREAST

(LA_DATA):

100 * NLAPAG2RESUCC / NLPAG2LOTOT

Location Update Success

(%) LOCAREAST

(LA_DATA):

100 * NLALOCSUCC / NLALOCTOT

Total 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 set

Uses 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)

(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)

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 BSC

Uses 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):

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)

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 MSC

Uses 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 BSC

Uses Universe:

BSDR81.unv

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 / CMSESTAB

Left 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 MSC

Uses Universe:

BSDR81.unv

Table 29 Through Connect Calls, Sheet 1: Through Connect Calls

Column Formula

MSC

-Through Connect Calls

(%) MTRAFTYPE:

100 * NSUEOS[ <traffic type> ] / NCALLS[ <traffic type>]

(MSC_TRAFFTYPE):

100 * <traffic type>_NSUEOS / <traffic type>_NCALLS

3.15

Traffic

File Name: Shows statistics for:

Traffic.rep Each MSC

Uses Universe:

BSDR81.unv

Table 30 Traffic, Sheet 1: Traffic

Column Formula

MSC

-Traffic (Erlang) MTRAFTYPE:

NTRALACC[ <traffic type> ] / NSCAN[<traffic type> ]

(MSC_TRAFFTYPE): <traffic type>_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]))

(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

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):

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

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 MSC Uses Universe:

BSDR81.unv

Table 32 Traffic Dispersion

Column Formula

Destination

-Route

-No. of Outgoing Calls OMS_TRDIP:

(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 / NCALLS

Rejected Calls (%) OMS_TRDIP:

100 * NRC / (NCC + NDO)

(DEST_DATA):

100 * NRC / NCALLS

Traffic (Erlang) OMS_TRDIP:

ATC / NSCS + AST / (SCI * NSCS)

(DEST_DATA):

TRAFFIC

Mean Conversation Time

(Sec.) OMS_TRDIP

(DEST_DATA):

ATB * SCI / NBA

Mean Holding Time (Sec.) OMS_TRDIP

(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 / NB

Route Mean Holding Time (Sec.) OMS_TRAR:

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

(ROUTE_PEAK):

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 / ATLC

Average Traffic (Erlang)

(ROUTE_DATA):

TRAFFIC

Maximum Traffic (Erlang)

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 set Uses 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

BSC Uses Universe:

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 MSC

Uses Universe:

BSDR81.unv

Table 37 Unsuccessful Calls, Sheet 1: Unsuccessful Calls

Column Formula

-Unsuccessful Calls (%) MTRAFTYPE:

100 * NUNSUCC[ <traffic type> ] / NCALLS[ <traffic type>]

(MSC_TRAFFTYPE):

100 * <traffic type>_NUNSUCC / <traffic type>_NCALLS

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 / CMSESTAB

SDCCH 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):

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

100 * (CDISQA + CDISQASUB) / CNDROP

(MSC_CELL_MAIN / BSC_CELL_MAIN):

100 * CDISQA / CNDROP

Drop Reason, Excessive TA

(%) CELLCCHDR, CLSDCCH:

(MSC_CELL_MAIN / BSC_CELL_MAIN):

100 * CDISTA / CNDROP

Drop 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)])

(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 / TNDROP

Drop 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 / TNDROP

Drop 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 / TNDROP

Drop Reason, Low SS

UL/DL (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISSBL + THDISSBL +

TFDISSBLSUB + THDISSBLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(MSC_CELL_MAIN / BSC_CELL_MAIN):

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 / TNDROP

Drop 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 / TNDROP

Drop 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 / TNDROP

Drop 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 / TNDROP

Drop Reason, Excessive TA

(%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

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

(MSC_CELL_MAIN / BSC_CELL_MAIN):

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 set Uses Universe:

BSDR81.unv

Table 40 Dropped Calls Cell BSC and Cell Set, Sheet 1: SDCCH

Column Formula

Cell Name

-Band

-Total No.of Dropped SDCCH Connections CLSDCCH (CELL_MAIN): CNDROP SDCCH Drop (%) CLSDCCH (CELL_MAIN): 100 * CNDROP / CMSESTAB SDCCH 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 / CNDROP

Drop Reason, Bad Quality

(%) CELLCCHDR, CLSDCCH:

100 * (CDISQA + CDISQASUB) / CNDROP

(CELL_MAIN):

100 * CDISQA / CNDROP

Drop Reason, Excessive

TA (%) CELLCCHDR, CLSDCCH:

(CELL_MAIN):

100 * CDISTA / CNDROP

Drop Reason, Other (%) CELLCCHDR, CLSDCCH:

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

(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)])

(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 / TNDROP

Drop Reason, Low SS DL

(%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISSDL + THDISSDL + TFDISSDLSUB +

THDISSDLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(CELL_MAIN):

100 * TDISSDL / TNDROP

Drop Reason, Low SS

UL(%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISSUL + THDISSUL + TFDISSULSUB +

THDISSULSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(CELL_MAIN):

Drop Reason, Low SS

UL/DL (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISSBL + THDISSBL + TFDISSBLSUB +

THDISSBLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(CELL_MAIN):

100 * TDISSBL / TNDROP

Drop Reason, Bad Quality

DL (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISQADL + THDISQADL + TFDISQADLSUB +

THDISQADLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(CELL_MAIN):

100 * TDISQADL / TNDROP

Drop Reason, Bad Quality

UL(%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISQAUL + THDISQAUL + TFDISQAULSUB +

THDISQAULSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(CELL_MAIN):

100 * TDISQAUL / TNDROP

Drop Reason, Bad Quality

UL/DL (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISQABL + THDISQABL + TFDISQABLSUB +

THDISQABLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(CELL_MAIN):

Drop Reason, Suddenly

Lost Connections (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFSUDLOS + THSUDLOS + TFSUDLOSSUB +

THSUDLOSSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(CELL_MAIN):

100 * TSUDLOS / TNDROP

Drop Reason, Excessive

TA (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISTA + THDISTA) / (TFNDROP + THNDROP +

TFNDROPSUB + THNDROPSUB)

(CELL_MAIN):

100 * TDISTA / TNDROP

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

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

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 / TNDROP

Left value (Y)

axis TCH Drop Reason, Excessive TA (%)

CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISTA + THDISTA) /

(TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(CELL_MAIN):

100 * TDISTA / TNDROP

Left 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 +

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

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 / CMSESTAB SDCCH Erlang Minutes per Drop CLSDCCH:

RPL * (CTRALACC / CNSCAN) / CNDROP

(BSC_CELL_MAIN / CELL_MAIN):

RPL * C_CTRALACC / CNDROP

Drop Reason, Low SS (%) CELLCCHDR, CLSDCCH:

100 * (CDISSS + CDISSSSUB) / CNDROP

(BSC_CELL_MAIN / CELL_MAIN):

100 * CDISSS / CNDROP

Drop Reason, Bad Quality

(%) CELLCCHDR, CLSDCCH:

100 * (CDISQA + CDISQASUB) / CNDROP

(BSC_CELL_MAIN / CELL_MAIN):

100 * CDISQA / CNDROP

Drop Reason, Excessive

TA (%) CELLCCHDR, CLSDCCH

(BSC_CELL_MAIN / CELL_MAIN):

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):

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

Drop Reason, Low SS DL

(%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISSDL + THDISSDL +

TFDISSDLSUB + THDISSDLSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(BSC_CELL_MAIN / CELL_MAIN):

100 * TDISSDL / TNDROP

Drop Reason, Low SS

UL(%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:

100 * (TFDISSUL + THDISSUL +

TFDISSULSUB + THDISSULSUB) / (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB)

(BSC_CELL_MAIN / CELL_MAIN):