Ericsson BSS GSM VN R1206B Functional Specification

Data Export Date: 11 Apr 2008


1. Change History


IssueDateAuthorComments
TBD   


2. Document References


Document NameDateDocument ReferenceURL
Vendor Documentation
BSS 06A Network Impact Report2006-06-30BSS 06A Network Impact Reporthttp://notesdoc/87256D28003200ED/(ADCWebOpenLinkLatestVD)?OpenAgent&ddHID=01082007-1083-BYKK&LinkType=VD&Open=1
BSS R12 Network Impact Report2007-01-26109 48-HSC 103 12/7 Uen Rev Fhttp://notesdoc/87256D28003200ED/(ADCWebOpenLinkLatestVD)?OpenAgent&ddHID=22052007-E4KH-F8JU&LinkType=VD&Open=1
User Description, Radio Network Statistics2007-05-02216/1553-HSC 103 12/9 Uen Dhttp://notesdoc/87256D28003200ED/(ADCWebOpenLinkLatestVD)?OpenAgent&ddHID=22052007-CXKM-EM47&LinkType=VD&Open=1


3. Outstanding Issues


NumberDateDescriptionPlanned Resolution
TBD   


4. Network Model


4.1 Network Objects

This section describes the network objects (logical and physical) that are referenced in this technology pack's data model.

BS

Base Station (representing a cell site) is mainly used as a link between Cell and BSC objects in the network hierarchy.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the BS.STRING 
NameA user friendly name preferably unique for the BS (site).STRING 
SGSNA unique identifier for the SGSN.STRINGSGSN
BSCThe BSC that controls this BS.STRINGBSC
MSCA unique identifier for the MSC.STRINGMSC
RegionRegion associated with the BS.STRINGRegion
NetworkNetwork associated with the BS.STRINGNetwork
BS_VersionHardware/Software version of the BS.STRING 
VendorManufacturer of the BS.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Site_NameA user_friendly name for the site (BS)STRING 
Site_Version STRING 


BSC

The Base Station Controller provides all the control functions and physical links between the MSC (and/or SGSN) and Cell. It switches circuit/packet data & provides functions such as handover, cell configuration data & control of RF power levels in base transceiver stations.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the BSC.STRING 
NameA user friendly name preferably unique for the BSC.STRING 
SGSNA unique identifier for the SGSN.STRINGSGSN
MSCThe MSC to which this BSC is connected.STRINGMSC
RegionRegion associated with the BSC.STRINGRegion
NetworkNetwork associated with the BSC.STRINGNetwork
VendorManufacturer of the BSC.STRING 
BSC_VersionHardware/Software version of the BSC.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 


Cell

The Cell handles the radio interface to the mobile station. The Cell is the radio equipment (transceivers and antennas) needed to service each cell in the network. A group of Cells is controlled by a BSC.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the Cell.STRING 
NameA user friendly name preferably unique for the Cell.STRING 
PCUA unique identifier for the PCU.STRINGPCU
NSVCA unique identifier for the NSVC.STRINGNSVC
Routing_AreaA unique identifier for the Routing_Area.STRINGRouting_Area
Registration_AreaA unique identifier for the Registration_Area.STRINGRegistration_Area
BSA unique identifier for the BS at which the Cell is located. The BS at which the cell is located.STRINGBS
LACThe Location Area Code encompassing the Cell.STRINGLAC
NetworkNetwork associated with the Cell.STRINGNetwork
GPRS_CellA unique identifier for the Cell.STRINGCell
UMTS_CellA unique identifier for the Cell.STRINGCell
BSCA unique identifier for the BSC.STRINGBSC
MSCA unique identifier for the MSC.STRINGMSC
SGSNA unique identifier for the SGSN.STRINGSGSN
RegionRegion associated with the Cell. Region
Cell_TypeIs the cell omni_directional, or a sector, or micro/pico/macro/umbrella cell, etc.STRING 
Defined_TRXNumber of defined TRX belonging to the cell.INTEGER 
Defined_TCHNumber of defined TCH channels of the Cell.INTEGER 
Defined_CCHNumber of defined CCH channels for the Cell.INTEGER 
Max_PowerThe bs_tx_pwr_max configuration attribute.FLOAT 
Segment_IdA unique identifier for the Segment.STRING 
Cell_VersionHardware/Software version of the Cell.STRING 
VendorManufacturer of the Cell.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Cell_DescriptionDescription of Cell.STRING 
BVC_IdA unique identifier for the BVC.STRING 
Defined_PDCHDesignated Packet Data Channel.INTEGER 
Dedicated_PDCHDedicated Packet Data Channel.INTEGER 
NSVC_CN_IdA unique identifier for the NSVC CN.STRING 
UTRAN_Absolute_Radio_Freq_ULUL UTRAN absolute Radio Frequency Channel numberSTRING 
UTRAN_Absolute_Radio_Freq_DLDLL UTRA absolute Radio Frequency Channel numberSTRING 
Primary_Scrambling_CodePrimary DL scrambling codeSTRING 
Primary_Common_Pilot_Ch_PowerPrimary CPICH channel powerINTEGER 
Primary_Sync_Ch_PowerPrimary synchronisation channel power, DLINTEGER 
Secondary_Sync_Ch_PowerSecondary synchronisation channel power, DLSTRING 
BCH_PowerBroadcast channel powerSTRING 


LAPD

Link Access Protocol-D Channel; the physical interface between the BSC and base stations is called the Abis interface. LAPD links are used for signalling.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the LAPD.STRING 
NameA user friendly name preferably unique for the LAPD.STRING 
SGSNA unique identifier for the SGSN.STRINGSGSN
BSA unique identifier for the BS, at the BS end of LAPD link.STRINGBS
BSCA unique identifier for the BSC, at the BSC end of LAPD link.STRINGBSC
MSCA unique identifier for the MSC.STRINGMSC
RegionRegion associated with the LAPD.STRINGRegion
NetworkNetwork associated with the LAPD.STRINGNetwork
LAPD_VersionHardware/Software version of the LAPD.STRING 
VendorManufacturer of the LAPD.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 


Neighbour

Represents a handover relationship between two cells that may perform handovers to each other.

Attribute NameDescriptionTypeRelated Object
Neighbour_IdA unique identifier for the Neighbour.STRING 
Neighbour_IDA unique string generated by the Metrica systemSTRING 
NameA user friendly name preferably unique for the Neighbour.STRING 
Source_CellA unique identifier for the Cell_Id of the Cell that is handling calls.STRINGCell
Target_Cell_IdA unique identifier for the Cell_Id of the Cell that is receiving handed-over calls.STRING 
Source_Cell_TypeType of Source Cell.STRING 
Target_Cell_TypeType of Target Cell.STRING 
Source_Cell_VersionHardware/Software version of the Source Cell.STRING 
Target_Cell_VersionHardware/Software version of the Target Cell.STRING 
Source_Cell_VendorManufacturer of the Source Cell.STRING 
Target_Cell_VendorManufacturer of the Target Cell.STRING 
Source_Cell_TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Target_Cell_TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Target_Cell_PositionPosition of Target Cell.INTEGER 


PCU

Packet Control Unit in a GPRS network.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the PCU.STRING 
NameA user friendly name preferably unique for the PCU.STRING 
SGSNA unique identifier for the SGSN.STRINGSGSN
NSVCA unique identifier for the NSVC.STRINGNSVC
RegionRegion associated with the PCU.STRINGRegion
NetworkNetwork associated with the PCU.STRINGNetwork
VendorManufacturer of the PCU.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
PCU_VersionHardware/Software version of the PCU.STRING 


Processor

The Processor object represents a CPU inside another network element. Some elements have more than one Processor.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the Processor.STRING 
NameA user friendly name preferably unique for the Processor.STRING 
RegionRegion associated with the Processor.STRINGRegion
NetworkNetwork associated with the Processor.STRINGNetwork
Processor_TypeType of Processor.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Node_IdThis is the identifier for the network element containing the Processor.STRING 
Node_NameA user friendly name preferably unique for the Node.STRING 
Node_TypeThe type of the network element containing the Processor.STRING 
Processor_VersionHardware/Software version of the Processor.STRING 
VendorManufacturer of the Processor.STRING 


Signalling_LinkSet

A set of Signalling Links between two points.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the SS7 LinkSet.STRING 
NameA user friendly name preferably unique for the SS7 LinkSet.STRING 
SS7_PointThe SS7 Point to which this SS7 LinkSet is connected to (at this end).STRINGSignalling_Point
NetworkNetwork associated with the SS7 LinkSet.STRINGNetwork
RegionRegion associated with the SS7 LinkSet.STRINGRegion
Node_IdThe Node (MSC or HLR) that this SS7 LinkSet is connected to (at this end).STRING 
Node_NameName of the node that this SS7 LinkSet is connected to (at this end).STRING 
Data_RateThe total of all the individual SS7 Link speeds (aggregated over all SS7 Links in the SS7 LinkSet) in bits per second (bit/s).FLOAT 
Designed_Link_FailuresThe number of SS7 Link failures permitted on the SS7 LinkSet while still keeping the SS7 LinkSet up to its designed capacity.INTEGER 
Node_TypeThe type of the network element that the SS7 LinkSet is connected to (at this end).STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Adjacent_Node_IdThe Adjacent Node that this SS7 LinkSet is connected from (at the other end).STRING 


Signalling_Link

The SS7 Signalling data link is a full-duplex, digital transmission channel, usually operating at 64 kbit/s.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the SS7 Link.STRING 
NameA user friendly name preferably unique for the SS7 Link.STRING 
SS7_LinkSetThe Node (MSC or HLR) that this SS7 Link is connected to (at this end).STRINGSignalling_LinkSet
RegionRegion associated with the SS7 Link.STRINGRegion
NetworkNetwork associated with the SS7 Link.STRINGNetwork
SS7_PointA unique identifier for the SS7 Point.STRINGSignalling_Point
Node_NameThe name for the network element that the SS7 Link is connected to (at this end).STRING 
Node_IdThe Node (MSC or HLR) that this SS7 Link is connected to (at this end).STRING 
Data_RateThe SS7 Link speed in bits per second (bit/s).FLOAT 
Node_TypeThe type of the network element that the SS7 Link is connected to at this end.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Adjacent_Node_IdThe Adjacent Node that this SS7 Link is connected from (at the other end).STRING 


Signalling_Point

Represents a signalling entity that is part of a Node.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the SS7 Point.STRING 
NameA user friendly name preferably unique for the SS7 Point.STRING 
RegionRegion associated with the SS7 Point. SS7_Point - the default value is derived via the Node.STRINGRegion
NetworkNetwork associated with the SS7 Point.STRINGNetwork
Node_IdA unique identifier for the Node.STRING 
Node_NameA user friendly name preferably unique for the Node.STRING 
Node_TypeType of Node.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Adjacent_Node_IdA unique identifier for the Adjacent Node.STRING 


Signalling_RouteSet

A Signalling Route is a path from one point to another in the signalling network. It is implemented by a number of LinkSets, but the relationship between RouteSets and LinkSets is not available in the data supplied by most vendors.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the SS7 RouteSet.STRING 
NameA user friendly name preferably unique for the SS7 RouteSet.STRING 
SS7_PointThe SS7 Point to which this SS7 RouteSet is connected (at this end).STRINGSignalling_Point
RegionRegion associated with the SS7 RouteSet.STRINGRegion
NetworkNetwork associated with the SS7 RouteSet.STRINGNetwork
Node_NameA user friendly name preferably unique for the Node.STRING 
Node_IdThe Node that this SS7 RouteSet is connected to (at this end).STRING 
Node_TypeType of Node.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Adjacent_Node_IdThe Adjacent node that this SS7 RouteSet is connected from (at the other end).STRING 


4.2 Reference Objects

This section describes the reference objects that are used only as lookups for compound-keyed raw data.

Not applicable to this tech pack.


5. Busy Hours

This section lists the busy hours that are defined in this technology pack, grouped by the network object to which they relate, as follows:


BSC Busy Hours

Busy Hour NameAcronymDefining KPI
busy_hourbbhBSC.Neutral.GSM.cells.tch_traffic


Cell Busy Hours

Busy Hour NameAcronymDefining KPI
busy_hourctbhCell.Neutral.GSM.tch.traffic


Processor Busy Hours

Busy Hour NameAcronymDefining KPI
busy_hourpbhProcessor.Neutral.GSM.cpu.load_pc


Signalling_Link Busy Hours

Busy Hour NameAcronymDefining KPI
received_busy_hourslrbhSignalling_Link.Neutral.GSM.link.incoming_utilisation
transmitted_busy_hoursltbhSignalling_Link.Neutral.GSM.link.outgoing_utilisation


Signalling_LinkSet Busy Hours

Busy Hour NameAcronymDefining KPI
received_busy_hourslsrbhSignalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_utilisation
transmitted_busy_hourslstbhSignalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_utilisation


6. Constants


This section lists all constants that are defined in this technology pack, and which may be referenced in KPI expressions.

None.

7. Performance Indicators

This section lists the performance indicators (both one-to-one counter mappings, and complex KPIs) that are defined in this technology pack, grouped by the network object to which they relate, as follows:

Note that all KPIs will have total, average, minimum and maximum values calculated for daily, weekly, and monthly summaries. Individual groups of KPIs may have additional summary types (including busy hours) applied to them, and these are listed against the respective KPIs in the tables below.


BSC Performance Indicators

BSC.Neutral.GSM.cells

Performance information for BSC?s, not calculated directly but is data aggregated from the Cells controlled by a BSC

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coverage FLOAT%Data availability 
%_tch_availabilitypercentok({BSC.Neutral.GSM.cells.available_tch}, {BSC.Neutral.GSM.cells.defined_tch})FLOAT%Percentage of available TCH over all Cells controlled by the BSCbbh
%_tch_blockingpercentfail({BSC.Neutral.GSM.cells.tch_blocks}, {BSC.Neutral.GSM.cells.tch_attempts})FLOAT%Percentage of blocked call attempts (TCH) over all Cells controlled by the BSCbbh
%_tch_dropped_callspercentfail({BSC.Neutral.GSM.cells.tch_dropped_calls}, {BSC.Neutral.GSM.cells.tch_attempts})FLOAT%Percentage of dropped calls (TCH) over all Cells controlled by the BSCbbh
available_tchgroup({Cell.Neutral.GSM.tch.available_ch})INTEGER#Total number of available TCH over all Cells controlled by the BSCbbh
defined_tchgroup({Cell.Neutral.GSM.tch.defined_ch})INTEGER#Total number of defined TCH over all Cells controlled by the BSCbbh
tch_attemptsgroup({Cell.Neutral.GSM.tch.seizure_attempts})INTEGER#Total attempted TCH seizures over all Cells controlled by the BSCbbh
tch_blocksgroup({Cell.Neutral.GSM.tch.blocks})INTEGER#Total blocked call attempts (blocked TCH seizures) over all Cells controlled by the BSCbbh
tch_dropped_callsgroup({Cell.Neutral.GSM.tch.total_dropped_calls})INTEGER#Total dropped calls over all Cells controlled by the BSCbbh
tch_trafficgroup({Cell.Neutral.GSM.tch.traffic})FLOATErlangTotalled traffic (occupancy) from all Cells controlled by the BSCbbh


Cell Performance Indicators

Cell.Neutral.GSM.access

The assignment request and granting activity on the RACH and AGCH channels

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({immass_attempts})FLOAT%  
%_immass_failurepercentfail({Cell.Neutral.GSM.access.immass_failures}, {Cell.Neutral.GSM.access.immass_attempts})FLOAT%Percentage of failed IMMEDIATE ASSIGNMENT attemptsctbh
%_immass_successpercentok({Cell.Neutral.GSM.access.immass_successes}, {Cell.Neutral.GSM.access.immass_attempts})FLOAT%Percentage of successful IMMEDIATE ASSIGNMENT attemptsctbh
immass_attemptscell_resource_access_raw.immass_attemptsINTEGER#IMMEDIATE ASSIGNMENT attempts (this is effectively the number of channel requests on the RACH)ctbh
immass_failurescell_resource_access_raw.immass_failuresINTEGER#Failed IMMEDIATE ASSIGNMENT proceduresctbh
immass_successescell_resource_access_raw.immass_successesINTEGER#Successful IMMEDIATE ASSIGNMENT procedures (this is effectively the number of messages sent on the AGCH)ctbh


Cell.Neutral.GSM.handover.cause

The reasons for handovers triggered from this cell i.e. Intra-Cell or Outgoing handovers, but not Incoming Inter-Cell or Inter-BSC handovers

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coverage FLOAT%Data coverage 
%_data_coveragegetvalidity({distance})FLOAT%  
%_directed_retrypercentfail({Cell.Neutral.GSM.handover.cause.directed_retry}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for directed retry handoverctbh
%_distancepercentok({Cell.Neutral.GSM.handover.cause.distance}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover caused by distance of the MS from the cellctbh
%_downlink_interferencepercentfail({Cell.Neutral.GSM.handover.cause.downlink_interference}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for intra-cell handover caused by interference on the downlinkctbh
%_downlink_levelpercentok({Cell.Neutral.GSM.handover.cause.downlink_level}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover caused by inadequate downlink signal levelctbh
%_downlink_qualitypercentok({Cell.Neutral.GSM.handover.cause.downlink_quality}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover caused by low downlink signal qualityctbh
%_grouped_downlinkpercentfail({Cell.Neutral.GSM.handover.cause.downlink_quality} + {Cell.Neutral.GSM.handover.cause.downlink_interference}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of requests due to Downlink Quality or Downlink Interference (not including Downlink Level)ctbh
%_grouped_msc_omcpercentfail({Cell.Neutral.GSM.handover.cause.msc_invoked} + {Cell.Neutral.GSM.handover.cause.omc_invoked}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of requests due to MSC or OMC invocationctbh
%_grouped_uplinkpercentfail({Cell.Neutral.GSM.handover.cause.uplink_quality} + {Cell.Neutral.GSM.handover.cause.uplink_interference}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of requests due to Uplink Quality or Uplink Interference (not including Uplink Level)ctbh
%_msc_invokedpercentok({Cell.Neutral.GSM.handover.cause.msc_invoked}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover due to the MSC invoking handover (finding a better cell)ctbh
%_omc_invokedpercentfail({Cell.Neutral.GSM.handover.cause.omc_invoked}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover caused by the OMC or other O&M activity invoking handoverctbh
%_otherpercentfail({Cell.Neutral.GSM.handover.cause.other}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover due to other causesctbh
%_power_budgetpercentok({Cell.Neutral.GSM.handover.cause.power_budget}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover caused by the power budget algorithm determining a better cellctbh
%_traffic_reasonspercentfail({Cell.Neutral.GSM.handover.cause.traffic_reasons}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover for traffic reasonsctbh
%_umbrellapercentok({Cell.Neutral.GSM.handover.cause.umbrella}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover to an umbrella cellctbh
%_uplink_interferencepercentfail({Cell.Neutral.GSM.handover.cause.uplink_interference}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for intra-cell handover caused by interference on the uplinkctbh
%_uplink_levelpercentok({Cell.Neutral.GSM.handover.cause.uplink_level}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover caused by low uplink signal levelctbh
%_uplink_qualitypercentok({Cell.Neutral.GSM.handover.cause.uplink_quality}, {Cell.Neutral.GSM.handover.cause.total_handovers})FLOAT%% of Requests for handover caused by inadequate uplink signal qualityctbh
directed_retry INTEGER#Number of Requests for a directed retry handover (selecting a channel or cell during connection ? not a true TCH-TCH handover)ctbh
distancecell_handover_causes_raw.distanceINTEGER#Number of Requests for handover caused by distance of the MS from the cellctbh
downlink_interference INTEGER#Number of Requests for intra-cell handover caused by interference on the downlinkctbh
downlink_levelcell_handover_causes_raw.downlink_levelINTEGER#Number of Requests for handover caused by inadequate downlink signal levelctbh
downlink_qualitycell_handover_causes_raw.downlink_qualityINTEGER#Number of Requests for handover caused by low downlink signal qualityctbh
grouped_downlink{Cell.Neutral.GSM.handover.cause.downlink_quality} + {Cell.Neutral.GSM.handover.cause.downlink_interference}INTEGER#Number of requests due to Downlink Quality or Downlink Interference (not including Downlink Level)ctbh
grouped_msc_omc{Cell.Neutral.GSM.handover.cause.msc_invoked} + {Cell.Neutral.GSM.handover.cause.omc_invoked}INTEGER#Number of requests due to MSC or OMC invocationctbh
grouped_uplink{Cell.Neutral.GSM.handover.cause.uplink_quality} + {Cell.Neutral.GSM.handover.cause.uplink_interference}INTEGER#Number of requests due to Uplink Quality or Uplink Interference (not including Uplink Level)ctbh
msc_invoked INTEGER#Number of Requests for handover due to the MSC invoking handover (finding a better cell)ctbh
omc_invokedcell_handover_causes_raw.omc_invokedINTEGER#Number of Requests for handover caused by the OMC or other O&M activity invoking handoverctbh
other INTEGER#Number of Requests for handover due to all other causes (i.e. anything not covered under one of the causes above)ctbh
power_budgetcell_handover_causes_raw.power_budgetINTEGER#Number of Requests for handover caused by the power budget algorithm determining a better cellctbh
total_handoverscell_handover_causes_raw.total_handoversINTEGER#All the handovers triggered from this cellctbh
traffic_reasonscell_handover_causes_raw.traffic_reasonsINTEGER#Number of Requests for handover for traffic reasons (e.g. handovers to a Cell that supports GPRS)ctbh
umbrella INTEGER#Number of Requests for handover to an umbrella cellctbh
uplink_interference INTEGER#Number of Requests for intra-cell handover caused by interference on the uplinkctbh
uplink_level INTEGER#Number of Requests for handover caused by low uplink signal levelctbh
uplink_qualitycell_handover_causes_raw.uplink_qualityINTEGER#Number of Requests for handover caused by inadequate uplink signal qualityctbh


Cell.Neutral.GSM.handover.result

The results of handover attempts within, from, and to the cell

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({incoming_interbsc_attempts})FLOAT%  
%_incoming_interbsc_failurepercentfail({Cell.Neutral.GSM.handover.result.incoming_interbsc_failures}, {Cell.Neutral.GSM.handover.result.incoming_interbsc_attempts})FLOAT%Percentage of incoming inter-BSC handovers that failedctbh
%_incoming_interbsc_successpercentok({Cell.Neutral.GSM.handover.result.incoming_interbsc_successes}, {Cell.Neutral.GSM.handover.result.incoming_interbsc_attempts})FLOAT%Percentage of incoming inter-BSC handovers that succeededctbh
%_incoming_intrabsc_failurepercentfail({Cell.Neutral.GSM.handover.result.incoming_intrabsc_failures}, {Cell.Neutral.GSM.handover.result.incoming_intrabsc_attempts})FLOAT%Percentage of incoming inter-cell handovers that failedctbh
%_incoming_intrabsc_successpercentok({Cell.Neutral.GSM.handover.result.incoming_intrabsc_successes}, {Cell.Neutral.GSM.handover.result.incoming_intrabsc_attempts})FLOAT%Percentage of incoming inter-cell handovers that succeededctbh
%_intracell_failurepercentfail({Cell.Neutral.GSM.handover.result.intracell_failures}, {Cell.Neutral.GSM.handover.result.intracell_attempts})FLOAT%Percentage of intra-cell handovers that failedctbh
%_intracell_successpercentok({Cell.Neutral.GSM.handover.result.intracell_successes}, {Cell.Neutral.GSM.handover.result.intracell_attempts})FLOAT%Percentage of intra-cell handovers that succeededctbh
%_outgoing_interbsc_failurepercentfail({Cell.Neutral.GSM.handover.result.outgoing_interbsc_failures}, {Cell.Neutral.GSM.handover.result.outgoing_interbsc_attempts})FLOAT%Percentage of outgoing inter-BSC handovers that failedctbh
%_outgoing_interbsc_successpercentok({Cell.Neutral.GSM.handover.result.outgoing_interbsc_successes}, {Cell.Neutral.GSM.handover.result.outgoing_interbsc_attempts})FLOAT%Percentage of outgoing inter-BSC handovers that succeededctbh
%_outgoing_intrabsc_failurepercentfail({Cell.Neutral.GSM.handover.result.outgoing_intrabsc_failures}, {Cell.Neutral.GSM.handover.result.outgoing_intrabsc_attempts})FLOAT%Percentage of outgoing inter-cell handovers that failedctbh
%_outgoing_intrabsc_successpercentok({Cell.Neutral.GSM.handover.result.outgoing_intrabsc_successes}, {Cell.Neutral.GSM.handover.result.outgoing_intrabsc_attempts})FLOAT%Percentage of outgoing inter-cell handovers that succeededctbh
incoming_interbsc_attemptscell_handover_results_inter_raw.incoming_interbsc_attemptsINTEGER#Total attempts for handoff from another cell controlled by a different BSC i.e an MSC controlled (?external?) inter-BSC handoverctbh
incoming_interbsc_bss_failures INTEGER#Inter-BSC handover failures caused by a problem in the BSS equipment (not attributable to the MS)ctbh
incoming_interbsc_failurescell_handover_results_inter_raw.incoming_interbsc_failuresINTEGER#Unsuccessful attempts for handover to another cell outgoing from this cell and controlled by the MSC i.e. a MSC controlled inter-cell handoverctbh
incoming_interbsc_resource_lacks INTEGER#Inter-BSC handover failures caused by a lack of target cell resources (i.e. no suitable channels available)ctbh
incoming_interbsc_seizure_failures INTEGER#Inter-BSC handover failures caused by the MS failing to seize the new channelctbh
incoming_interbsc_successescell_handover_results_inter_raw.incoming_interbsc_successesINTEGER#Successful incoming attempts for inter-BSC handover to another cell outgoing from this cell and controlled by the MSC i.e. a MSC controlled inter-cell handoverctbh
incoming_intrabsc_attemptscell_handover_results_intra_raw.incoming_intrabsc_attemptsINTEGER#Total attempts for handoff from another cell controlled by the same BSC i.e a BSC controlled (?internal?) inter-cell handoverctbh
incoming_intrabsc_bss_failures INTEGER#Incoming Inter-cell handover failures caused by a problem in the BSS equipment (not attributable to the MS)ctbh
incoming_intrabsc_failurescell_handover_results_intra_raw.incoming_intrabsc_failuresINTEGER#Unsuccessful attempts for handover from another cell coming into this cell and controlled by the BSC i.e. a BSC controlled inter-cell handoverctbh
incoming_intrabsc_resource_lacks INTEGER#Incoming Inter-cell handover failures caused by a lack of target cell resources (i.e. no suitable channels available)ctbh
incoming_intrabsc_seizure_failures INTEGER#Incoming Inter-cell handover failures caused by the MS failing to seize the new channelctbh
incoming_intrabsc_successescell_handover_results_intra_raw.incoming_intrabsc_successesINTEGER#Successful attempts for handover from another cell coming into this cell and controlled by the BSC i.e. a BSC controlled inter-cell handoverctbh
intracell_attemptscell_handover_results_intra_raw.intracell_attemptsINTEGER#Total attempts to handoff to a new channel in the same cell i.e an intra-cell handoverctbh
intracell_bss_failures INTEGER#Intra-cell handover failures caused by a problem in the BSS equipment (not attributable to the MS)ctbh
intracell_failurescell_handover_results_intra_raw.intracell_failuresINTEGER#Unsuccessful attempts to handoff to a new channel in the same cell i.e an intra-cell handoverctbh
intracell_resource_lacks INTEGER#Intra-cell handover failures caused by a lack of cell resources (i.e. no suitable channels available)ctbh
intracell_returnscell_handover_results_intra_raw.intracell_returnsINTEGER#Intra-cell handover failures where the MS returned to the old channelctbh
intracell_seizure_failures INTEGER#Intra-cell handover failures caused by the MS failing to seize the new channelctbh
intracell_successescell_handover_results_intra_raw.intracell_successesINTEGER#Successful attempts to handoff to a new channel in the same cell i.e an intra-cell handoverctbh
outgoing_interbsc_attemptscell_handover_results_inter_raw.outgoing_interbsc_attemptsINTEGER#Total attempts to handoff to another cell controlled by a different BSC i.e an MSC controlled (?external?) inter-BSC handoverctbh
outgoing_interbsc_bss_failures INTEGER#Outgoing inter-BSC handover failures caused by a problem in the BSS equipment (not attributable to the MS)ctbh
outgoing_interbsc_failurescell_handover_results_inter_raw.outgoing_interbsc_failuresINTEGER#Unsuccessful attempts for handover to another cell outgoing from this cell and controlled by the MSC i.e. a MSC controlled inter-cell handoverctbh
outgoing_interbsc_returnscell_handover_results_inter_raw.outgoing_interbsc_returnsINTEGER#Outgoing inter-BSC handover failures where the MS returned to the old channelctbh
outgoing_interbsc_successescell_handover_results_inter_raw.outgoing_interbsc_successesINTEGER#Successful attempts for handover to another cell outgoing from this cell and controlled by the MSC i.e. a MSC controlled inter-cell handoverctbh
outgoing_intrabsc_attemptscell_handover_results_intra_raw.outgoing_intrabsc_attemptsINTEGER#Total attempts to handoff to another cell controlled by the same BSC i.e a BSC controlled (?internal?) inter-cell handoverctbh
outgoing_intrabsc_bss_failures INTEGER#Outgoing inter-cell handover failures caused by a problem in the BSS equipment (not attributable to the MS)ctbh
outgoing_intrabsc_failurescell_handover_results_intra_raw.outgoing_intrabsc_failuresINTEGER#Unsuccessful attempts for handover to another cell outgoing from this cell and controlled by the BSC i.e. a BSC controlled inter-cell handoverctbh
outgoing_intrabsc_returnscell_handover_results_intra_raw.outgoing_intrabsc_returnsINTEGER#Outgoing inter-cell handover failures where the MS returned to the old channelctbh
outgoing_intrabsc_successescell_handover_results_intra_raw.outgoing_intrabsc_successesINTEGER#Successful attempts for handover to another cell outgoing from this cell and controlled by the BSC i.e. a BSC controlled inter-cell handoverctbh


Cell.Neutral.GSM.interference

The results of interference measurements on idle channels

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({idleband1_channels})FLOAT%  
idleband1_channelscell_interference_idle_raw.idleband1_channelsFLOAT#Mean number of channels whose measurements were in interference band 1 (lowest interference)ctbh
idleband2_channelscell_interference_idle_raw.idleband2_channelsFLOAT#Mean number of channels whose measurements were in interference band 2ctbh
idleband3_channelscell_interference_idle_raw.idleband3_channelsFLOAT#Mean number of channels whose measurements were in interference band 3ctbh
idleband4_channelscell_interference_idle_raw.idleband4_channelsFLOAT#Mean number of channels whose measurements were in interference band 4ctbh
idleband5_channelscell_interference_idle_raw.idleband5_channelsFLOAT#Mean number of channels whose measurements were in interference band 5 (highest interference)ctbh


Cell.Neutral.GSM.neighbour.handover.result

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coverage FLOAT%Data coverage 
%_data_coveragegetvalidity({attempts})FLOAT%  
%_failurepercentfail({Cell.Neutral.GSM.neighbour.handover.result.failures}, {Cell.Neutral.GSM.neighbour.handover.result.attempts})FLOAT%Percentage of handover attempts that failedctbh
%_successpercentok({Cell.Neutral.GSM.neighbour.handover.result.successes}, {Cell.Neutral.GSM.neighbour.handover.result.attempts})FLOAT%Percentage of handover attempts that succeededctbh
attemptscell_neighbour_results_raw.attemptsINTEGER#All the handovers that were attempted from the Source cell to the Target cell within the measurement periodctbh
failurescell_neighbour_results_raw.failuresINTEGER#Handovers that failedctbh
successescell_neighbour_results_raw.successesINTEGER#Handovers that succeededctbh


Cell.Neutral.GSM.page

The paging activity on the PCH channel

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({pch_discards})FLOAT%  
%_pch_failurepercentfail({Cell.Neutral.GSM.page.pch_failures} + {Cell.Neutral.GSM.page.pch_discards}, {Cell.Neutral.GSM.page.pch_attempts} + {Cell.Neutral.GSM.page.pch_discards})FLOAT%Percentage of Paging attempts that failed for any reasonctbh
%_pch_successpercentok({Cell.Neutral.GSM.page.pch_successes}, {Cell.Neutral.GSM.page.pch_attempts} + {Cell.Neutral.GSM.page.pch_discards})FLOAT%Percentage of Paging attempts that succeededctbh
pch_attempts INTEGER#Attempted transmission of Paging messagesctbh
pch_discardscell_resource_access_raw.pch_discardsINTEGER#Pages that were discarded from the PCH queuectbh
pch_failures INTEGER#Unsuccessful transmission of Paging messagesctbh
pch_successes INTEGER#Successful transmission of Paging messagesctbh


Cell.Neutral.GSM.sdcch

The performance and utilisation of a Cells Standalone Dedicated Control Channels (SDCCH)

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_availabilitypercentok({Cell.Neutral.GSM.sdcch.available_ch}, {Cell.Neutral.GSM.sdcch.defined_ch})FLOAT%% of available in-service SDCCH compared to the number of defined SDCCHctbh
%_blockingpercentfail({Cell.Neutral.GSM.sdcch.blocks}, {Cell.Neutral.GSM.sdcch.seizure_attempts})FLOAT%% of seizure attempts that are blocked. This KPI is used as a measure of congestionctbh
%_data_coverage FLOAT%Data coverage 
%_data_coveragegetvalidity({available_ch})FLOAT%  
%_dropped_callspercentfail({Cell.Neutral.GSM.sdcch.total_dropped_calls}, {Cell.Neutral.GSM.sdcch.seizure_successes})FLOAT%% of channel dropped after a successful seizure (including RF losses, including channels lost due to seizure failure on handover)ctbh
%_other_dropped_callspercentfail({Cell.Neutral.GSM.sdcch.other_dropped_calls}, {Cell.Neutral.GSM.sdcch.seizure_successes})FLOAT%% of attempts to seize a channel that succeeded but then dropped for non-RF reasonsctbh
%_rf_losspercentfail({Cell.Neutral.GSM.sdcch.rf_losses}, {Cell.Neutral.GSM.sdcch.seizure_successes})FLOAT%% of attempts to seize a channel that succeeded but then failed due to RF lossctbh
%_seizure_failurepercentfail({Cell.Neutral.GSM.sdcch.seizure_failures}, {Cell.Neutral.GSM.sdcch.seizure_attempts})FLOAT%% of attempts to seize a channel that failedctbh
%_seizure_successpercentok({Cell.Neutral.GSM.sdcch.seizure_successes}, {Cell.Neutral.GSM.sdcch.seizure_attempts})FLOAT%% of attempts to seize a channel that succeededctbh
assign_delay FLOATSecondAverage delay before assigning an SDCCH (only applicable to queueing cells)ctbh
available_chcell_control_traffic_raw.available_chINTEGER#The average number of available in-service SDCCH on the cell over the measurement periodctbh
blockscell_control_traffic_raw.blocksINTEGER#Attempts to assign a control channel that are blocked i.e. all channels are busy. The call may then either fail, overflow or in the case of handover attempts revert to the old channelctbh
congestion_timecell_control_traffic_raw.congestion_timeINTEGERSecondTotal time (during the measurement period) that all SDCCHs on the Cell were busy (i.e. not available for seizure)ctbh
defined_chcell_control_traffic_raw.defined_chINTEGER#The number of SDCCH equipped on the cell which would be available for use if the cell was fully availablectbh
max_busy_ch INTEGER#The maximum number of busy channels during the measurement periodctbh
mean_holding_timecell_control_traffic_raw.mean_holding_timeFLOATSecondAverage mean holding time of the channel in secondsctbh
other_dropped_callscell_control_traffic_raw.other_dropped_callsINTEGER#Failures that cause a channel to be dropped after a successful seizure (but not including RF losses, but including channels lost due to seizure failure on handover)ctbh
peak_utilisationpercentok({Cell.Neutral.GSM.sdcch.max_busy_ch}, {Cell.Neutral.GSM.sdcch.available_ch})FLOAT%Peak utilisation (maximum channels busy during the period as a percentage of defined channels)ctbh
rf_lossescell_control_traffic_raw.rf_lossesINTEGER#Channel drops while using a control channel either uplink or downlink. due to loss of RF signalctbh
seizure_attemptscell_control_traffic_raw.seizure_attemptsINTEGER#Attempts to assign a stand-alone dedicated control channel for any reason (either for a CHANNEL REQUEST for a SDCCH channel or a handover)ctbh
seizure_failurescell_control_traffic_raw.seizure_failuresINTEGER#Failed attempts to seize a channel by a MSctbh
seizure_successescell_control_traffic_raw.seizure_successesINTEGER#Successful seizures of a channel by a MSctbh
total_dropped_callscell_control_traffic_raw.total_dropped_callsINTEGER#Total dropped calls on SDCCHctbh
trafficcell_control_traffic_raw.trafficFLOATErlangTraffic carried on the cells SDCCHs, measured in Erlangs i.e. occupancyctbh
unavailable_ch{Cell.Neutral.GSM.sdcch.defined_ch} - {Cell.Neutral.GSM.sdcch.available_ch}INTEGER#The average number of unavailable SDCCH on the cell over the measurement periodctbh
utilisationpercentok({Cell.Neutral.GSM.sdcch.traffic}, {Cell.Neutral.GSM.sdcch.available_ch})FLOAT%Average utilisation over the period (traffic as a percentage of defined channels)ctbh


Cell.Neutral.GSM.tch.forecast

The forecast performance and utilisation of a Cell?s Traffic Channels (TCH)

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
capacitytp_gsm_cell_capacity_collect(nc_cell.cell_id, ml_subst(gStartdate), tp_gsm_cell_bh_traffic_end_date(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), ml_subst(gNumdays), "ml_subst(gGOS)", ml_property(system.property.dgos))FLOATErlangForecast capacity or critical traffic level 
extra_chtp_gsm_cell_bh_extra_ch_forecast_value(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), "ml_subst(gGOS)")INTEGER#Forecast smallest number of extra channels required in order to deliver the specified design grade of service for the forecast offered traffic 
linear_exhaustion_dateDECODE((tp_gsm_cell_bh_traffic_exhaustion_date(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage), "ml_subst(gGOS)", ml_property(system.property.dgos),NULL)), NULL, "will not reach exhaustion in this period","will reach exhausion on "||(tp_gsm_cell_bh_traffic_exhaustion_date(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage), "ml_subst(gGOS)", ml_property(system.property.dgos),NULL)))INTEGERUnixTimeForecast cell exhaustion date 
linear_regression_coefficienttp_gsm_cell_bh_traffic_forecast_growth(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Forecast linear regression coefficient 
linear_regression_errortp_gsm_cell_bh_traffic_regression_error(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Forecast linear regression error 
linear_traffic_growthtp_gsm_cell_bh_traffic_forecast_growth(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOATErlangForecast linear traffic growth 
required_chtp_gsm_cell_bh_required_ch_forecast_value(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), "ml_subst(gGOS)")INTEGER#Forecast smallest number of channels that can deliver the specified design grade of service for the forecast offered traffic 
traffictp_gsm_cell_bh_traffic_forecast_value(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), NULL)FLOATErlangForecast traffic carried on the cell?s Traffic Channels 
utilisationtp_gsm_cell_bh_utilisation_forecast_value(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), NULL)FLOAT%Forecast utilisation (traffic as a percentrage of defined channels) 


Cell.Neutral.GSM.tch

The performance and utilisation of a Cell?s Traffic Channels (TCH)

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_availabilitypercentok({Cell.Neutral.GSM.tch.available_ch}, {Cell.Neutral.GSM.tch.defined_ch})FLOAT%% of available in-service TCH compared to the number of defined TCHctbh
%_blockingpercentfail({Cell.Neutral.GSM.tch.blocks}, {Cell.Neutral.GSM.tch.seizure_attempts})FLOAT%% of seizure attempts that are blocked. This KPI is used as a measure of congestionctbh
%_data_coverage FLOAT%Data available 
%_data_coveragegetvalidity({available_ch})FLOAT%  
%_dropped_callspercentfail({Cell.Neutral.GSM.tch.total_dropped_calls}, {Cell.Neutral.GSM.tch.seizure_successes})FLOAT%% of channel dropped after a successful seizure (including RF losses, including channels lost due to seizure failure on handover)ctbh
%_other_dropped_callspercentfail({Cell.Neutral.GSM.tch.other_dropped_calls}, {Cell.Neutral.GSM.tch.seizure_successes})FLOAT%% of attempts to seize a channel that succeeded but then dropped for non-RF reasonsctbh
%_rf_losspercentfail({Cell.Neutral.GSM.tch.rf_losses}, {Cell.Neutral.GSM.tch.seizure_successes})FLOAT%% of attempts to seize a channel that succeeded but then failed due to RF lossctbh
%_seizure_failurepercentfail({Cell.Neutral.GSM.tch.seizure_failures}, {Cell.Neutral.GSM.tch.seizure_attempts})FLOAT%% of attempts to seize a channel that failedctbh
%_seizure_successpercentok({Cell.Neutral.GSM.tch.seizure_successes}, {Cell.Neutral.GSM.tch.seizure_attempts})FLOAT%% of attempts to seize a channel that succeededctbh
assign_delay INTEGERSecondAverage delay before assigning a TCH (only applicable to queueing cell)ctbh
available_chcell_voice_traffic_raw.available_chINTEGER#The average number of available in-service TCH on the cell over the measurement periodctbh
blockscell_voice_traffic_raw.blocksINTEGER#Attempts to assign a traffic channel that are blocked i.e. all channels are busy. The call may then either fail, overflow or in the case of handover attempts revert to the old channelctbh
call_seizure_attemptscell_voice_traffic_raw.call_seizure_attemptsINTEGER#Attempts to seize a Traffic Channel for an originating or terminating callctbh
call_seizure_failurescell_voice_traffic_raw.call_seizure_failuresINTEGER#Failed attempts to seize a Traffic Channel for an originating or terminating callctbh
call_seizure_successescell_voice_traffic_raw.call_seizure_successesINTEGER#Successful attempts to seize a Traffic Channel for an originating or terminating callctbh
capacitycriticaltraffic({Cell.Neutral.GSM.tch.defined_ch}, ml_property(system.property.dgos))FLOATErlangThe capacity or critical traffic level based upon a user supplied design grade of service levelctbh
congestion_timecell_voice_traffic_raw.congestion_timeINTEGERSecondTotal time (during the measurement period) that all Traffic Channels on the Cell were busy (i.e. not available for seizure)ctbh
defined_chcell_voice_traffic_raw.defined_chINTEGER#The number of TCH equipped on the cell which would be available for use if the cell was fully availablectbh
extra_capacity_requiredDECODE("ml_subst(gUserDefined)","true","true",(DECODE((tp_gsm_cell_bh_required_ch_end_value(nc_cell.cell_id, tp_gsm_cell_bh_traffic_end_date(nc_cell.cell_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage)), "ml_subst(gGOS)", ml_property(system.property.dgos))-tp_gsm_cell_bh_defined_ch_end_value(nc_cell.cell_id, tp_gsm_cell_bh_traffic_end_date(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), NULL, NULL)),0,"false","true")))FLOATErlangThe extra capacity required by a cell to carry the forecast traffic growth 
grade_of_servicegos({Cell.Neutral.GSM.tch.available_ch}, offeredtraffic({Cell.Neutral.GSM.tch.available_ch}, {Cell.Neutral.GSM.tch.traffic}))FLOAT%The estimated Grade of Service (GoS)ctbh
handover_seizure_attemptscell_voice_traffic_raw.handover_seizure_attemptsINTEGER#Attempts to seize a Traffic Channel in order to complete a Handoverctbh
handover_seizure_failurescell_voice_traffic_raw.handover_seizure_failuresINTEGER#Failed attempts to seize a Traffic Channel in order to complete a Handoverctbh
handover_seizure_successescell_voice_traffic_raw.handover_seizure_successesINTEGER#Successful attempts to seize a Traffic Channel in order to complete a Handoverctbh
is_exhaustedDECODE(tp_gsm_cell_bh_traffic_exhaustion_date(nc_cell.cell_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage), "ml_subst(gGOS)", ml_property(system.property.dgos),NULL),NULL,"YES","NO")INTEGERStatusBoolean indicator as to whether a cell is exhausted in forecasting 
lost_trafficofferedtraffic({Cell.Neutral.GSM.tch.available_ch}, {Cell.Neutral.GSM.tch.traffic}) - {Cell.Neutral.GSM.tch.traffic}FLOATErlangThe estimated traffic lost to the cellctbh
max_busy_ch INTEGER#The maximum number of busy channels during the measurement periodctbh
mean_holding_timecell_voice_traffic_raw.mean_holding_timeINTEGERSecondAverage mean holding time of the channel in secondsctbh
number_of_samplestp_gsm_cell_bh_traffic_num_samples(nc_cell.cell_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))INTEGER#Number of samples of data, required as a check for forecasting 
offered_trafficofferedtraffic({Cell.Neutral.GSM.tch.available_ch}, {Cell.Neutral.GSM.tch.traffic})FLOATErlangThe estimated traffic offered to the cellctbh
offered_utilisationpercentok(offeredtraffic({Cell.Neutral.GSM.tch.available_ch}, {Cell.Neutral.GSM.tch.traffic}) / {Cell.Neutral.GSM.tch.available_ch})FLOATErlangEstimated utilisation based on offered trafficctbh
other_dropped_callscell_voice_traffic_raw.other_dropped_callsINTEGER#Failures that cause a channel to be dropped after a successful seizure (not including RF losses, but including channels lost due to seizure failure on handover)ctbh
peak_utilisationpercentok({Cell.Neutral.GSM.tch.max_busy_ch}, {Cell.Neutral.GSM.tch.available_ch})FLOAT%Peak utilisation (maximum channels busy during the period as a percentage of defined channels)ctbh
required_chrequiredcircuits(offeredtraffic({Cell.Neutral.GSM.tch.available_ch}, {Cell.Neutral.GSM.tch.traffic}), ml_property(system.property.dgos))INTEGER#The smallest integer number of channels that can deliver the specified design grade of service for the offered trafficctbh
required_extra_ch{Cell.Neutral.GSM.tch.required_ch} - {Cell.Neutral.GSM.tch.defined_ch}INTEGER#The smallest integer number of extra channels required that can deliver the specified design grade of service for the offered trafficctbh
rf_lossescell_voice_traffic_raw.rf_lossesINTEGER#Calls dropped while using a traffic channel either uplink or downlink. due to loss of RF signalctbh
seizure_attemptscell_voice_traffic_raw.seizure_attemptsINTEGER#Attempts to assign a traffic Channel for any reason e.g. mobile origination, termination or handoverctbh
seizure_failurescell_voice_traffic_raw.seizure_failuresINTEGER#Failed attempts to seize a channel by a MSctbh
seizure_successescell_voice_traffic_raw.seizure_successesINTEGER#Successful seizures of a channel by a MSctbh
total_dropped_callscell_voice_traffic_raw.total_dropped_callsINTEGER#Total dropped callsctbh
trafficcell_voice_traffic_raw.trafficFLOATErlangTraffic carried on the cell?s Traffic Channels, measured in Erlangs i.e. occupancyctbh, dav3, dav5
unavailable_ch{Cell.Neutral.GSM.tch.defined_ch} - {Cell.Neutral.GSM.tch.available_ch}INTEGER#The average number of unavailable in-service TCH on the cell over the measurement periodctbh
utilisationpercentok({Cell.Neutral.GSM.tch.traffic}, {Cell.Neutral.GSM.tch.available_ch})FLOAT%Average utilisation over the period (traffic as a percentrage of defined channels)ctbh


LAPD Performance Indicators

LAPD.Neutral.GSM.link_if

The performance of a LAPD link between a BSC and a BS or BCF, as viewed from the BSC

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({bad_frames})FLOAT%  
bad_frameslapd_link_interface_raw.bad_framesINTEGER#Bad frames received at the BSCbbh
link_failureslapd_link_interface_raw.link_failuresINTEGER#Failures on the linkbbh
link_overloadslapd_link_interface_raw.link_overloadsINTEGER#Overloads on the linkbbh
protocol_errorslapd_link_interface_raw.protocol_errorsINTEGER#Protocol errors received at the BSCbbh
received_frameslapd_link_interface_raw.received_framesINTEGER#Data frames received at the BSC from the BS or BCFbbh
resent_frameslapd_link_interface_raw.resent_framesINTEGER#Retransmitted frames from the BSCbbh
transmitted_frameslapd_link_interface_raw.transmitted_framesINTEGER#Data frames sent from the BSC to the BS or BCFbbh


Processor Performance Indicators

Processor.Neutral.GSM.cpu

The performance (load or utilisation) of the CPU

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({load_pc})FLOAT%  
load_pcprocessor_cpu_raw.load_pcFLOAT%Percentage load of the CPU from all non-idle activities (i.e. call processing, etc.)pbh


Signalling_Link Performance Indicators

Signalling_Link.Neutral.GSM.link

The performance of an individual Signalling Link

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_availablepercentok({available_time}, ({available_time} + {unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the Link was availableslrbh, sltbh
%_data_coveragegetvalidity({available_time})FLOAT%  
%_local_inhibition_timepercentfail({local_inhibition_time}, ({available_time} + {unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the link was inhibited due to local management actionsslrbh, sltbh
%_remote_inhibition_timepercentfail({remote_inhibition_time}, ({available_time} + {unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the link was inhibited due to remote management actionsslrbh, sltbh
%_unavailablepercentfail({unavailable_time}, ({available_time} + {unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the Link was unavailableslrbh, sltbh
available_timess7_link_availability_raw.available_timeINTEGERSecondAmount of time the Link was available during the measurement periodslrbh, sltbh
changebacks INTEGER#Local automatic changebacksslrbh, sltbh
changeoversss7_link_performance_raw.changeoversINTEGER#Local automatic changeoversslrbh, sltbh
congestion_lossesss7_link_utilisation_raw.congestion_lossesINTEGER#Number of congestion events that resulted in lost MSUsslrbh, sltbh
congestion_timess7_link_utilisation_raw.congestion_timeINTEGERSecondAmount of time during which the Link was congestedslrbh, sltbh
congestionsss7_link_utilisation_raw.congestionsINTEGER#Number of Link congestion indicationsslrbh, sltbh
discarded_msusss7_link_utilisation_raw.discarded_msusINTEGER#Number of MSUs that were discarded because of Link congestionslrbh, sltbh
failures_abr INTEGER#Link failures due to receipt of an abnormal FIBR or BSNRslrbh, sltbh
failures_alignmentss7_link_performance_raw.failures_alignmentINTEGER#Link failures due to alignment or proving failureslrbh, sltbh
failures_congestion INTEGER#Link failures due to the link being congested for too longslrbh, sltbh
failures_delay INTEGER#Link failures due to excessive delay on ACKslrbh, sltbh
failures_error_rate INTEGER#Link failures due to an excessive error rateslrbh, sltbh
failures INTEGER#Link failures (any reason)slrbh, sltbh
in_service_timess7_link_performance_raw.in_service_timeINTEGERSecondThe total time the Link has been up (since last reset)slrbh, sltbh
incoming_trafficss7_link_utilisation_raw.incoming_trafficINT8#Incoming traffic receivedslrbh
incoming_utilisationpercentok((8 * {incoming_traffic}), {measurement_seconds} * (decode(nc_ss7_link.data_rate, null, 0, "NULL", 0, nc_ss7_link.data_rate)))FLOAT%Incoming traffic utilisation ? percentage of available incoming capacity usedslrbh
link_failure_timess7_link_availability_raw.link_failure_timeINTEGERSecondAmount of time the Link was unavailable because it had failedslrbh, sltbh
local_busy_timess7_link_availability_raw.local_busy_timeINTEGERSecondAmount of local busy timeslrbh, sltbh
local_inhibition_timess7_link_availability_raw.local_inhibition_timeINTEGERSecondAmount of time the link was inhibited due to local management actionsslrbh, sltbh
outgoing_traffic INT8#Outgoing traffic sentsltbh
outgoing_utilisationpercentok((8 * {outgoing_traffic}), {measurement_seconds} * (decode(nc_ss7_link.data_rate, null, 0, "NULL", 0, nc_ss7_link.data_rate)))FLOAT%Outgoing traffic utilisation ? percentage of available outgoing capacity usedsltbh
received_msusss7_link_utilisation_raw.received_msusINTEGER#Number of Message Signal Units (MSUs) receivedslrbh
received_neg_ackss7_link_performance_raw.received_neg_ackINTEGER#Number of negative acknowledgements (ACK) receivedslrbh
received_sif_siosss7_link_utilisation_raw.received_sif_siosINTEGER#Number of SIF and SIO octets receivedslrbh
received_su_errorsss7_link_performance_raw.received_su_errorsINTEGER#Number of Signalling Units (Sus) received with errorsslrbh
remote_inhibition_timess7_link_availability_raw.remote_inhibition_timeINTEGERSecondAmount of time the link was inhibited due to remote management actionsslrbh, sltbh
remote_outage_timess7_link_availability_raw.remote_outage_timeINTEGERSecondAmount of time the Link was unavailable because of a remote Processor outageslrbh, sltbh
remote_outages INTEGER#Number of remote Processor outagesslrbh, sltbh
restores INTEGER#Number of times the link was restoredslrbh, sltbh
retransmitted_sif_siosss7_link_utilisation_raw.retransmitted_sif_siosINTEGER#Number of SIF and SIO octets re-transmittedsltbh
transmitted_msusss7_link_utilisation_raw.transmitted_msusINTEGER#Number of Message Signal Units (MSUs) transmittedsltbh
transmitted_sif_siosss7_link_utilisation_raw.transmitted_sif_siosINTEGER#Number of SIF and SIO octets transmittedsltbh
unavailable_timess7_link_availability_raw.unavailable_timeINTEGERSecondAmount of time the Link was unavailable (for any reason)slrbh, sltbh


Signalling_LinkSet Performance Indicators

Signalling_LinkSet.Neutral.GSM.forecast

The forecast performance of a set of Signalling Links

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
capacitytp_gsm_linkset_capacity_collect(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), tp_gsm_linkset_bh_incoming_traffic_end_date(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), ml_subst(gNumdays), "ml_subst(gNMT)", ml_property(system.property.dnmt))FLOATErlangForecast maximum nominal Erlangs per linkset 
in_failure_capacitytp_gsm_linkset_in_failure_capacity_collect(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), tp_gsm_linkset_bh_incoming_traffic_end_date(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), ml_subst(gNumdays), "ml_subst(gNMT)", ml_property(system.property.dnmt))FLOATErlangForecast capacity for the entire linkset during design link failures 
linear_exhaustion_dateDECODE((tp_gsm_linkset_bh_incoming_traffic_exhaustion_date(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage), "ml_subst(gNMT)" ,ml_subst(gMIT),ml_subst(gLIF))), NULL, "will not reach exhaustion in this period","will reach exhausion on "||(tp_gsm_linkset_bh_incoming_traffic_exhaustion_date(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage), "ml_subst(gNMT)",ml_subst(gMIT),ml_subst(gLIF))))INTEGERUnixTimeForecast linear exhaustion date 
linear_regression_coefficienttp_gsm_linkset_bh_incoming_traffic_forecast_growth(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Forecast linear regression coefficient 
linear_regression_errortp_gsm_linkset_bh_incoming_traffic_regression_error(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Forecast linear regression error 
linear_traffic_growthtp_gsm_linkset_bh_incoming_traffic_forecast_growth(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Froecast linear traffic growth 
traffictp_gsm_linkset_bh_incoming_traffic_forecast_value(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), NULL)FLOAT#Forecast traffic value 


Signalling_LinkSet.Neutral.GSM.signalling_linkset

The performance of a set of Signalling Links

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_availablepercentok({Signalling_LinkSet.Neutral.GSM.signalling_linkset.available_time}, ({Signalling_LinkSet.Neutral.GSM.signalling_linkset.available_time} + {Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the LinkSet was availableslsrbh, slstbh
%_data_coverage FLOAT%Data Coverage 
%_data_coveragegetvalidity({available_time})FLOAT%  
%_unavailablepercentfail({Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time}, ({Signalling_LinkSet.Neutral.GSM.signalling_linkset.available_time} + {Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the LinkSet was unavailableslsrbh, slstbh
available_timess7_linkset_raw.available_timeINTEGERSecondTime for which the LinkSet was availableslsrbh, slstbh
capacitycriticaltraffic({Signalling_LinkSet.Neutral.GSM.signalling_linkset.links}, ml_property(system.property.dnmt))FLOATErlangMaximum nominal Erlangs per linksetslsrbh, slstbh
failuresss7_linkset_raw.failuresINTEGER#Number of LinkSet failuresslsrbh, slstbh
in_failure_capacitycriticaltraffic(ss7_linkset_week.count_links, "ml_subst(gMIT)")FLOATErlangCapacity for the entire linkset during design link failures 
incoming_trafficgroup({Signalling_Link.Neutral.GSM.link.incoming_traffic})INTEGER#Total Incoming traffic receivedslsrbh
incoming_utilisationpercentok((8 * {Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_traffic}), {Signalling_LinkSet.Neutral.GSM.signalling_linkset.measurement_seconds} * avg(decode(nc_ss7_linkset.data_rate, null, 0, "NULL", 0, nc_ss7_linkset.data_rate)))FLOAT%Incoming traffic utilisation ? percentage of available incoming capacity usedslsrbh
is_exhaustedDECODE(tp_gsm_linkset_bh_incoming_traffic_exhaustion_date(nc_ss7_linkset.ss7_linkset_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage), "ml_subst(gNMT)",ml_subst(gMIT),ml_subst(gLIF)),NULL,"YES","NO")INTEGERStatusForecast flag indicating if linkset capacity is exhausted 
linkscount({Signalling_Link.Neutral.GSM.link.ss7_link_id})INTEGER#Number of Links in the LinkSetslsrbh, slstbh
mean_%_availablepercentok({Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_available_time}, ({Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_available_time} + {Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_time}))FLOAT%Average percentage Availability of the Links in the LinkSetslsrbh, slstbh
mean_%_unavailablepercentfail({Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_time}, ({Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_available_time} + {Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_time}))FLOAT%Average percentage Unavailability of the Links in the LinkSetslsrbh, slstbh
mean_available_timegroup({Signalling_LinkSet.Neutral.GSM.signalling_linkset.available_time})FLOATSecondAverage Link available time for all the Links in the Linksetslsrbh, slstbh
mean_incoming_traffic{incoming_traffic}/count(*)FLOAT#Average Incoming traffic received per linkslsrbh
mean_outgoing_traffic{outgoing_traffic}/count(*)FLOAT#Average Outgoing traffic sent per linkslstbh
mean_unavailable_timegroup({Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time})FLOATSecondAverage Link available time for all the Links in the Linksetslsrbh, slstbh
msustp_gsm_linkset_bh_received_msus_end_value(nc_ss7_linkset.ss7_linkset_id, tp_gsm_linkset_bh_incoming_traffic_end_date(nc_ss7_linkset.ss7_linkset_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage)), "ml_subst(gNMT)", ml_property(system.property.dnmt))INTEGER#Forecast number of Message Signal Units (MSUs) 
number_of_samplestp_gsm_linkset_bh_incoming_traffic_num_samples(nc_ss7_linkset.ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))INTEGER#Forecast number of samples 
outgoing_trafficgroup({Signalling_Link.Neutral.GSM.link.outgoing_traffic})INTEGER#Total Outgoing traffic sentslstbh
outgoing_utilisationpercentok((8 * {Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffic}), {Signalling_LinkSet.Neutral.GSM.signalling_linkset.measurement_seconds} * avg(decode(nc_ss7_linkset.data_rate, null, 0, "NULL", 0, nc_ss7_linkset.data_rate)))FLOAT%Outgoing traffic utilisation ? percentage of available outgoing capacity usedslstbh
received_msus INTEGER#Number of Message Signal Units (MSUs) receivedslsrbh
received_sif_sios INTEGER#Number of SIF and SIO octets receivedslsrbh
total_failuresgroup({Signalling_Link.Neutral.GSM.link.failures})INTEGER#Total Failures of all Links in the LinkSetslsrbh, slstbh
traffic INTEGER#Forecast total trafficslsrbh, slstbh
transmitted_msus INTEGER#Number of Message Signal Units (MSUs) transmittedslstbh
transmitted_sif_sios INTEGER#Number of SIF and SIO octets transmittedslstbh
unavailable_timess7_linkset_raw.unavailable_timeINTEGERSecondTime for which the LinkSet was unavailableslsrbh, slstbh


Signalling_Point Performance Indicators

Signalling_Point.Neutral.GSM.signalling_point

The signalling networks performance, as seen from a Signalling Point

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({adjacent_sp_inaccessible})FLOAT%  
adjacent_sp_inaccessible_timess7_point_raw.adjacent_sp_inaccessible_timeINTEGERSecondTime for which an adjacent Signalling Point was inaccessible 
adjacent_sp_inaccessibless7_point_raw.adjacent_sp_inaccessibleINTEGER#Number of times an adjacent Signalling Point became inaccessible 
discarded_msus INTEGER#Number of Message Signal Units (MSUs) discarded due to routing errors 
received_tfcsss7_point_raw.received_tfcsINTEGER#Number of Transfer-Control (TFC) signals received, indicating RouteSet congestion 


Signalling_RouteSet Performance Indicators

Signalling_RouteSet.Neutral.GSM.routeset

The performance of a set of Signalling Routes

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_available FLOAT%Percentage of time (during the measurement period) that the RouteSet was available 
%_data_coveragegetvalidity({available_time})FLOAT%  
%_unavailable FLOAT%Percentage of time (during the measurement period) that the RouteSet was unavailable 
available_timess7_routeset_raw.available_timeINTEGERSecondTime for which the RouteSet was available 
failuresss7_routeset_raw.failuresINTEGER#Number of RouteSet failures 
unavailable_timess7_routeset_raw.unavailable_timeINTEGERSecondTime for which the RouteSet was unavailable 



8. Database Schema


8.1 Hierarchy Tables

This section lists the hierarchy ("NC") tables that are included in this technology pack's database schema.

nc_bsc

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
bsc_idVARCHAR(50) [CELLTCH] NODEID
msc_idVARCHAR(50) [CELLTCH] "Populated by the customer"
sgsn_idVARCHAR(50) [CELLTCH] "Populated by the customer"
region_idVARCHAR(50) [CELLTCH] REGION_ID
network_idVARCHAR(50) [CELLTCH] NETWORK_ID
timestampINTEGER 
endstampINTEGER 
bsc_nameVARCHAR(255) [CELLTCH] NODEID
bsc_versionVARCHAR(50) [CELLTCH] "R1206B"
vendor_idVARCHAR(50) [CELLTCH] "Ericsson"
technologyVARCHAR(50) [CELLTCH] "GSM"


nc_bs

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
bs_idVARCHAR(50) [CELLTCH] NODEID&"-"&substr(OBJ_ID,6,0)
bsc_idVARCHAR(50) [CELLTCH] NODEID
msc_idVARCHAR(50) [CELLTCH] lookup("nc_bsc","msc_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
sgsn_idVARCHAR(50) [CELLTCH] lookup("nc_bsc","sgsn_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
region_idVARCHAR(50) [CELLTCH] lookup("nc_bsc","region_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
network_idVARCHAR(50) [CELLTCH] lookup("nc_bsc", "network_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
timestampINTEGER 
endstampINTEGER 
site_nameVARCHAR(255) [CELLTCH] NODEID&"-"&substr(OBJ_ID,6,0)
site_versionVARCHAR(50) [CELLTCH] "R1206B"
vendorVARCHAR(50) [CELLTCH] "Ericsson"
technologyVARCHAR(50) [CELLTCH] "GSM"


nc_cell

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
cell_idVARCHAR(50) [CELLTCH] OBJ_ID
bs_idVARCHAR(50) [CELLTCH] NODEID&"-"&substr(OBJ_ID,6,0)
bsc_idVARCHAR(50) [CELLTCH] NODEID
pcu_idVARCHAR(50) [CELLTCH] NODEID
nsvc_idVARCHAR(50) [CELLTCH] "Populated by the customer"
lac_idVARCHAR(50) [CELLTCH] "Populated by the customer"
routing_area_idVARCHAR(50) [CELLTCH] "Populated by the customer"
msc_idVARCHAR(50) [CELLTCH] lookup("nc_bsc","msc_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
sgsn_idVARCHAR(50) [CELLTCH] "Populated by the customer"
region_idVARCHAR(50) [CELLTCH] lookup("nc_bsc","region_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
network_idVARCHAR(50) [CELLTCH] lookup("nc_bsc", "network_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
timestampINTEGER 
endstampINTEGER 
cell_nameVARCHAR(255) [CELLTCH] OBJ_ID
cell_typeVARCHAR(50) [CELLTCH] "Sectored"
cell_descriptionVARCHAR(255) [CELLTCH] "Populated by the customer"
registration_area_idVARCHAR(50) [CELLTCH] "Populated by the customer"
max_powerVARCHAR(50) 
defined_trxVARCHAR(50) [CELLTCH] truncate(((TNUCHCNT+TNUCHSUB) + CNUCHCNT/8),0)
defined_tchVARCHAR(50) [CELLTCH] TNUCHCNT
defined_cchVARCHAR(50) [CELLTCH] CNUCHCNT
segment_idVARCHAR(50) [CELLTCH] "Populated by the customer"
cell_versionVARCHAR(50) [CELLTCH] "R1206B"
vendorVARCHAR(50) [CELLTCH] "Ericsson"
technologyVARCHAR(50) [CELLTCH] "GSM"


nc_lapd

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
lapd_idVARCHAR(50) [LAPD] NODEID&"-"&OBJ_ID
bs_idVARCHAR(50) [LAPD] NODEID&"-"&substr(OBJ_ID,6,0)
bsc_idVARCHAR(50) [LAPD] NODEID
msc_idVARCHAR(50) [LAPD] lookup("nc_bsc","msc_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
sgsn_idVARCHAR(50) [LAPD] lookup("nc_bsc","sgsn_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
region_idVARCHAR(50) [LAPD] lookup("nc_bsc","region_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
network_idVARCHAR(50) [LAPD] lookup("nc_bsc", "network_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
timestampINTEGER 
endstampINTEGER 
lapd_nameVARCHAR(255) [LAPD] NODEID&"-"&OBJ_ID
lapd_versionVARCHAR(50) [LAPD] "Populated by the customer"
vendorVARCHAR(50) [LAPD] "Ericsson"
technologyVARCHAR(50) [LAPD] "GSM"


nc_neighbour

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
neighbour_idVARCHAR(50) [CELLHO] CELLID
source_cell_idVARCHAR(50) [CELLHO] OBJ_ID_1
target_cell_idVARCHAR(50) [CELLHO] OBJ_ID_2
timestampINTEGER 
endstampINTEGER 
neighbour_nameVARCHAR(255) [CELLHO] CELLID
source_cell_typeVARCHAR(50) [CELLHO] lookup("nc_cell","cell_type",utime(START_DATE & START_TIME,"%d %b %y %R"), OBJ_ID_1)
target_cell_typeVARCHAR(50) [CELLHO] lookup("nc_cell","cell_type",utime(START_DATE & START_TIME,"%d %b %y %R"), OBJ_ID_2)
source_cell_versionVARCHAR(50) [CELLHO] lookup("nc_cell","cell_version",utime(START_DATE & START_TIME,"%d %b %y %R"), OBJ_ID_1)
target_cell_versionVARCHAR(50) [CELLHO] lookup("nc_cell","cell_version",utime(START_DATE & START_TIME,"%d %b %y %R"), OBJ_ID_2)
source_cell_vendorVARCHAR(50) [CELLHO] "Ericsson"
target_cell_vendorVARCHAR(50) [CELLHO] lookup("nc_cell","vendor",utime(START_DATE & START_TIME,"%d %b %y %R"), OBJ_ID_2)
source_cell_technologyVARCHAR(50) [CELLHO] "GSM"
target_cell_technologyVARCHAR(50) [CELLHO] lookup("nc_cell","technology",utime(START_DATE & START_TIME,"%d %b %y %R"), OBJ_ID_2)
target_cell_positionVARCHAR(50) 


nc_pcu

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
pcu_idVARCHAR(50) [CELLTCH] NODEID
nsvc_idVARCHAR(50) [CELLTCH] "Populated by the customer"
sgsn_idVARCHAR(50) [CELLTCH] lookup("nc_bsc","sgsn_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
region_idVARCHAR(50) [CELLTCH] lookup("nc_bsc","region_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
network_idVARCHAR(50) [CELLTCH] lookup("nc_bsc", "network_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
timestampINTEGER 
endstampINTEGER 
vendorVARCHAR(50) [CELLTCH] "Ericsson"
pcu_nameVARCHAR(255) [CELLTCH] NODEID
pcu_versionVARCHAR(50) [CELLTCH] "R1206B"
technologyVARCHAR(50) [CELLTCH] "GSM"


nc_processor

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
processor_idVARCHAR(50) [LOAS] NODEID
node_idVARCHAR(50) [LOAS] NODEID
region_idVARCHAR(50) [LOAS] lookup("nc_bsc","region_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
network_idVARCHAR(50) [LOAS] lookup("nc_bsc", "network_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
timestampINTEGER 
endstampINTEGER 
node_nameVARCHAR(255) [LOAS] lookup("nc_bsc","bsc_name",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
node_typeVARCHAR(50) [LOAS] "BSC"
processor_nameVARCHAR(255) [LOAS] NODEID
processor_typeVARCHAR(50) [LOAS] "BSC"
technologyVARCHAR(50) [LOAS] "GSM"
vendorVARCHAR(50) [LOAS] "Ericsson"
processor_versionVARCHAR(50) [LOAS] "Populated by the customer"


nc_ss7_link

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
ss7_link_idVARCHAR(50) [C7SL] NODEID&"-"&OBJ_ID
ss7_linkset_idVARCHAR(50) [C7SL] NODEID&"-"&leftstr(OBJ_ID,len(OBJ_ID)-2)
ss7_point_idVARCHAR(50) [C7SL] NODEID&"-"& leftstr(OBJ_ID,strstr(OBJ_ID,"-")-1)
node_idVARCHAR(50) [C7SL] NODEID
region_idVARCHAR(50) [C7SL] lookup("nc_bsc", "region_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
network_idVARCHAR(50) [C7SL] lookup("nc_bsc", "network_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
timestampINTEGER 
endstampINTEGER 
node_nameVARCHAR(255) [C7SL] NODEID&"-"&OBJ_ID
node_typeVARCHAR(50) [C7SL] "BSC"
adjacent_node_idVARCHAR(50) 
data_rateVARCHAR(50) [C7SL] "Populated by the customer"
ss7_link_nameVARCHAR(255) [C7SL] NODEID&"-"&OBJ_ID
technologyVARCHAR(50) [C7SL] "GSM"


nc_ss7_linkset

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
ss7_linkset_idVARCHAR(50) [C7SLSET] NODEID&"-"&OBJ_ID
ss7_point_idVARCHAR(50) [C7SLSET] NODEID&"-"& leftstr(OBJ_ID,strstr(OBJ_ID,"-")-1)
node_idVARCHAR(50) [C7SLSET] NODEID
region_idVARCHAR(50) [C7SLSET] lookup("nc_bsc", "region_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
network_idVARCHAR(50) [C7SLSET] lookup("nc_bsc", "network_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
timestampINTEGER 
endstampINTEGER 
node_nameVARCHAR(255) [C7SLSET] NODEID
node_typeVARCHAR(50) [C7SLSET] "BSC"
adjacent_node_idVARCHAR(50) 
data_rateVARCHAR(50) [C7SLSET] "Populated by the customer"
designed_link_failuresVARCHAR(50) [C7SLSET] "Populated by the customer"
ss7_linkset_nameVARCHAR(255) [C7SLSET] NODEID&"-"&OBJ_ID
technologyVARCHAR(50) [C7SLSET] "GSM"


nc_ss7_point

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
ss7_point_idVARCHAR(50) [C7ADJSLP] NODEID&"-"&OBJ_ID
node_idVARCHAR(50) [C7ADJSLP] NODEID
region_idVARCHAR(50) [C7ADJSLP] lookup("nc_bsc", "region_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
network_idVARCHAR(50) [C7ADJSLP] lookup("nc_bsc", "network_id", utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
timestampINTEGER 
endstampINTEGER 
node_nameVARCHAR(255) [C7ADJSLP] NODEID
node_typeVARCHAR(50) [C7ADJSLP] "BSC"
ss7_point_nameVARCHAR(255) [C7ADJSLP] NODEID&"-"&OBJ_ID
adjacent_node_idVARCHAR(50) 
technologyVARCHAR(50) [C7ADJSLP] "GSM"


nc_ss7_routeset

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
ss7_routeset_idVARCHAR(50) [C7RTSET] NODEID&"-"&OBJ_ID
ss7_point_idVARCHAR(50) 
node_idVARCHAR(50) [C7RTSET] NODEID
region_idVARCHAR(50) [C7RTSET] lookup("nc_bsc","region_id",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
network_idVARCHAR(50) [C7RTSET] lookup("nc_bsc","network_id",utime(START_DATE & START_TIME,"%d %b %y %R"), C7RTSET.NODEID)
timestampINTEGER 
endstampINTEGER 
node_nameVARCHAR(255) [C7RTSET] lookup("nc_bsc","bsc_name",utime(START_DATE & START_TIME,"%d %b %y %R"), NODEID)
node_typeVARCHAR(50) [C7RTSET] "BSC"
adjacent_node_idVARCHAR(50) 
ss7_routeset_nameVARCHAR(255) [C7RTSET] NODEID&"-"&OBJ_ID
technologyVARCHAR(50) [C7RTSET] "GSM"


nc_cell_gprs_ext

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
cell_idVARCHAR(50) [CELLGPRS] OBJ_ID
timestampINTEGER 
endstampINTEGER 
nsvc_cn_idVARCHAR(50) 
bvc_idVARCHAR(50) 
defined_pdchVARCHAR(50) [CELLGPRS] IF (ALLPDCHSCAN <= 0 ) THEN 0 ELSE (ALLPDCHACC / ALLPDCHSCAN)
dedicated_pdchVARCHAR(50) [CELLGPRS] PREEMPTPDCH


nc_cell_umts_ext

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
cell_idVARCHAR(50) 
gprs_cell_idVARCHAR(50) 
umts_cell_idVARCHAR(50) 
timestampINTEGER 
endstampINTEGER 
uarfcnulVARCHAR(50) 
uarfcndlVARCHAR(50) 
primscrmblcdVARCHAR(50) 
primcpichpwrVARCHAR(50) 
primschpwrVARCHAR(50) 
secschpwrVARCHAR(50) 
bchpowerVARCHAR(50) 


nc_bs_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
bs_idVARCHAR(50)n/a
bsc_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_bsc_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
bsc_idVARCHAR(50)n/a
msc_idVARCHAR(50)n/a
sgsn_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_cell_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
cell_idVARCHAR(50)n/a
bs_idVARCHAR(50)n/a
lac_idVARCHAR(50)n/a
routing_area_idVARCHAR(50)n/a
pcu_idVARCHAR(50)n/a
nsvc_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_lapd_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
lapd_idVARCHAR(50)n/a
bs_idVARCHAR(50)n/a
bsc_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_pcu_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
pcu_idVARCHAR(50)n/a
nsvc_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_processor_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
processor_idVARCHAR(50)n/a
node_idVARCHAR(50)n/a
region_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_ss7_link_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
ss7_link_idVARCHAR(50)n/a
ss7_linkset_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_ss7_linkset_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
ss7_linkset_idVARCHAR(50)n/a
ss7_point_idVARCHAR(50)n/a
node_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_ss7_point_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
ss7_point_idVARCHAR(50)n/a
node_idVARCHAR(50)n/a
region_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_ss7_routeset_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
ss7_routeset_idVARCHAR(50)n/a
ss7_point_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


8.2 Raw Performance Tables

This section lists the performance tables that are included in this technology pack's database schema, grouped by the network object to which they relate, as follows:


Raw Cell Tables

cell_control_traffic_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
cell_idVARCHAR(50) [CELLTCH] OBJ_ID
dayINTEGER 
assign_delayVARCOUNTER 
available_chVARCOUNTER [CELLTCH] if ( CAVASCAN > 0 ) then round((CAVAACC/CAVASCAN),0) else leftstr("x",0)
blocksVARCOUNTER [CELLTCH] CCONGS + CCONGSSUB
congestion_timeVARCOUNTER [CELLTCH] CTCONGS + CTCONSUB
defined_chVARCOUNTER [CELLTCH] CNUCHCNT
max_busy_chVARCOUNTER 
mean_holding_timeVARCOUNTER [CELLTCH] if ((CNSCAN > 0) and (CMSESTAB > 0)) then ((CTRALACC/CNSCAN) * (COLLECTION_INTERVAL_MINS*60)/CMSESTAB) else leftstr("x",0)
other_dropped_callsVARCOUNTER [CELLTCH] CNDROP-(CDISQA+CDISQASUB+CDISSS+CDISSSSUB+CDISTA)
rf_lossesVARCOUNTER [CELLTCH] CDISQA + CDISQASUB + CDISSS + CDISTA + CDISSSSUB
seizure_attemptsVARCOUNTER [CELLTCH] CCALLS
seizure_failuresVARCOUNTER [CELLTCH] CCALLS - CMSESTAB
seizure_successesVARCOUNTER [CELLTCH] CMSESTAB
total_dropped_callsVARCOUNTER [CELLTCH] CNDROP
trafficVARCOUNTER [CELLTCH] if ( CNSCAN > 0 ) then round(CTRALACC/CNSCAN,2) else leftstr("x",0)


cell_handover_causes_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
cell_idVARCHAR(50) [CELLHO] CELLID
[CELEVENTH] OBJ_ID
dayINTEGER 
directed_retryVARCOUNTER 
distanceVARCOUNTER [CELLHO] HOEXCTA_O + HOEXCTA_External_O
downlink_interferenceVARCOUNTER 
downlink_levelVARCOUNTER [CELLHO] HOTOKCL_O + HOTOKCL_External_O
downlink_qualityVARCOUNTER [CELLHO] HODWNQA_O + HODWNQA_External_O
msc_invokedVARCOUNTER 
omc_invokedVARCOUNTER [CELEVENTH] HOATTBL
otherVARCOUNTER 
power_budgetVARCOUNTER [CELLHO] HOTOLCL_O + HOTOLCL_External_O
total_handoversVARCOUNTER [CELLHO] HOVERCNT_O + HOVERCNT_External_O
traffic_reasonsVARCOUNTER [CELEVENTH] HOATTLS
umbrellaVARCOUNTER [CELLHO] HOAATOL
uplink_interferenceVARCOUNTER [CELLHO] HOINDQA
uplink_levelVARCOUNTER 
uplink_qualityVARCOUNTER [CELLHO] HOUPLQA_O + HOUPLQA_External_O


cell_handover_results_inter_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
cell_idVARCHAR(50) [CELLHO] CELLID
dayINTEGER 
incoming_interbsc_attemptsVARCOUNTER [CELLHO] HOVERCNT_External_I
incoming_interbsc_bss_failuresVARCOUNTER 
incoming_interbsc_failuresVARCOUNTER [CELLHO] HOVERCNT_External_I - HOVERSUC_External_I
incoming_interbsc_resource_lacksVARCOUNTER 
incoming_interbsc_seizure_failuresVARCOUNTER 
incoming_interbsc_successesVARCOUNTER [CELLHO] HOVERSUC_External_I
outgoing_interbsc_attemptsVARCOUNTER [CELLHO] HOVERCNT_External_O
outgoing_interbsc_bss_failuresVARCOUNTER 
outgoing_interbsc_failuresVARCOUNTER [CELLHO] HOVERCNT_External_O - HOVERSUC_External_O
outgoing_interbsc_returnsVARCOUNTER [CELLHO] HORTTOCH_External_O
outgoing_interbsc_successesVARCOUNTER [CELLHO] HOVERSUC_External_O


cell_handover_results_intra_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
cell_idVARCHAR(50) [CELLHO] CELLID
dayINTEGER 
incoming_intrabsc_attemptsVARCOUNTER [CELLHO] HOVERCNT_I
incoming_intrabsc_bss_failuresVARCOUNTER 
incoming_intrabsc_failuresVARCOUNTER [CELLHO] HOVERCNT_I - HOVERSUC_I
incoming_intrabsc_resource_lacksVARCOUNTER 
incoming_intrabsc_seizure_failuresVARCOUNTER 
incoming_intrabsc_successesVARCOUNTER [CELLHO] HOVERSUC_I
intracell_attemptsVARCOUNTER [CELLHO] HOINUQA + HOINDQA + HOINBQA + HOATFRHRAMR + HOATFRHRNAMR + HOATHRFRAMR + HOATHRFRNAMR + HOATTHRPACK
intracell_bss_failuresVARCOUNTER 
intracell_failuresVARCOUNTER [CELLHO] (HOINUQA + HOINDQA + HOINBQA + HOATFRHRAMR + HOATFRHRNAMR + HOATHRFRAMR + HOATHRFRNAMR + HOATTHRPACK) - HOINSUC
intracell_resource_lacksVARCOUNTER 
intracell_returnsVARCOUNTER [CELLHO] HOINBOCH
intracell_seizure_failuresVARCOUNTER 
intracell_successesVARCOUNTER [CELLHO] HOINSUC
outgoing_intrabsc_attemptsVARCOUNTER [CELLHO] HOVERCNT_O
outgoing_intrabsc_bss_failuresVARCOUNTER 
outgoing_intrabsc_failuresVARCOUNTER [CELLHO] HOVERCNT_O - HOVERSUC_O
outgoing_intrabsc_returnsVARCOUNTER [CELLHO] HORTTOCH_O
outgoing_intrabsc_successesVARCOUNTER [CELLHO] HOVERSUC_O


cell_interference_idle_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
cell_idVARCHAR(50) [IDLETCH] OBJ_ID
dayINTEGER 
idleband1_channelsVARCOUNTER [IDLETCH] if ((NOACCUF>0) and (NOACCOF>0) and (NOACCUH>0) and (NOACCOH>0)) then (ITFUSIB1/NOACCUF) + (ITFOSIB1/NOACCOF) + (ITHUSIB1/NOACCUH) + (ITHOSIB1/NOACCOH) else leftstr("x",0)
idleband2_channelsVARCOUNTER [IDLETCH] if ((NOACCUF>0) and (NOACCOF>0) and (NOACCUH>0) and (NOACCOH>0)) then (ITFUSIB2/NOACCUF) + (ITFOSIB2/NOACCOF) + (ITHUSIB2/NOACCUH) + (ITHOSIB2/NOACCOH) else leftstr("x",0)
idleband3_channelsVARCOUNTER [IDLETCH] if ((NOACCUF>0) and (NOACCOF>0) and (NOACCUH>0) and (NOACCOH>0)) then (ITFUSIB3/NOACCUF) + (ITFOSIB3/NOACCOF) + (ITHUSIB3/NOACCUH) + (ITHOSIB3/NOACCOH) else leftstr("x",0)
idleband4_channelsVARCOUNTER [IDLETCH] if ((NOACCUF>0) and (NOACCOF>0) and (NOACCUH>0) and (NOACCOH>0)) then (ITFUSIB4/NOACCUF) + (ITFOSIB4/NOACCOF) + (ITHUSIB4/NOACCUH) + (ITHOSIB4/NOACCOH) else leftstr("x",0)
idleband5_channelsVARCOUNTER [IDLETCH] if ((NOACCUF>0) and (NOACCOF>0) and (NOACCUH>0) and (NOACCOH>0)) then (ITFUSIB5/NOACCUF) + (ITFOSIB5/NOACCOF) + (ITHUSIB5/NOACCUH) + (ITHOSIB5/NOACCOH) else leftstr("x",0)


cell_neighbour_results_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
neighbour_idVARCHAR(50) [CELLHO] CELLID
dayINTEGER 
attemptsVARCOUNTER [CELLHO] HOVERCNT
failuresVARCOUNTER [CELLHO] HOVERCNT - HOVERSUC
successesVARCOUNTER [CELLHO] HOVERSUC


cell_resource_access_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
cell_idVARCHAR(50) [RANDOMACC] OBJ_ID
[CELLPAG] OBJ_ID
dayINTEGER 
immass_attemptsVARCOUNTER [RANDOMACC] CNROCNT+RAACCFA
[CELLPAG] leftstr("x",0)
immass_failuresVARCOUNTER [RANDOMACC] RAACCFA
[CELLPAG] leftstr("x",0)
immass_successesVARCOUNTER [RANDOMACC] CNROCNT
[CELLPAG] leftstr("x",0)
pch_attemptsVARCOUNTER 
pch_discardsVARCOUNTER [CELLPAG] PAGPCHCONG + PAGETOOOLD
[RANDOMACC] leftstr("x",0)
pch_failuresVARCOUNTER 
pch_successesVARCOUNTER 


cell_voice_traffic_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
cell_idVARCHAR(50) [CELLTCH] OBJ_ID
dayINTEGER 
trafficVARCOUNTER [CELLTCH] if ((TFNSCAN > 0) and (THNSCAN > 0)) then round((TFTRALACC/TFNSCAN) + (THTRALACC/THNSCAN),2) else leftstr("x",0)
seizure_attemptsVARCOUNTER [CELLTCH] TFCALLS + THCALLS
seizure_successesVARCOUNTER [CELLTCH] TFMSESTB + THMSESTBSUB
seizure_failuresVARCOUNTER [CELLTCH] (TFCALLS + THCALLS ) - (TFMSESTB + THMSESTB)
call_seizure_attemptsVARCOUNTER [CELLTCH] TASSALL
call_seizure_successesVARCOUNTER [CELLTCH] TFCASSALL+TFCASSALLSUB+THCASSALL+THCASSALLSUB
call_seizure_failuresVARCOUNTER [CELLTCH] TASSALL - (TFCASSALL+TFCASSALLSUB+THCASSALL+THCASSALLSUB)
handover_seizure_attemptsVARCOUNTER [CELLTCH] TFCALLS+THCALLS-TASSALL
handover_seizure_successesVARCOUNTER [CELLTCH] TFMSESTB + THMSESTB - (TFCASSALL + TFCASSALLSUB) - (THCASSALL + THCASSALLSUB)
handover_seizure_failuresVARCOUNTER [CELLTCH] (TFCALLS+THCALLS-TASSALL) - (TFMSESTB+THMSESTB-(TFCASSALL+TFCASSALLSUB)-(THCASSALL+THCASSALLSUB))
mean_holding_timeVARCOUNTER [CELLTCH] if ((TFNSCAN > 0) and (THNSCAN > 0) and ((TFMSESTB + THMSESTB)> 0)) then round((round(TFTRALACC/TFNSCAN,2) + round(THTRALACC/THNSCAN,2))*(COLLECTION_INTERVAL_MINS*60/(TFMSESTB+THMSESTB)),0) else 0
congestion_timeVARCOUNTER [CELLTCH] TFTCONGS + TFTCONSUB + THTCONGS + THTCONSUB
assign_delayVARCOUNTER 
blocksVARCOUNTER [CELLTCH] TFCONGSAS+TFCONGSASSUB+TFCONGSHO+TFCONGSHOSUB+THCONGSAS+THCONGSASSUB+THCONGSHO+ THCONGSHOSUB
rf_lossesVARCOUNTER [CELLTCH] TFDISTA + TFDISSUL + TFDISSULSUB + TFDISSDL + TFDISSDLSUB + TFDISSBL + TFDISSBLSUB + TFDISQAUL + TFDISQAULSUB + TFDISQADL + TFDISQADLSUB + TFDISQABL + TFDISQABLSUB + TFSUDLOS + TFSUDLOSSUB + TFDISFERDL + TFDISFERUL + TFDISFERBL + TFDISFERULSUB + TFDISFERDLSUB + TFDISFERBLSUB + THDISTA + THDISSUL + THDISSULSUB + THDISSDL + THDISSDLSUB + THDISSBL + THDISSBLSUB +THDISQAUL + THDISQABL +THDISQADL + THDISQAULSUB + THDISQABLSUB + THDISQADLSUB + THSUDLOS + THSUDLOSSUB + THDISFERDL + THDISFERUL + THDISFERBL + THDISFERULSUB + THDISFERDLSUB + THDISFERBLSUB
other_dropped_callsVARCOUNTER [CELLTCH] (TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB) - (TFDISTA + TFDISSUL + TFDISSULSUB + TFDISSDL + TFDISSDLSUB + TFDISSBL + TFDISSBLSUB + TFDISQAUL + TFDISQAULSUB + TFDISQADL + TFDISQADLSUB + TFDISQABL + TFDISQABLSUB + TFSUDLOS + TFSUDLOSSUB + TFDISFERDL + TFDISFERUL + TFDISFERBL + TFDISFERULSUB + TFDISFERDLSUB + TFDISFERBLSUB + THDISTA + THDISSUL + THDISSULSUB + THDISSDL + THDISSDLSUB + THDISSBL + THDISSBLSUB +THDISQAUL + THDISQABL +THDISQADL + THDISQAULSUB + THDISQABLSUB + THDISQADLSUB + THSUDLOS + THSUDLOSSUB + THDISFERDL + THDISFERUL + THDISFERBL + THDISFERULSUB + THDISFERDLSUB + THDISFERBLSUB )
total_dropped_callsVARCOUNTER [CELLTCH] TFNDROP + THNDROP + TFNDROPSUB + THNDROPSUB
max_busy_chVARCOUNTER 
defined_chVARCOUNTER [CELLTCH] TNUCHCNT
available_chVARCOUNTER [CELLTCH] if ( TAVASCAN > 0) then round(TAVAACC/TAVASCAN,0) else leftstr("x",0)


Raw LAPD Tables

lapd_link_interface_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
lapd_idVARCHAR(50) [LAPD] NODEID&"-"&OBJ_ID
dayINTEGER 
bad_framesVARCOUNTER [LAPD] CBADFRAME
link_failuresVARCOUNTER [LAPD] CLINKFAIL
link_overloadsVARCOUNTER [LAPD] COVERLOAD
protocol_errorsVARCOUNTER [LAPD] CPROCOLERR
received_framesVARCOUNTER [LAPD] CRECIFRAME
resent_framesVARCOUNTER [LAPD] CRETRANSM
transmitted_framesVARCOUNTER [LAPD] CTRIFRAME


Raw Processor Tables

processor_cpu_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
processor_idVARCHAR(50) [LOAS] NODEID
dayINTEGER 
load_pcVARCOUNTER [LOAS] if (NSCAN>0) then round(ACCLOAD/NSCAN,2) else leftstr("x",0)


Raw Signalling_Link Tables

ss7_link_availability_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_link_idVARCHAR(50) [C7SL] NODEID&"-"&OBJ_ID
dayINTEGER 
available_timeVARCOUNTER [C7SL] (COLLECTION_INTERVAL_MINS*60) - UNAVAILDUR
unavailable_timeVARCOUNTER [C7SL] UNAVAILDUR
local_inhibition_timeVARCOUNTER [C7SL] LOCINHDUR
remote_inhibition_timeVARCOUNTER [C7SL] REMINHDUR
link_failure_timeVARCOUNTER [C7SL] UNAVSLFDUR
remote_outage_timeVARCOUNTER [C7SL] UNAVRBLDUR
remote_outagesVARCOUNTER 
local_busy_timeVARCOUNTER [C7SL] round(LBUSDUR/10,0)


ss7_link_performance_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_link_idVARCHAR(50) [C7SL] NODEID&"-"&OBJ_ID
dayINTEGER 
in_service_timeVARCOUNTER [C7SL] ASLDUR
failuresVARCOUNTER 
failures_abrVARCOUNTER 
failures_delayVARCOUNTER 
failures_error_rateVARCOUNTER 
failures_congestionVARCOUNTER 
failures_alignmentVARCOUNTER [C7SL] NSLALPRFL
received_su_errorsVARCOUNTER [C7SL] NSUERR
received_neg_ackVARCOUNTER [C7SL] NNAREC
changeoversVARCOUNTER [C7SL] CHOVERS
changebacksVARCOUNTER 
restoresVARCOUNTER 


ss7_link_utilisation_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_link_idVARCHAR(50) [C7SL] NODEID&"-"&OBJ_ID
dayINTEGER 
transmitted_sif_siosVARCOUNTER [C7SL] NSIFTR
retransmitted_sif_siosVARCOUNTER [C7SL] NORTRO
received_sif_siosVARCOUNTER [C7SL] NSIFSRE
transmitted_msusVARCOUNTER [C7SL] NMSUTR
received_msusVARCOUNTER [C7SL] NMSURE
congestionsVARCOUNTER [C7SL] CONCNT1 + CONCNT2 + CONCNT3
congestion_timeVARCOUNTER [C7SL] CONDUR1 +CONDUR2 +CONDUR3
discarded_msusVARCOUNTER [C7SL] DISMSU1 +DISMSU2 +DISMSU3
congestion_lossesVARCOUNTER [C7SL] LOFMSU1 +LOFMSU2 +LOFMSU3
outgoing_trafficVARCOUNTER 
incoming_trafficVARCOUNTER [C7SL] IF HSLNMSURE != 0 then NSIFSRE + (6 * HSLNMSURE) else NSIFSRE + ( 6 * NMSURE)


Raw Signalling_LinkSet Tables

ss7_linkset_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_linkset_idVARCHAR(50) [C7SLSET] NODEID&"-"&OBJ_ID
[C7ADJSLP] NODEID&"-"&OBJ_ID
dayINTEGER 
available_timeVARCOUNTER [C7SLSET] (COLLECTION_INTERVAL_MINS*60) - STUNADURAT
[C7ADJSLP] leftstr("x",0)
unavailable_timeVARCOUNTER [C7SLSET] STUNADURAT
[C7ADJSLP] leftstr("x",0)
failuresVARCOUNTER [C7ADJSLP] ASPINA
[C7SLSET] leftstr("x",0)


Raw Signalling_Point Tables

ss7_point_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_point_idVARCHAR(50) [C7OPC] NODEID&"-"&OBJ_ID
[C7ADJSLP] NODEID&"-"&OBJ_ID
dayINTEGER 
adjacent_sp_inaccessibleVARCOUNTER [C7ADJSLP] ASPINA
adjacent_sp_inaccessible_timeVARCOUNTER [C7ADJSLP] ASPADUR
discarded_msusVARCOUNTER 
received_tfcsVARCOUNTER [C7OPC] round((ROPC / 8000),0)


Raw Signalling_RouteSet Tables

ss7_routeset_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_routeset_idVARCHAR(50) [C7RTSET] NODEID&"-"&OBJ_ID
dayINTEGER 
available_timeVARCOUNTER [C7RTSET] (COLLECTION_INTERVAL_MINS*60)-STINADURAT
unavailable_timeVARCOUNTER [C7RTSET] STINADURAT
failuresVARCOUNTER [C7RTSET] STINACNT


8.3 Views

This section lists the views that are included in this technology pack's database schema.

9. Performance Alarms

This section shows details of the performance alarms that are defined in this technology pack:

None.

10. Reports

This section shows details of the reports that are defined in this technology pack:

Best Cells TCH Utilisation Graph

This chart shows the top (1?10) cells with the highest TCH utilisation over the selected period

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Top-N TypeBest-N
Sorted ByCell.Neutral.GSM.tch.utilisation
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionbusy_hour, Average
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Highest Period Average Utilisation Cells (Bar Chart)
Busy-hour AverageCell.Neutral.GSM.tch.utilisationbusy_hour 
Period AverageCell.Neutral.GSM.tch.utilisationAverage 

BSC Cell TCH Graph

This shows an overview of 4 areas of Cell Traffic Channel performance, aggregated for all the Cells under a BSC

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.BSC
Primary ObjectBSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionBSC
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Availability (Line Chart)
AvailabilityBSC.Neutral.GSM.cells.%_tch_availabilityUser-defined 
Component 2: Blocking (Line Chart)
BlockingBSC.Neutral.GSM.cells.%_tch_blockingUser-defined 
Component 3: Dropped Calls (Line Chart)
Dropped CallsBSC.Neutral.GSM.cells.%_tch_dropped_callsUser-defined 
Component 4: Traffic (Line Chart)
TrafficBSC.Neutral.GSM.cells.tch_trafficUser-defined 

BSC Cell TCH Report

This report shows key cell TCH traffic statistics aggregated over a BSC in a selected time period. The report shows available & defined channels, traffic carried, number of seizures, % blocking and % dropped

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.BSC
Primary ObjectBSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionBSC, MSC, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
FilteringBSC.Neutral.GSM.cells.%_tch_blocking (min), BSC.Neutral.GSM.cells.%_tch_dropped_calls (min), BSC.Neutral.GSM.cells.tch_traffic (min), BSC.Neutral.GSM.cells.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: BSC Cell TCH Report (Table)
% TCH BlockingBSC.Neutral.GSM.cells.%_tch_blockingUser-defined 
% TCH Dropped CallsBSC.Neutral.GSM.cells.%_tch_dropped_callsUser-defined 
TCH TrafficBSC.Neutral.GSM.cells.tch_trafficUser-defined 
TCH AttemptsBSC.Neutral.GSM.cells.tch_attemptsUser-defined 
Not displayed (for filtering only)BSC.Neutral.GSM.cells.%_data_coverageUser-defined 
Defined TCHBSC.Neutral.GSM.cells.defined_tchUser-defined 
BSC Busy Hourbusy_hourbusy_hour 
BSCBSC.nameUser-defined 
Available TCHBSC.Neutral.GSM.cells.available_tchUser-defined 

Cell Availability Graph

These charts show the availability of a Cell?s TCHs and SDCCHs

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.Availability
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Average
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Availability (Line Chart)
SDCCHCell.Neutral.GSM.sdcch.%_availabilityUser-defined 
TCHCell.Neutral.GSM.tch.%_availabilityUser-defined 
Component 2: Cell Availability (Bar Chart)
Outages (100% if data is available, 0% if not)Cell.Neutral.GSM.tch.%_data_coverageUser-defined 
Component 3: SDCCH Channels (Line Chart)
AvailableCell.Neutral.GSM.sdcch.available_chUser-defined 
DefinedCell.Neutral.GSM.sdcch.defined_chUser-defined 
Component 4: TCH Channels (Line Chart)
AvailableCell.Neutral.GSM.tch.available_chUser-defined 
DefinedCell.Neutral.GSM.tch.defined_chUser-defined 

Cell Availability Report

This report shows the availability of TCH and SDCCH channels

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.Availability
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionbusy_hour, Average
FilteringCell.Neutral.GSM.sdcch.%_availability (max), Cell.Neutral.GSM.tch.%_availability (max), Cell.Neutral.GSM.tch.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell Availability Report (Table)
% Available Cell SDCCHCell.Neutral.GSM.sdcch.%_availabilityUser-defined 
% Available Cell TCHCell.Neutral.GSM.tch.%_availabilityUser-defined 
Not displayed (for filtering only)Cell.Neutral.GSM.tch.%_data_coverageUser-defined 
CellCell.nameUser-defined 
BSCBSC.nameUser-defined 
Average Defined Cell TCHCell.Neutral.GSM.tch.defined_chUser-defined 
Average Defined Cell SDCCHCell.Neutral.GSM.sdcch.defined_chUser-defined 
Average Available Cell TCHCell.Neutral.GSM.tch.available_chUser-defined 
Average Available Cell SDCCHCell.Neutral.GSM.sdcch.available_chUser-defined 

Cell Cell Handover Report

This report shows handover results between neighbour cells

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.Handovers
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, Neighbour
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
FilteringCell.Neutral.GSM.neighbour.handover.result.%_failure (min), Cell.Neutral.GSM.neighbour.handover.result.attempts (min), Cell.Neutral.GSM.neighbour.handover.result.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell-Cell Handover Report (Table)
% FailuresCell.Neutral.GSM.neighbour.handover.result.%_failureUser-defined 
AttemptsCell.Neutral.GSM.neighbour.handover.result.attemptsUser-defined 
Target Cell NameNeighbour.Target_Cell_IdUser-defined 
Source Cell NameNeighbour.Source_CellUser-defined 
Source BSC NameCell.BSCUser-defined 
Not displayed (for filtering only)Cell.Neutral.GSM.neighbour.handover.result.%_data_coverageUser-defined 

Cell Handover and Cause Report

This report consists of two tables, showing: - the causes of each cell?s handovers - the success of each cell?s handovers

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.Handovers
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
FilteringCell.Neutral.GSM.handover.cause.%_uplink_quality (min), Cell.Neutral.GSM.handover.cause.%_downlink_quality (min), Cell.Neutral.GSM.handover.cause.%_power_budget (min), Cell.Neutral.GSM.handover.cause.%_data_coverage (min), Cell.Neutral.GSM.handover.cause.%_uplink_level (min), Cell.Neutral.GSM.handover.cause.%_downlink_level (min), Cell.Neutral.GSM.handover.cause.%_uplink_interference (min), Cell.Neutral.GSM.handover.cause.%_downlink_interference (min), Cell.Neutral.GSM.handover.result.intracell_attempts (min), Cell.Neutral.GSM.handover.result.outgoing_intrabsc_attempts (min), Cell.Neutral.GSM.handover.result.incoming_intrabsc_attempts (min), Cell.Neutral.GSM.handover.result.outgoing_interbsc_attempts (min), Cell.Neutral.GSM.handover.result.incoming_interbsc_attempts (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell Handover Sub-Report (Table)
BSCBSC.nameUser-defined 
CellCell.nameUser-defined 
Umbrella %Cell.Neutral.GSM.handover.cause.%_umbrellaUser-defined 
Traffic Reasons %Cell.Neutral.GSM.handover.cause.%_traffic_reasonsUser-defined 
Total HOCell.Neutral.GSM.handover.cause.total_handoversUser-defined 
Quality % UplinkCell.Neutral.GSM.handover.cause.%_uplink_qualityUser-defined 
Quality % DownlinkCell.Neutral.GSM.handover.cause.%_downlink_qualityUser-defined 
Power %Cell.Neutral.GSM.handover.cause.%_power_budgetUser-defined 
Other %Cell.Neutral.GSM.handover.cause.%_otherUser-defined 
Not displayed (for filtering only)Cell.Neutral.GSM.handover.cause.%_data_coverageUser-defined 
Level % UplinkCell.Neutral.GSM.handover.cause.%_uplink_levelUser-defined 
Level % DownlinkCell.Neutral.GSM.handover.cause.%_downlink_levelUser-defined 
Invoked OMC %Cell.Neutral.GSM.handover.cause.%_omc_invokedUser-defined 
Invoked MSC %Cell.Neutral.GSM.handover.cause.%_msc_invokedUser-defined 
Interference % UplinkCell.Neutral.GSM.handover.cause.%_uplink_interferenceUser-defined 
Interference % DownlinkCell.Neutral.GSM.handover.cause.%_downlink_interferenceUser-defined 
Distance %Cell.Neutral.GSM.handover.cause.%_distanceUser-defined 
Directed Retry %Cell.Neutral.GSM.handover.cause.%_directed_retryUser-defined 
Component 2: Handover Cause Sub-Report (Table)
BSCBSC.nameUser-defined 
CellCell.nameUser-defined 
Intra-cell Failure %Cell.Neutral.GSM.handover.result.%_intracell_failureUser-defined 
Intra-cell AttemptsCell.Neutral.GSM.handover.result.intracell_attemptsUser-defined 
Intra-BSC Outgoing AttemptsCell.Neutral.GSM.handover.result.outgoing_intrabsc_attemptsUser-defined 
Intra-BSC Incoming Failure %Cell.Neutral.GSM.handover.result.%_incoming_intrabsc_failureUser-defined 
Intra-BSC Incoming AttemptsCell.Neutral.GSM.handover.result.incoming_intrabsc_attemptsUser-defined 
Intra-BSC Failure %Cell.Neutral.GSM.handover.result.%_outgoing_intrabsc_failureUser-defined 
Inter-BSC Outgoing Failure %Cell.Neutral.GSM.handover.result.%_outgoing_interbsc_failureUser-defined 
Inter-BSC Outgoing AttemptsCell.Neutral.GSM.handover.result.outgoing_interbsc_attemptsUser-defined 
Inter-BSC Incoming Failure %Cell.Neutral.GSM.handover.result.%_incoming_interbsc_failureUser-defined 
Inter-BSC Incoming AttemptsCell.Neutral.GSM.handover.result.incoming_interbsc_attemptsUser-defined 

Cell Handover Causes Pareto Graph

This graph is a Pareto chart showing the percentage relative contributions of cell handover causes for a selected handover cause in descending order. Each handover cause and the total number of causes are to be displayed as a bar on a bar-chart for each cell.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.Handovers
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingNo
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell Handover Causes Pareto Graph (Bar Chart)
Directed RetryCell.Neutral.GSM.handover.cause.directed_retryUser-defined 
DistanceCell.Neutral.GSM.handover.cause.distanceUser-defined 
Downlink InterferenceCell.Neutral.GSM.handover.cause.downlink_interferenceUser-defined 
Downlink LevelCell.Neutral.GSM.handover.cause.downlink_levelUser-defined 
Downlink QualityCell.Neutral.GSM.handover.cause.downlink_qualityUser-defined 
Downlink Quality and InterferenceCell.Neutral.GSM.handover.cause.grouped_downlinkUser-defined 
MSC and OMC InvocationsCell.Neutral.GSM.handover.cause.grouped_msc_omcUser-defined 
Other CausesCell.Neutral.GSM.handover.cause.otherUser-defined 
Power BudgetCell.Neutral.GSM.handover.cause.power_budgetUser-defined 
TotalCell.Neutral.GSM.handover.cause.total_handoversUser-defined 
Traffic ReasonsCell.Neutral.GSM.handover.cause.traffic_reasonsUser-defined 
UmbrellaCell.Neutral.GSM.handover.cause.umbrellaUser-defined 
Uplink InterferenceCell.Neutral.GSM.handover.cause.uplink_interferenceUser-defined 
Uplink LevelCell.Neutral.GSM.handover.cause.uplink_levelUser-defined 
Uplink QualityCell.Neutral.GSM.handover.cause.uplink_qualityUser-defined 
Uplink Quality and InterferenceCell.Neutral.GSM.handover.cause.grouped_uplinkUser-defined 

Cell Handover Causes Trend Graph

This graph shows the trend in cell handover causes for a selected handover cause

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.Handovers
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Directed Retry and Other (Line Chart)
Directed RetryCell.Neutral.GSM.handover.cause.directed_retryUser-defined 
Other CausesCell.Neutral.GSM.handover.cause.otherUser-defined 
TotalCell.Neutral.GSM.handover.cause.total_handoversUser-defined 
Component 2: Interference (Line Chart)
DownlinkCell.Neutral.GSM.handover.cause.downlink_interferenceUser-defined 
TotalCell.Neutral.GSM.handover.cause.total_handoversUser-defined 
UplinkCell.Neutral.GSM.handover.cause.uplink_interferenceUser-defined 
Component 3: Level (Line Chart)
DownlinkCell.Neutral.GSM.handover.cause.downlink_levelUser-defined 
TotalCell.Neutral.GSM.handover.cause.total_handoversUser-defined 
UplinkCell.Neutral.GSM.handover.cause.uplink_levelUser-defined 
Component 4: MSC and OMC Invoked (Line Chart)
InvocationCell.Neutral.GSM.handover.cause.grouped_msc_omcUser-defined 
TotalCell.Neutral.GSM.handover.cause.total_handoversUser-defined 
Component 5: Power Budget (Better Cell) and Distance (Line Chart)
DistanceCell.Neutral.GSM.handover.cause.distanceUser-defined 
Power BudgetCell.Neutral.GSM.handover.cause.power_budgetUser-defined 
TotalCell.Neutral.GSM.handover.cause.total_handoversUser-defined 
Component 6: Quality (Line Chart)
DownlinkCell.Neutral.GSM.handover.cause.downlink_qualityUser-defined 
TotalCell.Neutral.GSM.handover.cause.total_handoversUser-defined 
UplinkCell.Neutral.GSM.handover.cause.uplink_qualityUser-defined 
Component 7: Quality and Interference (Line Chart)
DownlinkCell.Neutral.GSM.handover.cause.grouped_downlinkUser-defined 
TotalCell.Neutral.GSM.handover.cause.total_handoversUser-defined 
UplinkCell.Neutral.GSM.handover.cause.grouped_uplinkUser-defined 
Component 8: Umbrella and Traffic Reasons (Line Chart)
TotalCell.Neutral.GSM.handover.cause.total_handoversUser-defined 
Traffic ReasonsCell.Neutral.GSM.handover.cause.traffic_reasonsUser-defined 
UmbrellaCell.Neutral.GSM.handover.cause.umbrellaUser-defined 

Cell Handover Failure Graph

This shows the performance of three types of handover: - Intra-Cell - Intra-BSC (Internal Inter-Cell) - Inter-BSC (External Inter-Cell)

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.Handovers
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Incoming Inter-BSC (Line Chart)
AttemptsCell.Neutral.GSM.handover.result.incoming_interbsc_attemptsUser-defined 
FailuresCell.Neutral.GSM.handover.result.incoming_interbsc_failuresUser-defined 
Component 2: Incoming Intra-BSC (Line Chart)
AttemptsCell.Neutral.GSM.handover.result.incoming_intrabsc_attemptsUser-defined 
FailuresCell.Neutral.GSM.handover.result.incoming_intrabsc_failuresUser-defined 
Component 3: Intra-Cell (Line Chart)
AttemptsCell.Neutral.GSM.handover.result.intracell_attemptsUser-defined 
FailuresCell.Neutral.GSM.handover.result.intracell_failuresUser-defined 
Component 4: Outgoing Inter-BSC (Line Chart)
AttemptsCell.Neutral.GSM.handover.result.outgoing_interbsc_attemptsUser-defined 
FailuresCell.Neutral.GSM.handover.result.outgoing_interbsc_failuresUser-defined 
Component 5: Outgoing Intra-BSC (Line Chart)
AttemptsCell.Neutral.GSM.handover.result.outgoing_intrabsc_attemptsUser-defined 
FailuresCell.Neutral.GSM.handover.result.outgoing_intrabsc_failuresUser-defined 

Cell Handover Graph

This graph shows the trend in handover performance of internal and external handovers outgoing from the cell and intra cell handovers

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.Handovers
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Intra-cell Handovers (Line Chart)
FailedCell.Neutral.GSM.handover.result.intracell_failuresUser-defined 
SuccessfulCell.Neutral.GSM.handover.result.intracell_successesUser-defined 
Component 2: Outgoing External Inter-cell Handover (Line Chart)
FailedCell.Neutral.GSM.handover.result.outgoing_interbsc_failuresUser-defined 
SuccessfulCell.Neutral.GSM.handover.result.outgoing_interbsc_successesUser-defined 
Component 3: Outgoing Internal Inter-cell Handover (Line Chart)
FailedCell.Neutral.GSM.handover.result.outgoing_intrabsc_failuresUser-defined 
SuccessfulCell.Neutral.GSM.handover.result.outgoing_intrabsc_successesUser-defined 

Cell SDCCH Congestion Graph

This shows KPIs related to Cell SDCCH blocking and congestion

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.SDCCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Blocking (Line Chart)
% BlockingCell.Neutral.GSM.sdcch.%_blockingUser-defined 
Component 2: Attempts (Line Chart)
AttemptsCell.Neutral.GSM.sdcch.seizure_attemptsUser-defined 
Component 3: Blocks (Line Chart)
BlocksCell.Neutral.GSM.sdcch.blocksUser-defined 

Cell SDCCH Drops Graph

This shows the percentage of SDCCH?s that dropped, together with the numbers of drops caused by RF losses and other reasons

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.SDCCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Drops (Line Chart)
% DropsCell.Neutral.GSM.sdcch.%_dropped_callsUser-defined 
Component 2: Dropped Calls (Line Chart)
Other DroppedCell.Neutral.GSM.sdcch.other_dropped_callsUser-defined 
RF LossCell.Neutral.GSM.sdcch.rf_lossesUser-defined 

Cell SDCCH Graph

This shows an overview of 4 areas of Cell Standalone Dedicated Control Channel (SDCCH) performance

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.SDCCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Blocking (Line Chart)
% BlockingCell.Neutral.GSM.sdcch.%_blockingUser-defined 
Component 2: Availability (Line Chart)
AvailabilityCell.Neutral.GSM.sdcch.%_availabilityUser-defined 
Component 3: Dropped Calls (Line Chart)
Dropped CallsCell.Neutral.GSM.sdcch.%_dropped_callsUser-defined 
Component 4: Traffic (Line Chart)
TrafficCell.Neutral.GSM.sdcch.trafficUser-defined 

Cell SDCCH Traffic Graph

This shows the traffic and utilisation of a Cell?s SDCCH?s, together with the number of seizure attempts

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.SDCCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Seizures (Line Chart)
SeizuresCell.Neutral.GSM.sdcch.seizure_attemptsUser-defined 
Component 2: Traffic (Line Chart)
TrafficCell.Neutral.GSM.sdcch.trafficUser-defined 
Component 3: Utilisation (Line Chart)
UtilisationCell.Neutral.GSM.sdcch.utilisationUser-defined 

Cell SDCCH Traffic Report

This report shows several Standalone Dedicated Control Channel (SDCCH) KPIs over a period

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.SDCCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
FilteringCell.Neutral.GSM.sdcch.%_blocking (min), Cell.Neutral.GSM.sdcch.%_dropped_calls (min), Cell.Neutral.GSM.sdcch.mean_holding_time (max), Cell.Neutral.GSM.sdcch.%_data_coverage (min), Cell.Neutral.GSM.sdcch.traffic (min/max)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell SDCCH Traffic Report (Table)
Available ChannelsCell.Neutral.GSM.sdcch.available_chUser-defined 
BSCBSC.nameUser-defined 
Blocking (%)Cell.Neutral.GSM.sdcch.%_blockingUser-defined 
CellCell.nameUser-defined 
Defined ChannelsCell.Neutral.GSM.sdcch.defined_chUser-defined 
Dropped (%)Cell.Neutral.GSM.sdcch.%_dropped_callsUser-defined 
MHT (s)Cell.Neutral.GSM.sdcch.mean_holding_timeUser-defined 
Not displayed (for filtering only)Cell.Neutral.GSM.sdcch.%_data_coverageUser-defined 
SDCCH Seizure AttemptsCell.Neutral.GSM.sdcch.seizure_attemptsUser-defined 
SDCCH Seizure BlocksCell.Neutral.GSM.sdcch.blocksUser-defined 
SDCCH Seizure DroppedCell.Neutral.GSM.sdcch.total_dropped_callsUser-defined 
Traffic (E)Cell.Neutral.GSM.sdcch.trafficUser-defined 

Cell TCH Congestion Graph

This shows KPIs related to Cell TCH blocking and congestion

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Blocking (Line Chart)
% BlockingCell.Neutral.GSM.tch.%_blockingUser-defined 
Component 2: Attempts (Line Chart)
AttemptsCell.Neutral.GSM.tch.seizure_attemptsUser-defined 
Component 3: Blocks (Line Chart)
BlocksCell.Neutral.GSM.tch.blocksUser-defined 

Cell TCH Drops Graph

This shows the percentage of Traffic Channels that dropped, together with the numbers of drops caused by RF losses and other reasons

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Drops (Line Chart)
% DropsCell.Neutral.GSM.tch.%_dropped_callsUser-defined 
Component 2: Dropped Calls (Line Chart)
Other DroppedCell.Neutral.GSM.tch.other_dropped_callsUser-defined 
RF LossCell.Neutral.GSM.tch.rf_lossesUser-defined 

Cell TCH Exhaustion Report

This report shows all cells that will reach exhaustion in the specified forecast. The report shows carried traffic, % blocking, % utilisation, grade of service and lost traffic in the most recent actual busy hour, and then the selected dimensioning parameter, the critical traffic, the sample size, correlation coefficient, traffic growth and exhaustion date. The report is always generated with weekly busy hour values. The user defines the length of forecast in days and the design GOS as runtime parameters, and has the option to include or exclude exhausted cells.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingNo
Period SelectionWeekly
Summary Selectionbusy_hour, 3-day Average, 5-day Average
FilteringCell.Neutral.GSM.tch.number_of_samples (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell TCH Exhaustion Report (Table)
BSCBSC.nameUser-defined 
CapacityCell.Neutral.GSM.tch.capacityUser-defined 
CellCell.nameUser-defined 
Forecast Exhaust OnCell.Neutral.GSM.tch.forecast.linear_exhaustion_dateUser-defined 
Forecast Is ExhaustedCell.Neutral.GSM.tch.is_exhaustedUser-defined 
Forecast Sample SizeCell.Neutral.GSM.tch.number_of_samplesUser-defined 
Forecast Traffic Growth (E/week)Cell.Neutral.GSM.tch.forecast.linear_traffic_growthUser-defined 
Latest Weekly BH % BlockingCell.Neutral.GSM.tch.%_blockingbusy_hour 
Latest Weekly BH % UtilisationCell.Neutral.GSM.tch.utilisationbusy_hour 
Latest Weekly BH GOSCell.Neutral.GSM.tch.grade_of_servicebusy_hour 
Latest Weekly BH Lost TrafficCell.Neutral.GSM.tch.lost_trafficbusy_hour 
Latest Weekly BH Traffic (E)Cell.Neutral.GSM.tch.trafficbusy_hour 
Summarised TrafficCell.Neutral.GSM.tch.trafficUser-defined 

Cell TCH Graph

This shows an overview of 4 areas of Cell Traffic Channel performance.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Blocking (Line Chart)
% BlockingCell.Neutral.GSM.tch.%_blockingUser-defined 
Component 2: Availability (Line Chart)
AvailabilityCell.Neutral.GSM.tch.%_availabilityUser-defined 
Component 3: Dropped Calls (Line Chart)
Dropped CallsCell.Neutral.GSM.tch.%_dropped_callsUser-defined 
Component 4: Traffic (Line Chart)
TrafficCell.Neutral.GSM.tch.trafficUser-defined 

Cell TCH Historical Traffic Report

This report shows key cell TCH traffic statistics for a single cell over all the weeks in the forecast base range. The report shows available & defined channels, % blocking, carried traffic, offered traffic, lost traffic, critical traffic, 3-DAV and 5-DAV traffic, % utilisation and grade of service. The report is always generated with weekly busy hour values. The user defines the design GOS as a runtime parameter.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionWeekly
FilteringCell.Neutral.GSM.tch.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell TCH Historical Traffic Report (Table)
Available ChannelsCell.Neutral.GSM.tch.available_chbusy_hour 
BSCBSC.nameUser-defined 
Blocking (%)Cell.Neutral.GSM.tch.%_blockingbusy_hour 
Busy Hourbusy_hourbusy_hour 
CapacityCell.Neutral.GSM.tch.capacitybusy_hour 
Carried Traffic (E)Cell.Neutral.GSM.tch.trafficbusy_hour 
CellCell.nameUser-defined 
DAV 3 Average Carried Traffic (E)Cell.Neutral.GSM.tch.traffic3-day Average 
DAV 5 Average Carried Traffic (E)Cell.Neutral.GSM.tch.traffic5-day Average 
Defined ChannelsCell.Neutral.GSM.tch.defined_chbusy_hour 
GOSCell.Neutral.GSM.tch.grade_of_servicebusy_hour 
Lost Traffic (E)Cell.Neutral.GSM.tch.lost_trafficbusy_hour 
Not displayed (for filtering only)Cell.Neutral.GSM.tch.%_data_coverageUser-defined 
Offered UtilisationCell.Neutral.GSM.tch.offered_utilisationbusy_hour 
Week of User-defined 

Cell TCH Low Utilisation Report

This report shows all cells that will remain consistently under utilised in the forecast period i.e start off with low utilisation and finish with low utilisation. The report shows carried traffic, % blocking, % utilisation, grade of service and lost traffic in the most recent actual busy hour and then the selected dimensioning parameter, the critical traffic, the sample size, correlation coefficient and current and final utilisation. The report is always generated with weekly busy hour values. The report can be filtered on the maximum current Utilisation and forecast utilisation; these parameters mandatory and default to 25%. The user defines the length of forecast in days and the design GOS as runtime parameters.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingYes
Period SelectionWeekly
Summary Selectionbusy_hour, 3-day Average, 5-day Average
FilteringCell.Neutral.GSM.tch.number_of_samples (min), Cell.Neutral.GSM.tch.utilisation (max), Cell.Neutral.GSM.tch.forecast.utilisation (max)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell TCH Low Utilisation Report (Table)
BSCBSC.nameUser-defined 
CapacityCell.Neutral.GSM.tch.capacityUser-defined 
SamplesCell.Neutral.GSM.tch.number_of_samplesUser-defined 
Latest Weekly BH Traffic (E)Cell.Neutral.GSM.tch.trafficbusy_hour 
Latest Weekly BH Lost Traffic (E)Cell.Neutral.GSM.tch.lost_trafficbusy_hour 
Latest Weekly BH GOSCell.Neutral.GSM.tch.grade_of_servicebusy_hour 
Latest Weekly BH % UtilisationCell.Neutral.GSM.tch.utilisationbusy_hour 
Latest Weekly BH % BlockingCell.Neutral.GSM.tch.%_blockingbusy_hour 
Forecast % UtilisationCell.Neutral.GSM.tch.forecast.utilisationbusy_hour 
CellCell.nameUser-defined 
Carried Traffic (E)Cell.Neutral.GSM.tch.trafficUser-defined 

Cell TCH Offered Traffic Graph

This chart shows the trend in the principal cell traffic parameters: busy hour traffic, 3-DAV and 5-DAV traffic. The chart is based on weekly summarised data. The user defines the design GOS as a runtime parameter.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionWeekly
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell TCH Offered Traffic Graph (Line Chart)
CapacityCell.Neutral.GSM.tch.capacityUser-defined 
Weekly 3-DAV ValueCell.Neutral.GSM.tch.traffic3-day Average 
Weekly Busy Hour ValueCell.Neutral.GSM.tch.trafficbusy_hour 
Weekly 5-DAV ValueCell.Neutral.GSM.tch.traffic5-day Average 

Cell TCH Required Channels Report

This report shows the forecast channel requirements for a set of cells for three different forecast periods. The forecast can be dimensioned using Weekly BH, 3-DAV or 5-DAV values of carried or offered traffic. For all selected cells, the report shows the sample size, the correlation coefficient of the forecast, the actual and required channels and the selected dimensioning parameter in the latest busy hour and then the required channels and forecast traffic at periods of N1, N2 and N3 days ahead where N1, N2 and N3 are configurable but default to 60, 90 and 120. The report is always generated from weekly busy hour values.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingYes
Period SelectionWeekly
Summary Selectionbusy_hour, 3-day Average, 5-day Average
FilteringCell.Neutral.GSM.tch.extra_capacity_required (min/max)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell TCH Required Channels Report (Table)
BSC NameBSC.nameUser-defined 
Cell NameCell.nameUser-defined 
End Date Defined ChannelsCell.Neutral.GSM.tch.defined_chbusy_hour 
End Date Grade of ServiceCell.Neutral.GSM.tch.grade_of_servicebusy_hour 
End Date Lost Traffic (E)Cell.Neutral.GSM.tch.lost_trafficbusy_hour 
End Date UtilisationCell.Neutral.GSM.tch.utilisationbusy_hour 
Extra ChannelsCell.Neutral.GSM.tch.forecast.extra_chUser-defined 
Latest Actual Required Number of ChannelsCell.Neutral.GSM.tch.required_chUser-defined 
Latest Actual Traffic (E)Cell.Neutral.GSM.tch.trafficUser-defined 
N1 Days Forecast Required Number of ChannelsCell.Neutral.GSM.tch.forecast.required_chUser-defined 
N1 Days Forecast Traffic (E)Cell.Neutral.GSM.tch.forecast.trafficUser-defined 
Not displayed (for filtering only)Cell.Neutral.GSM.tch.extra_capacity_requiredUser-defined 
SamplesCell.Neutral.GSM.tch.number_of_samplesUser-defined 

Cell TCH Traffic Forecast Graph

This chart allows the user to plot the weekly trend of either the carried or offered traffic for one of the three following dimensioning parameters: the busy hour traffic; 3-day average traffic; or, the 5-day average traffic. It also plots a regression of the selected dimensioning parameter extrapolated over a user-defined forecast period. The forecast is based on weekly summarised data.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionWeekly
Summary Selectionbusy_hour, 3-day Average, 5-day Average
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: N Day Cell TCH Traffic Forecast Graph (Line Chart)
Capacity GOS={Design GOS}Cell.Neutral.GSM.tch.forecast.capacityUser-defined 
Cell [will reach exhaustion on date|will not reach exhaustion in this period].Cell.Neutral.GSM.tch.forecast.linear_exhaustion_dateUser-defined 
Growth is (Erlangs/week)Cell.Neutral.GSM.tch.forecast.linear_traffic_growthUser-defined 
Linear regression on Traffic, Coefficient of RegressionCell.Neutral.GSM.tch.forecast.linear_regression_coefficientUser-defined 
Standard Error of RegressionCell.Neutral.GSM.tch.forecast.linear_regression_errorUser-defined 
TrafficCell.Neutral.GSM.tch.trafficUser-defined 
Traffic ForecastCell.Neutral.GSM.tch.forecast.trafficUser-defined 

Cell TCH Traffic Graph

This shows the traffic and utilisation of a Cell?s Traffic Channels, together with the number of seizure attempts

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Seizures (Line Chart)
SeizuresCell.Neutral.GSM.tch.seizure_attemptsUser-defined 
Component 2: Traffic (Line Chart)
TrafficCell.Neutral.GSM.tch.trafficUser-defined 
Component 3: Utilisation (Line Chart)
UtilisationCell.Neutral.GSM.tch.utilisationUser-defined 

Cell TCH Traffic Report

This report shows KPIs for several Traffic Channel (TCH) KPIs over a period

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
FilteringCell.Neutral.GSM.tch.%_blocking (min), Cell.Neutral.GSM.tch.%_dropped_calls (min), Cell.Neutral.GSM.tch.mean_holding_time (max), Cell.Neutral.GSM.tch.%_availability (min), Cell.Neutral.GSM.tch.traffic (min/max)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Cell TCH Traffic (Table)
BSCBSC.nameUser-defined 
Blocking (%)Cell.Neutral.GSM.tch.%_blockingUser-defined 
Busy Hourbusy_hourbusy_hour 
CellCell.nameUser-defined 
Channels AvailableCell.Neutral.GSM.tch.available_chUser-defined 
Channels DefinedCell.Neutral.GSM.tch.defined_chUser-defined 
Dropped (%)Cell.Neutral.GSM.tch.%_dropped_callsUser-defined 
MHT (s)Cell.Neutral.GSM.tch.mean_holding_timeUser-defined 
Not displayed (for filtering only)Cell.Neutral.GSM.tch.%_availabilityUser-defined 
TCH Seizure AttemptsCell.Neutral.GSM.tch.call_seizure_attemptsUser-defined 
TCH Seizure BlocksCell.Neutral.GSM.tch.blocksUser-defined 
TCH Seizure DroppedCell.Neutral.GSM.tch.total_dropped_callsUser-defined 
Traffic (E)Cell.Neutral.GSM.tch.trafficUser-defined 

Cell TCH Utilisation Graph

This graph shows the trend in utilisation for a single cell: traffic (offered and carried), % utilisation and calculated GOS

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Average
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: GOS (Line Chart)
Graph Overlay Value: User-defined
Design GOS overlay
GOSCell.Neutral.GSM.tch.grade_of_serviceUser-defined 
Component 2: Offered Traffic (Line Chart)
Critical Traffic (overlay)Cell.Neutral.GSM.tch.capacityUser-defined 
Offered TrafficCell.Neutral.GSM.tch.offered_trafficUser-defined 
Component 3: Offered Utilisation (Line Chart)
Graph Overlay Value: User-defined
100% overlay
Offered UtilisationCell.Neutral.GSM.tch.offered_utilisationUser-defined 
Component 4: Traffic (Line Chart)
Critical Traffic (overlay)Cell.Neutral.GSM.tch.capacityUser-defined 
TrafficCell.Neutral.GSM.tch.trafficUser-defined 

Linkset Availability Report Link KPIs

This report shows the availability of a set of linksets and failures and unavailability on the constituent links.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet, Signalling_Point, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary SelectionTotal
FilteringSignalling_LinkSet.Neutral.GSM.signalling_linkset.total_failures (min), Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min), Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_time (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: SS7 Linkset Availability Report (Link KPIs) (Table)
# LinksSignalling_LinkSet.Neutral.GSM.signalling_linkset.linksUser-defined 
Link FailuresSignalling_LinkSet.Neutral.GSM.signalling_linkset.total_failuresUser-defined 
Not displayed (for filtering only)Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverageUser-defined 
LinksetSignalling_LinkSet.nameUser-defined 
Links Unavailable (s)Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_timeUser-defined 

Linkset Availability Report Linkset KPIs

This report shows the availability of a set of linksets and failures

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet, Signalling_Point, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary SelectionTotal
FilteringSignalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: SS7 Linkset Availability Report (Linkset KPIs) (Table)
% Linkset In-serviceSignalling_LinkSet.Neutral.GSM.signalling_linkset.%_availableUser-defined 
LinksetSignalling_LinkSet.nameUser-defined 
Not displayed (for filtering only)Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverageUser-defined 
Linkset Unavailable (s)Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_timeUser-defined 

Linkset Utilisation Report

This report shows the utilisation of a set of linksets through the traffic carried on their constituent links.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet, Signalling_Point, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
FilteringSignalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min), Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_traffic (min), Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffic (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Linkset Utilisation Report (Table)
# LinksSignalling_LinkSet.Neutral.GSM.signalling_linkset.linksTotal 
LinksetSignalling_LinkSet.nameUser-defined 
Not displayed (for filtering only)Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverageUser-defined 
RX Average Link (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_incoming_trafficreceived_busy_hour 
RX Busy Hourreceived_busy_hourreceived_busy_hour 
RX MSUSSignalling_LinkSet.Neutral.GSM.signalling_linkset.received_msusreceived_busy_hour 
RX SIF/SIO OctetsSignalling_LinkSet.Neutral.GSM.signalling_linkset.received_sif_siosreceived_busy_hour 
RX Usage (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_trafficreceived_busy_hour 
TX Average Link (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_outgoing_traffictransmitted_busy_hour 
TX Busy Hourtransmitted_busy_hourtransmitted_busy_hour 
TX MSUSSignalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_msustransmitted_busy_hour 
TX SIF/SIO OctetsSignalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_sif_siostransmitted_busy_hour 
TX Usage (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffictransmitted_busy_hour 

Processor Load Graph

This graph shows the performance of a support processor associated with a node against time

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Processor
Primary ObjectProcessor
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionProcessor
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Average
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Processor Load (Line Chart)
% LoadProcessor.Neutral.GSM.cpu.load_pcUser-defined 

Signalling Linkset Exhaustion Report

This report shows all linksets that will reach exhaustion in the specified forecast. The report is always generated with weekly busy hour values. The user has the option to set the following run-time parameters: Nominal Maximum Traffic - Default value 0.4, Maximum In-Failure Traffic - Default value 0.8, Default Links In-Failure - Default value 1.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet, Signalling_Point, Region
Date RangingYes
Period SelectionWeekly
Summary Selectionreceived_busy_hour, transmitted_busy_hour
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: SS7 Linkset Exhaustion Report (Table)
CapacitySignalling_LinkSet.Neutral.GSM.signalling_linkset.capacityUser-defined 
Designed Link FailuresSignalling_LinkSet.Designed_Link_FailuresUser-defined 
Exhaustion DateSignalling_LinkSet.Neutral.GSM.forecast.linear_exhaustion_dateUser-defined 
In-Failure CapacitySignalling_LinkSet.Neutral.GSM.signalling_linkset.in_failure_capacityUser-defined 
Is ExhaustedSignalling_LinkSet.Neutral.GSM.signalling_linkset.is_exhaustedUser-defined 
LinksSignalling_LinkSet.Neutral.GSM.signalling_linkset.linksUser-defined 
Linkset NameSignalling_LinkSet.nameUser-defined 
MSUsSignalling_LinkSet.Neutral.GSM.signalling_linkset.msusUser-defined 
SamplesSignalling_LinkSet.Neutral.GSM.signalling_linkset.number_of_samplesUser-defined 
TrafficSignalling_LinkSet.Neutral.GSM.signalling_linkset.trafficUser-defined 
Traffic ForecastSignalling_LinkSet.Neutral.GSM.forecast.trafficUser-defined 
Traffic GrowthSignalling_LinkSet.Neutral.GSM.forecast.linear_traffic_growthUser-defined 

SS7 Link Availability Graph

This graph shows the link availability for a selected SS7 link

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Link
Primary ObjectSignalling_Link
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_Link
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary SelectionTotal
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Total % Link Availability (Line Chart)
% Link AvailabilitySignalling_Link.Neutral.GSM.link.%_availableTotal 
Component 2: Total % Local Busy (Line Chart)
% Local BusySignalling_Link.Neutral.GSM.link.%_local_inhibition_timeTotal 
Component 3: Total Link Failures (Line Chart)
Link FailuresSignalling_Link.Neutral.GSM.link.failuresTotal 

SS7 Linkset Availability Graph Link KPIs

This graph shows the linkset availability of the constituent links for a selected SS7 linkset.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary SelectionTotal
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Total % Link Availability (Line Chart)
% Link AvailabilitySignalling_LinkSet.Neutral.GSM.signalling_linkset.mean_%_availableTotal 
Component 2: Total Link Failures (Line Chart)
Link FailuresSignalling_LinkSet.Neutral.GSM.signalling_linkset.total_failuresTotal 

SS7 Linkset Availability Graph Linkset KPIs

This graph shows the linkset availability for a selected SS7 linkset.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary SelectionTotal
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Total % Linkset Availability (Line Chart)
% Linkset AvailabilitySignalling_LinkSet.Neutral.GSM.signalling_linkset.%_availableTotal 
Component 2: Total Linkset Failures (Line Chart)
Linkset FailuresSignalling_LinkSet.Neutral.GSM.signalling_linkset.failuresTotal 

SS7 Linkset Utilisation Graph

This graph shows the linkset transmission and reception utilisation for a selected SS7 link.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionreceived_busy_hour, transmitted_busy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Signalling Linkset MSUs on Linkset (Line Chart)
RXSignalling_LinkSet.Neutral.GSM.signalling_linkset.received_msusUser-defined 
TXSignalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_msusUser-defined 
Component 2: Signalling Linkset Traffic (Octets) (Line Chart)
IncomingSignalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_trafficUser-defined 
OutgoingSignalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_trafficUser-defined 

SS7 Linkset Utilisation Report RX

This report shows the utilisation of a set of linksets through the traffic received on their constituent links.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet, Signalling_Point, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionreceived_busy_hour, Total
FilteringSignalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: SS7 Linkset Utilisation Report (RX) (Table)
# LinksSignalling_LinkSet.Neutral.GSM.signalling_linkset.linksUser-defined 
LinksetSignalling_LinkSet.nameUser-defined 
RX Usage (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_trafficUser-defined 
RX SIF/SIO OctetsSignalling_LinkSet.Neutral.GSM.signalling_linkset.received_sif_siosUser-defined 
RX MSUSSignalling_LinkSet.Neutral.GSM.signalling_linkset.received_msusUser-defined 
RX Busy Hourreceived_busy_hourreceived_busy_hour 
RX Average Link (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_incoming_trafficUser-defined 
Not displayed (for filtering only)Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverageUser-defined 

SS7 Linkset Utilisation Report TX

This report shows the utilisation of a set of linksets through the traffic transmitted on their constituent links.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet, Signalling_Point, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectiontransmitted_busy_hour, Total
FilteringSignalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: SS7 Linkset Utilisation Report (TX) (Table)
# LinksSignalling_LinkSet.Neutral.GSM.signalling_linkset.linksUser-defined 
LinksetSignalling_LinkSet.nameUser-defined 
TX Usage (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_trafficUser-defined 
TX SIF/SIO OctetsSignalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_sif_siosUser-defined 
TX MSUSSignalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_msusUser-defined 
TX Busy Hourtransmitted_busy_hourtransmitted_busy_hour 
TX Average Link (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_outgoing_trafficUser-defined 
Not displayed (for filtering only)Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverageUser-defined 

SS7 Link Utilisation Graph

This graph shows the link utilisation for a selected SS7 link.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Link
Primary ObjectSignalling_Link
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_Link
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionreceived_busy_hour, transmitted_busy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: MSUs (Line Chart)
ReceivedSignalling_Link.Neutral.GSM.link.received_msusUser-defined 
TransmittedSignalling_Link.Neutral.GSM.link.transmitted_msusUser-defined 
Component 2: SIF and SIO Octets (Line Chart)
ReceivedSignalling_Link.Neutral.GSM.link.received_sif_siosUser-defined 
TransmittedSignalling_Link.Neutral.GSM.link.transmitted_sif_siosUser-defined 
Component 3: Traffic (Line Chart)
IncomingSignalling_Link.Neutral.GSM.link.incoming_trafficUser-defined 
OutgoingSignalling_Link.Neutral.GSM.link.outgoing_trafficUser-defined 

SS7 Routeset Availability Graph

This graph shows the routeset availability for a selected SS7 routeset

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Routeset
Primary ObjectSignalling_RouteSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_RouteSet
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary SelectionTotal
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Routeset Availability (Line Chart)
% AvailabilitySignalling_RouteSet.Neutral.GSM.routeset.%_availableUser-defined 
Component 2: Total Routeset Failures (Line Chart)
Total FailuresSignalling_RouteSet.Neutral.GSM.routeset.failuresUser-defined 

SS7 Signalling Linkset Traffic Forecast Graph

This chart allows the user to plot the weekly trend of either the busy hour received or transmitted traffic. It also plots a regression of the selected parameter extrapolated over a user-defined forecast period. The report is always generated with weekly busy hour values. The user has the option to set the following run-time parameters: Nominal Maximum Traffic - Default value 0.4, Maximum In-Failure Traffic - Default value 0.8, Default Links In-Failure - Default value 1.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet
Date RangingYes
Period SelectionWeekly
Summary Selectionreceived_busy_hour, transmitted_busy_hour
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Heading (Line Chart)
Coefficient of RegressionSignalling_LinkSet.Neutral.GSM.forecast.linear_regression_coefficientUser-defined 
Growth is {linear_traffic_growth}Signalling_LinkSet.Neutral.GSM.forecast.linear_traffic_growthUser-defined 
Standard Error of RegressionSignalling_LinkSet.Neutral.GSM.forecast.linear_regression_errorUser-defined 
Linkset [will reach exhaustion on {linear_exhaustion_date}|will not reach exhaustion in this period]Signalling_LinkSet.Neutral.GSM.forecast.linear_exhaustion_dateUser-defined 
Component 2: SS7 Signalling Linkset Traffic Forecast Graph (Line Chart)
CapacitySignalling_LinkSet.Neutral.GSM.forecast.capacityUser-defined 
Forecast TrafficSignalling_LinkSet.Neutral.GSM.forecast.trafficUser-defined 
In-Failure CapacitySignalling_LinkSet.Neutral.GSM.forecast.in_failure_capacityUser-defined 
TrafficSignalling_LinkSet.Neutral.GSM.signalling_linkset.trafficUser-defined 

Summary Cell TCH Traffic Report

This report shows key cell TCH traffic statistics for a set of cells. The report is always generated with weekly busy hour values.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingNo
Period SelectionWeekly
FilteringCell.Neutral.GSM.tch.offered_utilisation (min), Cell.Neutral.GSM.tch.lost_traffic (min), Cell.Neutral.GSM.tch.grade_of_service (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Summary Cell TCH Traffic Report (Table)
3-DAV Carried Traffic (E)Cell.Neutral.GSM.tch.traffic3-day Average 
5-DAV Carried Traffic (E)Cell.Neutral.GSM.tch.traffic5-day Average 
Offered UtilisationCell.Neutral.GSM.tch.offered_utilisationbusy_hour 
Lost Traffic (E)Cell.Neutral.GSM.tch.lost_trafficbusy_hour 
GOSCell.Neutral.GSM.tch.grade_of_servicebusy_hour 
Defined ChannelsCell.Neutral.GSM.tch.defined_chbusy_hour 
CellCell.nameUser-defined 
Carried Traffic (E)Cell.Neutral.GSM.tch.trafficUser-defined 
CapacityCell.Neutral.GSM.tch.capacitybusy_hour 
Busy Hourbusy_hourbusy_hour 
Blocking (%)Cell.Neutral.GSM.tch.%_blockingbusy_hour 
BSCBSC.nameUser-defined 
Available ChannelsCell.Neutral.GSM.tch.available_chbusy_hour 

System Traffic Cell Graph

This graph shows the total system-wide BSS cell TCH traffic statistics for all cells in the network.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Network.System
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object Selection 
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary SelectionTotal
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: System Traffic (Cell) Graph (Line Chart)
Traffic (E)Cell.Neutral.GSM.tch.trafficTotal 

Weekly Cell TCH Traffic Graph

This graph shows key cell TCH traffic statistics for a set of cells. The graph is always generated from weekly summary data.

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionWeekly
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Weekly Cell TCH Traffic Graph (Line Chart)
3-Day AverageCell.Neutral.GSM.tch.traffic3-day Average 
5-Day AverageCell.Neutral.GSM.tch.traffic5-day Average 
Busy HourCell.Neutral.GSM.tch.trafficbusy_hour 

Worst Cells TCH Availability Graph

This chart shows the top (1?10) cells with the lowest TCH channel availability (as percentage of the number of defined channels) over the selected period

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Top-N TypeWorst-N
Sorted ByCell.Neutral.GSM.tch.%_availability
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Lowest Period Average % Availability Cells (Bar Chart)
Busy-hour AverageCell.Neutral.GSM.tch.%_availabilitybusy_hour 
Period AverageCell.Neutral.GSM.tch.%_availabilityTotal 

Worst Cells TCH Blocking Graph

This chart shows the top (1?10) cells with the highest TCH blocking percentage over the selected period

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Top-N TypeWorst-N
Sorted ByCell.Neutral.GSM.tch.%_blocking
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Highest Period Average % Blocking Cells (Bar Chart)
Busy-hour AverageCell.Neutral.GSM.tch.%_blockingbusy_hour 
Period AverageCell.Neutral.GSM.tch.%_blockingTotal 

Worst Cells TCH Drops Graph

This chart shows the top (1?10) cells with the highest TCH dropped call percentage over the selected period

Overview

Report FeatureDetails
Report Tree BranchSystem.GSM.Engineering.Radio.Cell.TCH
Primary ObjectCell
Top-N TypeWorst-N
Sorted ByCell.Neutral.GSM.tch.%_dropped_calls
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell, BS, BSC, LAC, MSC, Region
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Highest Period Average % Blocking Cells (Bar Chart)
Busy-hour AverageCell.Neutral.GSM.tch.%_dropped_callsbusy_hour 
Period AverageCell.Neutral.GSM.tch.%_dropped_callsTotal 


11. Data Availability

This section lists the data availability definitions for the network objects previously described.

Grouping ObjectKPI TypeReporting ObjectDefining KPI Group
BSCCells ReportingCellCell.Neutral.GSM.tch
MSCCells ReportingCellCell.Neutral.GSM.tch