Making a report - Just 3 columns 1

dmazzini · Sep 24, 2006

Hi lets start...quite hard to explain may be

I want to be able to generate a report limiting the number of columns to 3. First 1,2,3 then continue again down with data for 4,5,6 and then data for 7,8,9

Let me explain you much better...

I have a routine:

Code:

sub generate_kpi_report {
    print LOG"   ------------------------------------ \n";
    print LOG "        CELL IDENTIFICATION DATA\n";
    print LOG "  ------------------------------------ \n";          
    print LOG "   BSCNAME:              $bscname\n";
    print LOG "   BCFNAME:              $bcfname\n";
    print LOG "   BCFID:                $bcfid\n";
    print LOG "   BTSNAME:              $btsname\n";
    print LOG "   BTSID:                $btsid\n";
    print LOG "  ------------------------------------ \n";
    print LOG "              KPI DATA\n";
    print LOG "  ------------------------------------ \n";          
    print LOG "   SDCCH-DROP-RATIO:     $sdcchdrop_ratio\n";
    print LOG "   SDCCH-RADIO-FAIL:     $sdcchradio_fail\n";
    print LOG "   SDCCH-BTS-FAIL:       $sdcch_bts_fail\n";
    print LOG "   SDCCH-LAPD-FAIL:      $sdcch_lapd_fail\n";
    print LOG "   SDCCH-CONG-TIME:    $sdcch_congestion_time\n";
    print LOG "   TCH-CONG-TIME:        $tch_congestion_time\n";
    print LOG "   TCH-TRAFFIC-UTLZ:     $tch_traffic_erlang\n";
    print LOG "   DCR-BEFORE:           $drop_call_ratio_bef_re_est\n";
    print LOG "   DCR-AFTER:            $drop_call_ratio_after_re_est\n";
    print LOG "   TOTAL-HO-FAIL:        $total_ho_failure\n";
    print LOG "   TOTAL-BLOCKED-CALLS:  $total_blocked_calls\n";
    print LOG "   GOOD-RX-QUAL-UL:      $good_rx_quality_ul\n";
    print LOG "   GOOD-RX-QUAL-DL:      $good_rx_quality_dl\n\n";    
    
}

I would like to have this info 3 timesdivided by columns, something like:

Code:

BSCNAME:AL3     | BSCNAME:AL3| BSCNAME:AL2|
BCFNAME:1       | BCFNAME:2  | BCFNAME:7  |
BCFID:1         | BCFID:1    | BCFID:13   |
BTSNAME:1       | BTSNAME:1  | BTSNAME:1  |
BTSID:1         | BTSID:2    | BTSID:2    |
    
---------       ---------     ---------
KPI DATA         KPI DATA     KPI DATA
---------       ---------     ---------
X:    1         X:    5       X:     9
Y:    2         Y:    2       Y:     23
Z:    3         Z:    8       Z:     45
\
and then

again the same info for next 3 Cells
......

again the same info for nest 3 Cells

I have been using in th past things like:

Code:

# a report on the /etc/passwd file
 format STDOUT_TOP =
                         Passwd File
 Name                Login    Office   Uid   Gid Home
 ------------------------------------------------------------------
 .
 format STDOUT =
 @<<<<<<<<<<<<<<<<<< @||||||| @<<<<<<@>>>> @>>>> @<<<<<<<<<<<<<<<<<
 $name,              $login,  $office,$uid,$gid, $home
 .

Any ideas? I don't knoe how to limit the number of columns and/or to do it using format functions.

By the way, the variables are coming from some files that I have parsed.

dmazzini
GSM System and Telecomm Consultant

rharsh · Sep 24, 2006

How about posting an accurate representation of the parsed data (or the file it's coming from) and the expected output?

dmazzini · Sep 25, 2006

Hi man

I am going to details:

1.Perl Script create sh files for triggers automatic performance reports based on a list of cells. (csv file). ( this works OK )
2.The performance reports are plain files. (These are produced OK)
3. Script reads these performance reports and then parse the data, putting Key Performance Indicators (KPI) into variables. (This work OK)
4. Generate an output file "KPI report for all cells" with the parsed data (It works ok). Just I would like to be able to format the output to 3 columns, it means data for 3 cells and then next group data for next 3 cells and so on.

Desired output file for "KPI report for all cells" :

Code:

BSCNAME:AL3     | BSCNAME:AL3| BSCNAME:AL2|
BCFNAME:1       | BCFNAME:2  | BCFNAME:7  |
BCFID:1         | BCFID:1    | BCFID:13   |
BTSNAME:1       | BTSNAME:1  | BTSNAME:1  |
BTSID:1         | BTSID:2    | BTSID:2    |
    
---------       ---------     ---------
KPI DATA         KPI DATA     KPI DATA
---------       ---------     ---------
X:    1         X:    5       X:     9
Y:    2         Y:    2       Y:     23
Z:    3         Z:    8       Z:     45

-------------------------------------------

BSCNAME:AL3     | BSCNAME:AL3| BSCNAME:AL2|
BCFNAME:1       | BCFNAME:2  | BCFNAME:7  |
BCFID:1         | BCFID:1    | BCFID:13   |
BTSNAME:1       | BTSNAME:1  | BTSNAME:1  |
BTSID:1         | BTSID:2    | BTSID:2    |
    
---------       ---------     ---------
KPI DATA         KPI DATA     KPI DATA
---------       ---------     ---------
X:    1         X:    5       X:     9
Y:    2         Y:    2       Y:     23
Z:    3         Z:    8       Z:     45
-------------------------------------------

Below script

Code:

#!/opt/nokianms/bin/perl
#**********************************************************************
use Getopt::Long;
use Term::ReadKey;
use DBI;

#**********************************************************************
#
# Main program starts here
#
#**********************************************************************

my $now = `date +%Y%m%d%H%M%S`;
$now =~ s/\r|\n//g;
my $PATH = `pwd`;
my $log = "RICKPI_".$now;
chomp $PATH; 
system("clear\n"); 

open( LOG, ">$log" ) or die( "Can not open : $log!" );

print LOG"   ------------------------------------ \n";
print LOG "       KPI Report generated by kpimx\n";
print LOG "  ------------------------------------ \n"; 

 
parse_cluster_file();

foreach $bscname (sort {$a <=> $b} keys %CLUSTER ) {
	   foreach $cnumber (sort {$a <=> $b} keys %{$CLUSTER{$bscname}}) {
		   foreach $cont (sort {$a <=> $b} keys %{$CLUSTER{$bscname}{$cnumber}}) {   
			   create_nd_script_216();			  
			   print "Getting Statistical data for BTS $CLUSTER{$bscname}{$cnumber}{$cont} located at $bscname. (ND 216 Report)\n\n";
			   $cmd = `sh nd216.sh rdr rdr`;			   
    		   	   parse_report_216(); 			   
			   create_nd_script_204();			   
			   print "Getting Statistical data for BTS $CLUSTER{$bscname}{$cnumber}{$cont} located at $bscname. (ND 204 Report)\n\n";
			   $cmd = `sh nd204.sh rdr rdr`;
			   parse_report_204();			   
			   generate_kpi_report() 			    
		   }
	  } 		  
}  

close LOG;
chmod(0777,$log);
@ND=("nd204.sh","nd216.sh","ndp204mx.lst","ndpmx216.lst");
foreach $filename_created (@ND){
	if ( -f $filename_created && unlink($filename_created) ) {
        	#print "The file: $filename_created was deleted\n";
	}
}

system("/usr/dt/bin/dtpad -standAlone  -noReadOnlyWarning  -viewOnly $log \&");

# #################################################################
# Sub Parse_Report_216
# #################################################################

sub parse_report_216{
    open(FILEHANDLE, 'ndp216mx.lst') or die "Failed: $!";
    @INFO=<FILEHANDLE>;
    foreach $line(@INFO) {	
            chomp($line);
            next if $line =~ /^\s*$/; 
            
            #Getting BCF and BTS
   
	        if ($line =~ /=+\s+BTS\s+NAME\s+:\s+(\w+)\s+\(\s+ID:\s+(\d+)+\s+\)/){
	            $btsname=$1;$btsid=$2;
	            print "BTSNAME=$1,BTSID:$2\n";      
	        }
	
	        if ($line =~ /=+\s+BCF\s+NAME\s+:\s+(\w+)\s+\(\s+ID:\s+(\d+)+\s+\)/){
	            $bcfname=$1;$bcfid=$2;
	            print "BCFNAME=$1,BCFID:$2\n";      
	        }
	
	        # Getting csf_2o SDCCH success ratio	
	        #if ($line =~ /(.+)\/csf_2o\s+((\d+)\.(\d+))\s%\s+(\d+)\.(\d+)+\s%/){
	        #    $sdcch_success_ratio = $2 ."%";
	        #    print "SDCCH-SUCCESS-RATIO:$sdcch_success_ratio\n";	         
	        #}

		#SDCCH DROP RATIO ........................../sdr_1a     13.26 %       17.62 %		
		#.		      SDCCH_RADIO_FAIL ...../c1003      0.58 %        0.47 %
		#.                     SDCCH_A_IF_FAIL_CALL ./c1078     11.63 %       16.13 %
		#.                     SDCCH_ABIS_FAIL_CALL ./c1075      1.04 %        1.02 %
		#.                     SDCCH_USER_ACT ......./c1037      0.00 %        0.00 %
		#.                     SDCCH_BCSU_RESET ...../c1038      0.00 %        0.00 %
		#.                     SDCCH_NETW_ACT ......./c1039      0.00 %        0.00 %
		#.                     SDCCH_BTS_FAIL ......./c1036      0.00 %        0.00 %
		#.                     SDCCH_LAPD_FAIL ....../c1035      0.00 %        0.00 %
		#.                     SDCCH_RF_OLD_HO ....../c1004      0.00 %        0.00 %
		#.                     SDCCH_ABIS_FAIL_OLD ../c1076      0.00 %        0.00 %
		#.                     SDCCH_A_IF_FAIL_OLD ../c1079      0.00 %  
		
		#Getting sdr_1a SDCCH drop ratio	
	        if ($line =~ /(.+)\/sdr_1a\s+((\d+)\.(\d+))\s%\s+(\d+)\.(\d+)+\s%/){
	            $sdcchdrop_ratio = $2 ."%";
	            print "SDCCH-DROP-RATIO:$sdcchdrop_ratio\n";	         
	        }
		
		#Getting c1003 SDCCH radio fail	
	        if ($line =~ /(.+)\/c1003\s+((\d+)\.(\d+))\s%\s+(\d+)\.(\d+)+\s%/){
	            $sdcchradio_fail = $2 ."%";
	            print "SDCCH-RADIO-FAIL:$sdcchradio_fail\n";	         
	        }
		
		#Getting c1078 SDCCH_A_IF_FAIL_CALL
	        if ($line =~ /(.+)\/c1078\s+((\d+)\.(\d+))\s%\s+(\d+)\.(\d+)+\s%/){
	            $sdcch_a_if_fail_call = $2 ."%";
	            print "SDCCH_A_IF_FAIL_CALL:$sdcch_a_if_fail_call\n";	         
	        }
		
		#Getting c1075 SDCCH_ABIS_FAIL_CALL
	        if ($line =~ /(.+)\/c1075\s+((\d+)\.(\d+))\s%\s+(\d+)\.(\d+)+\s%/){
	            $sdcch_abis_fail_call = $2 ."%";
	            print "SDCCH_ABIS_FAIL_CALL:$sdcch_abis_fail_call\n";	         
	        }
		
		#Getting c1036 SDCCH_BTS_FAIL
	        if ($line =~ /(.+)\/c1036\s+((\d+)\.(\d+))\s%\s+(\d+)\.(\d+)+\s%/){
	            $sdcch_bts_fail = $2 ."%";
	            print "SDCCH_BTS_FAIL:$sdcch_bts_fail\n";	         
	        }
		
		#Getting c1036 SDCCH_LAPD_FAIL
	        if ($line =~ /(.+)\/c1035\s+((\d+)\.(\d+))\s%\s+(\d+)\.(\d+)+\s%/){
	            $sdcch_lapd_fail = $2 ."%";
	            print "SDCCH_LAPD_FAIL:$sdcch_lapd_fail\n";	         
	        }



		
	
	        # Getting cngt_2. SDCCH Congestion Time
	
	        if ($line =~ /(.+)\/cngt_2\s+((\d+)\.(\d+))\s+(.+)/){
	            $sdcch_congestion_time = $2 ."s";
	            print "SDCCH-CONG-TIME:$sdcch_congestion_time\n";	         
	        }
	
	        # Getting cngt_1. TCH Congestion Time
	       	
	        if ($line =~ /(.+)\/cngt_1\s+((\d+)\.(\d+))\s+(.+)/){
	            $tch_congestion_time = $2 ."s";
	            print "TCH-CONG-TIME:$tch_congestion_time\n";	         
	        }
	
	        #Getting trf_12a. TCH Utlization (Erlangs)
	
		if ($line =~ /(.+)\/trf_12a\s+((\d+)\.(\d+))\s+(.+)/){
	            $tch_traffic_erlang = $2 ." Erl";
	            print "TCH-UTILIZATION:$tch_traffic_erlang\n";	         
		}
    }			    
	
    close FILEHANDLE;
}	



# #################################################################
# Sub Parse_Cluster_File
# #################################################################


sub parse_cluster_file{
    open(FILEHANDLE, "CLUSTER.csv") or die "Failed: $!";
    while (<FILEHANDLE>) {
           chomp;
	   $cont++;
           my ($bscname,$cnumber,$btsid)=split(/\,/);
	   $CLUSTER{$bscname}{$cnumber}{$cont}=$btsid;
    }
    close FILEHANDLE;  
}

# #################################################################
# Sub Parse_Report_204
# #################################################################

sub parse_report_204{
    open(FILEHANDLE, 'ndp204mx.lst') or die "Failed: $!";
    @INFO=<FILEHANDLE>;
    foreach $line(@INFO) {	
             chomp($line);
             next if $line =~ /^\s*$/; 
        
             #Getting BCF and BTS
   
	     if ($line =~ /=+\s+Area:\s+BTS:\s+(\w+)\s+\(BCF:\s+(\w+)+\)/){
	         $bscfname=$2;$btsname=$1;
	         print "BCFNAME=$2,BTSNAME=$1\n";      
	     }
	
	     # Getting Call Setup Success Rate
             #. (before re-est.) 100-dcr_8c        
             #. (after re-est.) 100-dcr_8e       
   
	     if ($line =~ /(.+)\s+\/100\-dcr_8c\s+(.+)\s+(.+)/){
	         $succesfull_drop_call_ratio_bef_re_est =  sprintf("%0.2f",$2).$3;
	         print "CSSR-BEFORE:$succesfull_drop_call_ratio_bef_re_est\n";	         
	     }

	     if ($line =~ /(.+)\s+\/100\-dcr_8e\s+(.+)\s+(.+)/){
	         $succesfull_drop_call_ratio_after_re_est =  sprintf("%0.2f",$2).$3;
	         print "CSSR-AFTER:$succesfull_drop_call_ratio_after_re_est\n";	        
	     }
	
	     # Getting TCH drop call ratio after TCH assignment
             #.before re-establishment dcr_8c        
             #.after re-establishment dcr_8e  
    
             if ($line =~ /(.+)\/dcr_8c\s+(.+)\s+(.+)/){
	            $drop_call_ratio_bef_re_est =  sprintf("%0.2f",$2).$3;
	            print "DCR-BEFORE:$drop_call_ratio_bef_re_est\n";	        
	         }

             if ($line =~ /(.+)\/dcr_8e\s+(.+)\s+(.+)/){
	            $drop_call_ratio_after_re_est =  sprintf("%0.2f",$2).$3;
	            print "DCR-AFTER:$drop_call_ratio_after_re_est\n";	        
             }
    
             # Getting Total for Failure Percentage of Handover Attempts
             # Total HO failure hfr_2       
    
             if ($line =~ /(.+)\/hfr_2\s+(.+)\s+(.+)/){
	            $total_ho_failure =  sprintf("%0.2f",$2).$3;
	            print "TOTAL-HO-FAILURE:$total_ho_failure\n";	        
             }
    
             # Getting Traffic Channel Blocking. 
             #. Blocked calls blck_9c (blck_8f)                 

             if ($line =~ /(.+)\/blck_9c\s+\(blck_8f\)\s+(.+)\s+(.+)/){
	            $total_blocked_calls =  $2.$3;
	            print "TOTAL-BLOCKED-CALLS:$total_blocked_calls\n";	        
             }    
  
             #These are both non-AMR and AMR calls. RX Quality based on BER.
             # These are both non-AMR and AMR calls
             # Good Rx Quality (UL) ulq_2 Qual5
             # Good Rx Quality (DL) dlq_2 Qual5  
                                                                                      
             # Getting Cumulative uplink quality distribution (ulq_2) :
   
             if ($line =~ /ulq_2/){
	            $flag_ulq_2=1; 
	         }
    
             if ($flag_ulq_2==1 and $line =~ /(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)/){
                $good_rx_quality_ul= $11.".".$12. "%";
                print "GOOD-RX-QUAL-UL=$good_rx_quality_ul\n";
                $flag_ulq_2=0;
             }
    
             #Getting Cumulative downlink quality distribution (dlq_2) :
    
             if ($line =~ /dlq_2/){
	            $flag_dlq_2=1; 
             }
    
             if ($flag_dlq_2==1 and $line =~ /(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)\s+(\d+)\.(\d+)/){
                $good_rx_quality_dl= $11.".".$12. "%";
                print "GOOD-RX-QUAL-DL=$good_rx_quality_dl\n";
                $flag_dlq_2=0;
             }   
	
	       
    }    
    close FILEHANDLE;
    
}

# #################################################################
# Sub create_nd_script_204
# #################################################################

sub create_nd_script_204 {

$myscript = qq (#!/bin/sh
#Autogenerated by verifmx.pl dmazzini

SCRIPT=\$PRODUCTROOT/content/ndobss/ndp204mx.sql
OUTFILE=$PATH/ndp204mx.lst
RunSql()

{ 
         (
         sqlplus -silent << END_OF_SQL_START
         \${SQL_LOGIN}
         start \${SQLFILE} 
4
$cnumber
$CLUSTER{$bscname}{$cnumber}{$cont}


END_OF_SQL_START
        )
}

DBUSER=\$1
DBPASS=\$2

SQL_LOGIN="\$DBUSER/\$DBPASS"
SQLFILE="\${SCRIPT} \${OUTFILE} dummy dummy v.3.1.11"
RunSql

	echo "-------------------------------------------------------------------------------" > $PATH/tmp.lst
	echo " " >> $PATH/tmp.lst
	echo "                        Report Generation Data " >> $PATH/tmp.lst
	echo " " >> $PATH/tmp.lst
	echo "-------------------------------------------------------------------------------" >> $PATH/tmp.lst
	echo " " >> $PATH/tmp.lst
	echo "Date                   : "`date` >> $PATH/tmp.lst
	echo "Menu Command Path      : by cron" >> $PATH/tmp.lst
	echo "User / Host            : "\$USER" / "\$HOST >> $PATH/tmp.lst
	echo \'Network Doctor         : report number \\c\' >> $PATH/tmp.lst
	echo "\${SCRIPT}"|tail -c10|cut -c1-3 >>$PATH/tmp.lst
	echo >>$PATH/tmp.lst
	echo >>$PATH/tmp.lst
	echo >>$PATH/tmp.lst
	cat \${OUTFILE} >>$PATH/tmp.lst
	cat $PATH/tmp.lst > \${OUTFILE}


 );
 open( OUTSH, ">nd204.sh" )  or die( "Can not open nd204.sh: $!" );
 print OUTSH $myscript;
 chmod(0777,"nd204.sh");
 close OUTSH;
 
}

# #################################################################
# Sub create_nd_script_216
# #################################################################

sub create_nd_script_216 {

$myscript = qq (#!/bin/sh
#Autogenerated by verifmx.pl dmazzini
 
SCRIPT=\$PRODUCTROOT/content/ndobss/ndp216mx.sql
OUTFILE=$PATH/ndp216mx.lst

RunSql()
#
{ 
         (
         sqlplus -silent << END_OF_SQL_START
         \${SQL_LOGIN}
         start \${SQLFILE} 
$cnumber
$CLUSTER{$bscname}{$cnumber}{$cont}
2




END_OF_SQL_START
        )
}

#
DBUSER=\$1
DBPASS=\$2
#
SQL_LOGIN="\$DBUSER/\$DBPASS"
SQLFILE="\${SCRIPT} \${OUTFILE} dummy dummy v.3.1.11"
RunSql
#

echo "-------------------------------------------------------------------------------" > $PATH/tmp.lst
	echo " " >> $PATH/tmp.lst
	echo "                        Report Generation Data " >> $PATH/tmp.lst
	echo " " >> $PATH/tmp.lst
	echo "-------------------------------------------------------------------------------" >> $PATH/tmp.lst
	echo " " >> $PATH/tmp.lst
	echo "Date                   : "`date` >> $PATH/tmp.lst
	echo "Menu Command Path      : by cron" >> $PATH/tmp.lst
	echo "User / Host            : "\$USER" / "\$HOST >> $PATH/tmp.lst
	echo \'Network Doctor         : report number \\c\' >> $PATH/tmp.lst
	echo "\${SCRIPT}"|tail -c10|cut -c1-3 >>$PATH/tmp.lst
	echo >>$PATH/tmp.lst
	echo >>$PATH/tmp.lst
	echo >>$PATH/tmp.lst
	cat \${OUTFILE} >>$PATH/tmp.lst
	cat $PATH/tmp.lst > \${OUTFILE}

 );
 
 open( OUTSH, ">nd216.sh" )  or die( "Can not open nd216.sh: $!" );
 print OUTSH $myscript;
 chmod(0777,"nd216.sh");
 close OUTSH;
 
}
sub generate_kpi_report {
    print LOG"   ------------------------------------ \n";
    print LOG "        CELL IDENTIFICATION DATA\n";
    print LOG "  ------------------------------------ \n";          
    print LOG "   BSCNAME:              $bscname\n";
    print LOG "   BCFNAME:              $bcfname\n";
    print LOG "   BCFID:                $bcfid\n";
    print LOG "   BTSNAME:              $btsname\n";
    print LOG "   BTSID:                $btsid\n";
    print LOG "  ------------------------------------ \n";
    print LOG "              KPI DATA\n";
    print LOG "  ------------------------------------ \n";          
    print LOG "   SDCCH-DROP-RATIO:     $sdcchdrop_ratio\n";
    print LOG "   SDCCH-RADIO-FAIL:     $sdcchradio_fail\n";
    print LOG "   SDCCH-A-IF-FAIL:      $sdcch_a_if_fail_call\n";
    print LOG "   SDCCH-ABIS-FAIL:      $sdcch_abis_fail_call\n";
    print LOG "   SDCCH-BTS-FAIL:       $sdcch_bts_fail\n";
    print LOG "   SDCCH-LAPD-FAIL:      $sdcch_lapd_fail\n";
    print LOG "   SDCCH-CONG-TIME:      $sdcch_congestion_time\n";
    print LOG "   TCH-CONG-TIME:        $tch_congestion_time\n";
    print LOG "   TCH-TRAFFIC-UTLZ:     $tch_traffic_erlang\n";
    print LOG "   CSSR-BEFORE:          $succesfull_drop_call_ratio_bef_re_est\n";
    print LOG "   CSSR-AFTER:           $succesfull_drop_call_ratio_after_re_est\n";
    print LOG "   DCR-BEFORE:           $drop_call_ratio_bef_re_est\n";
    print LOG "   DCR-AFTER:            $drop_call_ratio_after_re_est\n";
    print LOG "   TOTAL-HO-FAIL:        $total_ho_failure\n";
    print LOG "   TOTAL-BLOCKED-CALLS:  $total_blocked_calls\n";
    print LOG "   GOOD-RX-QUAL-UL:      $good_rx_quality_ul\n";
    print LOG "   GOOD-RX-QUAL-DL:      $good_rx_quality_dl\n\n";    
    
}

report 204 output

Code:

-------------------------------------------------------------------------------
 
                        Report Generation Data 
 
-------------------------------------------------------------------------------
 
Date                   : Thu Aug 31 17:00:29 SAT 2006
Menu Command Path      : by cron
User / Host            : ricuser / nok1scs
Network Doctor         : report number 204



===============================================================================
=
=                   NETWORK BENCHMARK STATISTICS
=
=                   Network:         PLMN
=                   Area:            All BTSs selected
=                   Period:          from 20060831 to 20060831
=                   Time criteria:   Whole period
=
===============================================================================

This report provides versatile information about the selected BTS area.
- objects
- key parameters
- Key Performance Indicators

Measurement used: p_nbsc_traffic, p_nbsc_ho, p_nbsc_power, p_nbsc_res_access,
.     p_nbsc_res_avail, p_nbsc_rx_qual, p_nbsc_rx_statistics, p_nbsc_service
.     p_nbsc_fer, p_nbsc_pbcch_avail

Note: This report is meant primarily for the area level. If used on the BTS
.     level, some formulas may not be exactly correct. Use report 216 for BTS.

Note: Rx Quality and Rx Level measurements are usually run with a measurement
.     period longer than 60min. Therefore applying Busy Period over them may
.     not succeed, and no results are shown.

Note: Running this report may take a long time. Patience please.

===============================================================================
- 



Network object data about the selected area
*******************************************
(counted from the objects table)

(used   = object and all parent objects unlocked)
(unused = object and/or any of parent objects locked)

All BCF:                   13
.....Unused BCF:                  1
.....Used BCF:                   12

All BTS:                   39
.....Unused BTS:                  1
.....Used BTS:                   38

All TRX:                  113
.....Unused TRX:                 15
.....Used TRX:                   98

Number of adjacencies
of used BTSs:                   789



                                 Amount of                                      
BCF HW Type                      used BCFs                                      
------------------------------ -----------                                      
UltraSite                               12                                      
Note: For a cell level list, run report 099.


Number of used frequencies: ...............................        38
. (TRX and its parents are unlocked )
Number of TRXs per BTS:....................................       2.6

Frequency reuse pattern (effective reuse) ........../cnf_1       14.7
. (frequencies/average nbr of TRX per BTS)
. Note: - the value makes sense only to large area, eg. more than 50 cells
.       - the value makes sense only in nonhopping or baseband hopping area
- 
Statistics about the basic settings of used BTSs:
('used' means that BTS and its parent BCF are unlocked)

CELL BARRED (BAR)                             COUNT                             
---------------------------------------- ----------                             
No                                               38                             

BTS HOPPING (HOP)                             COUNT                             
---------------------------------------- ----------                             
Rf hopping                                       22                             
not hopping                                      16                             

DR in use (DR)                                COUNT                             
---------------------------------------- ----------                             
Yes                                              38                             

Trunk Reservation Used (TR)                   COUNT                             
---------------------------------------- ----------                             
No                                               38                             

Call Reestablishment Allowed (RE)             COUNT                             
---------------------------------------- ----------                             
No                                               38                             

Allow IMSI attach/detach (ATT)                COUNT                             
---------------------------------------- ----------                             
Yes                                              38                             

DTX mode (DTX)                                COUNT                             
---------------------------------------- ----------                             
Shall                                            38                             

RxLev Access Min (RXP)                        COUNT                             
---------------------------------------- ----------                             
-102.0 dBm                                       38                             

Radio Link Timeout (RTL)                      COUNT                             
---------------------------------------- ----------                             
  16.0 SACCH                                     38                             

Number of Blocks for AGCH (AG)                COUNT                             
---------------------------------------- ----------                             
   1.0                                           38                             

MS TxPower Max GSM (PMAX1)                    COUNT                             
---------------------------------------- ----------                             
  33.0 dBm                                       38                             

MS TxPower Max GSM 1800/1900 (PMAX2)          COUNT                             
---------------------------------------- ----------                             
  30.0 dBm                                       38                             

MS TxPower Min (PMIN)                         COUNT                             
---------------------------------------- ----------                             
   0.0 dBm                                       22                             
  13.0 dBm                                       16                             

Max Number of Repetition  (NY1)               COUNT                             
---------------------------------------- ----------                             
   5.0                                           38                             

Max Number of Retransmission (RET)            COUNT                             
---------------------------------------- ----------                             
   4.0                                           38                             

Number of Multiframes  (MFR)                  COUNT                             
---------------------------------------- ----------                             
   4.0                                           38                             

Timer for Periodic MS LUP   (PER)             COUNT                             
---------------------------------------- ----------                             
   2.0 Hours                                     38                             

GPRS enabled   (GENA)                         COUNT                             
---------------------------------------- ----------                             
Yes                                              38                             

Note: For full parameter settings distribution, run the report 068.


Note: For a full BCF software deployment list, run report 099.


BSC software version used                                                       
(only BSCs above used BTSs counted)           COUNT                             
---------------------------------------- ----------                             
110                                              38                             

Note: For full BSC software deployment list run report 092.
- 


CALL SUCCESS FACTORS (breakdown I)
====================
SDCCH access probability
.     (before FCS) ............................./csf_1       99.36 %
.     (after FCS) ............................./csf_1a       99.36 %

SDCCH success ratio
.     (SDCCH fail based, incl.LU) ............./csf_2k       94.19 %
.     (SDCCH to TCH based) ..................../csf_2o       90.85 %

TCH access probability
.     (before DR and queuing) ................./csf_3m       90.62 %
.     (before DR) ............................./csf_3i       90.72 %
.     (real) ................................../csf_3o    96.95 %

TCH success ratio (after seizure)
.     (before re-est.) ......................../csf_4u       98.28 %
.     (after re-est) ........................../csf_4v       98.28 %

Note: See the formula descriptions for the accuracy limitations.
Note: For a cell level list, run report 250.


CALL SUCCESS FACTORS (breakdown II)
====================
TCH assignment probability ............. /100-blck_29         0.00 %
TCH success ratio after assignment
.     (before re-est.) .................. /100-dcr_8c         0.00 %
.     (after re-est.) ................... /100-dcr_8e         0.00 %

- 

CCCH / paging
=============
All pagings .........................................     16291145
. CS pagings from Aif ........................./c3000     16223189    (  99.6 %)
. CS pagings from Gb ........................../c3058            0    (   0.0 %)
. PS pagings from Gb ........................../c3057        67956    (   0.4 %)

Delete paging commands ......................../c3038            0    (   0.0 %)

Note: For a cell level list, run report 186.


PCCCH / paging
==============
All pagings .........................................            0
. CS pagings on PCCCH ......................../c91018            0    (   0.0 %)
. PS pagings on PCCCH ......................../c91019            0    (   0.0 %)
. Packet Paging requests on PCCCH ............/c91020            0    (   0.0 %)

Deleted paging commands ....................../c91017            0    (   0.0 %)

AG
==
Imm.assign  .................................../c3001       477573
Imm.assign rejected .........................../c3002         3083
Del.ind. message received .(DL CCCH overload)../c3005            0
AG blocking ................................./blck_13         0.00 %

P-Imm.assign  ................................/c72084        74722
P-Imm.assign rejected ......................../c72087         8711
P-Imm.assign NACK received .................../c72086            0
P-Imm.assign NACK ratio ...................../blck_21         0.00 %


RACH
====
Chn.required msg (PS) received from BTS ....../c72082        73183
These are handled by PCU.

Chn.required msg (CS) received from BTS ......./c3004       480663
RACH rejected by BSC:
. rejected due distance ......................./c3031            0  (   0.00 %)
. rejected due to illegal est. cause ........./rach_6            8  (   0.00 %)
. BCSU overload lower limit (S7).............../c3039            0  (   0.00 %)
. BCSU overload upper limit (S7).............../c3040            0  (   0.00 %)
. BCSU MCMU overload protection (S7).........../c3041            0  (   0.00 %)

Note: For a cell level list, run report 134.

- 

SDCCH
=====
SDCCH availability ............................/ava_4        87.78 %
Dynamic SDCCH allocation (TCH reconfigured to SDCCH):
. Attempts ..................................../c1154         2077
Note: For a cell level list, run report 139.

SDCCH requests ................................/c1000       480553
. HO in......................................../c1006            0  (   0.00 %)
. blocked ........................./blck_15 (blck_5a)         3071  (   0.64 %)
. To FACCH call setup ........................./c1099            0  (   0.00 %)
. LU ........................................../c3019       242343  (  50.43 %)
. MTC (incl. SMS) ............................./c3012        76117  (  15.84 %)
. MOC (incl. SMS,SS) ........................../c3013       125111  (  26.03 %)
.   supplementary service request (S9) ......../c3044         7510  (   1.56 %)
. IMSI detach (S7) ............................/c3033         8955  (   1.86 %)
. call re-establishment......................../c3020            0  (   0.00 %)
. emergency call ............................../c3021          266  (   0.06 %)
. other (fails, ghosts) ......................./sd_1a        24690  (   5.14 %)


SDCCH usage ................................../trf_7b         5.43 %

Average SDCCH seizure length ................../trf_4         2.95 sec

Note: For a cell level list, run report 189.



SDCCH failures
==============
SDCCH seizures .............................../trf_54       477482
SDCCH drop ratio ............................./sdr_1a         6.69 %
. SDCCH_RADIO_FAIL............................./c1003         5809  (   1.22 %)
. SDCCH_A_IF_FAIL_CALL........................./c1078          162  (   0.03 %)
. SDCCH_ABIS_FAIL_CALL........................./c1075        25650  (   5.37 %)
. SDCCH_USER_ACT.............................../c1037            8  (   0.00 %)
. SDCCH_BCSU_RESET............................./c1038            0  (   0.00 %)
. SDCCH_NETW_ACT.............................../c1039            0  (   0.00 %)
. SDCCH_BTS_FAIL.............................../c1036            1  (   0.00 %)
. SDCCH_LAPD_FAIL............................../c1035            0  (   0.00 %)
. SDCCH_RF_OLD_HO........(HO drop)............./c1004           95  (   0.02 %)
. SDCCH_ABIS_FAIL_OLD....(HO drop)............./c1076            0  (   0.00 %)
. SDCCH_A_IF_FAIL_OLD....(HO drop)............./c1079          240  (   0.05 %)

T3101 expired (S7) .........................../c57020            0  (   0.00 %)
. (denominator in % calculation is same as above)
SDCCH drop ratio without T3101 expiry ........./sdr_4         6.69 %

Note: For a cell level list, run report 166.
- 

TCH
===
TCH availability (speech and GPRS)............/ava_1d        77.69 %
Note: For a cell level list, run report 139 or 185.

TCH requests ................................../c1010       316977
. FACCH call setup ............................/c1043            0  (   0.00 %)
. new calls (normal and DR out) ............./trf_18a       145870  (  46.02 %)
. handovers ................................../ho_14b       166248  (  52.45 %)
. call retries due to Aif pool mismatch ....../trf_49         3249
. HO retries due to Aif pool mismatch ......../trf_50         1610

TCH requests for FACCH call setup (c1043):
. Blocked .................................../blck_18            0  (     na %)
. Succ. seizures ............................../c1099            0  (     na %)
. MOC ........................................./c3024            0  (     na %)
. MTC ........................................./c3023            0  (     na %)
. call re-establishment ......................./c3025            0  (     na %)
. emergency call ............................../c3022            0  (     na %)
. IMSI detach (S7) ............................/c3034            0  (     na %)
. supplementary service request (S9) ........../c3045            0  (     na %)

TCH requests for new calls (trf_18a):
. DR handover to other cell
.    succ ....................................../dr_3        13449  (   9.22 %)
.    unsucc ..................................../dr_7          926  (   0.63 %)
. DR handover intracell (IUO opt.)
.    succ ...................................../c4074            0  (   0.00 %)
.    unsucc ..................................../dr_8            0  (   0.00 %)
. To queue ..................................../c1016            0  (   0.00 %)
.    From queue to DR (S8)...................../c1173            0  (   0.00 %)
.    Unserved queued ........................../c1024            0  (   0.00 %)
. TCH normal seizures (queued or not) ......../trf_55       130723  (  89.62 %)
.    re-establishments (S7).................../c57032            0  (   0.00 %)
. Blocked calls .................../blck_9c (blck_8f)         1698  (   3.05 %)
. Blocked calls .................../blck_9c (blck_8h)         1698  (   0.77 %)

TCH normal seizures (trf_55):
. MS got on TCH (S7).........................../c1148       129092  (  98.75 %)

TCH requests for HO (ho_14b):
. Succ.TCH HO seizures, queued .............../que_2a            0  (   0.00 %)
. Succ.TCH HO seizures, non queued .........../que_8a       149441  (  89.89 %)
. Blocked HOs ............................/(blck_11c)        16807  (  10.11 %)

TCH req rej due to lack of res. .............../c1011        27152

MS average power ............................../pwr_1           27  dBm
MS-BS average distance ......................../dis_1   840  m


TCH time (hours) ............................/trf_24c      1425.08 hr
Number of calls ............................./trf_39a       141596
Average call length ........................../trf_2b        35.58  sec

Average FTCH seizure length .................../trf_5           18  sec
.  Note: For a cell level list, run report 189.


Average TCH usage .........................../trf_85b        14.58 %
. by CS traffic ............................./trf_83a        14.52 %
. by PS traffic (DL)........................./trf_84b         0.05 %
.  Note: For a cell level list, run report 185 (CS) or 229 (CS,PS).


HO / Calls ratio ............................/trf_13e        78.97 %
. Intra-cell HOs included..................../trf_13d        97.86 %
.  Note: For a cell level list, run report 157.

Average queue time in call ..................../c1020            0  sec
Average queue time in HO ....................../c1022            0  sec


TCH failures
============
TCH drop call ratio after TCH seizure
. before re-establisment....................../dcr_3i         1.72 %
.  TCH_RADIO_FAIL............................../c1013          892  (   0.63 %)
.  TCH_ABIS_FAIL_CALL........................../c1084          492  (   0.35 %)
.  TCH_A_IF_FAIL_CALL........................../c1087           55  (   0.04 %)
.  TCH_TR_FAIL................................./c1029           15  (   0.01 %)
.  TCH_USER_ACT................................/c1048           10  (   0.01 %)
.  TCH_BCSU_RESET............................../c1049            0  (   0.00 %)
.  TCH_NETW_ACT................................/c1050            0  (   0.00 %)
.  TCH_ACT_FAIL_CALL.........................../c1081            1  (   0.00 %)
.  TCH_BTS_FAIL................................/c1047            2  (   0.00 %)
.  TCH_LAPD_FAIL.............................../c1046            1  (   0.00 %)
.  TCH_RF_OLD_HO.......(HO drop).............../c1014          790  (   0.56 %)
.  TCH_ABIS_FAIL_OLD...(HO drop).............../c1085            7  (   0.00 %)
.  TCH_A_IF_FAIL_OLD...(HO drop).............../c1088          167  (   0.12 %)
.  TCH_TR_FAIL_OLD.....(HO drop).............../c1030            0  (   0.00 %)
. after re-establisment......................./dcr_3j         1.72 %

T3101 expired (S9) .........................../c57038            0  (   0.00 %)
. (denominator in % calculation is same as above)

Note: For a cell level list, run report 163.

TCH drop call ratio after TCH assignment
.  before re-establishment .................../dcr_8c         0.00 %
.  after re-establishment ..................../dcr_8e         0.00 %

Dropped conversation ratio .................../dcr_5b         0.00 %

Drops per erlang, before re-establishment ..../dcr_10         1.71
Drops per erlang, after re-establishment ..../dcr_10b         1.71

TCH capacity
============
Aver. ext. TCH capacity of extended cells (    0 cells):        tsl
Unavail. TCH ................................../uav_14          0.0  (   0 %)
Avail. TCH ..........................................
. CS HR ......................................./ava_31          0.0  (   0 %)
. CS FR ......................................./ava_33          0.0  (   0 %)
. CS dual ...................................../ava_35          0.0  (   0 %)

Average normal TCH capacity per BTS (all cells):                tsl
Unavail. TCH ................................../uav_13          4.5  (  22 %)
Avail. TCH ...........................................
. CS HR ......................................./ava_30          0.0  (   0 %)
. CS FR ......................................./ava_32          0.4  (   2 %)
. CS dual ...................................../ava_34         13.7  (  68 %)
. PS default ................................./ava_26a          0.9  (   4 %)
. PS dedicated .............................../ava_17a          0.7  (   3 %)

Note: For more detailed PS info run report 229.
Note: For more detailed CS info run report 205.


- 


TCH codec versions
==================
All % is in ratio to sum of all seizures:

Seizures ............................................       279544
Full Rate V1 ................................../c1108          807   (   0.29 %)
.         V2 (enhanced)......................../c1109        27062   (   9.68 %)
.         V3 (AMR) ............................/c1110        53632   (  19.19 %)
Half Rate V1 ................................../c1111        49791   (  17.81 %)
.         V2 ................................../c1112            0   (   0.00 %)
.         V3 (AMR)............................./c1113       148252   (  53.03 %)

Failures ............................................           15
Full Rate V1 ................................../c1127            0   (   0.00 %)
.         V2 (enhanced)......................../c1128            2   (  13.33 %)
.         V3 (AMR)............................./c1129            6   (  40.00 %)
Half Rate V1 ................................../c1130            4   (  26.67 %)
.         V2 ................................../c1131            0   (   0.00 %)
.         V3 (AMR)............................./c1132            3   (  20.00 %)

Note: For a cell level list, run report 247.

Full/Half rate
==============
Full rate TCH time .........................../trf_56         462 hr (  32.45 %)
Half rate TCH time .........................../trf_57         963 hr (  67.55 %)

Full rate time congestion .................../cngt_3a                (   4.40 %)
Half rate time congestion .................../cngt_4a                (   0.66 %)

Note: For a cell level list, run report 236.


non-AMR/AMR
=============
Non-AMR TCH time ............................/trf_115         374 hr (  28.73 %)
AMR TCH time ................................/trf_116         928 hr (  71.27 %)
.  Full rate ................................/trf_117         334 hr (  25.65 %)
.  Half rate ................................/trf_118         594 hr (  45.62 %)

Note: This is based on Rx Quality measurement
Note: For a cell level list, run report 244.


9.6 and 14.4 kbit/s data
=========================
TCH requests for 9.6 kbit/s data (S10)........./c1189          515
. TCH seizures (S10).........................../c1190          426   (  82.72 %)

TCH requests for 14.4 kbit/s data............../c1156            0
. TCH seizures ................................/c1157            0   (   0.00 %)

High Speed Circuit Switched Data
=================================

TCH requests for transparent data............../c1158            0
. TCH seizures ................................/c1159            0   (   0.00 %)

Call Setups on TCH ............................/c1162            0
. TCH failures ................................/c1164            0   (   0.00 %)

Intracell Handovers
Attempts  ...................................../c4124            0
. Successful  ................................./c4125            0   (   0.00 %)
.  Downgrades  ................................/c4127            0   (   0.00 %)
.  Uprades  .................................../c4126            0   (   0.00 %)

Intercell Handovers (BSC controlled incoming)
Attempts  ...................................../c4120            0
. Succesful  ................................../c4121            0   (   0.00 %)
.  Downgrades  ................................/c4123            0   (   0.00 %)
.  Uprades  .................................../c4122            0   (   0.00 %)

Inter-BSC Handovers (MSC controlled incoming)
Attempts  ...................................../c4114            0
. Succesful  ................................../c4115            0   (   0.00 %)
.  Downgrades  ................................/c4117            0   (   0.00 %)
.  Uprades  .................................../c4116            0   (   0.00 %)

Average TCH holding time ...................../trf_58          0.0 sec
Average upgrade pending time for HSCSD......../trf_62   0 sec
Average pending time due to congestion......../trf_63   0 sec
Total HSCSD call time on TCH ................./trf_61          0.0  hr

- 

TCH dual band
=============

Seizures by single band MS .................../c59002           na   (     na %)
Seizures by dual band MS ...................../c59003           na   (     na %)

Call time by single band MS (minutes)....../trf_43/60           na   (     na %)
Call time by dual band MS (minutes)......../trf_44/60           na   (     na %)

Note: All % is in ratio to total sum.



Reported time by MS capability classes (S9)
===========================================
.                                                              min
Total reported time ........................../trf_64            0
. Ph.1 MS ..................................../c71000            0   (        na %)
. Ph.2 MS ..................................../c71001            0   (        na %)

.                                                              min
Reported time by bands
. Single band GSM850 MS (S10) ................/c71033            0   (        na %)
. Single band GSM900 MS ....................../c71004            0   (        na %)
. Single band EGSM900 MS ...................../c71005            0   (        na %)
. Single band GSM1800 MS ...................../c71006            0   (        na %)
. Dual band MS .............................../c71007            0   (        na %)
. Tri band MS ................................/c71008            0   (        na %)
. Others ............................................            0   (        na %)
Note: % is counted in ratio to total reported time trf_64


TCH seizures by multislot classes
Total TCH seizures .........................../trf_65            0
. Multislot Class 1.........................../c71015            0   (        na %)
. Multislot Class 2.........................../c71016            0   (        na %)
. Multislot Class 3.........................../c71017            0   (        na %)
. Multislot Class 4.........................../c71018            0   (        na %)
. Multislot Class 5.........................../c71019            0   (        na %)
. Multislot Class 6.........................../c71020            0   (        na %)
. Multislot Class 7.........................../c71021            0   (        na %)
. Multislot Class 8.........................../c71022            0   (        na %)
. Multislot Class 9.........................../c71023            0   (        na %)
. Multislot Class 10........................../c71024            0   (        na %)
. Multislot Class 11........................../c71025            0   (        na %)
. Multislot Class 12........................../c71026            0   (        na %)
. Multislot Class 13........................../c71027            0   (        na %)
. Multislot Class 14........................../c71028            0   (        na %)
. Multislot Class 15........................../c71029            0   (        na %)
. Multislot Class 16........................../c71030            0   (        na %)
. Multislot Class 17........................../c71031            0   (        na %)
. Multislot Class 18........................../c71032            0   (        na %)
. Multislot incapable........................./c71014            0   (        na %)
Note: % is counted in ratio to total reported time trf_65

Note: The measurement is an optional feature in BSC
- 


Call re-establishment performance
=================================
SDCCH assignments ............................/c57022            0
SDCCH releases .............................. /c57026            0   (     na %)
TCH assignments.............................../c57032            0   (     na %)





HANDOVERS
=========

HO drop ratio ................................/hfr_68         0.55 %
Total HO failure ............................../hfr_2        10.81 %
. HO failure due to blocking ................./hfr_55         6.89 %

Outgoing MSC ctrl HO attempts ................../ho_9        39395
.   Successes ................................./c4004        35872  (  91.06 %)
.   Failures ................................./hof_6a         3523  (   8.94 %)
.     MSC ctrl ho not allowed ................./c4037            0  (   0.00 %)
.     Blocked ................................./c4055         1392  (   3.53 %)
.     Return to old .........................../c4006         1058  (   2.69 %)
.     End of HO  ............................../c4007          238  (   0.60 %)
.     End of HO BSS .........................../c4008            3  (   0.01 %)
.     Call clear ............................../c4041          832  (   2.11 %)
.     Wrong Aif circuit type ................../c4102            0  (   0.00 %)
.     Adjacent cell error ...................../c4100            0  (   0.00 %)

.   Drop calls (S7)............................/c4107          184  (   0.47 %)


Outgoing BSC ctrl HO attempts ................./ho_11       114619
.   Successes ................................./c4014       105407  (  91.96 %)
.   Failures ................................./hof_8a         9212  (   8.04 %)
.     BSC ctrl ho not allowed ................./c4038            1  (   0.00 %)
.     Blocked ................................./c4072         4794  (   4.18 %)
.     Return to old .........................../c4015         3371  (   2.94 %)
.     End of HO  ............................../c4016          403  (   0.35 %)
.     End of HO BSS .........................../c4017            0  (   0.00 %)
.     Call clear ............................../c4042          310  (   0.27 %)
.     Wrong Aif circuit type ................../c4096          277  (   0.24 %)

.   Drop calls ................................/c4084          344  (   0.30 %)


Intra cell  HO attempts ......................./ho_24        34385
.   Successes ................................./ho_27        26748  (  77.79 %)
.   Failures ................................../hof_9         7637  (  22.21 %)
.     Intra cell ho not allowed .............../c4036            0  (   0.00 %)
.     Blocked ................................./c4019         6787  (  19.74 %)
.     Return to old .........................../c4022          247  (   0.72 %)
.     MS lost .(drop call)...................../c4020          442  (   1.29 %)
.     Radio chn.act.failure .................../c4021           15  (   0.04 %)
.     Call clear ............................../c4039           66  (   0.19 %)
.     Wrong Aif circuit type ................../c4098           79  (   0.23 %)

.   Drop calls ................................/c4085          442  (   1.29 %)

Note: For a cell level list, run report 150.
Note: For adjacency level list run report 153.

- 
Causes:
UL quality...................................../c4023         8628  (   5.24 %)
UL level......................................./c4024        30888  (  18.74 %)
DL quality...................................../c4025        23856  (  14.47 %)
DL level......................................./c4026         6771  (   4.11 %)
Distance ....................................../c4027            0  (   0.00 %)
MSC invocation (traffic reason) .............../c4028            0  (   0.00 %)
UL interference .............................../c4029          633  (   0.38 %)
DL interference .............................../c4030         5061  (   3.07 %)
Umbrella ....................................../c4031        53177  (  32.27 %)
Pbdgt ........................................./c4032        13428  (   8.15 %)
OMC (forced by user) ........................../c4033            1  (   0.00 %)
Directed retry ................................/c4079         9937  (   6.03 %)
Pre-emption .................................../c4086            0  (   0.00 %)
Rapid field drop ............................../c4087            0  (   0.00 %)
Low distance ................................../c4088            0  (   0.00 %)
Bad CI ......................................../c4089            0  (   0.00 %)
Good CI ......................................./c4090            0  (   0.00 %)
Aif circuit type change (S5).................../c4099          342  (   0.21 %)
Slow moving MS (S5) .........................../c4091            0  (   0.00 %)
MS slow speed (S6) ............................/c4105            0  (   0.00 %)
MS high speed (S6) ............................/c4106            0  (   0.00 %)
Bad rxlev on super (S7)......................../c4109            0  (   0.00 %)
Good rxlev on reg (S7)........................./c4110            0  (   0.00 %)
Direct access (S7)............................./c4128            0  (   0.00 %)
Enhanced rapid field drop (S7)................./c4111            0  (   0.00 %)
BSC controlled TRHO (S8)......................./c4035            0  (   0.00 %)
DADLB (S8)...................................../c4129         4438  (   0.03 %)
GPRS (S9)....................................../c4130         7651  (   4.64 %)
HSCSD (S10)..................................../c4141            0  (   0.00 %)

Note: For a cell level list, run report 154.
- 

SHORT MESSAGES
==============

SDCCH SMS attempts ............................./sms_5        36797
. success ....................................../sms_3              (  99.94 %)
TCH SMS attempts .............................../sms_6          421
. success ....................................../sms_2              (  98.81 %)

Note: For a cell level list, run report 132.
- 

===============================================================================
=               UPLINK INTERFERENCE STATISTICS
===============================================================================

The UL interference is measured based on the levels in idle FTCH.
The measurement reports the average number of idle FTCH in different
bands which are defined by boundaries. Boundaries are set as BTS
parameters.

------------------ boundary B00 (value fixed: -110dBm)
band 1
------------------ boundary B01 (value eg.:   -105dBm, critical)
band 2
------------------ boundary B02 (value e.g.:  -100dBm)
band 3
------------------ boundary B03 (value e.g.:  -95dBm)
band 4
------------------ boundary B04 (value e.g.:  -90dBm)
band 5
------------------ boundary B05 (value fixed: -47dBm)

Note:
.     If Mast Head Amplifiers are used, the boundary settings need to be checked.
.     MHA for the 1800 and 1900 networks add a constant 12 dB gain, whereas
.     TalkFamily MHA for the 900 network has an adjustable gain.
.     Additionally, TalkFamily MHAs have a 12 dB nominal gain and UltraSites
.     have a high, 32...33 dB gain.


The boundaries used in the selected BTS area are reported below:


THRS BOUNDARY1 (BO0) - fixed                  COUNT                             
---------------------------------------- ----------                             
-110.0 dBm                                       38                             

THRS BOUNDARY1 (BO1)                          COUNT                             
---------------------------------------- ----------                             
-100.0 dBm                                       38                             

THRS BOUNDARY1 (BO2)                          COUNT                             
---------------------------------------- ----------                             
 -95.0 dBm                                       38                             

THRS BOUNDARY1 (BO3)                          COUNT                             
---------------------------------------- ----------                             
 -90.0 dBm                                       38                             

THRS BOUNDARY1 (BO4)                          COUNT                             
---------------------------------------- ----------                             
 -85.0 dBm                                       38                             

THRS BOUNDARY1 (BO5) - fixed                  COUNT                             
---------------------------------------- ----------                             
 -47.0 dBm                                       38                             

The percentual distribution of idle FTCH in the selected area:

idle FTCH idle FTCH idle FTCH idle FTCH idle FTCH                               
in band 1 in band 2 in band 3 in band 4 in band 5                               
      (%)       (%)       (%)       (%)       (%)                               
--------- --------- --------- --------- ---------                               
    100.0       0.0       0.0       0.0       0.0                               

Note : For cell level list run the report 190.
Note : For TRX level list run the report 196.

- 

                                                                                
                                                                                

                                                                                
                                                                                

===============================================================================
=
=		UL, DL QUALITY/LEVEL DISTRIBUTION (BER BASED)
=
===============================================================================
Note1: The used measurement 'Rx Level Statistics' is an optional BSC feature.
Note2: If RX-level sub range[1...5] settings overlap the total quality
.      distribution may exceed 100 %.

Rx lev range (dBm) = upper boundary (level) of range


                                                                         Share  
RX lev      UL      UL      UL      UL      UL      UL      UL      UL      in  
range       q0      q1      q2      q3      q4      q5      q6      q7   range  
(dBm)      (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%)  
------ ------- ------- ------- ------- ------- ------- ------- ------- -------  
-100      9.39    0.92    0.86    0.81    0.70    0.59    0.51    0.71   14.50  
-95      13.94    0.35    0.29    0.22    0.12    0.08    0.06    0.05   15.12  
-90      24.17    0.32    0.31    0.23    0.10    0.06    0.04    0.04   25.29  
-80      35.70    0.26    0.33    0.26    0.09    0.07    0.05    0.05   36.81  
-70       6.83    0.02    0.04    0.04    0.02    0.02    0.02    0.02    7.01  
-47       1.24    0.00    0.01    0.01    0.01    0.01    0.01    0.00    1.28  
       ------- ------- ------- ------- ------- ------- ------- ------- -------  
sum      91.28    1.88    1.84    1.58    1.04    0.84    0.68    0.87  100.00  

                                                                         Share  
RX lev      DL      DL      DL      DL      DL      DL      DL      DL      in  
range       q0      q1      q2      q3      q4      q5      q6      q7   range  
(dBm)      (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%)  
------ ------- ------- ------- ------- ------- ------- ------- ------- -------  
-100      0.44    0.07    0.09    0.13    0.17    0.19    0.17    0.13    1.40  
-95       1.29    0.17    0.21    0.24    0.23    0.18    0.13    0.09    2.53  
-90       3.79    0.34    0.43    0.43    0.38    0.28    0.18    0.13    5.97  
-80      31.86    2.20    2.42    2.03    1.36    0.74    0.40    0.25   41.26  
-70      29.36    1.48    1.59    1.20    0.72    0.36    0.20    0.11   35.03  
-47      12.60    0.29    0.33    0.23    0.17    0.09    0.06    0.04   13.82  
       ------- ------- ------- ------- ------- ------- ------- ------- -------  
sum      79.35    4.54    5.07    4.26    3.03    1.85    1.15    0.75  100.00  

Note: For TRX level list run report 197.

===============================================================================
=
=		UL, DL CUMULATIVE QUALITY DISTRIBUTION (BER BASED)
=
===============================================================================

These are both non-AMR and AMR calls.

                                                                                
                                                                                
Cumulative uplink quality distribution (ulq_2) :


  Qual0   Qual1   Qual2   Qual3   Qual4   Qual5   Qual6   Qual7                 
------- ------- ------- ------- ------- ------- ------- -------                 
  91.28   93.16   95.00   96.57   97.61   98.45   99.13  100.00                 

                                                                                
                                                                                
Cumulative downlink quality distribution (dlq_2) :


  Qual0   Qual1   Qual2   Qual3   Qual4   Qual5   Qual6   Qual7                 
------- ------- ------- ------- ------- ------- ------- -------                 
  79.35   83.89   88.96   93.22   96.25   98.10   99.25  100.00                 

Note: For TRX level list run report 196 (S9) or report 244 (S10->).
- 

===============================================================================
=
=		UL, DL QUALITY DISTRIBUTION PER CODEC (BER BASED). S10
=
===============================================================================
NOTE: In T12/S10 there are bugs that make the measurement unusable for
.     identifying bit rates for MODE1..4
.     In OSS3.1/S10 and S10.5 the bugs are fixed by CDs.
NOTE: The report contains correct information only if codec sets are the same
.     in all BTSs.

Used measurement: Rx Quality

Uplink quality distribution  (total    9760996 samples):


         *** ****** ******   UL   ****** ****** ****** ***                      
        q0     q1     q2     q3     q4     q5     q6     q7                     
Codec   (%)    (%)    (%)    (%)    (%)    (%)    (%)    (%)                    
----- ------ ------ ------ ------ ------ ------ ------ ------                   
NoAMR   91.3    1.9    1.8    1.6    1.0    0.8    0.7    0.9                   
FR M1    0.0    0.6    0.0    0.0    1.1    0.1    0.1    3.1                   
FR M2    1.5    0.0    0.1    0.1    0.1    0.1    0.0    0.0                   
FR M3    0.1    0.0    0.1    0.1    0.1    0.0    0.0    0.0                   
FR M4   17.3    0.3    0.4    0.2    0.0    0.0    0.0    0.0                   
HR M1    5.9    0.2    0.2    0.4    0.4    0.3    0.2    0.1                   
HR M2    0.4    0.1    0.2    0.1    0.0    0.0    0.0    0.0                   
HR M3   34.4    0.7    1.3    0.3    0.1    0.4    0.1    0.0                   
HR M4    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0                   
                                                                                
Downlink quality distribution (total    9751251 samples):


         *** ****** ******   DL   ****** ****** ****** ***                      
        q0     q1     q2     q3     q4     q5     q6     q7                     
Codec   (%)    (%)    (%)    (%)    (%)    (%)    (%)    (%)                    
----- ------ ------ ------ ------ ------ ------ ------ ------                   
NoAMR   79.3    4.5    5.1    4.3    3.0    1.9    1.1    0.8                   
FR M1    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.1                   
FR M2    0.4    0.0    0.0    0.1    0.1    0.1    0.1    0.0                   
FR M3    0.2    0.0    0.0    0.0    0.1    0.1    0.1    0.0                   
FR M4   14.5    1.4    1.4    1.1    0.7    0.3    0.1    0.0                   
HR M1    3.0    0.2    0.4    0.4    0.4    0.4    0.4    0.3                   
HR M2    1.0   24.1    0.1    0.2    1.3    0.1    0.1    1.0                   
HR M3   34.3    1.4    1.5    3.0    0.7    0.2    3.1    0.0                   
HR M4    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0                   
                                                                                

Bitrates (kbps) and occurences for each codec set used in the BTS area          
during given time period                                                        
Note: the occurences are counted among those records that have AMR data.        
                                                                                
Bitrates in FR codec Bitrates in HR codec                                       
(M4,M3,M2,M1)        (M4,M3,M2,M1)        NBR_OF_RCDS                           
-------------------- -------------------- -----------                           
0                    0                           1173                           

Note: For more details (object and time resolution) run report report 244.
- 

===============================================================================
=
=		UL,DL QUALITY/CODEC TYPE DISTRIBUTION (UL FER, DL FEP)
=
===============================================================================


Bitrates (kbps) and occurences for each codec set used in the BTS area          
during given time period                                                        
Note: the occurences are counted among those records that have AMR data.        
                                                                                
                                                                                
                                                                                

UL call samples (total 4643270) distribution ulq_3.


Bitrates (kbps) and occurences for each codec set used in the BTS area          
during given time period                                                        
Note: the occurences are counted among those records that have AMR data.        
                                                                                
                     UL      UL      UL      UL      UL      UL      UL      UL 
                  class   class   class   class   class   class   class   class 
                      0       1       2       3       4       5       6       7 
Codec               (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%) 
--------------- ------- ------- ------- ------- ------- ------- ------- ------- 
HR                11.79    0.19    0.17    0.06    0.04    0.02    0.02    0.24 
FR                 0.32    0.00    0.00    0.00    0.00    0.00    0.00    0.00

dmazzini · Sep 25, 2006

Full 204 report.

Code:

-------------------------------------------------------------------------------
 
                        Report Generation Data 
 
-------------------------------------------------------------------------------
 
Date                   : Thu Aug 31 17:00:29 SAT 2006
Menu Command Path      : by cron
User / Host            : ricuser / nok1scs
Network Doctor         : report number 204



===============================================================================
=
=                   NETWORK BENCHMARK STATISTICS
=
=                   Network:         PLMN
=                   Area:            All BTSs selected
=                   Period:          from 20060831 to 20060831
=                   Time criteria:   Whole period
=
===============================================================================

This report provides versatile information about the selected BTS area.
- objects
- key parameters
- Key Performance Indicators

Measurement used: p_nbsc_traffic, p_nbsc_ho, p_nbsc_power, p_nbsc_res_access,
.     p_nbsc_res_avail, p_nbsc_rx_qual, p_nbsc_rx_statistics, p_nbsc_service
.     p_nbsc_fer, p_nbsc_pbcch_avail

Note: This report is meant primarily for the area level. If used on the BTS
.     level, some formulas may not be exactly correct. Use report 216 for BTS.

Note: Rx Quality and Rx Level measurements are usually run with a measurement
.     period longer than 60min. Therefore applying Busy Period over them may
.     not succeed, and no results are shown.

Note: Running this report may take a long time. Patience please.

===============================================================================
- 



Network object data about the selected area
*******************************************
(counted from the objects table)

(used   = object and all parent objects unlocked)
(unused = object and/or any of parent objects locked)

All BCF:                   13
.....Unused BCF:                  1
.....Used BCF:                   12

All BTS:                   39
.....Unused BTS:                  1
.....Used BTS:                   38

All TRX:                  113
.....Unused TRX:                 15
.....Used TRX:                   98

Number of adjacencies
of used BTSs:                   789



                                 Amount of                                      
BCF HW Type                      used BCFs                                      
------------------------------ -----------                                      
UltraSite                               12                                      
Note: For a cell level list, run report 099.


Number of used frequencies: ...............................        38
. (TRX and its parents are unlocked )
Number of TRXs per BTS:....................................       2.6

Frequency reuse pattern (effective reuse) ........../cnf_1       14.7
. (frequencies/average nbr of TRX per BTS)
. Note: - the value makes sense only to large area, eg. more than 50 cells
.       - the value makes sense only in nonhopping or baseband hopping area
- 
Statistics about the basic settings of used BTSs:
('used' means that BTS and its parent BCF are unlocked)

CELL BARRED (BAR)                             COUNT                             
---------------------------------------- ----------                             
No                                               38                             

BTS HOPPING (HOP)                             COUNT                             
---------------------------------------- ----------                             
Rf hopping                                       22                             
not hopping                                      16                             

DR in use (DR)                                COUNT                             
---------------------------------------- ----------                             
Yes                                              38                             

Trunk Reservation Used (TR)                   COUNT                             
---------------------------------------- ----------                             
No                                               38                             

Call Reestablishment Allowed (RE)             COUNT                             
---------------------------------------- ----------                             
No                                               38                             

Allow IMSI attach/detach (ATT)                COUNT                             
---------------------------------------- ----------                             
Yes                                              38                             

DTX mode (DTX)                                COUNT                             
---------------------------------------- ----------                             
Shall                                            38                             

RxLev Access Min (RXP)                        COUNT                             
---------------------------------------- ----------                             
-102.0 dBm                                       38                             

Radio Link Timeout (RTL)                      COUNT                             
---------------------------------------- ----------                             
  16.0 SACCH                                     38                             

Number of Blocks for AGCH (AG)                COUNT                             
---------------------------------------- ----------                             
   1.0                                           38                             

MS TxPower Max GSM (PMAX1)                    COUNT                             
---------------------------------------- ----------                             
  33.0 dBm                                       38                             

MS TxPower Max GSM 1800/1900 (PMAX2)          COUNT                             
---------------------------------------- ----------                             
  30.0 dBm                                       38                             

MS TxPower Min (PMIN)                         COUNT                             
---------------------------------------- ----------                             
   0.0 dBm                                       22                             
  13.0 dBm                                       16                             

Max Number of Repetition  (NY1)               COUNT                             
---------------------------------------- ----------                             
   5.0                                           38                             

Max Number of Retransmission (RET)            COUNT                             
---------------------------------------- ----------                             
   4.0                                           38                             

Number of Multiframes  (MFR)                  COUNT                             
---------------------------------------- ----------                             
   4.0                                           38                             

Timer for Periodic MS LUP   (PER)             COUNT                             
---------------------------------------- ----------                             
   2.0 Hours                                     38                             

GPRS enabled   (GENA)                         COUNT                             
---------------------------------------- ----------                             
Yes                                              38                             

Note: For full parameter settings distribution, run the report 068.


Note: For a full BCF software deployment list, run report 099.


BSC software version used                                                       
(only BSCs above used BTSs counted)           COUNT                             
---------------------------------------- ----------                             
110                                              38                             

Note: For full BSC software deployment list run report 092.
- 


CALL SUCCESS FACTORS (breakdown I)
====================
SDCCH access probability
.     (before FCS) ............................./csf_1       99.36 %
.     (after FCS) ............................./csf_1a       99.36 %

SDCCH success ratio
.     (SDCCH fail based, incl.LU) ............./csf_2k       94.19 %
.     (SDCCH to TCH based) ..................../csf_2o       90.85 %

TCH access probability
.     (before DR and queuing) ................./csf_3m       90.62 %
.     (before DR) ............................./csf_3i       90.72 %
.     (real) ................................../csf_3o    96.95 %

TCH success ratio (after seizure)
.     (before re-est.) ......................../csf_4u       98.28 %
.     (after re-est) ........................../csf_4v       98.28 %

Note: See the formula descriptions for the accuracy limitations.
Note: For a cell level list, run report 250.


CALL SUCCESS FACTORS (breakdown II)
====================
TCH assignment probability ............. /100-blck_29         0.00 %
TCH success ratio after assignment
.     (before re-est.) .................. /100-dcr_8c         0.00 %
.     (after re-est.) ................... /100-dcr_8e         0.00 %

- 

CCCH / paging
=============
All pagings .........................................     16291145
. CS pagings from Aif ........................./c3000     16223189    (  99.6 %)
. CS pagings from Gb ........................../c3058            0    (   0.0 %)
. PS pagings from Gb ........................../c3057        67956    (   0.4 %)

Delete paging commands ......................../c3038            0    (   0.0 %)

Note: For a cell level list, run report 186.


PCCCH / paging
==============
All pagings .........................................            0
. CS pagings on PCCCH ......................../c91018            0    (   0.0 %)
. PS pagings on PCCCH ......................../c91019            0    (   0.0 %)
. Packet Paging requests on PCCCH ............/c91020            0    (   0.0 %)

Deleted paging commands ....................../c91017            0    (   0.0 %)

AG
==
Imm.assign  .................................../c3001       477573
Imm.assign rejected .........................../c3002         3083
Del.ind. message received .(DL CCCH overload)../c3005            0
AG blocking ................................./blck_13         0.00 %

P-Imm.assign  ................................/c72084        74722
P-Imm.assign rejected ......................../c72087         8711
P-Imm.assign NACK received .................../c72086            0
P-Imm.assign NACK ratio ...................../blck_21         0.00 %


RACH
====
Chn.required msg (PS) received from BTS ....../c72082        73183
These are handled by PCU.

Chn.required msg (CS) received from BTS ......./c3004       480663
RACH rejected by BSC:
. rejected due distance ......................./c3031            0  (   0.00 %)
. rejected due to illegal est. cause ........./rach_6            8  (   0.00 %)
. BCSU overload lower limit (S7).............../c3039            0  (   0.00 %)
. BCSU overload upper limit (S7).............../c3040            0  (   0.00 %)
. BCSU MCMU overload protection (S7).........../c3041            0  (   0.00 %)

Note: For a cell level list, run report 134.

- 

SDCCH
=====
SDCCH availability ............................/ava_4        87.78 %
Dynamic SDCCH allocation (TCH reconfigured to SDCCH):
. Attempts ..................................../c1154         2077
Note: For a cell level list, run report 139.

SDCCH requests ................................/c1000       480553
. HO in......................................../c1006            0  (   0.00 %)
. blocked ........................./blck_15 (blck_5a)         3071  (   0.64 %)
. To FACCH call setup ........................./c1099            0  (   0.00 %)
. LU ........................................../c3019       242343  (  50.43 %)
. MTC (incl. SMS) ............................./c3012        76117  (  15.84 %)
. MOC (incl. SMS,SS) ........................../c3013       125111  (  26.03 %)
.   supplementary service request (S9) ......../c3044         7510  (   1.56 %)
. IMSI detach (S7) ............................/c3033         8955  (   1.86 %)
. call re-establishment......................../c3020            0  (   0.00 %)
. emergency call ............................../c3021          266  (   0.06 %)
. other (fails, ghosts) ......................./sd_1a        24690  (   5.14 %)


SDCCH usage ................................../trf_7b         5.43 %

Average SDCCH seizure length ................../trf_4         2.95 sec

Note: For a cell level list, run report 189.



SDCCH failures
==============
SDCCH seizures .............................../trf_54       477482
SDCCH drop ratio ............................./sdr_1a         6.69 %
. SDCCH_RADIO_FAIL............................./c1003         5809  (   1.22 %)
. SDCCH_A_IF_FAIL_CALL........................./c1078          162  (   0.03 %)
. SDCCH_ABIS_FAIL_CALL........................./c1075        25650  (   5.37 %)
. SDCCH_USER_ACT.............................../c1037            8  (   0.00 %)
. SDCCH_BCSU_RESET............................./c1038            0  (   0.00 %)
. SDCCH_NETW_ACT.............................../c1039            0  (   0.00 %)
. SDCCH_BTS_FAIL.............................../c1036            1  (   0.00 %)
. SDCCH_LAPD_FAIL............................../c1035            0  (   0.00 %)
. SDCCH_RF_OLD_HO........(HO drop)............./c1004           95  (   0.02 %)
. SDCCH_ABIS_FAIL_OLD....(HO drop)............./c1076            0  (   0.00 %)
. SDCCH_A_IF_FAIL_OLD....(HO drop)............./c1079          240  (   0.05 %)

T3101 expired (S7) .........................../c57020            0  (   0.00 %)
. (denominator in % calculation is same as above)
SDCCH drop ratio without T3101 expiry ........./sdr_4         6.69 %

Note: For a cell level list, run report 166.
- 

TCH
===
TCH availability (speech and GPRS)............/ava_1d        77.69 %
Note: For a cell level list, run report 139 or 185.

TCH requests ................................../c1010       316977
. FACCH call setup ............................/c1043            0  (   0.00 %)
. new calls (normal and DR out) ............./trf_18a       145870  (  46.02 %)
. handovers ................................../ho_14b       166248  (  52.45 %)
. call retries due to Aif pool mismatch ....../trf_49         3249
. HO retries due to Aif pool mismatch ......../trf_50         1610

TCH requests for FACCH call setup (c1043):
. Blocked .................................../blck_18            0  (     na %)
. Succ. seizures ............................../c1099            0  (     na %)
. MOC ........................................./c3024            0  (     na %)
. MTC ........................................./c3023            0  (     na %)
. call re-establishment ......................./c3025            0  (     na %)
. emergency call ............................../c3022            0  (     na %)
. IMSI detach (S7) ............................/c3034            0  (     na %)
. supplementary service request (S9) ........../c3045            0  (     na %)

TCH requests for new calls (trf_18a):
. DR handover to other cell
.    succ ....................................../dr_3        13449  (   9.22 %)
.    unsucc ..................................../dr_7          926  (   0.63 %)
. DR handover intracell (IUO opt.)
.    succ ...................................../c4074            0  (   0.00 %)
.    unsucc ..................................../dr_8            0  (   0.00 %)
. To queue ..................................../c1016            0  (   0.00 %)
.    From queue to DR (S8)...................../c1173            0  (   0.00 %)
.    Unserved queued ........................../c1024            0  (   0.00 %)
. TCH normal seizures (queued or not) ......../trf_55       130723  (  89.62 %)
.    re-establishments (S7).................../c57032            0  (   0.00 %)
. Blocked calls .................../blck_9c (blck_8f)         1698  (   3.05 %)
. Blocked calls .................../blck_9c (blck_8h)         1698  (   0.77 %)

TCH normal seizures (trf_55):
. MS got on TCH (S7).........................../c1148       129092  (  98.75 %)

TCH requests for HO (ho_14b):
. Succ.TCH HO seizures, queued .............../que_2a            0  (   0.00 %)
. Succ.TCH HO seizures, non queued .........../que_8a       149441  (  89.89 %)
. Blocked HOs ............................/(blck_11c)        16807  (  10.11 %)

TCH req rej due to lack of res. .............../c1011        27152

MS average power ............................../pwr_1           27  dBm
MS-BS average distance ......................../dis_1   840  m


TCH time (hours) ............................/trf_24c      1425.08 hr
Number of calls ............................./trf_39a       141596
Average call length ........................../trf_2b        35.58  sec

Average FTCH seizure length .................../trf_5           18  sec
.  Note: For a cell level list, run report 189.


Average TCH usage .........................../trf_85b        14.58 %
. by CS traffic ............................./trf_83a        14.52 %
. by PS traffic (DL)........................./trf_84b         0.05 %
.  Note: For a cell level list, run report 185 (CS) or 229 (CS,PS).


HO / Calls ratio ............................/trf_13e        78.97 %
. Intra-cell HOs included..................../trf_13d        97.86 %
.  Note: For a cell level list, run report 157.

Average queue time in call ..................../c1020            0  sec
Average queue time in HO ....................../c1022            0  sec


TCH failures
============
TCH drop call ratio after TCH seizure
. before re-establisment....................../dcr_3i         1.72 %
.  TCH_RADIO_FAIL............................../c1013          892  (   0.63 %)
.  TCH_ABIS_FAIL_CALL........................../c1084          492  (   0.35 %)
.  TCH_A_IF_FAIL_CALL........................../c1087           55  (   0.04 %)
.  TCH_TR_FAIL................................./c1029           15  (   0.01 %)
.  TCH_USER_ACT................................/c1048           10  (   0.01 %)
.  TCH_BCSU_RESET............................../c1049            0  (   0.00 %)
.  TCH_NETW_ACT................................/c1050            0  (   0.00 %)
.  TCH_ACT_FAIL_CALL.........................../c1081            1  (   0.00 %)
.  TCH_BTS_FAIL................................/c1047            2  (   0.00 %)
.  TCH_LAPD_FAIL.............................../c1046            1  (   0.00 %)
.  TCH_RF_OLD_HO.......(HO drop).............../c1014          790  (   0.56 %)
.  TCH_ABIS_FAIL_OLD...(HO drop).............../c1085            7  (   0.00 %)
.  TCH_A_IF_FAIL_OLD...(HO drop).............../c1088          167  (   0.12 %)
.  TCH_TR_FAIL_OLD.....(HO drop).............../c1030            0  (   0.00 %)
. after re-establisment......................./dcr_3j         1.72 %

T3101 expired (S9) .........................../c57038            0  (   0.00 %)
. (denominator in % calculation is same as above)

Note: For a cell level list, run report 163.

TCH drop call ratio after TCH assignment
.  before re-establishment .................../dcr_8c         0.00 %
.  after re-establishment ..................../dcr_8e         0.00 %

Dropped conversation ratio .................../dcr_5b         0.00 %

Drops per erlang, before re-establishment ..../dcr_10         1.71
Drops per erlang, after re-establishment ..../dcr_10b         1.71

TCH capacity
============
Aver. ext. TCH capacity of extended cells (    0 cells):        tsl
Unavail. TCH ................................../uav_14          0.0  (   0 %)
Avail. TCH ..........................................
. CS HR ......................................./ava_31          0.0  (   0 %)
. CS FR ......................................./ava_33          0.0  (   0 %)
. CS dual ...................................../ava_35          0.0  (   0 %)

Average normal TCH capacity per BTS (all cells):                tsl
Unavail. TCH ................................../uav_13          4.5  (  22 %)
Avail. TCH ...........................................
. CS HR ......................................./ava_30          0.0  (   0 %)
. CS FR ......................................./ava_32          0.4  (   2 %)
. CS dual ...................................../ava_34         13.7  (  68 %)
. PS default ................................./ava_26a          0.9  (   4 %)
. PS dedicated .............................../ava_17a          0.7  (   3 %)

Note: For more detailed PS info run report 229.
Note: For more detailed CS info run report 205.


- 


TCH codec versions
==================
All % is in ratio to sum of all seizures:

Seizures ............................................       279544
Full Rate V1 ................................../c1108          807   (   0.29 %)
.         V2 (enhanced)......................../c1109        27062   (   9.68 %)
.         V3 (AMR) ............................/c1110        53632   (  19.19 %)
Half Rate V1 ................................../c1111        49791   (  17.81 %)
.         V2 ................................../c1112            0   (   0.00 %)
.         V3 (AMR)............................./c1113       148252   (  53.03 %)

Failures ............................................           15
Full Rate V1 ................................../c1127            0   (   0.00 %)
.         V2 (enhanced)......................../c1128            2   (  13.33 %)
.         V3 (AMR)............................./c1129            6   (  40.00 %)
Half Rate V1 ................................../c1130            4   (  26.67 %)
.         V2 ................................../c1131            0   (   0.00 %)
.         V3 (AMR)............................./c1132            3   (  20.00 %)

Note: For a cell level list, run report 247.

Full/Half rate
==============
Full rate TCH time .........................../trf_56         462 hr (  32.45 %)
Half rate TCH time .........................../trf_57         963 hr (  67.55 %)

Full rate time congestion .................../cngt_3a                (   4.40 %)
Half rate time congestion .................../cngt_4a                (   0.66 %)

Note: For a cell level list, run report 236.


non-AMR/AMR
=============
Non-AMR TCH time ............................/trf_115         374 hr (  28.73 %)
AMR TCH time ................................/trf_116         928 hr (  71.27 %)
.  Full rate ................................/trf_117         334 hr (  25.65 %)
.  Half rate ................................/trf_118         594 hr (  45.62 %)

Note: This is based on Rx Quality measurement
Note: For a cell level list, run report 244.


9.6 and 14.4 kbit/s data
=========================
TCH requests for 9.6 kbit/s data (S10)........./c1189          515
. TCH seizures (S10).........................../c1190          426   (  82.72 %)

TCH requests for 14.4 kbit/s data............../c1156            0
. TCH seizures ................................/c1157            0   (   0.00 %)

High Speed Circuit Switched Data
=================================

TCH requests for transparent data............../c1158            0
. TCH seizures ................................/c1159            0   (   0.00 %)

Call Setups on TCH ............................/c1162            0
. TCH failures ................................/c1164            0   (   0.00 %)

Intracell Handovers
Attempts  ...................................../c4124            0
. Successful  ................................./c4125            0   (   0.00 %)
.  Downgrades  ................................/c4127            0   (   0.00 %)
.  Uprades  .................................../c4126            0   (   0.00 %)

Intercell Handovers (BSC controlled incoming)
Attempts  ...................................../c4120            0
. Succesful  ................................../c4121            0   (   0.00 %)
.  Downgrades  ................................/c4123            0   (   0.00 %)
.  Uprades  .................................../c4122            0   (   0.00 %)

Inter-BSC Handovers (MSC controlled incoming)
Attempts  ...................................../c4114            0
. Succesful  ................................../c4115            0   (   0.00 %)
.  Downgrades  ................................/c4117            0   (   0.00 %)
.  Uprades  .................................../c4116            0   (   0.00 %)

Average TCH holding time ...................../trf_58          0.0 sec
Average upgrade pending time for HSCSD......../trf_62   0 sec
Average pending time due to congestion......../trf_63   0 sec
Total HSCSD call time on TCH ................./trf_61          0.0  hr

- 

TCH dual band
=============

Seizures by single band MS .................../c59002           na   (     na %)
Seizures by dual band MS ...................../c59003           na   (     na %)

Call time by single band MS (minutes)....../trf_43/60           na   (     na %)
Call time by dual band MS (minutes)......../trf_44/60           na   (     na %)

Note: All % is in ratio to total sum.



Reported time by MS capability classes (S9)
===========================================
.                                                              min
Total reported time ........................../trf_64            0
. Ph.1 MS ..................................../c71000            0   (        na %)
. Ph.2 MS ..................................../c71001            0   (        na %)

.                                                              min
Reported time by bands
. Single band GSM850 MS (S10) ................/c71033            0   (        na %)
. Single band GSM900 MS ....................../c71004            0   (        na %)
. Single band EGSM900 MS ...................../c71005            0   (        na %)
. Single band GSM1800 MS ...................../c71006            0   (        na %)
. Dual band MS .............................../c71007            0   (        na %)
. Tri band MS ................................/c71008            0   (        na %)
. Others ............................................            0   (        na %)
Note: % is counted in ratio to total reported time trf_64


TCH seizures by multislot classes
Total TCH seizures .........................../trf_65            0
. Multislot Class 1.........................../c71015            0   (        na %)
. Multislot Class 2.........................../c71016            0   (        na %)
. Multislot Class 3.........................../c71017            0   (        na %)
. Multislot Class 4.........................../c71018            0   (        na %)
. Multislot Class 5.........................../c71019            0   (        na %)
. Multislot Class 6.........................../c71020            0   (        na %)
. Multislot Class 7.........................../c71021            0   (        na %)
. Multislot Class 8.........................../c71022            0   (        na %)
. Multislot Class 9.........................../c71023            0   (        na %)
. Multislot Class 10........................../c71024            0   (        na %)
. Multislot Class 11........................../c71025            0   (        na %)
. Multislot Class 12........................../c71026            0   (        na %)
. Multislot Class 13........................../c71027            0   (        na %)
. Multislot Class 14........................../c71028            0   (        na %)
. Multislot Class 15........................../c71029            0   (        na %)
. Multislot Class 16........................../c71030            0   (        na %)
. Multislot Class 17........................../c71031            0   (        na %)
. Multislot Class 18........................../c71032            0   (        na %)
. Multislot incapable........................./c71014            0   (        na %)
Note: % is counted in ratio to total reported time trf_65

Note: The measurement is an optional feature in BSC
- 


Call re-establishment performance
=================================
SDCCH assignments ............................/c57022            0
SDCCH releases .............................. /c57026            0   (     na %)
TCH assignments.............................../c57032            0   (     na %)





HANDOVERS
=========

HO drop ratio ................................/hfr_68         0.55 %
Total HO failure ............................../hfr_2        10.81 %
. HO failure due to blocking ................./hfr_55         6.89 %

Outgoing MSC ctrl HO attempts ................../ho_9        39395
.   Successes ................................./c4004        35872  (  91.06 %)
.   Failures ................................./hof_6a         3523  (   8.94 %)
.     MSC ctrl ho not allowed ................./c4037            0  (   0.00 %)
.     Blocked ................................./c4055         1392  (   3.53 %)
.     Return to old .........................../c4006         1058  (   2.69 %)
.     End of HO  ............................../c4007          238  (   0.60 %)
.     End of HO BSS .........................../c4008            3  (   0.01 %)
.     Call clear ............................../c4041          832  (   2.11 %)
.     Wrong Aif circuit type ................../c4102            0  (   0.00 %)
.     Adjacent cell error ...................../c4100            0  (   0.00 %)

.   Drop calls (S7)............................/c4107          184  (   0.47 %)


Outgoing BSC ctrl HO attempts ................./ho_11       114619
.   Successes ................................./c4014       105407  (  91.96 %)
.   Failures ................................./hof_8a         9212  (   8.04 %)
.     BSC ctrl ho not allowed ................./c4038            1  (   0.00 %)
.     Blocked ................................./c4072         4794  (   4.18 %)
.     Return to old .........................../c4015         3371  (   2.94 %)
.     End of HO  ............................../c4016          403  (   0.35 %)
.     End of HO BSS .........................../c4017            0  (   0.00 %)
.     Call clear ............................../c4042          310  (   0.27 %)
.     Wrong Aif circuit type ................../c4096          277  (   0.24 %)

.   Drop calls ................................/c4084          344  (   0.30 %)


Intra cell  HO attempts ......................./ho_24        34385
.   Successes ................................./ho_27        26748  (  77.79 %)
.   Failures ................................../hof_9         7637  (  22.21 %)
.     Intra cell ho not allowed .............../c4036            0  (   0.00 %)
.     Blocked ................................./c4019         6787  (  19.74 %)
.     Return to old .........................../c4022          247  (   0.72 %)
.     MS lost .(drop call)...................../c4020          442  (   1.29 %)
.     Radio chn.act.failure .................../c4021           15  (   0.04 %)
.     Call clear ............................../c4039           66  (   0.19 %)
.     Wrong Aif circuit type ................../c4098           79  (   0.23 %)

.   Drop calls ................................/c4085          442  (   1.29 %)

Note: For a cell level list, run report 150.
Note: For adjacency level list run report 153.

- 
Causes:
UL quality...................................../c4023         8628  (   5.24 %)
UL level......................................./c4024        30888  (  18.74 %)
DL quality...................................../c4025        23856  (  14.47 %)
DL level......................................./c4026         6771  (   4.11 %)
Distance ....................................../c4027            0  (   0.00 %)
MSC invocation (traffic reason) .............../c4028            0  (   0.00 %)
UL interference .............................../c4029          633  (   0.38 %)
DL interference .............................../c4030         5061  (   3.07 %)
Umbrella ....................................../c4031        53177  (  32.27 %)
Pbdgt ........................................./c4032        13428  (   8.15 %)
OMC (forced by user) ........................../c4033            1  (   0.00 %)
Directed retry ................................/c4079         9937  (   6.03 %)
Pre-emption .................................../c4086            0  (   0.00 %)
Rapid field drop ............................../c4087            0  (   0.00 %)
Low distance ................................../c4088            0  (   0.00 %)
Bad CI ......................................../c4089            0  (   0.00 %)
Good CI ......................................./c4090            0  (   0.00 %)
Aif circuit type change (S5).................../c4099          342  (   0.21 %)
Slow moving MS (S5) .........................../c4091            0  (   0.00 %)
MS slow speed (S6) ............................/c4105            0  (   0.00 %)
MS high speed (S6) ............................/c4106            0  (   0.00 %)
Bad rxlev on super (S7)......................../c4109            0  (   0.00 %)
Good rxlev on reg (S7)........................./c4110            0  (   0.00 %)
Direct access (S7)............................./c4128            0  (   0.00 %)
Enhanced rapid field drop (S7)................./c4111            0  (   0.00 %)
BSC controlled TRHO (S8)......................./c4035            0  (   0.00 %)
DADLB (S8)...................................../c4129         4438  (   0.03 %)
GPRS (S9)....................................../c4130         7651  (   4.64 %)
HSCSD (S10)..................................../c4141            0  (   0.00 %)

Note: For a cell level list, run report 154.
- 

SHORT MESSAGES
==============

SDCCH SMS attempts ............................./sms_5        36797
. success ....................................../sms_3              (  99.94 %)
TCH SMS attempts .............................../sms_6          421
. success ....................................../sms_2              (  98.81 %)

Note: For a cell level list, run report 132.
- 

===============================================================================
=               UPLINK INTERFERENCE STATISTICS
===============================================================================

The UL interference is measured based on the levels in idle FTCH.
The measurement reports the average number of idle FTCH in different
bands which are defined by boundaries. Boundaries are set as BTS
parameters.

------------------ boundary B00 (value fixed: -110dBm)
band 1
------------------ boundary B01 (value eg.:   -105dBm, critical)
band 2
------------------ boundary B02 (value e.g.:  -100dBm)
band 3
------------------ boundary B03 (value e.g.:  -95dBm)
band 4
------------------ boundary B04 (value e.g.:  -90dBm)
band 5
------------------ boundary B05 (value fixed: -47dBm)

Note:
.     If Mast Head Amplifiers are used, the boundary settings need to be checked.
.     MHA for the 1800 and 1900 networks add a constant 12 dB gain, whereas
.     TalkFamily MHA for the 900 network has an adjustable gain.
.     Additionally, TalkFamily MHAs have a 12 dB nominal gain and UltraSites
.     have a high, 32...33 dB gain.


The boundaries used in the selected BTS area are reported below:


THRS BOUNDARY1 (BO0) - fixed                  COUNT                             
---------------------------------------- ----------                             
-110.0 dBm                                       38                             

THRS BOUNDARY1 (BO1)                          COUNT                             
---------------------------------------- ----------                             
-100.0 dBm                                       38                             

THRS BOUNDARY1 (BO2)                          COUNT                             
---------------------------------------- ----------                             
 -95.0 dBm                                       38                             

THRS BOUNDARY1 (BO3)                          COUNT                             
---------------------------------------- ----------                             
 -90.0 dBm                                       38                             

THRS BOUNDARY1 (BO4)                          COUNT                             
---------------------------------------- ----------                             
 -85.0 dBm                                       38                             

THRS BOUNDARY1 (BO5) - fixed                  COUNT                             
---------------------------------------- ----------                             
 -47.0 dBm                                       38                             

The percentual distribution of idle FTCH in the selected area:

idle FTCH idle FTCH idle FTCH idle FTCH idle FTCH                               
in band 1 in band 2 in band 3 in band 4 in band 5                               
      (%)       (%)       (%)       (%)       (%)                               
--------- --------- --------- --------- ---------                               
    100.0       0.0       0.0       0.0       0.0                               

Note : For cell level list run the report 190.
Note : For TRX level list run the report 196.

- 

                                                                                
                                                                                

                                                                                
                                                                                

===============================================================================
=
=		UL, DL QUALITY/LEVEL DISTRIBUTION (BER BASED)
=
===============================================================================
Note1: The used measurement 'Rx Level Statistics' is an optional BSC feature.
Note2: If RX-level sub range[1...5] settings overlap the total quality
.      distribution may exceed 100 %.

Rx lev range (dBm) = upper boundary (level) of range


                                                                         Share  
RX lev      UL      UL      UL      UL      UL      UL      UL      UL      in  
range       q0      q1      q2      q3      q4      q5      q6      q7   range  
(dBm)      (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%)  
------ ------- ------- ------- ------- ------- ------- ------- ------- -------  
-100      9.39    0.92    0.86    0.81    0.70    0.59    0.51    0.71   14.50  
-95      13.94    0.35    0.29    0.22    0.12    0.08    0.06    0.05   15.12  
-90      24.17    0.32    0.31    0.23    0.10    0.06    0.04    0.04   25.29  
-80      35.70    0.26    0.33    0.26    0.09    0.07    0.05    0.05   36.81  
-70       6.83    0.02    0.04    0.04    0.02    0.02    0.02    0.02    7.01  
-47       1.24    0.00    0.01    0.01    0.01    0.01    0.01    0.00    1.28  
       ------- ------- ------- ------- ------- ------- ------- ------- -------  
sum      91.28    1.88    1.84    1.58    1.04    0.84    0.68    0.87  100.00  

                                                                         Share  
RX lev      DL      DL      DL      DL      DL      DL      DL      DL      in  
range       q0      q1      q2      q3      q4      q5      q6      q7   range  
(dBm)      (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%)  
------ ------- ------- ------- ------- ------- ------- ------- ------- -------  
-100      0.44    0.07    0.09    0.13    0.17    0.19    0.17    0.13    1.40  
-95       1.29    0.17    0.21    0.24    0.23    0.18    0.13    0.09    2.53  
-90       3.79    0.34    0.43    0.43    0.38    0.28    0.18    0.13    5.97  
-80      31.86    2.20    2.42    2.03    1.36    0.74    0.40    0.25   41.26  
-70      29.36    1.48    1.59    1.20    0.72    0.36    0.20    0.11   35.03  
-47      12.60    0.29    0.33    0.23    0.17    0.09    0.06    0.04   13.82  
       ------- ------- ------- ------- ------- ------- ------- ------- -------  
sum      79.35    4.54    5.07    4.26    3.03    1.85    1.15    0.75  100.00  

Note: For TRX level list run report 197.

===============================================================================
=
=		UL, DL CUMULATIVE QUALITY DISTRIBUTION (BER BASED)
=
===============================================================================

These are both non-AMR and AMR calls.

                                                                                
                                                                                
Cumulative uplink quality distribution (ulq_2) :


  Qual0   Qual1   Qual2   Qual3   Qual4   Qual5   Qual6   Qual7                 
------- ------- ------- ------- ------- ------- ------- -------                 
  91.28   93.16   95.00   96.57   97.61   98.45   99.13  100.00                 

                                                                                
                                                                                
Cumulative downlink quality distribution (dlq_2) :


  Qual0   Qual1   Qual2   Qual3   Qual4   Qual5   Qual6   Qual7                 
------- ------- ------- ------- ------- ------- ------- -------                 
  79.35   83.89   88.96   93.22   96.25   98.10   99.25  100.00                 

Note: For TRX level list run report 196 (S9) or report 244 (S10->).
- 

===============================================================================
=
=		UL, DL QUALITY DISTRIBUTION PER CODEC (BER BASED). S10
=
===============================================================================
NOTE: In T12/S10 there are bugs that make the measurement unusable for
.     identifying bit rates for MODE1..4
.     In OSS3.1/S10 and S10.5 the bugs are fixed by CDs.
NOTE: The report contains correct information only if codec sets are the same
.     in all BTSs.

Used measurement: Rx Quality

Uplink quality distribution  (total    9760996 samples):


         *** ****** ******   UL   ****** ****** ****** ***                      
        q0     q1     q2     q3     q4     q5     q6     q7                     
Codec   (%)    (%)    (%)    (%)    (%)    (%)    (%)    (%)                    
----- ------ ------ ------ ------ ------ ------ ------ ------                   
NoAMR   91.3    1.9    1.8    1.6    1.0    0.8    0.7    0.9                   
FR M1    0.0    0.6    0.0    0.0    1.1    0.1    0.1    3.1                   
FR M2    1.5    0.0    0.1    0.1    0.1    0.1    0.0    0.0                   
FR M3    0.1    0.0    0.1    0.1    0.1    0.0    0.0    0.0                   
FR M4   17.3    0.3    0.4    0.2    0.0    0.0    0.0    0.0                   
HR M1    5.9    0.2    0.2    0.4    0.4    0.3    0.2    0.1                   
HR M2    0.4    0.1    0.2    0.1    0.0    0.0    0.0    0.0                   
HR M3   34.4    0.7    1.3    0.3    0.1    0.4    0.1    0.0                   
HR M4    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0                   
                                                                                
Downlink quality distribution (total    9751251 samples):


         *** ****** ******   DL   ****** ****** ****** ***                      
        q0     q1     q2     q3     q4     q5     q6     q7                     
Codec   (%)    (%)    (%)    (%)    (%)    (%)    (%)    (%)                    
----- ------ ------ ------ ------ ------ ------ ------ ------                   
NoAMR   79.3    4.5    5.1    4.3    3.0    1.9    1.1    0.8                   
FR M1    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.1                   
FR M2    0.4    0.0    0.0    0.1    0.1    0.1    0.1    0.0                   
FR M3    0.2    0.0    0.0    0.0    0.1    0.1    0.1    0.0                   
FR M4   14.5    1.4    1.4    1.1    0.7    0.3    0.1    0.0                   
HR M1    3.0    0.2    0.4    0.4    0.4    0.4    0.4    0.3                   
HR M2    1.0   24.1    0.1    0.2    1.3    0.1    0.1    1.0                   
HR M3   34.3    1.4    1.5    3.0    0.7    0.2    3.1    0.0                   
HR M4    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0                   
                                                                                

Bitrates (kbps) and occurences for each codec set used in the BTS area          
during given time period                                                        
Note: the occurences are counted among those records that have AMR data.        
                                                                                
Bitrates in FR codec Bitrates in HR codec                                       
(M4,M3,M2,M1)        (M4,M3,M2,M1)        NBR_OF_RCDS                           
-------------------- -------------------- -----------                           
0                    0                           1173                           

Note: For more details (object and time resolution) run report report 244.
- 

===============================================================================
=
=		UL,DL QUALITY/CODEC TYPE DISTRIBUTION (UL FER, DL FEP)
=
===============================================================================


Bitrates (kbps) and occurences for each codec set used in the BTS area          
during given time period                                                        
Note: the occurences are counted among those records that have AMR data.        
                                                                                
                                                                                
                                                                                

UL call samples (total 4643270) distribution ulq_3.


Bitrates (kbps) and occurences for each codec set used in the BTS area          
during given time period                                                        
Note: the occurences are counted among those records that have AMR data.        
                                                                                
                     UL      UL      UL      UL      UL      UL      UL      UL 
                  class   class   class   class   class   class   class   class 
                      0       1       2       3       4       5       6       7 
Codec               (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%) 
--------------- ------- ------- ------- ------- ------- ------- ------- ------- 
HR                11.79    0.19    0.17    0.06    0.04    0.02    0.02    0.24 
FR                 0.32    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
EFR               11.90    0.13    0.11    0.03    0.02    0.01    0.01    0.09 
AMR HR 7.5        38.56    0.56    0.45    0.09    0.05    0.02    0.01    0.07 
AMR HR 5.9         0.32    0.04    0.03    0.01    0.01    0.00    0.00    0.02 
AMR HR 4.75       10.12    0.76    0.59    0.24    0.13    0.09    0.05    1.16 
AMR FR 12.2       19.12    0.15    0.13    0.02    0.01    0.00    0.00    0.02 
AMR FR 7.5         0.22    0.02    0.01    0.00    0.00    0.00    0.00    0.01 
AMR FR 5.9         0.91    0.02    0.01    0.01    0.00    0.00    0.00    0.47 
AMR FR 4.75        0.17    0.03    0.02    0.01    0.01    0.01    0.01    0.04 
                ------- ------- ------- ------- ------- ------- ------- ------- 
sum               93.43    1.91    1.52    0.46    0.27    0.16    0.11    2.15 


DL call samples (total 0) distribution dlq_3.

Bitrates (kbps) and occurences for each codec set used in the BTS area          
during given time period                                                        
Note: the occurences are counted among those records that have AMR data.        
                                                                                
                     DL      DL      DL      DL      DL      DL      DL      DL 
                  class   class   class   class   class   class   class   class 
                      0       1       2       3       4       5       6       7 
Codec               (%)     (%)     (%)     (%)     (%)     (%)     (%)     (%) 
--------------- ------- ------- ------- ------- ------- ------- ------- ------- 
HR                 0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
FR                 0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
EFR                0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
AMR HR 7.5         0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
AMR HR 5.9         0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
AMR HR 4.75        0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
AMR FR 12.2        0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
AMR FR 7.5         0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
AMR FR 5.9         0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
AMR FR 4.75        0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 
                ------- ------- ------- ------- ------- ------- ------- ------- 
sum                0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00 


Note: All DL samples are estimated in S10. DL sampling needs some
time to collect enough data for making the correlations. Therefore the counters
may show 0 first.

Measurement setup:
The class boundaries B1..B7 (FER %) and averaging window size (SACCH frames)
are defined in the measurement setup.  B0 and B8 are fixed.
Class0 is between boundary 0 (B0) and boundary 1 (B1) etc.
Occurences gives the nbr of records where the setting is met.
If there are more than one line then different settings are used in the area.

Bitrates (kbps) and occurences for each codec set used in the BTS area          
during given time period                                                        
Note: the occurences are counted among those records that have AMR data.        
                                                                                
                                              Ave                               
B0   B1   B2   B3   B4   B5   B6   B7   B8    win                               
(%)  (%)  (%)  (%)  (%)  (%)  (%)  (%)  (%)  size OCCURENCES                    
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----------                    
  0   2.0  4.0  6.0  8.0 10.0 12.0 14.0  100    2       8273                    

For details run report 245.
===============================================================================
=                             END OF REPORT
===============================================================================

dmazzini
GSM System and Telecomm Consultant

dmazzini · Sep 25, 2006

As you can see script needs some improvements like:

1. Reg Exp could be more efficient.
2. Sh scripts can be inserted into perl, not need to create sh scripts and then trigger it.
3. Reduce some extra code.

The main problem as well is the time. I did it 2-3 nights ago. Not too much time to do it nice, since I have some other things to do...But it is working ok.

Now, I an sad when one of this guys that just know how to make click asked me...Should it be possible to present data just for 3 cells and then continue on next line..I said, why not...And then I realize that I might change few things...jejejeje! New challenges...

Cheers

dmazzini
GSM System and Telecomm Consultant

dmazzini · Sep 27, 2006

Hi

Problem was fixed. I was talking to the people that is going to use the report..They did not really know what they want. Just they want to see information and see values easily.

So I came out with it. And They told me...That what we wanted..jejejeje!

Thanks

Code:

format STDOUT_TOP =                                                              
                                                                                 SITE KPI REPORT
                                                                                 ---------------             
BSCNAME	  BCFNAME	BTSNAME 	BTSID  SDCCH  SDCCH  SDCCH  SDCCH  SDCCH  SDCCH  SDCCH   TCH 	   TCH        CSSR   CSSR    DCR    DCR     TOTAL   TOTAL      GOOD-RX   GOOD-RX
                              		   DROP   RADIO  A-IF   ABIS   BTS    LAPD   CONG    CONG  	   TRAFFIC    AFTER  BEFORE  BEFORE AFTER   HO      BLOCKED    QUAL      QUAL
		              		           RATIO  FAIL   FAIL   FAIL   FAIL   FAIL   TIME    TIME 	   UTLZ                                     FAIL    CALLS      UL        DL
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
.
format STDOUT =
@<<<<<<<<< @<<<<<<<<<   @<<<<<<<<<      @<<<<< @<<<<< @<<<<< @<<<<< @<<<<< @<<<<< @<<<<< @<<<<<  @<<<<<<<  @<<<<<     @<<<<< @<<<<<  @<<<<< @<<<<<  @<<<<<< @<<<<<     @<<<<<    @<<<<< 
$bscname,$bcfname,$btsname,$btsid,$sdcchdrop_ratio,$sdcchradio_fail,$sdcch_a_if_fail_call,$sdcch_abis_fail_call,$sdcch_bts_fail,$sdcch_lapd_fail,$sdcch_congestion_time,$tch_congestion_time,$tch_traffic_erlang,$succesfull_drop_call_ratio_bef_re_est,$succesfull_drop_call_ratio_after_re_est,$drop_call_ratio_bef_re_est,$drop_call_ratio_after_re_est,$total_ho_failure,$total_blocked_calls,$good_rx_quality_ul,$good_rx_quality_dl
.

Below output report generated

Code:

   ------------------------------------ 
       KPI Report generated by kpimx
   ------------------------------------ 
                                                                                 SITE KPI REPORT
                                                                                 ---------------
BSCNAME	  BCFNAME	BTSNAME 	BTSID  SDCCH  SDCCH  SDCCH  SDCCH  SDCCH  SDCCH  SDCCH   TCH 	   TCH        CSSR   CSSR    DCR    DCR     TOTAL   TOTAL      GOOD-RX   GOOD-RX
                              		       DROP   RADIO  A-IF   ABIS   BTS    LAPD   CONG    CONG  	   TRAFFIC    AFTER  BEFORE  BEFORE AFTER   HO      BLOCKED    QUAL      QUAL
		              		       RATIO  FAIL   FAIL   FAIL   FAIL   FAIL   TIME    TIME 	   UTLZ                                     FAIL    CALLS      UL        DL
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BSCAL38    DFSOB24      DFSOB243        83     2.77%  0.69%  0.00%  2.08%  0.00%  0.00%  0.00s   0.0s      0.6 Er     99.71% 99.71%  0.29%  0.29%   0.63%      0.0     98.35%    99.61%
BSCAL38    DFSOB01      DFSOB011        84     1.04%  0.23%  0.00%  0.81%  0.00%  0.00%  0.00s   0.0s      1.5 Er     99.93% 99.93%  0.07%  0.07%   2.26%      0.0     98.23%    99.62%
BSCAL38    DFSOB01      DFSOB013        85     6.68%  5.22%  0.00%  1.46%  0.00%  0.00%  0.00s   0.0s      3.7 Er     98.07% 98.07%  1.93%  1.93%   4.13%      0.0     95.59%    97.81%
BSCAL38    DFSOB07      DFSOB071        88     1.57%  0.30%  0.00%  1.27%  0.00%  0.00%  0.00s   0.0s      6.6 Er     99.55% 99.55%  0.45%  0.45%   6.13%      0.0     98.18%    99.18%
BSCAL38    DFSOB07      DFSOB073        89     2.52%  0.34%  0.00%  2.17%  0.00%  0.00%  0.00s   0.0s      1.6 Er     99.82% 99.82%  0.18%  0.18%   4.97%      0.0     98.82%    99.82%
BSCAL38    DFSOB07      DFSOB072        90     36.47% 0.35%  0.00%  36.13% 0.00%  0.00%  0.00s   0.0s      1.0 Er     99.53% 99.53%  0.47%  0.47%   2.24%      0.0     98.59%    99.52%
BSCDF38    DFSOB24      DFSOB241        81     2.29%  0.75%  0.00%  1.54%  0.00%  0.00%  0.00s   0.0s      1.2 Er     99.67% 99.67%  0.33%  0.33%   1.25%      0.0     98.32%    98.86%
BSCDF38    DFSOB24      DFSOB242        82     2.27%  0.55%  0.00%  1.72%  0.00%  0.00%  0.00s   0.0s      1.8 Er     99.48% 99.48%  0.52%  0.52%   1.11%      0.0     98.44%    99.33%
BSCDF38    DFSOB01      DFSOB012        86     2.01%  0.32%  0.00%  1.69%  0.00%  0.00%  0.00s   0.0s      3.7 Er     99.80% 99.80%  0.20%  0.20%   3.21%      0.0     98.18%    99.41%
BSCDF38    DFSOB01      DFSOB015        87     4.12%  1.70%  0.01%  2.41%  0.00%  0.00%  0.02s   0.1s      3.0 Er     98.93% 98.93%  1.07%  1.07%   12.97%     0.0     95.09%    98.06%

dmazzini
GSM System and Telecomm Consultant

rharsh · Sep 27, 2006

I haven't had a chance to look at this in a couple days, but see if the code below helps get you started - there isn't really any error checking, so that's something you may need to look into.

Code:

my @toPrint;

while (<DATA>) {

	# If there are three elements (arrays) in @toPrint
	# print them and clear @toPrint
	if (@toPrint == 3) {
		print_records(\@toPrint);
		@toPrint = ();
	}

	next if /^\s*$/;
	
	my @temp;
	push @temp, $_;

	while (my $line = <DATA>) {
		last if $line =~ /^\s*$/;
		push @temp, $line;
	}
	@temp = trim(@temp);
	push @toPrint, \@temp;
}

# Print Last Set of Records in @toPrint
if (@toPrint) {
	print_records(\@toPrint);
	@toPrint = ();
}

sub print_records {
	my $aref = shift;
	my $print_template = join(' | ', ("%-15s") x scalar @$aref) . " \|\n";
	
	#print '-' x (17 + 18 * scalar(@$aref-1)), "\n";
	print '-' x (17 + 18 * $#{$aref}), "\n";

	ROW: foreach my $row (0 ..  $#{$aref->[0]}) {
		my @temp;

		CELL: foreach my $cell (@$aref) {
			push @temp, $cell->[$row];
		}

		if ($temp[0] eq 'KPI DATA') {
			print '-' x (17 + 18 * $#{$aref}), "\n";
			printf $print_template, @temp;
			print '-' x (17 + 18 * $#{$aref}), "\n";
		} else {
			printf $print_template, @temp;
		}
	}
	print '-' x (17 + 18 * $#{$aref}), "\n\n";
}

sub trim {
	my @temp = @_;
	for (@temp) {s/^\s+//; s/\s+$//;}
	return @temp;
}

__DATA__
BSCNAME:AL3
BCFNAME:1
BCFID:1
BTSNAME:1-1
BTSID:1
KPI DATA
X:    1
Y:    2
Z:    3

BSCNAME:AL3
BCFNAME:2
BCFID:1
BTSNAME:1-2
BTSID:2
KPI DATA
X:    5
Y:    2
Z:    8

BSCNAME:AL2
BCFNAME:7
BCFID:13
BTSNAME:1-3
BTSID:2
KPI DATA
X:     9
Y:     23
Z:     45

BSCNAME:AL3
BCFNAME:1
BCFID:1
BTSNAME:1-4
BTSID:1
KPI DATA
X:    1
Y:    2
Z:    3

BSCNAME:AL3
BCFNAME:2
BCFID:1
BTSNAME:1-5
BTSID:2
KPI DATA
X:    5
Y:    2
Z:    8

BSCNAME:AL2
BCFNAME:7
BCFID:13
BTSNAME:1-6
BTSID:2
KPI DATA
X:     9
Y:     23
Z:     45

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Making a report - Just 3 columns 1

dmazzini

Programmer

rharsh

Technical User

dmazzini

Programmer

dmazzini

Programmer

dmazzini

Programmer

dmazzini

Programmer

rharsh

Technical User

Similar threads

Part and Inventory Search

Sponsor