Data Export Date: 07 Sep 2008
Issue | Date | Author | Comments |
---|---|---|---|
TBD |
None.
Number | Date | Description | Planned Resolution |
---|---|---|---|
TBD |
This section describes the network objects (logical and physical) that are referenced in this technology pack's data model.
The Home Location Register is the main network database (may be distributed). The HLR records permanent subscriber information, and keeps track of each subscriber's status and location in the network.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the HLR. | STRING | |
Name | A user friendly name preferably unique for the HLR. | STRING | |
Region | Region associated with the HLR. | STRING | Region |
Network | Network associated with the HLR. | STRING | Network |
Vendor | Manufacturer of the HLR. | STRING | |
HLR_Version | Hardware/Software version of the HLR. | STRING | |
Technology | Technology of the network/element (e.g. GSM, GPRS, UMTS). | STRING |
Location/Paging Area Code; a group of cells, managed by an MSC, that a mobile station's location may be recorded against.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the LAC. | STRING | |
Name | A user friendly name preferably unique for the LAC. | STRING | |
MSC | The MSC which controls this Location Area Code. | STRING | MSC |
Region | Region associated with the LAC. | STRING | Region |
Network | Network associated with the LAC. | STRING | Network |
Vendor | Manufacturer of the LAC. | STRING |
The Mobile Switching Centre has circuit/voice switching functions, as well as linking several BSCs to the core network and managing some of their functions (eg inter-BSC handover). It is also connected to an SS7 network for database queries.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the MSC. | STRING | |
Name | A user friendly name preferably unique for the MSC. | STRING | |
Region | Region associated with the MSC. | STRING | Region |
Network | Network associated with the MSC. | STRING | Network |
Vendor | Manufacturer of the MSC. | STRING | |
MSC_Version | Hardware/Software version of the MSC. | STRING | |
Technology | Technology of the network/element (e.g. GSM, GPRS, UMTS). | STRING | |
MSC_Type | Type of MSC. | STRING |
Network information.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the Network. | STRING | |
Name | A user friendly name preferably unique for the Network. | STRING | |
Network_Type | Type of Network (e.g. GSM-900, GSM-1800 or GSM-1900). | STRING | |
Default_Link_Speed | The default speed of SS7 Signalling Links in this network. | FLOAT |
The Processor object represents a CPU inside another network element. Some elements have more than one Processor.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the Processor. | STRING | |
Name | A user friendly name preferably unique for the Processor. | STRING | |
Region | Region associated with the Processor. | STRING | Region |
Network | Network associated with the Processor. | STRING | Network |
Processor_Type | Type of Processor. | STRING | |
Technology | Technology of the network/element (e.g. GSM, GPRS, UMTS). | STRING | |
Node_Id | This is the identifier for the network element containing the Processor. | STRING | |
Node_Name | A user friendly name preferably unique for the Node. | STRING | |
Node_Type | The type of the network element containing the Processor. | STRING | |
Processor_Version | Hardware/Software version of the Processor. | STRING | |
Vendor | Manufacturer of the Processor. | STRING |
A user defined grouping of network elements.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | Region associated with the network object. | STRING | |
Name | A user friendly name preferably unique for the Region. | STRING | |
Network | Network associated with the Region. | STRING | Network |
For each logical Route Interface, there will be 2 entries - 1 for the interface at each end, as it is the interfaces that report the data. Routes may connect switches and other nodes (including BSCs) in a circuit-switched network.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the Route IF. | STRING | |
Name | A user friendly name preferably unique for the Route IF. | STRING | |
Region | Region associated with the Route IF. | STRING | Region |
Network | Network associated with the Route IF. | STRING | Network |
Source_Id | A unique identifier for the Node (Switch) at this end of the connection. | STRING | |
Source_Type | Type of Source. | STRING | |
Source_Name | A user friendly name preferably unique for the Source. | STRING | |
Target_Type | Type of Target. | STRING | |
Target_Name | A user friendly name preferably unique for the Target. | STRING | |
Is_POI | Is it a Point of Interconnection. | BOOLEAN | |
Is_Trunk | Is it a Trunk Route? | BOOLEAN | |
Route_Direction | There are three options - Incoming, Outgoing or BothWay. | STRING | |
Route_Type | The type of route. | STRING | |
Target_Id | A unique identifier for the Node at the other end of the connection. | STRING | |
Source_Technology | Technology of the Source (e.g. GSM, GPRS, UMTS). | STRING | |
Target_Technology | Technology of the Target (e.g. GSM, GPRS, UMTS). | STRING |
A set of Signalling Links between two points.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the SS7 LinkSet. | STRING | |
Name | A user friendly name preferably unique for the SS7 LinkSet. | STRING | |
SS7_Point | The SS7 Point to which this SS7 LinkSet is connected to (at this end). | STRING | Signalling_Point |
Network | Network associated with the SS7 LinkSet. | STRING | Network |
Region | Region associated with the SS7 LinkSet. | STRING | Region |
Node_Id | The Node (MSC or HLR) that this SS7 LinkSet is connected to (at this end). | STRING | |
Node_Name | Name of the node that this SS7 LinkSet is connected to (at this end). | STRING | |
Data_Rate | The 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_Failures | The number of SS7 Link failures permitted on the SS7 LinkSet while still keeping the SS7 LinkSet up to its designed capacity. | INTEGER | |
Node_Type | The type of the network element that the SS7 LinkSet is connected to (at this end). | STRING | |
Technology | Technology of the network/element (e.g. GSM, GPRS, UMTS). | STRING | |
Adjacent_Node_Id | The Adjacent Node that this SS7 LinkSet is connected from (at the other end). | STRING |
The SS7 Signalling data link is a full-duplex, digital transmission channel, usually operating at 64 kbit/s.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the SS7 Link. | STRING | |
Name | A user friendly name preferably unique for the SS7 Link. | STRING | |
SS7_LinkSet | The Node (MSC or HLR) that this SS7 Link is connected to (at this end). | STRING | Signalling_LinkSet |
SS7_Point | A unique identifier for the SS7 Point. | STRING | Signalling_Point |
Region | Region associated with the SS7 Link. | STRING | Region |
Network | Network associated with the SS7 Link. | STRING | Network |
Node_Name | The name for the network element that the SS7 Link is connected to (at this end). | STRING | |
Node_Id | The Node (MSC or HLR) that this SS7 Link is connected to (at this end). | STRING | |
Data_Rate | The SS7 Link speed in bits per second (bit/s). | FLOAT | |
Node_Type | The type of the network element that the SS7 Link is connected to at this end. | STRING | |
Technology | Technology of the network/element (e.g. GSM, GPRS, UMTS). | STRING | |
Adjacent_Node_Id | The Adjacent Node that this SS7 Link is connected from (at the other end). | STRING |
Represents a signalling entity that is part of a Node.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the SS7 Point. | STRING | |
Name | A user friendly name preferably unique for the SS7 Point. | STRING | |
Region | Region associated with the SS7 Point. SS7_Point - the default value is derived via the Node. | STRING | Region |
Network | Network associated with the SS7 Point. | STRING | Network |
Node_Id | A unique identifier for the Node. | STRING | |
Node_Name | A user friendly name preferably unique for the Node. | STRING | |
Node_Type | Type of Node. | STRING | |
Technology | Technology of the network/element (e.g. GSM, GPRS, UMTS). | STRING | |
Adjacent_Node_Id | A unique identifier for the Adjacent Node. | STRING |
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 Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the SS7 RouteSet. | STRING | |
Name | A user friendly name preferably unique for the SS7 RouteSet. | STRING | |
SS7_Point | The SS7 Point to which this SS7 RouteSet is connected (at this end). | STRING | Signalling_Point |
Region | Region associated with the SS7 RouteSet. | STRING | Region |
Network | Network associated with the SS7 RouteSet. | STRING | Network |
Node_Name | A user friendly name preferably unique for the Node. | STRING | |
Node_Id | The Node that this SS7 RouteSet is connected to (at this end). | STRING | |
Node_Type | Type of Node. | STRING | |
Technology | Technology of the network/element (e.g. GSM, GPRS, UMTS). | STRING | |
Adjacent_Node_Id | The Adjacent node that this SS7 RouteSet is connected from (at the other end). | STRING |
The Visitor Location Register is distributed, and one VLR is usually associated with each MSC. It caches a subset of the information from the HLR, for subscribers that connected locally, plus some other temporary information.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the VLR. | STRING | |
Name | A user friendly name preferably unique for the VLR. | STRING | |
MSC | The MSC to which the VLR belongs. | STRING | MSC |
Network | Network associated with the VLR. | STRING | Network |
Region | Region associated with the VLR. | STRING | Region |
VLR_Version | Hardware/Software version of the VLR. | STRING | |
Vendor | Manufacturer of the VLR. | STRING | |
Technology | Technology of the network/element (e.g. GSM, GPRS, UMTS). | STRING |
This section describes the reference objects that are used only as lookups for compound-keyed raw data.
Call completion codes for voice switches.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the Completion Code. | STRING | |
Name | A user friendly name preferably unique for the Completion Code. | STRING | |
Completion_Code_Type | Type of Completion Code. | STRING | |
Completion_Code_Description | Description of Completion Code. | STRING |
Supplementary Services supported by voice switches.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the Supplementary Service. | STRING | |
Name | A user friendly name preferably unique for the Supplementary Service. | STRING |
Types of traffic carried by a voice switch.
Attribute Name | Description | Type | Related Object |
---|---|---|---|
ID | A unique identifier for the Traffic Type. | STRING | |
Name | A user friendly name preferably unique for the Traffic Type. | STRING | |
Direction | Direction of Traffic. | STRING | |
IS_Switched | Is the traffic switched? | STRING |
This section lists the busy hours that are defined in this technology pack, grouped by the network object to which they relate, as follows:
Busy Hour Name | Acronym | Defining KPI |
---|---|---|
busy_hour | hbh | HLR.Neutral.GSM.access.auc_la_update_attempts |
Busy Hour Name | Acronym | Defining KPI |
---|---|---|
busy_hour | mbh | MSC.Neutral.GSM.traffic.traffic |
traffic_type_busy_hour | mtbh | MSC.Neutral.GSM.traffic.traffic |
Busy Hour Name | Acronym | Defining KPI |
---|---|---|
busy_hour | pbh | Processor.Neutral.GSM.cpu.load_pc |
Busy Hour Name | Acronym | Defining KPI |
---|---|---|
busy_hour | rbh | Route_IF.Neutral.GSM.transmission.bothway_traffic |
incoming_busy_hour | ribh | Route_IF.Neutral.GSM.transmission.incoming_traffic |
outgoing_busy_hour | robh | Route_IF.Neutral.GSM.transmission.outgoing_traffic |
Busy Hour Name | Acronym | Defining KPI |
---|---|---|
received_busy_hour | slrbh | Signalling_Link.Neutral.GSM.link.incoming_utilisation |
transmitted_busy_hour | sltbh | Signalling_Link.Neutral.GSM.link.outgoing_utilisation |
Busy Hour Name | Acronym | Defining KPI |
---|---|---|
received_busy_hour | slsrbh | Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_utilisation |
transmitted_busy_hour | slstbh | Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_utilisation |
Busy Hour Name | Acronym | Defining KPI |
---|---|---|
busy_hour | vbh | VLR.Neutral.GSM.mobility.vlr_subscribers |
This section lists all constants that are defined in this technology pack, and which may be referenced in KPI expressions.
Constant Name | Description | Units | Default Value |
---|---|---|---|
GTP_header_Size | Byte | 16 |
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.
Statistics on authentication procedures
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_auc_failure | percentfail({HLR.Neutral.GSM.access.auc_failures}, {HLR.Neutral.GSM.access.auc_attempts}) | FLOAT | % | Percentage of failed requests for authentication parameters to the Authentication Centre (HLR to AUC) | hbh |
%_auc_success | percentok({HLR.Neutral.GSM.access.auc_successes}, {HLR.Neutral.GSM.access.auc_attempts}) | FLOAT | % | Failed requests for authentication parameters to the Authentication Centre (HLR to AUC) | hbh |
%_auth_failure | percentfail({HLR.Neutral.GSM.access.auth_failures}, {HLR.Neutral.GSM.access.auth_attempts}) | FLOAT | % | Percentage of failed requests from a VLR for authentication parameters (VLR to HLR) | hbh |
%_auth_success | percentok({HLR.Neutral.GSM.access.auth_successes}, {HLR.Neutral.GSM.access.auth_attempts}) | FLOAT | % | Percentage of successful requests from a VLR for authentication parameters (VLR to HLR) | hbh |
%_data_coverage | getvalidity({auc_attempts}) | FLOAT | % | ||
auc_attempts | hlr_resource_access_raw.auc_attempts | INTEGER | # | Requests for authentication parameters to the Authentication Centre (HLR to AUC) | hbh |
auc_failures | hlr_resource_access_raw.auc_failures | INTEGER | # | Successful requests for authentication parameters to the Authentication Centre (HLR to AUC) | hbh |
auc_la_update_attempts | {HLR.Neutral.GSM.access.auc_attempts} + {HLR.Neutral.GSM.mobility.la_update_attempts} | INTEGER | # | Total auc_attempts + la_update_attempts for HLR Busy Hour | |
auc_successes | hlr_resource_access_raw.auc_successes | INTEGER | # | Successful requests for authentication parameters to the Authentication Centre (HLR to AUC) | hbh |
auth_attempts | hlr_resource_access_raw.auth_attempts | INTEGER | # | Requests from a VLR for authentication parameters (VLR to HLR) | hbh |
auth_failures | hlr_resource_access_raw.auth_failures | INTEGER | # | Failed requests from a VLR for authentication parameters (VLR to HLR) | hbh |
auth_reused | hlr_resource_access_raw.auth_reused | INTEGER | # | Number of times that authentication parameters have been re-used | hbh |
auth_successes | hlr_resource_access_raw.auth_successes | INTEGER | # | Successful requests from a VLR for authentication parameters (VLR to HLR) | hbh |
Statistics on the communication between VLRs and the HLR
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_active_subscribers | percentfail({HLR.Neutral.GSM.mobility.vlr_subscribers}, {HLR.Neutral.GSM.mobility.subscribers}) | FLOAT | % | Percentage of subscribers known to this HLR that are registered in a VLR | hbh |
%_data_coverage | getvalidity({la_update_attempts}) | FLOAT | % | ||
%_inactive_subscribers | percentfail({HLR.Neutral.GSM.mobility.subscribers} - {HLR.Neutral.GSM.mobility.vlr_subscribers}, {HLR.Neutral.GSM.mobility.subscribers}) | FLOAT | % | Percentage of subscribers known to this HLR that are not registered in a VLR | hbh |
%_la_update_failure | percentfail({HLR.Neutral.GSM.mobility.la_update_failures}, {HLR.Neutral.GSM.mobility.la_update_attempts}) | FLOAT | % | Percentage of failed requests to update a subscriber?s Location Area | hbh |
%_la_update_success | percentok({HLR.Neutral.GSM.mobility.la_update_successes}, {HLR.Neutral.GSM.mobility.la_update_attempts}) | FLOAT | % | Percentage of successful requests to update a subscriber?s Location Area | hbh |
%_msrn_failure | percentfail({HLR.Neutral.GSM.mobility.msrn_failures}, {HLR.Neutral.GSM.mobility.msrn_attempts}) | FLOAT | % | Percentage of failed requests for MSRN by a VLR | hbh |
%_msrn_success | percentok({HLR.Neutral.GSM.mobility.msrn_successes}, {HLR.Neutral.GSM.mobility.msrn_attempts}) | FLOAT | % | Percentage of successful requests for MSRN by a VLR | hbh |
%_vlr_insert_failure | percentfail({HLR.Neutral.GSM.mobility.vlr_insert_failures}, {HLR.Neutral.GSM.mobility.vlr_insert_attempts}) | FLOAT | % | Percentage of failed attempts to insert subscriber data in a VLR | hbh |
%_vlr_insert_success | percentok({HLR.Neutral.GSM.mobility.vlr_insert_successes}, {HLR.Neutral.GSM.mobility.vlr_insert_attempts}) | FLOAT | % | Percentage of successful attempts to insert subscriber data in a VLR | hbh |
la_update_attempts | hlr_resource_access_raw.la_update_attempts | INTEGER | # | Requests received to update a subscriber?s Location Area | hbh |
la_update_failures | hlr_resource_access_raw.la_update_failures | INTEGER | # | Failed requests to update a subscriber?s Location Area | hbh |
la_update_successes | hlr_resource_access_raw.la_update_successes | INTEGER | # | Successful requests to update a subscriber?s Location Area | hbh |
msrn_attempts | hlr_resource_access_raw.msrn_attempts | INTEGER | # | Requests for a Mobile Subscriber Roaming Number (MSRN) by a VLR | hbh |
msrn_failures | hlr_resource_access_raw.msrn_failures | INTEGER | # | Failed requests for MSRN by a VLR | hbh |
msrn_successes | hlr_resource_access_raw.msrn_successes | INTEGER | # | Successful requests for MSRN by a VLR | hbh |
roamers | hlr_resource_access_raw.roamers | INTEGER | # | Subscribers roaming outside this HLR?s area or outside this PLMN (network) | hbh |
subscribers | hlr_resource_access_raw.subscribers | INTEGER | # | Subscribers registered in this HLR | hbh |
vlr_insert_attempts | hlr_resource_access_raw.vlr_insert_attempts | INTEGER | # | Attempts to insert subscriber data in a VLR | hbh |
vlr_insert_failures | hlr_resource_access_raw.vlr_insert_failures | INTEGER | # | Failed attempts to insert subscriber data in a VLR | hbh |
vlr_insert_successes | hlr_resource_access_raw.vlr_insert_successes | INTEGER | # | Successful attempts to insert subscriber data in a VLR | hbh |
vlr_subscribers | hlr_resource_access_raw.vlr_subscribers | INTEGER | # | Subscribers known to this HLR that are registered in a VLR | hbh |
The results of updates from or within a Location Area (LA)
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_data_coverage | getvalidity({attach_updates}) | FLOAT | % | ||
%_vlr_update_failure | percentfail({LAC.Neutral.GSM.mobility.vlr_update_failures}, {LAC.Neutral.GSM.mobility.vlr_update_attempts}) | FLOAT | % | Percentage of failures to update the VLR with location information about MS?s in this LA | mbh |
%_vlr_update_successes | percentok({LAC.Neutral.GSM.mobility.vlr_update_successes}, {LAC.Neutral.GSM.mobility.vlr_update_attempts}) | FLOAT | % | Percentage of successful attempts to update the VLR with location information about MS?s in this LA | mbh |
attach_updates | lac_resource_access_raw.attach_updates | INTEGER | # | Updates from IMSI Attach actions | mbh |
la_updates | lac_resource_access_raw.la_updates | INTEGER | # | Updates from MS?s changing to this LAC | mbh |
periodic_updates | lac_resource_access_raw.periodic_updates | INTEGER | % | Periodic updates | mbh |
vlr_update_attempts | lac_resource_access_raw.vlr_update_attempts | INTEGER | # | Attempts to update the VLR with location information about MS?s in this LA | mbh |
vlr_update_failures | lac_resource_access_raw.vlr_update_failures | INTEGER | # | Failures to update the VLR with location information about MS?s in this LA | mbh |
vlr_update_successes | lac_resource_access_raw.vlr_update_successes | INTEGER | # | Successful attempts to update the VLR with location information about MS?s in this LA | mbh |
The results of paging activity within a Location Area
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_data_coverage | getvalidity({pages}) | FLOAT | % | ||
%_response | percentok({LAC.Neutral.GSM.page.responses}, {LAC.Neutral.GSM.page.total_pages}) | FLOAT | % | The percentage of pages (first + subsequent) that received a response | mbh |
%_success | percentok({LAC.Neutral.GSM.page.responses}, {LAC.Neutral.GSM.page.pages}) | FLOAT | % | The percentage of pages (not counting repeat attempts to send the same page) that eventually received a response (possibly after re-paging) | mbh |
%_unresponse | percentfail({LAC.Neutral.GSM.page.unresponses}, {LAC.Neutral.GSM.page.total_pages}) | FLOAT | % | The percentage of pages (first + subsequent) that didn?t receive a response | mbh |
pages | lac_resource_access_raw.pages | INTEGER | % | First attempts to page an MS within this Location Area | mbh |
repages | lac_resource_access_raw.repages | INTEGER | # | Attempts to re-page (after the first page in this LAC received no response) | mbh |
responses | lac_resource_access_raw.responses | INTEGER | # | Responses to pages | mbh |
total_pages | lac_resource_access_raw.total_pages | INTEGER | # | Total attempts to page an MS within this Location Area | mbh |
unresponses | lac_resource_access_raw.unresponses | INTEGER | # | The number of paging attempts that received no response the MS | mbh |
How many of the calls controlled by this MSC terminated with each of the available Completion Codes (CCs)
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_data_coverage | getvalidity({completed}) | FLOAT | % | ||
completed | msc_call_completion_raw.completed | INTEGER | # | Number of calls that completed with the Completion Code | mbh |
The call setup performance for calls originating or terminating at an MS in the BSS controlled by this MSC
The performance data measurements for this KPI group are recorded against the combination of MSC and Completion_Code (cc_id)
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_data_coverage | getvalidity({originate_attempts}) | FLOAT | % | ||
%_originate_failure | percentfail({MSC.Neutral.GSM.call_setup.originate_failures}, {MSC.Neutral.GSM.call_setup.originate_attempts}) | FLOAT | % | % Failure to assign channels for originating calls | mbh |
%_originate_success | percentok({MSC.Neutral.GSM.call_setup.originate_successes}, {MSC.Neutral.GSM.call_setup.originate_attempts}) | FLOAT | % | % Success to assign channels for originating calls | mbh |
%_terminate_failure | percentfail({MSC.Neutral.GSM.call_setup.terminate_failures}, {MSC.Neutral.GSM.call_setup.terminate_attempts}) | FLOAT | % | % Failure to assign channels for terminating calls | mbh |
%_terminate_success | percentok({MSC.Neutral.GSM.call_setup.terminate_successes}, {MSC.Neutral.GSM.call_setup.terminate_attempts}) | FLOAT | % | % Success to assign channels for terminating calls | mbh |
originate_attempts | msc_call_setup_raw.originate_attempts | INTEGER | # | Channel assignment attempts for originating calls | mbh |
originate_failures | msc_call_setup_raw.originate_failures | INTEGER | # | Failures to assign channels for originating calls | mbh |
originate_successes | msc_call_setup_raw.originate_successes | INTEGER | # | Successful attempts to assign channels for originating calls | mbh |
terminate_attempts | msc_call_setup_raw.terminate_attempts | INTEGER | # | Channel assignment attempts for terminating calls | mbh |
terminate_failures | msc_call_setup_raw.terminate_failures | INTEGER | # | Failures to assign channels for terminating calls | mbh |
terminate_successes | msc_call_setup_raw.terminate_successes | INTEGER | # | Successful attempts to assign channels for terminating calls | mbh |
The calls managed by an MSC to a particular destination MSC
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_answered_calls | percentok({MSC.Neutral.GSM.destination.answered_calls}, {MSC.Neutral.GSM.destination.total_calls}) | FLOAT | % | Percentage of calls to the destination that were answered (Answer-Seize percentage) | mbh |
%_data_coverage | getvalidity({MSC.Neutral.GSM.destination.total_calls}) | FLOAT | % | Data coverage | |
%_data_coverage | getvalidity({answered_calls}) | FLOAT | % | ||
answered_calls | msc_call_destinations_raw.answered_calls | INTEGER | # | Number of calls to the destination that were answered | mbh |
answered_mean_holding_time | ({MSC.Neutral.GSM.destination.answered_traffic} * {MSC.Neutral.GSM.destination.measurement_seconds}) / {MSC.Neutral.GSM.destination.answered_calls} | FLOAT | Second | Conversational mean holding time of circuits to the destination (i.e. only counting the part of the call after it has been answered) | mbh |
answered_traffic | msc_call_destinations_raw.answered_traffic | FLOAT | Erlang | Conversational traffic to the destination (i.e. only including the part of the call after it has been answered) | mbh |
mean_holding_time | ({MSC.Neutral.GSM.destination.traffic} * {MSC.Neutral.GSM.destination.measurement_seconds}) / {MSC.Neutral.GSM.destination.total_calls} | FLOAT | Second | Mean holding time of circuits to the destination | mbh |
total_calls | msc_call_destinations_raw.total_calls | INTEGER | # | Number of calls to the destination | mbh |
traffic | msc_call_destinations_raw.traffic | FLOAT | Erlang | Traffic to the destination (including calls that have not been answered) | mbh |
The results of handovers passing through this MSC, either (a) to or from a different MSC, or (b) between two BSCs controlled by this MSC
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_data_coverage | getvalidity({MSC.Neutral.GSM.handover.interbsc_attempts}) | FLOAT | % | Data coverage | |
%_data_coverage | getvalidity({incoming_intermsc_attempts}) | FLOAT | % | ||
%_incoming_intermsc_failure | percentfail({MSC.Neutral.GSM.handover.incoming_intermsc_failures}, {MSC.Neutral.GSM.handover.incoming_intermsc_attempts}) | FLOAT | % | Percentage of incoming nter-MSC handovers that failed | mbh |
%_incoming_intermsc_success | percentok({MSC.Neutral.GSM.handover.incoming_intermsc_successes}, {MSC.Neutral.GSM.handover.incoming_intermsc_attempts}) | FLOAT | % | Percentage of incoming inter-MSC handovers that succeeded | mbh |
%_interbsc_failure | percentfail({MSC.Neutral.GSM.handover.interbsc_failures}, {MSC.Neutral.GSM.handover.interbsc_attempts}) | FLOAT | % | Percentage of inter-BSC handovers that failed | mbh |
%_interbsc_success | percentok({MSC.Neutral.GSM.handover.interbsc_successes}, {MSC.Neutral.GSM.handover.interbsc_attempts}) | FLOAT | % | Percentage of inter-BSC handovers that succeeded | mbh |
%_outgoing_intermsc_failure | percentfail({MSC.Neutral.GSM.handover.outgoing_intermsc_failures}, {MSC.Neutral.GSM.handover.outgoing_intermsc_attempts}) | FLOAT | % | Percentage of outgoing inter-MSC handovers that failed | mbh |
%_outgoing_intermsc_success | percentok({MSC.Neutral.GSM.handover.outgoing_intermsc_successes}, {MSC.Neutral.GSM.handover.outgoing_intermsc_attempts}) | FLOAT | % | Percentage of outgoing inter-MSC handovers that succeeded | mbh |
incoming_intermsc_attempts | msc_handover_results_raw.incoming_intermsc_attempts | INTEGER | # | Handover attempts coming in from another MSC (i.e. inter-MSC) | mbh |
incoming_intermsc_failures | msc_handover_results_raw.incoming_intermsc_failures | INTEGER | # | Failed incoming inter-MSC handover attempts (i.e. inter-MSC) | mbh |
incoming_intermsc_successes | msc_handover_results_raw.incoming_intermsc_successes | INTEGER | # | Successful incoming inter-MSC handover attempts (i.e. inter-MSC) | mbh |
interbsc_attempts | msc_handover_results_raw.interbsc_attempts | INTEGER | # | Attempted inter-BSC handovers controlled by this MSC (i.e. intra-MSC) | mbh |
interbsc_failures | msc_handover_results_raw.interbsc_failures | INTEGER | # | Failed inter-BSC handovers controlled by this MSC (i.e. intra-MSC) | mbh |
interbsc_successes | msc_handover_results_raw.interbsc_successes | INTEGER | # | Successful inter-BSC handovers controlled by this MSC (i.e. intra-MSC) | mbh |
outgoing_intermsc_attempts | msc_handover_results_raw.outgoing_intermsc_attempts | INTEGER | # | Handover attempts to another MSC (i.e. inter-MSC) | mbh |
outgoing_intermsc_failures | msc_handover_results_raw.outgoing_intermsc_failures | INTEGER | # | Failed outgoing inter-MSC handover attempts (i.e. inter-MSC) | mbh |
outgoing_intermsc_successes | msc_handover_results_raw.outgoing_intermsc_successes | INTEGER | # | Successful outgoing inter-MSC handover attempts (i.e. inter-MSC) | mbh |
The Paging activity to Mobiles in the BSS controlled by this MSC
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_data_coverage | getvalidity({global_pages}) | FLOAT | % | ||
%_global_response | percentok({MSC.Neutral.GSM.page.global_responses}, {MSC.Neutral.GSM.page.total_global_pages}) | FLOAT | % | Percentage of Global page responses | mbh |
%_global_unresponse | percentfail({MSC.Neutral.GSM.page.global_unresponses}, {MSC.Neutral.GSM.page.total_global_pages}) | FLOAT | % | Percentage of Global pages with no response | mbh |
%_local_response | percentok({MSC.Neutral.GSM.page.local_responses}, {MSC.Neutral.GSM.page.total_local_pages}) | FLOAT | % | Percentage of Local responses | mbh |
%_local_unresponse | percentfail({MSC.Neutral.GSM.page.local_unresponses}, {MSC.Neutral.GSM.page.total_local_pages}) | FLOAT | % | Percentage of Local pages with no response | mbh |
global_pages | msc_resource_pages_raw.global_pages | INTEGER | # | First Global paging messages sent | mbh |
global_repages | msc_resource_pages_raw.global_repages | INTEGER | # | Subsequent (repeat) Global paging messages sent | mbh |
global_responses | msc_resource_pages_raw.global_responses | INTEGER | # | Responses to Global paging messages | mbh |
global_unresponses | msc_resource_pages_raw.global_unresponses | INTEGER | # | Global paging messages that received no response | mbh |
local_pages | msc_resource_pages_raw.local_pages | INTEGER | # | First Local paging messages sent | mbh |
local_repages | msc_resource_pages_raw.local_repages | INTEGER | # | Subsequent (repeat) Local paging messages sent | mbh |
local_responses | msc_resource_pages_raw.local_responses | INTEGER | # | Responses to Local paging messages | mbh |
local_unresponses | msc_resource_pages_raw.local_unresponses | INTEGER | # | Local paging messages that received no response | mbh |
total_global_pages | msc_resource_pages_raw.total_global_pages | INTEGER | # | First and subsequent Global paging messages | mbh |
total_local_pages | msc_resource_pages_raw.total_local_pages | INTEGER | # | First and subsequent Local paging messages | mbh |
The usage of a Supplementary Service (SS) on an MSC. These are sometimes reported by the HLR, but are associated with an MSC in this data model
The performance data measurements for this KPI group are recorded against the combination of MSC and Supplementary_Service (service_id)
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_data_coverage | getvalidity({activates}) | FLOAT | % | ||
activates | msc_supplementary_services_raw.activates | INTEGER | # | Activations of the SS | mbh |
deactivates | msc_supplementary_services_raw.deactivates | INTEGER | # | Deactivations of the SS | mbh |
interrogations | msc_supplementary_services_raw.interrogations | INTEGER | # | Number of times that the SS was interrogated | mbh |
invocations | msc_supplementary_services_raw.invocations | INTEGER | # | Invocations of the SS | mbh |
The call-switching performance of the MSC for a all switched traffic types
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_answered_calls | percentok({MSC.Neutral.GSM.traffic.total_switched_traffic.answered_calls}, {MSC.Neutral.GSM.traffic.total_switched_traffic.call_attempts}) | FLOAT | % | Percentage of calls that were answered | mbh |
%_call_failure | percentfail({MSC.Neutral.GSM.traffic.total_switched_traffic.call_failures}, {MSC.Neutral.GSM.traffic.total_switched_traffic.call_attempts}) | FLOAT | % | Percentage of calls that failed (all reasons) | mbh |
%_call_success | percentok({MSC.Neutral.GSM.traffic.total_switched_traffic.call_successes}, {MSC.Neutral.GSM.traffic.total_switched_traffic.call_attempts}) | FLOAT | % | Percentage of calls that were set up | mbh |
%_data_coverage | getvalidity({MSC.Neutral.GSM.traffic.total_switched_traffic.traffic}) | FLOAT | % | Data coverage | |
answered_calls | group({MSC.Neutral.GSM.traffic.answered_calls}) | INTEGER | # | Calls that were answered | mbh |
call_attempts | group({MSC.Neutral.GSM.traffic.call_attempts}) | INTEGER | # | Call attempts for all switched Traffic Types | mbh |
call_failures | group({MSC.Neutral.GSM.traffic.call_failures}) | INTEGER | # | Calls that failed (all reasons) | mbh |
call_successes | group({MSC.Neutral.GSM.traffic.call_successes}) | INTEGER | # | Calls that were set up | mbh |
external_failed_calls | group({MSC.Neutral.GSM.traffic.external_failed_calls}) | INTEGER | # | Calls that failed due to errors beyond this entity or network | mbh |
internal_failed_calls | group({MSC.Neutral.GSM.traffic.internal_failed_calls}) | INTEGER | # | Calls that failed due to errors in this entity or network | mbh |
subscriber_error_calls | group({MSC.Neutral.GSM.traffic.subscriber_error_calls}) | INTEGER | # | Failed calls due to subscriber error | mbh |
traffic | group({MSC.Neutral.GSM.traffic.traffic}) | FLOAT | Erlang | Circuit occupancy for all switched Traffic Types | mbh |
The call-switching performance of the MSC for a particular traffic type
The performance data measurements for this KPI group are recorded against the combination of MSC and Traffic_Type (traffic_type_id)
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_answered_calls | percentok({MSC.Neutral.GSM.traffic.answered_calls}, {MSC.Neutral.GSM.traffic.call_attempts}) | FLOAT | % | Percentage of calls that were answered | mbh, mtbh |
%_call_failure | percentfail({MSC.Neutral.GSM.traffic.call_failures}, {MSC.Neutral.GSM.traffic.call_attempts}) | FLOAT | % | Percentage of calls that failed (all reasons) | mbh, mtbh |
%_call_success | percentok({MSC.Neutral.GSM.traffic.call_successes}, {MSC.Neutral.GSM.traffic.call_attempts}) | FLOAT | % | Percentage of calls that were set up | mbh, mtbh |
%_data_coverage | getvalidity({MSC.Neutral.GSM.traffic.call_attempts}) | FLOAT | % | Data coverage | |
%_data_coverage | getvalidity({answered_calls}) | FLOAT | % | ||
answered_calls | msc_traffic_raw.answered_calls | INTEGER | # | Calls that were answered | mbh, mtbh |
call_attempts | msc_traffic_raw.call_attempts | INTEGER | # | Call attempts in this Traffic Type | mbh, mtbh |
call_failures | msc_traffic_raw.call_failures | INTEGER | # | Calls that failed (all reasons) | mbh, mtbh |
call_successes | msc_traffic_raw.call_successes | INTEGER | # | Calls that were set up | mbh, mtbh |
external_failed_calls | msc_traffic_raw.external_failed_calls | INTEGER | # | Calls that failed due to errors beyond this entity or network | mbh, mtbh |
internal_failed_calls | msc_traffic_raw.internal_failed_calls | INTEGER | # | Calls that failed due to errors in this entity or network | mbh, mtbh |
subscriber_error_calls | msc_traffic_raw.subscriber_error_calls | INTEGER | # | Failed calls due to subscriber error | mbh, mtbh |
traffic | msc_traffic_raw.traffic | FLOAT | Erlang | Circuit occupancy for this Traffic Type | mbh, mtbh |
The performance (load or utilisation) of the CPU
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_data_coverage | getvalidity({load_pc}) | FLOAT | % | ||
load_pc | processor_cpu_raw.load_pc | FLOAT | % | Percentage load of the CPU from all non-idle activities (i.e. call processing, etc.) | pbh |
The forecast performance of the Route
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
capacity | tp_gsm_route_capacity_collect(route_if_id, ml_subst(gStartdate), tp_gsm_route_bh_traffic_end_date(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), ml_subst(gNumdays), "ml_subst(gGOS)", ml_property(system.property.dgos)) | FLOAT | Erlang | Forecast capacity or critical traffic level based upon a user supplied grade of service level | |
extra_circuits | nc_route.tp_gsm_route_bh_extra_circuits_forecast_value(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), "ml_subst(gGOS)") | INTEGER | # | Forecast extra circuits required | |
linear_exhaustion_date | DECODE((tp_gsm_route_bh_traffic_exhaustion_date(route_if_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_route_bh_traffic_exhaustion_date(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage), "ml_subst(gGOS)", ml_property(system.property.dgos),NULL))) | INTEGER | UnixTime | Forecast linear exhaustion date for the route | |
linear_regression_coefficient | nc_route.tp_gsm_route_bh_traffic_forecast_growth(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)) | FLOAT | # | Forecast linear regression coefficient | |
linear_regression_error | nc_route.tp_gsm_route_bh_traffic_regression_error(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)) | FLOAT | # | Forecast linear regression error | |
linear_traffic_growth | nc_route.tp_gsm_route_bh_traffic_forecast_growth(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)) | FLOAT | # | Forecast linear traffic growth | |
required_circuits | nc_route.tp_gsm_route_bh_required_circuits_forecast_value(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), "ml_subst(gGOS)") | INTEGER | # | Forecast number of circuits that can deliver the specified forecast grade of service for the offered traffic | |
traffic | nc_route.tp_gsm_route_bh_traffic_forecast_value(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), NULL) | FLOAT | Erlang | Forecast traffic on the route | |
utilisation | nc_route.tp_gsm_route_bh_utilisation_forecast_value(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), NULL) | FLOAT | % | Forecast utilisation |
The performance of the Route as seen from this end (Interface), reported by an MSC
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_blocked_circuits | percentfail({Route_IF.Neutral.GSM.transmission.blocked_circuits}, {Route_IF.Neutral.GSM.transmission.circuits}) | FLOAT | % | Percentage of circuits that are blocked or otherwise out of service | rbh |
%_bothway_answered | percentok({Route_IF.Neutral.GSM.transmission.bothway_answered_calls}, {Route_IF.Neutral.GSM.transmission.bothway_calls}) | FLOAT | % | Percentage of calls (incoming+outgoing) that were answered (Answer-Seize percentage) | rbh |
%_data_coverage | getvalidity({available_circuits}) | FLOAT | % | ||
%_incoming_answered | percentok({Route_IF.Neutral.GSM.transmission.incoming_answered_calls}, {Route_IF.Neutral.GSM.transmission.incoming_calls}) | FLOAT | % | Percentage of incoming calls that were answered (Answer-Seize percentage) | rbh, ribh |
%_outgoing_answered | percentok({Route_IF.Neutral.GSM.transmission.outgoing_answered_calls}, {Route_IF.Neutral.GSM.transmission.outgoing_calls}) | FLOAT | % | Percentage of outgoing calls that were answered (Answer-Seize percentage) | rbh, robh |
%_outgoing_congestions | percentfail({Route_IF.Neutral.GSM.transmission.outgoing_congestions}, {Route_IF.Neutral.GSM.transmission.bids}) | FLOAT | % | Percentage of outgoing calls that found all circuits busy | rbh, robh |
available_circuits | route_interface_transmission_raw.available_circuits | FLOAT | # | Number of unblocked, in-service circuits | rbh |
bids | route_interface_transmission_raw.bids | INTEGER | # | The number of attempts to seize a circuit (from this end) | rbh, robh |
blocked_circuits | route_interface_transmission_raw.blocked_circuits | FLOAT | # | Number of circuits that are blocked or otherwise out of service | rbh |
bothway_answered_calls | {Route_IF.Neutral.GSM.transmission.incoming_answered_calls} + {Route_IF.Neutral.GSM.transmission.outgoing_answered_calls} | INTEGER | # | Number of incoming+outgoing calls that were answered | rbh |
bothway_calls | {Route_IF.Neutral.GSM.transmission.incoming_calls} + {Route_IF.Neutral.GSM.transmission.outgoing_calls} | INTEGER | # | The number of incoming calls plus the number of outgoing calls | rbh |
bothway_traffic | {Route_IF.Neutral.GSM.transmission.incoming_traffic} + {Route_IF.Neutral.GSM.transmission.outgoing_traffic} | FLOAT | Erlang | Incoming+Outgoing traffic on the Route | rbh |
busy_time_pc | route_interface_transmission_raw.busy_time_pc | FLOAT | % | The percentage of time that all circuits were busy (i.e. couldn?t accept outgoing bids) | rbh |
capacity | criticaltraffic({Route_IF.Neutral.GSM.transmission.circuits},ml_property(system.property.dgos)) | FLOAT | Erlang | The capacity or critical traffic level based upon a user supplied grade of service level | rbh |
circuits | route_interface_transmission_raw.circuits | INTEGER | # | Number of circuits provisioned on the Route for incoming and or outgoing traffic | rbh |
extra_capacity_required | DECODE("ml_subst(gUser)","true","true",(DECODE((tp_gsm_route_bh_required_circuits_end_value(route_if_id, tp_gsm_route_bh_traffic_end_date(route_if_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage)), "ml_subst(gGOS)", ml_property(system.property.dgos))-tp_gsm_route_bh_circuits_end_value(route_if_id, tp_gsm_route_bh_traffic_end_date(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), NULL, NULL)),0,"false","true"))) | INTEGER | Erlang | Forecast extra capacity required | |
grade_of_service | gos({Route_IF.Neutral.GSM.transmission.available_circuits}, {Route_IF.Neutral.GSM.transmission.offered_traffic}) | FLOAT | % | The estimated Grade of Service (GoS) | rbh |
incoming_answered_calls | route_interface_transmission_raw.incoming_answered_calls | INTEGER | # | Number of incoming calls that were answered | rbh, ribh |
incoming_calls | route_interface_transmission_raw.incoming_calls | INTEGER | # | The number of incoming calls started (i.e. circuit seizures from the other end) | rbh, ribh |
incoming_mean_holding_time | ({Route_IF.Neutral.GSM.transmission.incoming_traffic} * {Route_IF.Neutral.GSM.transmission.measurement_seconds}) / {Route_IF.Neutral.GSM.transmission.incoming_calls} | FLOAT | Second | Mean holding time for incoming calls | rbh, ribh |
incoming_traffic | route_interface_transmission_raw.incoming_traffic | FLOAT | Erlang | Incoming traffic on the Route | rbh, ribh |
is_exhausted | DECODE(tp_gsm_route_bh_traffic_exhaustion_date(route_if_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage), "ml_subst(gGOS)", ml_property(system.property.dgos),NULL),NULL,"YES","NO") | INTEGER | Status | Forecasting flag indicating if route is exhausted | |
lost_traffic | {Route_IF.Neutral.GSM.transmission.offered_traffic} - {Route_IF.Neutral.GSM.transmission.bothway_traffic} | FLOAT | Erlang | The estimated traffic lost to the route | rbh |
number_of_samples | nc_route.tp_gsm_route_bh_traffic_num_samples(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)) | INTEGER | # | Forecasting number of data samples | |
offered_traffic | offeredtraffic({Route_IF.Neutral.GSM.transmission.available_circuits}, ({Route_IF.Neutral.GSM.transmission.bothway_traffic})) | FLOAT | Erlang | The estimated traffic offered to the Route | rbh |
offered_utilisation | percentok({Route_IF.Neutral.GSM.transmission.offered_traffic}, {Route_IF.Neutral.GSM.transmission.circuits}) | FLOAT | % | The estimated traffic lost to the route | rbh |
outgoing_answered_calls | route_interface_transmission_raw.outgoing_answered_calls | INTEGER | # | Number of outgoing calls that were answered | rbh, robh |
outgoing_calls | route_interface_transmission_raw.outgoing_calls | INTEGER | # | The number of successful bids (seizures) of a circuit | rbh, robh |
outgoing_congestion_time | route_interface_transmission_raw.outgoing_congestion_time | INTEGER | Second | The total time during the measurement period that all circuits on the Route were busy (i.e. couldn?t accept outgoing bids) | rbh, robh |
outgoing_congestions | route_interface_transmission_raw.outgoing_congestions | INTEGER | # | The number of bids that find that all circuits are busy. Such bids may either fail or overflow onto another Circuit Group | rbh, robh |
outgoing_mean_holding_time | ({Route_IF.Neutral.GSM.transmission.outgoing_traffic} * {Route_IF.Neutral.GSM.transmission.measurement_seconds}) / {Route_IF.Neutral.GSM.transmission.outgoing_calls} | FLOAT | Second | Mean holding time for outgoing calls | rbh, robh |
outgoing_traffic | route_interface_transmission_raw.outgoing_traffic | FLOAT | Erlang | Outgoing traffic on the Route | rbh, robh |
required_circuits | requiredcircuits({Route_IF.Neutral.GSM.transmission.offered_traffic}, ml_property(system.property.dgos)) | INTEGER | # | The smallest integer number of circuits that can deliver the specified design grade of service for the offered traffic | rbh |
required_extra_circuits | {Route_IF.Neutral.GSM.transmission.required_circuits} - {Route_IF.Neutral.GSM.transmission.circuits} | INTEGER | # | The smallest integer number of extra circuits required that can deliver the specified design grade of service for the offered traffic | rbh |
traffic | (route_interface_transmission_week.rbh_incoming_traffic + rbh_incoming_traffic) | FLOAT | Erlang | Forecasting traffic value based on weekly summary data | rbh |
The performance of an individual Signalling Link
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_available | percentok({Signalling_Link.Neutral.GSM.link.available_time}, ({Signalling_Link.Neutral.GSM.link.available_time} + {Signalling_Link.Neutral.GSM.link.unavailable_time})) | FLOAT | % | Percentage of time (during the measurement period) that the Link was available | slrbh, sltbh |
%_data_coverage | getvalidity({available_time}) | FLOAT | % | ||
%_local_inhibition_time | percentfail({Signalling_Link.Neutral.GSM.link.local_inhibition_time}, ({Signalling_Link.Neutral.GSM.link.available_time} + {Signalling_Link.Neutral.GSM.link.unavailable_time})) | FLOAT | % | Percentage of time (during the measurement period) that the link was inhibited due to local management actions | slrbh, sltbh |
%_remote_inhibition_time | percentfail({Signalling_Link.Neutral.GSM.link.remote_inhibition_time}, ({Signalling_Link.Neutral.GSM.link.available_time} + {Signalling_Link.Neutral.GSM.link.unavailable_time})) | FLOAT | % | Percentage of time (during the measurement period) that the link was inhibited due to remote management actions | slrbh, sltbh |
%_unavailable | percentfail({Signalling_Link.Neutral.GSM.link.unavailable_time}, ({Signalling_Link.Neutral.GSM.link.available_time} + {Signalling_Link.Neutral.GSM.link.unavailable_time})) | FLOAT | % | Percentage of time (during the measurement period) that the Link was unavailable | slrbh, sltbh |
available_time | ss7_link_availability_raw.available_time | INTEGER | Second | Amount of time the Link was available during the measurement period | slrbh, sltbh |
changebacks | ss7_link_performance_raw.changebacks | INTEGER | # | Local automatic changebacks | slrbh, sltbh |
changeovers | ss7_link_performance_raw.changeovers | FLOAT | # | Local automatic changeovers | slrbh, sltbh |
congestion_losses | ss7_link_utilisation_raw.congestion_losses | INTEGER | # | Number of congestion events that resulted in lost MSUs | slrbh, sltbh |
congestion_time | ss7_link_utilisation_raw.congestion_time | INTEGER | Second | Amount of time during which the Link was congested | slrbh, sltbh |
congestions | ss7_link_utilisation_raw.congestions | INTEGER | # | Number of Link congestion indications | slrbh, sltbh |
discarded_msus | ss7_link_utilisation_raw.discarded_msus | INTEGER | # | Number of MSUs that were discarded because of Link congestion | slrbh, sltbh |
failures_abr | ss7_link_performance_raw.failures_abr | INTEGER | # | Link failures due to receipt of an abnormal FIBR or BSNR | slrbh, sltbh |
failures_alignment | ss7_link_performance_raw.failures_alignment | INTEGER | # | Link failures due to alignment or proving failure | slrbh, sltbh |
failures_congestion | ss7_link_performance_raw.failures_congestion | INTEGER | # | Link failures due to the link being congested for too long | slrbh, sltbh |
failures_delay | ss7_link_performance_raw.failures_delay | INTEGER | # | Link failures due to excessive delay on ACK | slrbh, sltbh |
failures_error_rate | ss7_link_performance_raw.failures_error_rate | INTEGER | # | Link failures due to an excessive error rate | slrbh, sltbh |
failures | ss7_link_performance_raw.failures | INTEGER | # | Link failures (any reason) | slrbh, sltbh |
in_service_time | ss7_link_performance_raw.in_service_time | FLOAT | Second | The total time the Link has been up (since last reset) | slrbh, sltbh |
incoming_traffic | ss7_link_utilisation_raw.incoming_traffic | INTEGER | # | Incoming traffic received | slrbh |
incoming_utilisation | percentok((8 * {Signalling_Link.Neutral.GSM.link.incoming_traffic}), {Signalling_Link.Neutral.GSM.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 used | slrbh |
link_failure_time | ss7_link_availability_raw.link_failure_time | INTEGER | Second | Amount of time the Link was unavailable because it had failed | slrbh, sltbh |
local_busy_time | ss7_link_availability_raw.local_busy_time | INTEGER | Second | Amount of local busy time | slrbh, sltbh |
local_inhibition_time | ss7_link_availability_raw.local_inhibition_time | INTEGER | Second | Amount of time the link was inhibited due to local management actions | slrbh, sltbh |
outgoing_traffic | ss7_link_utilisation_raw.outgoing_traffic | INTEGER | # | Outgoing traffic sent | sltbh |
outgoing_utilisation | percentok((8 * {Signalling_Link.Neutral.GSM.link.outgoing_traffic}), {Signalling_Link.Neutral.GSM.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 used | sltbh |
received_msus | ss7_link_utilisation_raw.received_msus | INTEGER | # | Number of Message Signal Units (MSUs) received | slrbh |
received_neg_ack | ss7_link_performance_raw.received_neg_ack | INTEGER | # | Number of negative acknowledgements (ACK) received | slrbh |
received_sif_sios | ss7_link_utilisation_raw.received_sif_sios | INTEGER | # | Number of SIF and SIO octets received | slrbh |
received_su_errors | ss7_link_performance_raw.received_su_errors | INTEGER | # | Number of Signalling Units (Sus) received with errors | slrbh |
remote_inhibition_time | ss7_link_availability_raw.remote_inhibition_time | INTEGER | Second | Amount of time the link was inhibited due to remote management actions | slrbh, sltbh |
remote_outage_time | ss7_link_availability_raw.remote_outage_time | INTEGER | Second | Amount of time the Link was unavailable because of a remote Processor outage | slrbh, sltbh |
remote_outages | ss7_link_availability_raw.remote_outages | INTEGER | # | Number of remote Processor outages | slrbh, sltbh |
restores | ss7_link_performance_raw.restores | INTEGER | # | Number of times the link was restored | slrbh, sltbh |
retransmitted_sif_sios | ss7_link_utilisation_raw.retransmitted_sif_sios | INTEGER | # | Number of SIF and SIO octets re-transmitted | sltbh |
transmitted_msus | ss7_link_utilisation_raw.transmitted_msus | INTEGER | # | Number of Message Signal Units (MSUs) transmitted | sltbh |
transmitted_sif_sios | ss7_link_utilisation_raw.transmitted_sif_sios | INTEGER | # | Number of SIF and SIO octets transmitted | sltbh |
unavailable_time | ss7_link_availability_raw.unavailable_time | INTEGER | Second | Amount of time the Link was unavailable (for any reason) | slrbh, sltbh |
The forecast performance of a set of Signalling Links
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
capacity | tp_gsm_linkset_capacity_collect(ss7_linkset_id, ml_subst(gStartdate), tp_gsm_linkset_bh_incoming_traffic_end_date(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), ml_subst(gNumdays), "ml_subst(gNMT)", ml_property(system.property.dnmt)) | FLOAT | Erlang | Forecast maximum nominal Erlangs per linkset | |
in_failure_capacity | tp_gsm_linkset_in_failure_capacity_collect(ss7_linkset_id, ml_subst(gStartdate), tp_gsm_linkset_bh_incoming_traffic_end_date(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), ml_subst(gNumdays), "ml_subst(gNMT)", ml_property(system.property.dnmt)) | FLOAT | Erlang | Forecast capacity for the entire linkset during design link failures | |
linear_exhaustion_date | nc_ss7_linkset.DECODE((tp_gsm_linkset_bh_incoming_traffic_exhaustion_date(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(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage), "ml_subst(gNMT)",ml_subst(gMIT),ml_subst(gLIF)))) | INTEGER | UnixTime | Forecast linear exhaustion date | |
linear_regression_coefficient | nc_ss7_linkset.tp_gsm_linkset_bh_incoming_traffic_forecast_growth(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)) | FLOAT | # | Forecast linear regression coefficient | |
linear_regression_error | nc_ss7_linkset.tp_gsm_linkset_bh_incoming_traffic_regression_error(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)) | FLOAT | # | Forecast linear regression error | |
linear_traffic_growth | nc_ss7_linkset.tp_gsm_linkset_bh_incoming_traffic_forecast_growth(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)) | FLOAT | # | Froecast linear traffic growth | |
traffic | nc_ss7_linkset.tp_gsm_linkset_bh_incoming_traffic_forecast_value(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), NULL) | FLOAT | # | Forecast traffic value |
The performance of a set of Signalling Links
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_available | percentok({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 available | slsrbh, slstbh |
%_data_coverage | getvalidity({Signalling_LinkSet.Neutral.GSM.signalling_linkset.failures}) | FLOAT | % | Data Coverage | |
%_data_coverage | getvalidity({available_time}) | FLOAT | % | ||
%_unavailable | percentfail({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 unavailable | slsrbh, slstbh |
available_time | ss7_linkset_raw.available_time | INTEGER | Second | Time for which the LinkSet was available | slsrbh, slstbh |
capacity | criticaltraffic({Signalling_LinkSet.Neutral.GSM.signalling_linkset.links}, ml_property(system.property.dnmt)) | FLOAT | Erlang | Maximum nominal Erlangs per linkset | slsrbh, slstbh |
failures | ss7_linkset_raw.failures | INTEGER | # | Number of LinkSet failures | slsrbh, slstbh |
in_failure_capacity | ss7_linkset_week.criticaltraffic(count_links, "ml_subst(gMIT)") | FLOAT | Erlang | Capacity for the entire linkset during design link failures | |
incoming_traffic | group({Signalling_Link.Neutral.GSM.link.incoming_traffic}) | INTEGER | # | Total Incoming traffic received | slsrbh |
incoming_utilisation | percentok((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 used | slsrbh |
is_exhausted | nc_ss7_linkset.DECODE(tp_gsm_linkset_bh_incoming_traffic_exhaustion_date(ss7_linkset_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage), "ml_subst(gNMT)",ml_subst(gMIT),ml_subst(gLIF)),NULL,"YES","NO") | INTEGER | Status | Forecast flag indicating if linkset capacity is exhausted | |
links | count({Signalling_Link.Neutral.GSM.link.ss7_link_id}) | INTEGER | # | Number of Links in the LinkSet | slsrbh, slstbh |
mean_%_available | percentok({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 LinkSet | slsrbh, slstbh |
mean_%_unavailable | percentfail({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 LinkSet | slsrbh, slstbh |
mean_available_time | group({Signalling_LinkSet.Neutral.GSM.signalling_linkset.available_time}) | FLOAT | Second | Average Link available time for all the Links in the Linkset | slsrbh, slstbh |
mean_incoming_traffic | {Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_traffic}/count(*) | FLOAT | # | Average Incoming traffic received per link | slsrbh |
mean_outgoing_traffic | {Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffic}/count(*) | FLOAT | # | Average Outgoing traffic sent per link | slstbh |
mean_unavailable_time | group({Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time}) | FLOAT | Second | Average Link available time for all the Links in the Linkset | slsrbh, slstbh |
msus | tp_gsm_linkset_bh_received_msus_end_value(ss7_linkset_id, tp_gsm_linkset_bh_incoming_traffic_end_date(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_samples | nc_ss7_linkset.tp_gsm_linkset_bh_incoming_traffic_num_samples(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)) | INTEGER | # | Forecast number of samples | |
outgoing_traffic | group({Signalling_Link.Neutral.GSM.link.outgoing_traffic}) | INTEGER | # | Total Outgoing traffic sent | slstbh |
outgoing_utilisation | percentok((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 used | slstbh |
received_msus | ss7_link_utilisation_raw.received_msus | INTEGER | # | Number of Message Signal Units (MSUs) received | slsrbh |
received_sif_sios | ss7_link_utilisation_raw.received_sif_sios | INTEGER | # | Number of SIF and SIO octets received | slsrbh |
total_failures | group({Signalling_Link.Neutral.GSM.link.failures}) | INTEGER | # | Total Failures of all Links in the LinkSet | slsrbh, slstbh |
traffic | INTEGER | # | Forecast total traffic | slsrbh, slstbh | |
transmitted_msus | ss7_link_utilisation_raw.transmitted_msus | INTEGER | # | Number of Message Signal Units (MSUs) transmitted | slstbh |
transmitted_sif_sios | ss7_link_utilisation_raw.transmitted_sif_sios | INTEGER | # | Number of SIF and SIO octets transmitted | slstbh |
unavailable_time | ss7_linkset_raw.unavailable_time | INTEGER | Second | Time for which the LinkSet was unavailable | slsrbh, slstbh |
The signalling network?s performance, as seen from a Signalling Point
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_data_coverage | getvalidity({adjacent_sp_inaccessible}) | FLOAT | % | ||
adjacent_sp_inaccessible_time | ss7_point_raw.adjacent_sp_inaccessible_time | INTEGER | Second | Time for which an adjacent Signalling Point was inaccessible | |
adjacent_sp_inaccessible | ss7_point_raw.adjacent_sp_inaccessible | INTEGER | # | Number of times an adjacent Signalling Point became inaccessible | |
discarded_msus | ss7_point_raw.discarded_msus | INTEGER | # | Number of Message Signal Units (MSUs) discarded due to routing errors | |
received_tfcs | ss7_point_raw.received_tfcs | INTEGER | # | Number of Transfer-Control (TFC) signals received, indicating RouteSet congestion |
The performance of a set of Signalling Routes
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_available | percentok({Signalling_RouteSet.Neutral.GSM.routeset.available_time}, ({Signalling_RouteSet.Neutral.GSM.routeset.available_time} + {Signalling_RouteSet.Neutral.GSM.routeset.unavailable_time})) | FLOAT | % | Percentage of time (during the measurement period) that the RouteSet was available | |
%_data_coverage | getvalidity({available_time}) | FLOAT | % | ||
%_unavailable | percentfail({Signalling_RouteSet.Neutral.GSM.routeset.available_time}, ({Signalling_RouteSet.Neutral.GSM.routeset.available_time} + {Signalling_RouteSet.Neutral.GSM.routeset.unavailable_time})) | FLOAT | % | Percentage of time (during the measurement period) that the RouteSet was unavailable | |
available_time | ss7_routeset_raw.available_time | INTEGER | Second | Time for which the RouteSet was available | |
failures | ss7_routeset_raw.failures | INTEGER | # | Number of RouteSet failures | |
unavailable_time | ss7_routeset_raw.unavailable_time | INTEGER | Second | Time for which the RouteSet was unavailable |
The Mobility management activity (e.g. Location Area updates) in the BSS controlled by this VLR
KPI Name | Expression | Data Type | Units | Description | Additional Summaries |
---|---|---|---|---|---|
%_data_coverage | getvalidity({id_request_attempts}) | FLOAT | % | ||
%_id_request_failure | percentfail({VLR.Neutral.GSM.mobility.id_request_failures}, {VLR.Neutral.GSM.mobility.id_request_attempts}) | FLOAT | % | Percentage of failed identification requests to PVLR | mbh, vbh |
%_id_request_success | percentok({VLR.Neutral.GSM.mobility.id_request_successes}, {VLR.Neutral.GSM.mobility.id_request_attempts}) | FLOAT | % | Percentage of successful identification requests to PVLR | mbh, vbh |
%_imsi_attach_failure | percentfail({VLR.Neutral.GSM.mobility.imsi_attach_failures}, {VLR.Neutral.GSM.mobility.imsi_attach_attempts}) | FLOAT | % | Percentage of failed IMSI attach attempts | mbh, vbh |
%_imsi_attach_success | percentok({VLR.Neutral.GSM.mobility.imsi_attach_successes}, {VLR.Neutral.GSM.mobility.imsi_attach_attempts}) | FLOAT | % | Percentage of successful IMSI attach attempts | mbh, vbh |
%_lac_update_failure | percentfail({VLR.Neutral.GSM.mobility.lac_update_failures}, {VLR.Neutral.GSM.mobility.lac_update_attempts}) | FLOAT | % | Percentage of failed Location Area updates | mbh, vbh |
%_lac_update_success | percentok({VLR.Neutral.GSM.mobility.lac_update_successes}, {VLR.Neutral.GSM.mobility.lac_update_attempts}) | FLOAT | % | Percentage of successful Location Area updates | mbh, vbh |
%_vlr_update_failure | percentfail({VLR.Neutral.GSM.mobility.vlr_update_failures}, {VLR.Neutral.GSM.mobility.vlr_update_attempts}) | FLOAT | % | Percentage of Intra-VLR Location Area update failures | mbh, vbh |
%_vlr_update_success | percentok({VLR.Neutral.GSM.mobility.vlr_update_successes}, {VLR.Neutral.GSM.mobility.vlr_update_attempts}) | FLOAT | % | Percentage of Intra-VLR Location Area update successes | mbh, vbh |
id_request_attempts | vlr_resource_mobility_raw.id_request_attempts | INTEGER | # | Identification requests to PVLR | mbh, vbh |
id_request_failures | vlr_resource_mobility_raw.id_request_failures | INTEGER | # | Failed identification requests to PVLR | mbh, vbh |
id_request_successes | vlr_resource_mobility_raw.id_request_successes | INTEGER | # | Successful identification requests to PVLR | mbh, vbh |
imsi_attach_attempts | vlr_resource_mobility_raw.imsi_attach_attempts | INTEGER | # | IMSI attach attempts | mbh, vbh |
imsi_attach_failures | vlr_resource_mobility_raw.imsi_attach_failures | INTEGER | # | Failed IMSI attach attempts | mbh, vbh |
imsi_attach_successes | vlr_resource_mobility_raw.imsi_attach_successes | INTEGER | # | Successful IMSI attach attempts | mbh, vbh |
imsi_attach_updates | vlr_resource_mobility_raw.imsi_attach_updates | INTEGER | # | Updates due to IMSI attach | mbh, vbh |
imsi_detaches | vlr_resource_mobility_raw.imsi_detaches | INTEGER | # | IMSI detach events | mbh, vbh |
lac_update_attempts | vlr_resource_mobility_raw.lac_update_attempts | INTEGER | # | Location Area update attempts | mbh, vbh |
lac_update_failures | vlr_resource_mobility_raw.lac_update_failures | INTEGER | # | Failed Location Area updates | mbh, vbh |
lac_update_successes | vlr_resource_mobility_raw.lac_update_successes | INTEGER | # | Successful Location Area updates | mbh, vbh |
new_la_updates | vlr_resource_mobility_raw.new_la_updates | INTEGER | # | Updates for a new Location Area | mbh, vbh |
periodic_updates | vlr_resource_mobility_raw.periodic_updates | INTEGER | # | Periodic updates | mbh, vbh |
vlr_subscribers | vlr_resource_mobility_raw.vlr_subscribers | INTEGER | # | Subscribers in this VLR | mbh, vbh |
vlr_update_attempts | vlr_resource_mobility_raw.vlr_update_attempts | INTEGER | # | Intra-VLR Location Area update attempts | mbh, vbh |
vlr_update_failures | vlr_resource_mobility_raw.vlr_update_failures | INTEGER | # | Intra-VLR Location Area update failures | mbh, vbh |
vlr_update_successes | vlr_resource_mobility_raw.vlr_update_successes | INTEGER | # | Intra-VLR Location Area update successes | mbh, vbh |
vlr_visitors | vlr_resource_mobility_raw.vlr_visitors | INTEGER | # | Visitors from other PLMNs in this VLR | mbh, vbh |
This section lists the hierarchy ("NC") tables that are included in this technology pack's database schema.
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
hlr_id | VARCHAR(50) |
[HLR] NODEID [USHM] EXCH_ID [ACHLR] hlr_id |
region_id | VARCHAR(50) |
[HLR] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [ACHLR] region_id |
network_id | VARCHAR(50) |
[HLR] "PLMN" [USHM] "PLMN" [ACHLR] network_id |
timestamp | INTEGER | |
endstamp | INTEGER | |
vendor_id | VARCHAR(50) |
[HLR] "Alcatel" [USHM] "Siemens" [ACHLR] "Nokia" |
hlr_name | VARCHAR(255) |
[HLR] NODEID [USHM] EXCH_ID [ACHLR] hlr_id |
hlr_version | VARCHAR(50) |
[ACHLR] "M13.5" |
technology | VARCHAR(50) |
[USHM] "GSM" [ACHLR] "GSM" |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
lac_id | VARCHAR(50) |
[NLAC] Obj2 & "-" & Obj3 [TRZ] locationAreaCode [VLR_LAC] rank [USLM] LACID [VLRLAC] msc_id&"-"&lac_id |
msc_id | VARCHAR(50) |
[NLAC] Obj2 [TRZ] lookup("nc_cell","msc_id",utime(START_DATE & TIME,"%d %b %Y %R"), cellIdentity) [VLR_LAC] NODEID [USLM] EXCH_ID [VLRLAC] msc_id |
region_id | VARCHAR(50) |
[NLAC] "Provided by customer" [TRZ] lookup("nc_cell","region_id",utime(START_DATE & TIME,"%d %b %Y %R"), cellIdentity) [VLR_LAC] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [USLM] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID) [VLRLAC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
network_id | VARCHAR(50) |
[NLAC] "Provided by customer" [TRZ] lookup("nc_cell","network_id",utime(START_DATE & TIME,"%d %b %Y %R"), cellIdentity) [VLR_LAC] "PLMN" [USLM] "PLMN" [VLRLAC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
timestamp | INTEGER | |
endstamp | INTEGER | |
vendor_id | VARCHAR(50) |
[NLAC] "Alcatel" [TRZ] "Nortel" [VLR_LAC] "Alcatel" [USLM] "Siemens" [VLRLAC] "Nokia" |
lac_name | VARCHAR(255) |
[NLAC] Obj2 & "-" & Obj3 [TRZ] locationAreaCode [VLR_LAC] rank [USLM] LACID [VLRLAC] msc_id&"-"&lac_id |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
msc_id | VARCHAR(50) |
[CML_GS_GLOBAL] "MSC"&MSCID [VLR] NODEID [RCF_SS] NODEID [msc_traf] NODEID [DEST] NODEID [DEST] EXCH_ID [USSM] EXCH_ID [USMM] EXCH_ID [TC] msc_id |
region_id | VARCHAR(50) |
[CML_GS_GLOBAL] "Provided by customer" [VLR] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [msc_traf] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [DEST] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [USSM] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID) [USMM] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID) [TC] region_id |
network_id | VARCHAR(50) |
[CML_GS_GLOBAL] "Provided by customer" [VLR] "PLMN" [msc_traf] "PLMN" [DEST] "PLMN" [DEST] "PLMN" [USMM] "PLMN" [TC] network_id |
timestamp | INTEGER | |
endstamp | INTEGER | |
vendor_id | VARCHAR(50) |
[CML_GS_GLOBAL] "Alcatel" [VLR] "Alcatel" [msc_traf] "Alcatel" [DEST] "Alcatel" [DEST] "Siemens" [USMM] "Siemens" [TC] "Nokia" |
msc_version | VARCHAR(50) |
[CML_GS_GLOBAL] "Provided by customer" [VLR] "R6" [msc_traf] "R6" [DEST] "R6" [DEST] "SR11" [USMM] "SR11" [TC] "M13.5" |
msc_name | VARCHAR(255) |
[CML_GS_GLOBAL] "Provided by customer" [VLR] NODEID [msc_traf] NODEID [DEST] NODEID [DEST] EXCH_ID [USMM] EXCH_ID [TC] msc_id |
msc_type | VARCHAR(50) |
[CML_GS_GLOBAL] "Provided by customer" [TC] "MSC" |
technology | VARCHAR(50) |
[CML_GS_GLOBAL] "GSM" [USMM] "GSM" [TC] "GSM" |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
network_id | VARCHAR(50) |
[msc_traf] "PLMN" [TC] network_id |
timestamp | INTEGER | |
endstamp | INTEGER | |
network_type | VARCHAR(50) |
[TC] "MSC" |
default_link_speed | VARCHAR(50) |
[TC] "Populated by the customer" |
network_name | VARCHAR(255) |
[msc_traf] "PLMN" [TC] network_id |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
processor_id | VARCHAR(50) |
[BSC] BSC &"/"& CPUTYPE &"-"& ID [CPUE] BSC &"/"& CPUTYPE &"-"& ID [dproc_statistics] nodeid&"/"&procid [gproc_statistics] sitename&"/"&procid [PROC] NODEID&"/"&rank [P_NBSC_LOAD] NODEID & "/" & OBJ_NAME & "-" & OBJ_INDEX [PROC] if MEASURE_ID="CPXX" then EXCH_ID&"-"&NODEID else if MEASURE_ID="GPXX" then EXCH_ID&"-"<G else EXCH_ID [CLOM] msc_id &"-"& unit_id [CLOH] hlr_id &"-"& unit_id |
node_id | VARCHAR(50) |
[CPUE] BSC [dproc_statistics] nodeid [PROC] NODEID [P_NBSC_LOAD] NODEID [PROC] EXCH_ID [CLOM] msc_id [CLOH] hlr_id |
region_id | VARCHAR(50) |
[CPUE] lookup("nc_bsc","region_id",utime(START_DATE & TIME,"%d %b %Y %R"), BSC) [dproc_statistics] lookup("nc_bsc","region_id",utime(STRINGYMD0_0 & start,"%d %b %Y %R"), nodeid) [PROC] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [P_NBSC_LOAD] REGION [PROC] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID) [CLOM] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) [CLOH] lookup("nc_hlr","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),hlr_id) |
network_id | VARCHAR(50) |
[CPUE] lookup("nc_bsc","network_id",utime(START_DATE & TIME,"%d %b %Y %R"), BSC) [dproc_statistics] lookup("nc_bsc","network_id",utime(STRINGYMD0_0 & start ,"%d %b %Y %R"), nodeid) [PROC] "PLMN" [P_NBSC_LOAD] NETWORK [PROC] "PLMN" [CLOM] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) [CLOH] lookup("nc_hlr","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),hlr_id) |
timestamp | INTEGER | |
endstamp | INTEGER | |
node_name | VARCHAR(255) |
[CPUE] bscName [dproc_statistics] lookup("nc_bsc","bsc_name",utime(STRINGYMD0_0 & start,"%d %b %Y %R"), nodeid) [PROC] NODEID [P_NBSC_LOAD] NODEID [PROC] lookup("nc_msc","msc_name", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID) [CLOM] msc_id [CLOH] hlr_id |
node_type | VARCHAR(50) |
[CPUE] "BSC" [dproc_statistics] "DataPrc" [gproc_statistics] "GenericPrc" [PROC] "HLR" [P_NBSC_LOAD] "BSC" [PROC] "MSC" [CLOM] "MSC" [CLOH] "HLR" |
processor_name | VARCHAR(255) |
[CPUE] BSC &"/"& CPUTYPE &"-"& ID [dproc_statistics] nodeid&"/"&procid [PROC] NODEID&"/"&rank [P_NBSC_LOAD] NODEID & "/" & OBJ_NAME & "-" & OBJ_INDEX [PROC] if MEASURE_ID="CPXX" then EXCH_ID&"-"&NODEID else if MEASURE_ID="GPXX" then EXCH_ID&"-"<G else EXCH_ID [CLOM] msc_id &"-"& unit_id [CLOH] hlr_id &"-"& unit_id |
processor_type | VARCHAR(50) |
[CPUE] "CPUE" [CLOM] "computer_unit" [CLOH] "computer_unit" |
technology | VARCHAR(50) |
[CPUE] "GSM" [CLOM] "GSM" [CLOH] "GSM" |
vendor | VARCHAR(50) |
[CPUE] "Nortel" [CLOM] "Nokia" [CLOH] "Nokia" |
processor_version | VARCHAR(50) |
[CPUE] Manually populated by customer or "V15" [CLOM] "M13.5" [CLOH] "M13.5" |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
region_id | VARCHAR(50) |
[msc_traf] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [TC] region_id |
network_id | VARCHAR(50) |
[msc_traf] "PLMN" [TC] network_id |
timestamp | INTEGER | |
endstamp | INTEGER | |
region_name | VARCHAR(255) |
[msc_traf] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [TC] region_id |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
route_if_id | VARCHAR(50) |
[TRUNKGROUP] "MSC"&MSCID&"-"&OBJECTNAME [class_f] NODEID&"/"&routeid [TGRP] EXCH_ID & "-" & TGNO [CGR] msc_id&"/"&cgr_id |
source_id | VARCHAR(50) |
[TRUNKGROUP] "MSC"&MSCID [class_f] NODEID [TGRP] EXCH_ID [CGR] msc_id |
target_id | VARCHAR(50) |
[TRUNKGROUP] OBJECTNAME [class_f] routeid |
region_id | VARCHAR(50) |
[TRUNKGROUP] lookup("nc_msc","region_id",utime(START_DATE & START_TIME,"%d %b %Y %R"),"MSC"&MSCID) [class_f] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [TGRP] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID) [CGR] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
network_id | VARCHAR(50) |
[TRUNKGROUP] "PLMN" [class_f] "PLMN" [TGRP] "PLMN" [CGR] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
timestamp | INTEGER | |
endstamp | INTEGER | |
source_name | VARCHAR(255) |
[TRUNKGROUP] "MSC"&MSCID [TGRP] lookup("nc_msc","msc_name", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID) [CGR] msc_id |
target_name | VARCHAR(255) |
[TRUNKGROUP] OBJECTNAME |
source_type | VARCHAR(50) |
[TRUNKGROUP] "MSC" [TGRP] "MSC" [CGR] "MSC" |
target_type | VARCHAR(50) |
[TRUNKGROUP] "Provided by customer" |
route_type | VARCHAR(50) |
[TRUNKGROUP] "Provided by customer" [class_f] routetype |
route_direction | VARCHAR(50) |
[TRUNKGROUP] "Provided by customer" [class_f] if dir = "M" then "BothWay" else if dir = "A" then "Incoming" else "Outgoing" [TGRP] if OPMODE = "OG" then "Outgoing" else if OPMODE = "IC" then "Incoming" else if OPMODE = "B" then "BothWay" else "None" [CGR] if CGRDIR_ID = 2 then "Outgoing" else if CGRDIR_ID = 1 then "Incoming" else if CGRDIR_ID = 3 then "Bothway" else "Unknown" |
is_trunk | VARCHAR(50) |
[TRUNKGROUP] "True" [class_f] "True" [TGRP] "True" [CGR] "TRUE" |
is_poi | VARCHAR(50) |
[TRUNKGROUP] "True" [class_f] "True" [TGRP] "True" [CGR] "TRUE" |
route_if_name | VARCHAR(255) |
[TRUNKGROUP] "MSC"&MSCID&"-"&OBJECTNAME [class_f] NODEID&"/"&routeid [TGRP] EXCH_ID&"-"&TGNO [CGR] msc_id&"/"&cgr_id |
source_technology | VARCHAR(50) |
[TRUNKGROUP] "Provided by customer" [TGRP] "MSC" [CGR] "GSM" |
target_technology | VARCHAR(50) |
[TRUNKGROUP] "Provided by customer" [CGR] "GSM" |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
ss7_link_id | VARCHAR(50) |
[SignallingLink] From vendor neutral loadmaps in vendor specific Tech Packs, or defined by the customer [mtl_statistics] nodeid&"/"&linkid [SIGN] NODEID&"/"&linksetid&"/"&linkcode [sgnl_load] NODEID&"/"&linksetid&"/"&linkcode [C7GOC7LL] moi & "-" & Linksetname [MTPMSC] msc_id &"-"& sln_id |
ss7_linkset_id | VARCHAR(50) |
[mtl_statistics] "TBD" [SIGN] NODEID&"/"&linksetid [sgnl_load] NODEID&"/"&linksetid [C7GOC7LL] moi0&"."&moi1&"."&moi2 [MTPMSC] msc_id &"-"& snet_id &"-"& spc_id &"-"& slsn_id |
ss7_point_id | VARCHAR(50) |
[SIGN] NODEID [sgnl_load] NODEID [C7GOC7LL] lookup("nc_ss7_routeset","ss7_point_id", utime(START_DATE & TIME,"%d %b %y %R"), EXCH_ID) [MTPMSC] msc_id &"-"& snet_id &"-"& spc_id |
node_id | VARCHAR(50) |
[mtl_statistics] nodeid [SIGN] NODEID [sgnl_load] NODEID [C7GOC7LL] EXCH_ID [MTPMSC] msc_id |
region_id | VARCHAR(50) |
[mtl_statistics] lookup("nc_bsc","region_id",utime(STRINGYMD0_0 & start,"%d %b %Y %R"), nodeid) [SIGN] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [sgnl_load] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [C7GOC7LL] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-duration, moi0) [MTPMSC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
network_id | VARCHAR(50) |
[mtl_statistics] lookup("nc_bsc","network_id",utime(STRINGYMD0_0 & start,"%d %b %Y %R"), nodeid) [SIGN] "PLMN" [sgnl_load] "PLMN" [MTPMSC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
timestamp | INTEGER | |
endstamp | INTEGER | |
node_name | VARCHAR(255) |
[mtl_statistics] lookup("nc_bsc","bsc_name",utime(STRINGYMD0_0 & start,"%d %b %Y %R"), nodeid) [SIGN] NODEID [sgnl_load] NODEID [C7GOC7LL] EXCH_ID [MTPMSC] msc_id |
node_type | VARCHAR(50) |
[mtl_statistics] "BSC" [SIGN] "HLR" [sgnl_load] "MSC" [MTPMSC] "MSC" |
adjacent_node_id | VARCHAR(50) | |
data_rate | VARCHAR(50) |
[mtl_statistics] "CUSTOMER_TO_DEFINE" [sgnl_load] 65536 [MTPMSC] M210B1C2 |
ss7_link_name | VARCHAR(255) |
[mtl_statistics] nodeid&"/"&linkid [SIGN] NODEID&"/"&linksetid&"/"&linkcode [sgnl_load] NODEID&"/"&linksetid&"/"&linkcode [C7GOC7LL] moi & "-" & Linksetname [MTPMSC] msc_id &"-"& sln_id |
technology | VARCHAR(50) |
[MTPMSC] "GSM" |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
ss7_linkset_id | VARCHAR(50) |
[C7LS] EXCH_ID & "-" & LSNAM [AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id |
ss7_point_id | VARCHAR(50) |
[C7LS] lookup("nc_ss7_routeset","ss7_point_id", utime(START_DATE & TIME,"%d %b %y %R"), EXCH_ID) [AVANMSC] msc_id&"-"&snet_id&"-"&spc_id |
node_id | VARCHAR(50) |
[C7LS] EXCH_ID [AVANMSC] msc_id |
region_id | VARCHAR(50) |
[C7LS] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R"), EXCH_ID) [AVANMSC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
network_id | VARCHAR(50) |
[C7LS] "PLMN" [AVANMSC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
timestamp | INTEGER | |
endstamp | INTEGER | |
node_name | VARCHAR(255) |
[C7LS] lookup("nc_msc","msc_name", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID) [AVANMSC] msc_id |
node_type | VARCHAR(50) |
[C7LS] "MSC" [AVANMSC] "MSC" |
adjacent_node_id | VARCHAR(50) |
[AVANMSC] "Populated by the customer" |
data_rate | VARCHAR(50) |
[AVANMSC] "Populated by the customer" |
designed_link_failures | VARCHAR(50) |
[AVANMSC] "Populated by the customer" |
ss7_linkset_name | VARCHAR(255) |
[C7LS] EXCH_ID & "-" & LSNAM [AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id |
technology | VARCHAR(50) |
[C7LS] "GSM" [AVANMSC] "GSM" |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
ss7_point_id | VARCHAR(50) |
[C7MU] MOI [STAMSC] msc_id&"-"&snet_id&"-"&spc_id |
node_id | VARCHAR(50) |
[C7MU] MOI0 [STAMSC] msc_id |
region_id | VARCHAR(50) |
[C7MU] lookup("nc_msc","region_id",utime(START_DATE & TIME,"%d %b %y %R"), moi0) [STAMSC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
network_id | VARCHAR(50) |
[C7MU] "PLMN" [STAMSC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
timestamp | INTEGER | |
endstamp | INTEGER | |
node_name | VARCHAR(255) |
[C7MU] lookup("nc_msc","msc_name",utime(START_DATE & TIME,"%d %b %y %R"), moi0) [STAMSC] msc_id |
node_type | VARCHAR(50) |
[C7MU] "MSC" [STAMSC] "MSC" |
ss7_point_name | VARCHAR(255) |
[C7MU] MOI [STAMSC] msc_id&"-"&snet_id&"-"&spc_id |
adjacent_node_id | VARCHAR(50) | |
technology | VARCHAR(50) |
[C7MU] "GSM" [STAMSC] "GSM" |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
ss7_routeset_id | VARCHAR(50) |
[C7RS] MOI [AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id |
ss7_point_id | VARCHAR(50) |
[C7RS] MOI0 & "." & MOI1 [AVANMSC] msc_id&"-"&snet_id&"-"&spc_id |
node_id | VARCHAR(50) |
[C7RS] MOI0 [AVANMSC] msc_id |
region_id | VARCHAR(50) |
[C7RS] lookup("nc_msc","region_id",utime(START_DATE & TIME,"%d %b %y %R"), moi0) [AVANMSC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"), msc_id) |
network_id | VARCHAR(50) |
[C7RS] "PLMN" [AVANMSC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"), msc_id) |
timestamp | INTEGER | |
endstamp | INTEGER | |
node_name | VARCHAR(255) |
[C7RS] lookup("nc_msc","msc_name", utime(START_DATE & TIME,"%d %b %y %R")-duration, moi0) [AVANMSC] lookup("nc_msc","msc_name",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"), msc_id) |
node_type | VARCHAR(50) |
[C7RS] "MSC" [AVANMSC] "MSC" |
adjacent_node_id | VARCHAR(50) | |
ss7_routeset_name | VARCHAR(255) |
[C7RS] MOI [AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id |
technology | VARCHAR(50) |
[C7RS] "GSM" [AVANMSC] "GSM" |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
vlr_id | VARCHAR(50) |
[GS_RESULT] "MSC"&MSCID [VLR] NODEID [VLR_GLOBAL] if RANK=NULL then RANK1&"/"&RANK2 else RANK [USVM] EXCH_ID [VLR1MSC] msc_id |
msc_id | VARCHAR(50) |
[GS_RESULT] "MSC"&MSCID [VLR] NODEID [USVM] EXCH_ID [VLR1MSC] msc_id |
region_id | VARCHAR(50) |
[GS_RESULT] lookup("nc_msc","region_id",utime(START_DATE & START_TIME,"%d %b %Y %R"),"MSC"&MSCID) [VLR] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID) [USVM] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID) [VLR1MSC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
network_id | VARCHAR(50) |
[GS_RESULT] "PLMN" [VLR] "PLMN" [USVM] "PLMN" [VLR1MSC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id) |
timestamp | INTEGER | |
endstamp | INTEGER | |
vendor_id | VARCHAR(50) |
[GS_RESULT] "Alcatel" [VLR] "Alcatel" [VLR1MSC] "Nokia" |
vlr_name | VARCHAR(255) |
[GS_RESULT] "Provided by customer" [VLR] NODEID [USVM] EXCH_ID [VLR1MSC] msc_id |
vlr_version | VARCHAR(50) |
[GS_RESULT] "Provided by customer" [USVM] "SR11" [VLR1MSC] "M13.5" |
technology | VARCHAR(50) |
[GS_RESULT] "GSM" [USVM] "GSM" [VLR1MSC] "GSM" |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
completion_code_id | VARCHAR(50) |
[CCMEA] cc_id |
timestamp | INTEGER | |
endstamp | INTEGER | |
completion_code_name | VARCHAR(255) |
[CCMEA] cc_id |
completion_code_type | VARCHAR(50) | |
completion_code_description | VARCHAR(255) |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
supplementary_service_id | VARCHAR(50) |
[UNKNOWN] "MSC"&MSCID&"-"&SSID [RCF_SS] NODEID&"/"&rank [SERVI] service_id |
timestamp | INTEGER | |
endstamp | INTEGER | |
supplementary_service_name | VARCHAR(255) |
[UNKNOWN] "MSC"&MSCID&"-"&SSID [RCF_SS] NODEID&"/"&rank [SERVI] service_id |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | |
traffic_type_id | VARCHAR(50) |
[MSC_TRAF] TRAFFTYPE [ACCU_BSC] "TTYPE" [msc_traf] ttype [TRAFF] TY [TC] TCAT_ID |
timestamp | INTEGER | |
endstamp | INTEGER | |
direction | VARCHAR(50) |
[MSC_TRAF] "Provided by customer" [ACCU_BSC] if TTYPE = "ALORG" then "Originating" else if TTYPE = "ALTER" then "Terminating" else if TTYPE = "MTER" then "Terminating" else if TTYPE = "MGAT" then "Gateway" else TTYPE [msc_traf] if ttype = "ALOUT" then "Outgoing" else if ttype = "ALINC" then "Incoming" else if ttype = "ALTRA" then "Transit" else if ttype = "ALMISC" then "Miscellaneous" else if ttype = "ALTOT" then "Total" else if ttype = "ALINCT" then "Incoming Terminating" else if ttype = "ALORGO" then "Originating Outgoing" else if ttype = "ALINT" then "Internal" else if ttype = "ALORG" then "Originating" else if ttype = "ALTER" then "Terminating" else ttype [TRAFF] if TY = "MORTR" then "Originating" else if TY = "MICTR" then "Incoming" else if TY = "MTER" then "Terminating " else if TY = "MOUT_PLMN" then "Outgoing" else if TY = "MOUT_NOT_PLMN" then "Originating outgoing" else if TY = "MTRAN" then "Transit" else TY |
is_switched | VARCHAR(50) |
[MSC_TRAF] "Provided by customer" [ACCU_BSC] "false" [msc_traf] if ttype = "ALTOT" then "true" else "false" [TRAFF] if TY = "MICTR" then "TRUE" else if TY = "MORTR" then "TRUE" else "FALSE" |
traffic_type_name | VARCHAR(255) |
[MSC_TRAF] TRAFFTYPE [ACCU_BSC] "TTYPE" [msc_traf] ttype [TRAFF] if TY = "MTRAN" then "Transit" else if TY = "MOPLMN" then "Originating Outgoing" else if TY = "MTER" then "Terminating" else if TY = "MNPLMN" then "Terminating Incoming" else if TY = "MORTR" then "Originating" else if TY = "MICTR" then "Incoming" else TY [TC] TCAT_ID |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
hlr_id | VARCHAR(50) | n/a |
region_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
lac_id | VARCHAR(50) | n/a |
msc_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
msc_id | VARCHAR(50) | n/a |
region_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
network_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
processor_id | VARCHAR(50) | n/a |
node_id | VARCHAR(50) | n/a |
region_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
region_id | VARCHAR(50) | n/a |
network_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
route_if_id | VARCHAR(50) | n/a |
region_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
ss7_link_id | VARCHAR(50) | n/a |
ss7_linkset_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
ss7_linkset_id | VARCHAR(50) | n/a |
ss7_point_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
ss7_point_id | VARCHAR(50) | n/a |
node_id | VARCHAR(50) | n/a |
region_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
ss7_routeset_id | VARCHAR(50) | n/a |
ss7_point_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | SERIAL | n/a |
vlr_id | VARCHAR(50) | n/a |
msc_id | VARCHAR(50) | n/a |
timestamp | INTEGER | n/a |
endstamp | INTEGER | n/a |
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:
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
hlr_id | VARCHAR(50) |
[HLR] NODEID [USHM] EXCH_ID [ACHHLR] hlr_id [HL1HLR] hlr_id |
day | INTEGER | |
subscribers | VARCOUNTER |
[HLR] C18801 [USHM] SUB_REGISTERED_IN_HLR |
vlr_subscribers | VARCOUNTER |
[HL1HLR] M84B9C4 |
roamers | VARCOUNTER |
[USHM] OWN_SUB_ROAM_IN_FOREIGN_PLMN [HL1HLR] M83B5C1 |
la_update_attempts | VARCOUNTER |
[HLR] C10404 [USHM] RECVD_UPD_LOC_MSG_VLR_HPLMN+RECVD_UPD_LOC_MSG_VLR_VPLMN [HL1HLR] M83B5C5 + M83B5C6 |
la_update_successes | VARCOUNTER |
[HLR] C10405 [USHM] (RECVD_UPD_LOC_MSG_VLR_HPLMN+RECVD_UPD_LOC_MSG_VLR_VPLMN)-(UNS_UPLOCMSG_VLR_HPLMN_SUB_BEH+UNS_UPLOCMSG_VLR_HPLMN_IRR_VLR+UNS_UPLOCMSG_VLR_HPLMN_IRR_SYS+UNS_UPLOCMSG_VLR_VPLMN_SUB_BEH+UNS_UPLOCMSG_VLR_VPLMN_IRR_VLR+UNS_UPLOCMSG_VLR_VPLMN_IRR_SYS+UNS_LOC_UPD_OVL) [HL1HLR] M83B5C5 |
la_update_failures | VARCOUNTER |
[HLR] C10404-C10405 [USHM] UNS_UPLOCMSG_VLR_HPLMN_SUB_BEH+UNS_UPLOCMSG_VLR_HPLMN_IRR_VLR+UNS_UPLOCMSG_VLR_HPLMN_IRR_SYS+UNS_UPLOCMSG_VLR_VPLMN_SUB_BEH+UNS_UPLOCMSG_VLR_VPLMN_IRR_VLR+UNS_UPLOCMSG_VLR_VPLMN_IRR_SYS+UNS_LOC_UPD_OVL [HL1HLR] M83B5C6 |
msrn_attempts | VARCOUNTER |
[HLR] C10603 [USHM] SND_PROV_MSRN |
msrn_successes | VARCOUNTER |
[HLR] C10604 [USHM] RECVD_MSRN |
msrn_failures | VARCOUNTER |
[HLR] C10603-C10604 [USHM] SND_PROV_MSRN-RECVD_MSRN |
vlr_insert_attempts | VARCOUNTER |
[HLR] C10406 [USHM] SND_INS_SUBDT_MSG+SND_INS_SUBDT_MSG_SUB_ADMIN+SENT_INSERT_MS_DATA_AFTER_SCI |
vlr_insert_successes | VARCOUNTER |
[HLR] C10407 [USHM] (SND_INS_SUBDT_MSG+SND_INS_SUBDT_MSG_SUB_ADMIN+SENT_INSERT_MS_DATA_AFTER_SCI)-(UNS_INS_SUBDT_MSG+UNS_INS_SUBDT_MSG_SUB_ADMIN+UNS_RESP_INS_SUBDT_SS) |
vlr_insert_failures | VARCOUNTER |
[HLR] C10406-C10407 [USHM] UNS_INS_SUBDT_MSG+UNS_INS_SUBDT_MSG_SUB_ADMIN+UNS_RESP_INS_SUBDT_SS |
auc_attempts | VARCOUNTER |
[USHM] TRIPLES_REQUESTED_BY_HLR |
auc_successes | VARCOUNTER |
[USHM] TRIPLES_RETURNED_TO_HLR |
auc_failures | VARCOUNTER |
[USHM] TRIPLES_REQUESTED_BY_HLR-TRIPLES_RETURNED_TO_HLR |
auth_attempts | VARCOUNTER |
[HLR] C11001 [USHM] RECVD_SEND_PARAM_AR [ACHHLR] M87B3C6 |
auth_successes | VARCOUNTER |
[HLR] C11001-C11002 [USHM] RECVD_SEND_PARAM_AR-UNS_SND_PARAM_AR [ACHHLR] M87B3C7 |
auth_failures | VARCOUNTER |
[HLR] C11002 [USHM] UNS_SND_PARAM_AR [ACHHLR] M87B3C6 - M87B3C7 |
auth_reused | VARCOUNTER |
[HLR] C14001 [USHM] REUSED_TRIPLES |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
lac_id | VARCHAR(50) |
[NLAC] Obj2 & "-" & Obj3 [VLR_LAC] rank [USLM] LACID |
day | INTEGER | |
attach_updates | VARCOUNTER | |
la_updates | VARCOUNTER |
[NLAC] LA_LUR_LA |
pages | VARCOUNTER |
[NLAC] PA_MTER_LA [USLM] PAG_PROC |
periodic_updates | VARCOUNTER | |
repages | VARCOUNTER |
[NLAC] PA_RETRY_LA [USLM] RETRY_PAG |
responses | VARCOUNTER |
[NLAC] PA_RESP_LA [USLM] SUCC_PAG |
total_pages | VARCOUNTER |
[NLAC] PA_MTER_LA + if (PA_RETRY_LA=NULL then 0 else PA_RETRY_LA) [USLM] PAG_PROC+RETRY_PAG |
unresponses | VARCOUNTER |
[USLM] (PAG_PROC+RETRY_PAG)-SUCC_PAG |
vlr_update_attempts | VARCOUNTER |
[VLR_LAC] C20401 + C20403 [USLM] LOC_UPD |
vlr_update_failures | VARCOUNTER |
[VLR_LAC] C20404 |
vlr_update_successes | VARCOUNTER |
[VLR_LAC] C20401 + C20403 - C20404 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
msc_id | VARCHAR(50) |
[CCMEA] msc_id |
completion_code_id | VARCHAR(50) |
[CCMEA] cc_id |
day | INTEGER | |
completed | VARCOUNTER |
[CCMEA] M131B2C1 + M131B2C2 + M131B2C3 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
msc_id | VARCHAR(50) |
[NTDC] "MSC"&MSCID [DEST] NODEID [DEST] EXCH_ID [NUMD] msc_id |
destination_id | VARCHAR(50) |
[NTDC] "MSC"&MSCID&"-"&DECO [DEST] NODEID&"/"&deco [DEST] EXCH_ID&"-"&DECO [NUMD] dest_id &"-"&desttype_id&"-"&destdir_id |
day | INTEGER | |
answered_calls | VARCOUNTER |
[NTDC] CS_OG_TDC [DEST] round((calls \* effsub /100),0) [DEST] CCS_WITH_ANSWER [NUMD] M17B2C7 |
answered_traffic | VARCOUNTER |
[DEST] if DURATION=0 then NULL else round(TV_WITH_ANSWER/(DURATION*60),2) |
total_calls | VARCOUNTER |
[NTDC] CC_OG_TDC [DEST] calls [DEST] CC [NUMD] M17B2C5 |
traffic | VARCOUNTER |
[NTDC] round(TV_OG_TDC,2) [DEST] if DURATION=0 then NULL else round(TV/(DURATION*60*10),2) [NUMD] M17B2C11 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
msc_id | VARCHAR(50) |
[CML_GS_GLOBAL] "MSC"&MSCID [VLR] NODEID [USMM] EXCH_ID |
day | INTEGER | |
originate_attempts | VARCOUNTER |
[CML_GS_GLOBAL] CA_TCHRQ_MORTR [VLR] C31505 [USMM] GEN_TRAFF_CHAN_REQ_MORTR |
originate_failures | VARCOUNTER |
[CML_GS_GLOBAL] CA_TCHRQ_MORTR - CC_TCA_MORTR [VLR] C31505 - C31506 [USMM] GEN_TRAFF_CHAN_REQ_MORTR-CALL_TCH_ALLOCATION_MORTR |
originate_successes | VARCOUNTER |
[CML_GS_GLOBAL] CC_TCA_MORTR [VLR] C31506 [USMM] CALL_TCH_ALLOCATION_MORTR |
terminate_attempts | VARCOUNTER |
[CML_GS_GLOBAL] CA_MTER [VLR] C31507 [USMM] GEN_TRAFF_CHAN_REQ_MTER |
terminate_failures | VARCOUNTER |
[CML_GS_GLOBAL] CA_MTER - CC_TCA_MTER [VLR] C31507 - C31508 [USMM] GEN_TRAFF_CHAN_REQ_MTER-CALL_TCH_ALLOCATION_MTER |
terminate_successes | VARCOUNTER |
[CML_GS_GLOBAL] CC_TCA_MTER [VLR] C31508 [USMM] CALL_TCH_ALLOCATION_MTER |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
msc_id | VARCHAR(50) |
[HANDOVERS] "MSC"&MSCID [VLR] NODEID [USMM] EXCH_ID [HO1] msc_id |
day | INTEGER | |
incoming_intermsc_attempts | VARCOUNTER |
[HANDOVERS] HA_REQ_INC_MSCB [VLR] C30715 + C30718 [USMM] HANDOVER_MSC_MSC_IC_ATTEMPTS+SUBSEQ_MSC_MSC_HO_MSCB [HO1] M81B3C15 + M81B3C16 |
incoming_intermsc_failures | VARCOUNTER |
[HANDOVERS] HL_RES_OWN [VLR] C30715 + C30718 - C30719 [USMM] HANDOVER_MSC_MSC_IC_ATTEMPTS+SUBSEQ_MSC_MSC_HO_MSCB-SUCC_MSC_MSC_HO_MSCB-SUCC_SUBSEQ_MSC_MSC_HO_MSCB [HO1] M81B3C16 |
incoming_intermsc_successes | VARCOUNTER |
[HANDOVERS] HS_INC_MSCB [VLR] C30719 [USMM] SUCC_MSC_MSC_HO_MSCB+SUCC_SUBSEQ_MSC_MSC_HO_MSCB [HO1] M81B3C15 |
interbsc_attempts | VARCOUNTER |
[VLR] C30716 + TNORMAL_C30736 + TNOTNORMAL_C30736 [USMM] HANDOVER_ATTEMPTS-HANDOVER_MSC_MSC_OG_ATTEMPTS-SUBSEQ_MSC_MSC_HO_MSCB [HO1] M81B3C6 + M81B3C5 |
interbsc_failures | VARCOUNTER |
[VLR] C30716 + TNOTNORMAL_C30736 - C30717 [USMM] HANDOVER_ATTEMPTS-HANDOVER_MSC_MSC_OG_ATTEMPTS-SUBSEQ_MSC_MSC_HO_MSCB-SUCC_COMPLETED_HO-SUCC_HO_SEC_MSC_MSC_HO_MSCB [HO1] M81B3C6 |
interbsc_successes | VARCOUNTER |
[HANDOVERS] HS_INTRA [VLR] C30717 + TNORMAL_C30736 [USMM] SUCC_COMPLETED_HO+SUCC_HO_SEC_MSC_MSC_HO_MSCB [HO1] M81B3C5 |
outgoing_intermsc_attempts | VARCOUNTER |
[HANDOVERS] HA_REQ_OG_MSCA [VLR] C30713 + C30722 [USMM] HANDOVER_MSC_MSC_OG_ATTEMPTS+SUBSEQ_MSC_MSC_MSCA [HO1] M81B3C23 + M81B3C24 |
outgoing_intermsc_failures | VARCOUNTER |
[HANDOVERS] HL_ERR_OTH [VLR] C30713 + C30722 - C30714 - C30723 [USMM] HANDOVER_MSC_MSC_OG_ATTEMPTS+SUBSEQ_MSC_MSC_HO_MSCA-SUCC_MSC_MSC_HO_MSCA [HO1] M81B3C24 |
outgoing_intermsc_successes | VARCOUNTER |
[HANDOVERS] HS_OG_MSCA [VLR] C30714 + C30723 [USMM] SUCC_MSC_MSC_HO_MSCA [HO1] M81B3C23 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
msc_id | VARCHAR(50) |
[CML_GS_GLOBAL] "MSC"&MSCID [VLR] NODEID [USMM] EXCH_ID [VLR1MSC] msc_id |
day | INTEGER | |
global_pages | VARCOUNTER |
[VLR] C20304 [VLR1MSC] M82B4C8 |
global_repages | VARCOUNTER | |
global_responses | VARCOUNTER | |
global_unresponses | VARCOUNTER | |
local_pages | VARCOUNTER |
[CML_GS_GLOBAL] PA_START [VLR] C20303 [USMM] STARTED_PAGING_PROC [VLR1MSC] M82B4C7 |
local_repages | VARCOUNTER |
[CML_GS_GLOBAL] PA_RETRY [VLR] C30301 [USMM] STARTED_PAGING_RETRY_PROC [VLR1MSC] M82B4C7-M82B4C3 |
local_responses | VARCOUNTER |
[CML_GS_GLOBAL] PA_START+PA_RETRY-PL_TIMEOUT [VLR] C20305 [USMM] RECEIVED_PAG_RESP |
local_unresponses | VARCOUNTER |
[CML_GS_GLOBAL] PL_TIMEOUT [VLR] C20303 + C30301 - C20305 [USMM] STARTED_PAGING_PROC+STARTED_PAGING_RETRY_PROC-RECEIVED_PAG_RESP |
total_global_pages | VARCOUNTER | |
total_local_pages | VARCOUNTER |
[CML_GS_GLOBAL] PA_START + PA_RETRY [VLR] C20303 + C30301 [USMM] STARTED_PAGING_PROC+STARTED_PAGING_RETRY_PROC [VLR1MSC] M82B4C7 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
msc_id | VARCHAR(50) |
[CML_GS_GLOBAL] "MSC"&MSCID [RCF_SS] NODEID [USSM] EXCH_ID [SERVI] msc_id |
supplementary_service_id | VARCHAR(50) |
[CML_GS_GLOBAL] "MSC"&MSCID [RCF_SS] NODEID&"/"&rank [USSM] EXCH_ID & "-" & SSID [SERVI] service_id |
day | INTEGER | |
activates | VARCOUNTER |
[CML_GS_GLOBAL] MT_ASS_ALL [SERVI] M128B2C3 |
deactivates | VARCOUNTER |
[CML_GS_GLOBAL] MT_DSS_ALL [SERVI] M128B2C4 |
interrogations | VARCOUNTER |
[CML_GS_GLOBAL] SS_QA_VLR [RCF_SS] if C23001 >= 0 then C23001 else NULL [SERVI] M128B2C5 |
invocations | VARCOUNTER |
[CML_GS_GLOBAL] SA_CF_NREA_G+SA_CF_NREA_V+SS_INVOC_RHC [RCF_SS] if C33002 >= 0 then C33002 else NULL [USSM] if SSID="CFUN" then INV_SERV_CALL_FWD_UNCOND_CFUN else if SSID="CFBU" then INVOC_SERV_CALL_FWD_MSB_CFBU else if SSID="CFNR" then INVOC_SERV_CALL_FWD_NR_CFNR else if SSID="CFIN" then INVOC_SERV_CALL_FWD_MSNR_CFIN else if SSID="AOCC" then INVOC_SERV_AOC_CHARGE_AOCC else if SSID="AOCI" then INVOC_SERV_AOC_INFO_AOCI else if SSID="MULTIPARTY" then INVOC_SERV_AOC_MULTIPARTY else if SSID="CHOL" then INVOC_SERV_PUT_HOLD_CHOL else if SSID="CRETRIEVE" then INVOC_SERV_RTRV_HOLD_CRETRIEVE else if SSID="CLIP" then INVOC_SERV_CLIP else if SSID="CLIR" then INVOC_SERV_CLIR else if SSID="CALL_BACK" then INVOC_SERV_CALLBACK else if SSID="XFER" then INVOC_SERV_CALL_TRANSFER_XFER else if SSID="UUS" then INVOC_SERV_UUS else if SSID="SPLIT_MPTY" then INVOC_SERV_SPLIT_MPTY else if SSID="CCBS_MORTR" then INVOC_SERV_CCBS_MORTR else if SSID="CCBS_MTER" then INVOC_SERV_CCBS_MTER else leftstr("x",0) [SERVI] M128B2C2 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
msc_id | VARCHAR(50) |
[MSC_TRAF] "MSC"&MSCID [VLR] NODEID [msc_traf] NODEID [TRAFF] EXCH_ID [TC] msc_id |
traffic_type_id | VARCHAR(50) |
[MSC_TRAF] "Provided by customer" [VLR] "TTYPE" [msc_traf] ttype [TRAFF] TY [TC] TCAT_ID |
day | INTEGER | |
answered_calls | VARCOUNTER |
[MSC_TRAF] CS_NWTT [VLR] if TTYPE="ALORG" then C30513 else if TTYPE="ALTER" then C30606 else NULL [msc_traf] t01 [TRAFF] CALL_ATTEMPTS+DATACDA_ANA_ATTEMPTS+DATACDA_DIG_ATTEMPTS+ALTFAXSP_CALL_ATTEMPTS+FAX3_CALL_ATTEMPTS+DATACDS_ANA_ATTEMPTS+DATACDS_DIG_ATTEMPTS+ALT_SPCH_DATA_ATTEMPTS+IN_ATTEMPTS [TC] M20B2C4 |
call_attempts | VARCOUNTER |
[MSC_TRAF] CA_NWTT [VLR] if TTYPE="ALORG" then C30503 else if TTYPE="ALTER" then C30603 else if TTYPE = "ALGAT" then C31104 else NULL [msc_traf] t05 [TRAFF] CALL_ATTEMPTS [TC] M20B2C2 |
call_failures | VARCOUNTER |
[MSC_TRAF] CA_NWTT - CC_TCA_NWTT [VLR] if TTYPE="ALORG" then C30514 else if TTYPE="ALTER" then C30607 else NULL [msc_traf] (t05 - t04) [TRAFF] if TY="MORTR" then UNS_REQ_DEST_ERR+UNS_TECHN_FAULT+UNS_SERV_CHECK+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_OVERLOAD+UNS_CONGESTION+UNS_BS_REASON+UNS_LACK_IWE+UNS_SECURITY_FAIL else if TY="MOPLMN" then UNS_REQ_DEST_ERR+UNS_TECHN_FAULT+UNS_SERV_CHECK+UNS_CONGESTION+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_NETW_MANAGEMENT+UNS_BS_REASON else if TY="MNPLMN" then UNS_REQ_DEST_ERR+UNS_TECHN_FAULT+UNS_SERV_CHECK+UNS_CONGESTION+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_NETW_MANAGEMENT+UNS_BS_REASON else if TY="MICTR" then UNS_TECHN_FAULT+UNS_SERV_CHECK+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_OVERLOAD else if TY="MTER" then UNS_PAGING+UNS_REQ_DEST_ERR+UNS_TECHN_FAULT+UNS_SERV_CHECK+UNS_CONGESTION+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_SECURITY_FAIL+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_OVERLOAD+UNS_BS_REASON else if TY="MTRAN" then UNS_REQ_DEST_ERR+UNS_SN_CONGESTION+UNS_LINK_FAIL+UNS_PROTO_ERROR else leftstr("x",0) [TC] M20B2C2 - M20B2C3 |
call_successes | VARCOUNTER |
[MSC_TRAF] CC_TCA_NWTT [VLR] if TTYPE="ALORG" then (C30509 + C30510 + C30512) else if TTYPE="ALTER" then C30605 else NULL [msc_traf] t04 [TRAFF] if TY="MTRAN" then SN_THROUGH_CONNECTIONS else CALL_TCH_ALLOCATION [TC] M20B2C4 |
external_failed_calls | VARCOUNTER |
[VLR] if TTYPE="ALORG" then C30514 else if TTYPE="ALTER" then C30607 else NULL [msc_traf] EXTFAILS [TRAFF] if TY="MORTR" then UNS_REQ_DEST_ERR+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_BS_REASON else if TY="MOPLMN" then UNS_REQ_DEST_ERR+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_BS_REASON else if TY="MNPLMN" then UNS_REQ_DEST_ERR+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_BS_REASON else if TY="MICTR" then UNS_LINK_FAIL+UNS_PROTO_ERROR else if TY="MTER" then UNS_PAGING+UNS_REQ_DEST_ERR+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_BS_REASON else if TY="MTRAN" then UNS_REQ_DEST_ERR+UNS_SN_CONGESTION+UNS_LINK_FAIL+UNS_PROTO_ERROR else leftstr("x",0) [TC] M20B2C6 |
internal_failed_calls | VARCOUNTER |
[MSC_TRAF] CL_CONG_N7_NWTT + CL_CONG_SSS_NWTT + CL_CONG_TKG_NWTT + CL_IWF_NWTT + CL_NC_NWTT + CL_NM_NWTT + CL_OTH_NWTT + CL_OVL_NWTT + CL_PE_NWTT + CL_PL_NWTT + CL_RRR_NWTT + CL_SBU_NWTT+ CL_TF_NWTT [VLR] if TTYPE="ALORG" then C30514 else if TTYPE="ALTER" then C30607 else NULL [msc_traf] INTFAILS [TRAFF] if TY="MORTR" then UNS_TECHN_FAULT+UNS_CONGESTION+UNS_OVERLOAD else if TY="MOPLMN" then UNS_TECHN_FAULT+UNS_CONGESTION+UNS_NETW_MANAGEMENT else if TY="MNPLMN" then UNS_TECHN_FAULT+UNS_CONGESTION+UNS_NETW_MANAGEMENT else if TY="MICTR" then UNS_TECHN_FAULT+UNS_OVERLOAD else if TY="MTER" then UNS_TECHN_FAULT+UNS_CONGESTION+UNS_OVERLOAD else if TY="MTRAN" then UNS_TECHN_FAULT+UNS_CONGESTION+UNS_NETW_MANAGEMENT else leftstr("x",0) [TC] M20B2C5 |
subscriber_error_calls | VARCOUNTER |
[MSC_TRAF] CL_BL_NWTT [VLR] if TTYPE="ALORG" then C30514 else if TTYPE="ALTER" then C30607 else NULL [msc_traf] SUBFAILS [TRAFF] if TY="MORTR" then UNS_SERV_CHECK+UNS_MS_BLOCKED+UNS_SECURITY_FAIL+UNS_MS_DETACH+UNS_CUG_REJECT else if TY="MOPLMN" then UNS_SERV_CHECK+UNS_MS_BUSY+UNS_BLACK_LIST+UNS_IMEI_UNKNOWN+UNS_CUG_REJECT else if TY="MNPLMN" then UNS_SERV_CHECK+UNS_MS_BUSY+UNS_BLACK_LIST+UNS_IMEI_UNKNOWN+UNS_CUG_REJECT else if TY="MICTR" then UNS_SERV_CHECK+UNS_MS_BLOCKED+UNS_MS_DETACH+UNS_CUG_REJECT else if TY="MTER" then UNS_SERV_CHECK+UNS_MS_BLOCKED+UNS_MS_BUSY+UNS_SECURITY_FAIL+UNS_BLACK_LIST+UNS_IMEI_UNKNOWN+UNS_MS_DETACH else leftstr("x",0) [TC] M20B2C7 |
traffic | VARCOUNTER |
[MSC_TRAF] round(TV_NWTT,2) [msc_traf] round((traffic/10),2) [TRAFF] if DURATION=0 then NULL else round(TRAFFIC_VOLUME/(DURATION*60),2) [TC] M20B2C12/100 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
processor_id | VARCHAR(50) |
[BSC] BSC &"/"& CPUTYPE &"-"& ID [dproc_statistics] nodeid&"/"&procid [gproc_statistics] sitename&"/"&procid [PROC] NODEID&"/"&rank [P_NBSC_LOAD] NODEID & "/" & OBJ_NAME & "-" & OBJ_INDEX [PROC] if MEASURE_ID="CPXX" then EXCH_ID&"-"&NODEID else if MEASURE_ID="GPXX" then EXCH_ID&"-"<G else EXCH_ID [CLOM] msc_id &"-"& unit_id [CLOH] hlr_id &"-"& unit_id |
day | INTEGER | |
load_pc | VARCOUNTER |
[BSC] ((BSCB_0_1835_0_AVG + BSCB_1_1835_0_AVG + BSCB_2_1835_0_AVG + BSCB_3_1835_0_AVG + BSCB_4_1835_0_AVG + BSCB_5_1835_0_AVG + BSCB_6_1835_0_AVG + BSCB_7_1835_0_AVG + BSCB_8_1835_0_AVG + BSCB_9_1835_0_AVG) / 10) + ((CPUE_0_1835_0_AVG + CPUE_1_1835_0_AVG + CPUE_2_1835_0_AVG) / 3) + CPUM [dproc_statistics] cpu_usage_mean [gproc_statistics] cpu_usage_mean [PROC] C101 [P_NBSC_LOAD] if ( LOAD_DENOM1 != 0 ) then round(LOAD_RATE/LOAD_DENOM1,0) else leftstr("x",0) [PROC] if DURATION=0 then NULL else if INTEGRATION_FACTOR=0 then NULL else if MEASURE_ID="GPXX" then round((1000-((GP_IDR*GP_MEA)/(DURATION*60*1000)))/10,0) else if MEASURE_ID="CPXX" then round(TOTAL_INTENSITY/(INTEGRATION_FACTOR*10),0) else NULL [CLOM] M119B2C2/10 [CLOH] M119B2C2/10 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
route_if_id | VARCHAR(50) |
[TRUNKGROUP] "MSC"&MSCID&"-"&OBJECTNAME [class_f] NODEID&"/"&routeid [TGRP] EXCH_ID & "-" & TGNO [CGR] msc_id&"/"&alt_id |
day | INTEGER | |
available_circuits | VARCOUNTER |
[class_f] round((fs_i / 10),2) [TGRP] CONNECTED_LINES-(SEMI_BLOCKED_LINES+TRANS_BLOCKED_LINES) [CGR] M16B2C5 + M16B2C6 |
bids | VARCOUNTER |
[class_f] fpd_i + frd_i [TGRP] CCU_SUM_OF_LOSS+CC_O [CGR] M16B2C11 + M16B2C9 |
blocked_circuits | VARCOUNTER |
[class_f] round((fq_i - (fs_i / 10)),2) [TGRP] SEMI_BLOCKED_LINES+TRANS_BLOCKED_LINES [CGR] M16B2C23-(M16B2C5 + M16B2C6) |
busy_time_pc | VARCOUNTER |
[TGRP] if DURATION=0 then NULL else round((100.0*ATB_TIME)/(DURATION*60),2) [CGR] (ROUND(M16B2C7/100,0)) |
circuits | VARCOUNTER |
[class_f] fq_i [TGRP] CONNECTED_LINES [CGR] M16B2C3 |
incoming_answered_calls | VARCOUNTER |
[class_f] fea_i [TGRP] CCS_WITH_ANSWER_I [CGR] M16B2C16 |
incoming_calls | VARCOUNTER |
[TRUNKGROUP] CC_OG_TK [class_f] fpa_i [TGRP] CC_I [CGR] M16B2C12 |
incoming_traffic | VARCOUNTER |
[TRUNKGROUP] round(TV_CS_MICTR_TK,2) [class_f] round((foa_i / 10),2) [TGRP] if DURATION=0 then NULL else round(TV_I/(DURATION*60),2) [CGR] M16B2C24 |
outgoing_answered_calls | VARCOUNTER |
[class_f] fed_i [TGRP] CCS_WITH_ANSWER_O [CGR] M16B2C17 |
outgoing_calls | VARCOUNTER |
[TRUNKGROUP] CA_MICTR_TK [class_f] fpd_i [TGRP] CC_O [CGR] M16B2C13 |
outgoing_congestion_time | VARCOUNTER |
[TGRP] ATB_TIME [CGR] round (M16B2C7 / 100/(100 *(interval*60)),0) |
outgoing_congestions | VARCOUNTER |
[class_f] frd_i [TGRP] CCU_SUM_OF_LOSS [CGR] M16B2C9 |
outgoing_traffic | VARCOUNTER |
[TRUNKGROUP] round(TV_OG_TK,2) [class_f] round((fod_i / 10),2) [TGRP] if DURATION=0 then NULL else round(TV_O/(DURATION*60),2) [CGR] M16B2C25 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
ss7_link_id | VARCHAR(50) |
[SignallingLink] From vendor neutral loadmaps in vendor specific Tech Packs, or defined by the customer [mtl_statistics] nodeid&"/"&linkid [C7GOC7LL] moi & "-" & Linksetname [SLMSC] msc_id &"-"& sln_id [SLPMSC] msc_id &"-"& sln_id |
day | INTEGER | |
available_time | VARCOUNTER |
[mtl_statistics] round((utime(STRINGYMD0_0 & end,"%d %b %Y %R") - utime(STRINGYMD0_0 & start,"%d %b %Y %R")) - (mtp_unavailable / 1000),0) [C7GOC7LL] duration-slUnavailabilityDuration [SLMSC] (interval*60 - M208B2C1) |
unavailable_time | VARCOUNTER |
[mtl_statistics] round(mtp_unavailable / 1000,0) [C7GOC7LL] slUnavailabilityDuration [SLPMSC] M208B2C1 |
local_inhibition_time | VARCOUNTER |
[mtl_statistics] round(mtp_local_mgt / 1000,0) [C7GOC7LL] inhLinkDurUnavail [SLPMSC] M208B2C5 |
remote_inhibition_time | VARCOUNTER |
[mtl_statistics] round(mtp_remote_mgt / 1000,0) [C7GOC7LL] slRemoteProcOutage [SLPMSC] M208B2C6 |
link_failure_time | VARCOUNTER |
[mtl_statistics] round(mtp_linkfail / 1000,0) [C7GOC7LL] slFailed [SLPMSC] M208B2C2 |
remote_outage_time | VARCOUNTER |
[SLPMSC] M208B2C4 |
remote_outages | VARCOUNTER |
[mtl_statistics] mtp_start_rpo [SLPMSC] M208B2C10 |
local_busy_time | VARCOUNTER |
[mtl_statistics] round(mtp_local_busy / 1000,0) [SLPMSC] M208B2C7 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
ss7_link_id | VARCHAR(50) |
[SignallingLink] From vendor neutral loadmaps in vendor specific Tech Packs, or defined by the customer [mtl_statistics] nodeid&"/"&linkid [C7GOC7LL] moi & "-" & Linksetname [SLMSC] msc_id &"-"& sln_id [SLPMSC] msc_id &"-"& sln_id |
day | INTEGER | |
in_service_time | VARCOUNTER |
[mtl_statistics] round(mtp_link_ins / 1000,2) [C7GOC7LL] lInServiceDuration [SLMSC] M209B2C1 |
failures | VARCOUNTER |
[mtl_statistics] mtp_sl_fail [SLMSC] M209B2C2 |
failures_abr | VARCOUNTER |
[mtl_statistics] mtp_sl_fibr [SLMSC] M209B2C3 |
failures_delay | VARCOUNTER |
[SignallingLink] c5103_0_CUM [mtl_statistics] mtp_sl_ack [SLMSC] M209B2C4 |
failures_error_rate | VARCOUNTER |
[SignallingLink] c5103_1_CUM [mtl_statistics] mtp_sl_error_rate [SLMSC] M209B2C5 |
failures_congestion | VARCOUNTER |
[mtl_statistics] mtp_sl_congestion [C7GOC7LL] slCongestedStarts [SLMSC] M209B2C6 |
failures_alignment | VARCOUNTER |
[mtl_statistics] mtp_sl_alignment [SLMSC] M209B2C7 |
received_su_errors | VARCOUNTER |
[mtl_statistics] mtp_su_error [C7GOC7LL] signUnitsReceived [SLPMSC] M209B3C1 |
received_neg_ack | VARCOUNTER |
[SignallingLink] c5102_0_CUM [mtl_statistics] mtp_neg_acks [SLPMSC] M209B3C2 |
changeovers | VARCOUNTER |
[mtl_statistics] round(mtp_changeover,2) [SLMSC] M209B3C3 |
changebacks | VARCOUNTER |
[mtl_statistics] mtp_changeback [SLMSC] M209B3C4 |
restores | VARCOUNTER |
[SLPMSC] M209B3C5 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
ss7_link_id | VARCHAR(50) |
[SignallingLink] From vendor neutral loadmaps in vendor specific Tech Packs, or defined by the customer [mtl_statistics] nodeid&"/"&linkid [SIGN] NODEID&"/"&linksetid&"/"&linkcode [sgnl_load] NODEID&"/"&linksetid&"/"&linkcode [C7GOC7LL] moi & "-" & Linksetname [MTPMSC] msc_id &"-"& sln_id [SLMSC] msc_id &"-"& sln_id [SLPMSC] msc_id &"-"& sln_id |
day | INTEGER | |
transmitted_sif_sios | VARCOUNTER |
[mtl_statistics] mtp_sif_sio_tx [SIGN] C1 [sgnl_load] nte_i [C7GOC7LL] transmittedOctetsSIFSIO [SLPMSC] M210B2C1 |
retransmitted_sif_sios | VARCOUNTER |
[mtl_statistics] mtp_re_tx [C7GOC7LL] retransmittedOctets [SLPMSC] M210B2C5 |
received_sif_sios | VARCOUNTER |
[mtl_statistics] mtp_sif_sio_rx [SIGN] C2 [sgnl_load] ntr_i [C7GOC7LL] receivedOctetsSIFSIO [SLPMSC] M210B2C2 |
transmitted_msus | VARCOUNTER |
[SignallingLink] c5101_0_CUM [mtl_statistics] mtp_msu_tx [SIGN] C3 [C7GOC7LL] transmittedMSUs [SLPMSC] M210B2C3 |
received_msus | VARCOUNTER |
[SignallingLink] c5100_0_CUM [mtl_statistics] mtp_msu_rx [SIGN] C4 [C7GOC7LL] receivedMSUs [SLPMSC] M210B2C4 |
congestions | VARCOUNTER |
[mtl_statistics] round(sl_congestion / 1000,0) [C7GOC7LL] slCongestedStarts [SLMSC] M210B2C6 + M210B2C7 + M210B2C8 |
congestion_time | VARCOUNTER |
[mtl_statistics] mtp_congestion [C7GOC7LL] slCongestedDuration [SLMSC] M210B2C15 + M210B2C16 + M210B2C17 |
discarded_msus | VARCOUNTER |
[SignallingLink] c5102_2_CUM [mtl_statistics] msu_discarded [C7GOC7LL] discardedMSUs [SLMSC] M210B2C9 + M210B2C10 + M210B2C11 |
congestion_losses | VARCOUNTER |
[mtl_statistics] congestion_lost_m [SLMSC] (M210B2C12 + M210B2C13 + M210B2C14) |
outgoing_traffic | VARCOUNTER |
[C7GOC7LL] transmittedOctetsSIFSIO + retransmittedOctets + (6* transmittedMSUs) [MTPMSC] (M210B2C1 + (6 * M210B2C3)) |
incoming_traffic | VARCOUNTER |
[C7GOC7LL] receivedOctetsSIFSIO + (6*receivedMSUs) [SLPMSC] M210B2C2 + (6* M210B2C4) |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
ss7_linkset_id | VARCHAR(50) |
[C7LS] EXCH_ID & "-" & LSNAM [AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id |
day | INTEGER | |
available_time | VARCOUNTER |
[C7LS] (DURATION*60)-slsUnavailable [AVANMSC] (interval*60)-M212B2C3 |
unavailable_time | VARCOUNTER |
[C7LS] slsUnavailable [AVANMSC] M212B2C3 |
failures | VARCOUNTER |
[C7LS] numLinkSetNotAvail [AVANMSC] M212B2C1 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
ss7_point_id | VARCHAR(50) |
[C7MU] MOI [STAMSC] msc_id&"-"&snet_id&"-"&spc_id |
day | INTEGER | |
adjacent_sp_inaccessible | VARCOUNTER |
[C7MU] adjacentInaccessibleEvents [STAMSC] M211B2C1 |
adjacent_sp_inaccessible_time | VARCOUNTER |
[C7MU] adjacentInaccessibleDuration [STAMSC] M211B2C2 |
discarded_msus | VARCOUNTER |
[C7MU] discardedMSUs [STAMSC] M211B2C4 |
received_tfcs | VARCOUNTER |
[STAMSC] M211B2C3 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
ss7_routeset_id | VARCHAR(50) |
[C7RS] MOI [AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id |
day | INTEGER | |
available_time | VARCOUNTER |
[C7RS] duration-routeSetUnavailableDuration [AVANMSC] (interval*60)-M212B2C9 |
unavailable_time | VARCOUNTER |
[C7RS] routeSetUnavailableDuration [AVANMSC] M212B2C9 |
failures | VARCOUNTER |
[C7RS] routeSetUnavailable [AVANMSC] M212B2C8 |
Column Name | Data Type | Loader Block/Mapping |
---|---|---|
nc_id | INTEGER | |
vlr_id | VARCHAR(50) |
[CML_GS_GLOBAL] "MSC"&MSCID [VLR] NODEID [USVM] EXCH_ID [PLMNV] msc_id [VLR1MSC] msc_id |
day | INTEGER | |
lac_update_attempts | VARCOUNTER |
[CML_GS_GLOBAL] LA_REQ [VLR] C20416+C20415+C20414+C20413+C20411 [USVM] REQUESTS_LOCUPD [VLR1MSC] M82B3C101+M82B3C118+M82B3C106+M82B3C110+M82B3C114+M82B3C105+M82B3C122+M82B5C101 |
lac_update_successes | VARCOUNTER |
[CML_GS_GLOBAL] LS [VLR] C20453 [USVM] SUCC_REQUESTS_LOCUPD+SUCC_LOCUPD_WITH_IMSI_ATTACH [VLR1MSC] M82B3C102+M82B3C131+M82B3C107+M82B3C111+M82B3C115+M82B3C119+M82B3C123+M82B5C103 |
lac_update_failures | VARCOUNTER |
[CML_GS_GLOBAL] LA_REQ - LS [VLR] (C20416+C20415+C20414+C20413+C20411) - C20453 [USVM] REQUEST_LOCUPD-(SUCC_REQUESTS_LOCUPD+SUCC_LOCUPD_WITH_IMSI_ATTACH) [VLR1MSC] M82B3C101+M82B3C118+M82B3C106+M82B3C110+M82B3C114+M82B3C105-M82B3C102+M82B3C131+M82B3C107++M82B3C111+M82B3C115+M82B3C119 +M82B3C123+M82B5C103 |
vlr_update_attempts | VARCOUNTER |
[CML_GS_GLOBAL] LA_INTRA_VLR [VLR] (C20403 - C20414) [USVM] REQUESTS_LOCUPD_INTRA_VLR [VLR1MSC] M82B3C14 + M82B3C1 + M82B3C10 + M82B3C5 |
vlr_update_successes | VARCOUNTER |
[CML_GS_GLOBAL] LS_INTRA_VLR [VLR1MSC] M82B3C15 + M82B3C11 + M82B3C2 + M82B3C31 |
vlr_update_failures | VARCOUNTER |
[CML_GS_GLOBAL] LA_INTRA_VLR - LS_INTRA_VLR [VLR1MSC] M82B3C14 + M82B3C1 + M82B3C10 + M82B3C5 - M82B3C15 + M82B3C11 + M82B3C2 + M82B3C31 |
imsi_attach_attempts | VARCOUNTER |
[CML_GS_GLOBAL] LA_ATTACH [VLR] C30402 [USVM] REQUESTS_LOCUPD_WITH_IMSI_ATT [VLR1MSC] M82B5C101 |
imsi_attach_successes | VARCOUNTER |
[USVM] SUCC_LOCUPD_WITH_IMSI_ATTACH [VLR1MSC] M82B5C103 |
imsi_attach_failures | VARCOUNTER |
[USVM] REQUESTS_LOCUPD_WITH_IMSI_ATT-SUCC_LOCUPD_WITH_IMSI_ATTACH [VLR1MSC] M82B5C101 - M82B5C103 |
imsi_detaches | VARCOUNTER |
[VLR] C30403 [USVM] EXPLICIT_IMSI_DETACH+IMPLICIT_IMSI_DETACH [VLR1MSC] M82B5C105 |
imsi_attach_updates | VARCOUNTER |
[USVM] SUCC_LOCUPD_WITH_IMSI_ATTACH [VLR1MSC] M82B5C3 |
periodic_updates | VARCOUNTER |
[CML_GS_GLOBAL] LA_PER [VLR] C30405 [USVM] REQUESTS_PERIODIC_LOCUPD [VLR1MSC] M82B3C22 |
new_la_updates | VARCOUNTER |
[USVM] LA_CHANGES_OWN_PLMN+LA_CHANGES_FOREIGN_PLMN+VLR_AREA_LEAVES_FOREIGN_PLMN+VLR_AREA_LEAVES_OWN_PLMN |
id_request_attempts | VARCOUNTER |
[VLR] C20408 [USVM] IDENTITY_REQUESTS |
id_request_successes | VARCOUNTER |
[CML_GS_GLOBAL] LS_RC_PVLR |
id_request_failures | VARCOUNTER | |
vlr_visitors | VARCOUNTER |
[USVM] ENTRY_USED_FOREIGN [PLMNV] M340B2C3 |
vlr_subscribers | VARCOUNTER |
[VLR] C20402 [USVM] ENTRY_USED_OWN+ENTRY_USED_FOREIGN [VLR1MSC] M80B2C5 |
This section lists the views that are included in this technology pack's database schema.
SELECT Statement | |
---|---|
SELECT nc_id, processor_id, node_id, region_id, network_id, timestamp, node_name, node_type, processor_name, processor_type, technology, vendor, processor_version FROM nc_processor WHERE LOWER(node_type) = "bsc"; |
|
Column Name | Data Type |
nc_id | INTEGER |
processor_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
processor_name | VARCHAR(255) |
processor_type | VARCHAR(50) |
technology | VARCHAR(50) |
vendor | VARCHAR(50) |
processor_version | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, processor_id, node_id, region_id, network_id, timestamp, node_name, node_type, processor_name, processor_type, technology, vendor, processor_version FROM nc_processor WHERE LOWER(node_type) = "ggsn"; |
|
Column Name | Data Type |
nc_id | INTEGER |
processor_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
processor_name | VARCHAR(255) |
processor_type | VARCHAR(50) |
technology | VARCHAR(50) |
vendor | VARCHAR(50) |
processor_version | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, processor_id, node_id, region_id, network_id, timestamp, node_name, node_type, processor_name, processor_type, technology, vendor, processor_version FROM nc_processor WHERE LOWER(node_type) = "hlr"; |
|
Column Name | Data Type |
nc_id | INTEGER |
processor_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
processor_name | VARCHAR(255) |
processor_type | VARCHAR(50) |
technology | VARCHAR(50) |
vendor | VARCHAR(50) |
processor_version | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, processor_id, node_id, region_id, network_id, timestamp, node_name, node_type, processor_name, processor_type, technology, vendor, processor_version FROM nc_processor WHERE LOWER(node_type) = "msc"; |
|
Column Name | Data Type |
nc_id | INTEGER |
processor_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
processor_name | VARCHAR(255) |
processor_type | VARCHAR(50) |
technology | VARCHAR(50) |
vendor | VARCHAR(50) |
processor_version | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, processor_id, node_id, region_id, network_id, timestamp, node_name, node_type, processor_name, processor_type, technology, vendor, processor_version FROM nc_processor WHERE LOWER(node_type) = "sgsn"; |
|
Column Name | Data Type |
nc_id | INTEGER |
processor_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
processor_name | VARCHAR(255) |
processor_type | VARCHAR(50) |
technology | VARCHAR(50) |
vendor | VARCHAR(50) |
processor_version | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_link_id, ss7_linkset_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, adjacent_node_id, data_rate, ss7_link_name, technology FROM nc_ss7_link WHERE LOWER(node_type) = "bsc"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_link_id | VARCHAR(50) |
ss7_linkset_id | VARCHAR(50) |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
adjacent_node_id | VARCHAR(50) |
data_rate | VARCHAR(50) |
ss7_link_name | VARCHAR(50) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_link_id, ss7_linkset_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, adjacent_node_id, data_rate, ss7_link_name, technology FROM nc_ss7_link WHERE LOWER(node_type) = "mgw"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_link_id | VARCHAR(50) |
ss7_linkset_id | VARCHAR(50) |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
adjacent_node_id | VARCHAR(50) |
data_rate | VARCHAR(50) |
ss7_link_name | VARCHAR(50) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_link_id, ss7_linkset_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, adjacent_node_id, data_rate, ss7_link_name, technology FROM nc_ss7_link WHERE LOWER(node_type) = "msc"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_link_id | VARCHAR(50) |
ss7_linkset_id | VARCHAR(50) |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
adjacent_node_id | VARCHAR(50) |
data_rate | VARCHAR(50) |
ss7_link_name | VARCHAR(50) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_linkset_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, adjacent_node_id, data_rate, designed_link_failures, ss7_linkset_name, technology FROM nc_ss7_linkset WHERE LOWER(node_type) = "bsc"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_linkset_id | VARCHAR(50) |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
adjacent_node_id | VARCHAR(50) |
data_rate | VARCHAR(50) |
designed_link_failures | VARCHAR(50) |
ss7_linkset_name | VARCHAR(255) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_linkset_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, adjacent_node_id, data_rate, designed_link_failures, ss7_linkset_name, technology FROM nc_ss7_linkset WHERE LOWER(node_type) = "mgw"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_linkset_id | VARCHAR(50) |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
adjacent_node_id | VARCHAR(50) |
data_rate | VARCHAR(50) |
designed_link_failures | VARCHAR(50) |
ss7_linkset_name | VARCHAR(255) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_linkset_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, adjacent_node_id, data_rate, designed_link_failures, ss7_linkset_name, technology FROM nc_ss7_linkset WHERE LOWER(node_type) = "msc"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_linkset_id | VARCHAR(50) |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
adjacent_node_id | VARCHAR(50) |
data_rate | VARCHAR(50) |
designed_link_failures | VARCHAR(50) |
ss7_linkset_name | VARCHAR(255) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, ss7_point_name, adjacent_node_id, technology FROM nc_ss7_point WHERE LOWER(node_type) = "bsc"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
ss7_point_name | VARCHAR(255) |
adjacent_node_id | VARCHAR(50) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, ss7_point_name, adjacent_node_id, technology FROM nc_ss7_point WHERE LOWER(node_type) = "mgw"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
ss7_point_name | VARCHAR(255) |
adjacent_node_id | VARCHAR(50) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, ss7_point_name, adjacent_node_id, technology FROM nc_ss7_point WHERE LOWER(node_type) = "msc"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
ss7_point_name | VARCHAR(255) |
adjacent_node_id | VARCHAR(50) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_routeset_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, adjacent_node_id, ss7_routeset_name, technology FROM nc_ss7_routeset WHERE LOWER(node_type) = "bsc"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_routeset_id | VARCHAR(50) |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
adjacent_node_id | VARCHAR(50) |
ss7_routeset_name | VARCHAR(255) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_routeset_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, adjacent_node_id, ss7_routeset_name, technology FROM nc_ss7_routeset WHERE LOWER(node_type) = "mgw"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_routeset_id | VARCHAR(50) |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
adjacent_node_id | VARCHAR(50) |
ss7_routeset_name | VARCHAR(255) |
technology | VARCHAR(50) |
SELECT Statement | |
---|---|
SELECT nc_id, ss7_routeset_id, ss7_point_id, node_id, region_id, network_id, timestamp, node_name, node_type, adjacent_node_id, ss7_routeset_name, technology FROM nc_ss7_routeset WHERE LOWER(node_type) = "msc"; |
|
Column Name | Data Type |
nc_id | INTEGER |
ss7_routeset_id | VARCHAR(50) |
ss7_point_id | VARCHAR(50) |
node_id | VARCHAR(50) |
region_id | VARCHAR(50) |
network_id | VARCHAR(50) |
timestamp | INTEGER |
node_name | VARCHAR(255) |
node_type | VARCHAR(50) |
adjacent_node_id | VARCHAR(50) |
ss7_routeset_name | VARCHAR(255) |
technology | VARCHAR(50) |
This section shows details of the performance alarms that are defined in this technology pack:
None.
This section shows details of the reports that are defined in this technology pack:
This report shows key route traffic statistics for a single route over all the weeks in the forecast base range. The report shows available & defined circuits, % congestion, 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.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Route_IF |
Date Ranging | No |
Period Selection | Weekly |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Historical Route Traffic Report (Table) | |||
3-DAV Summarised Carried Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | 3-day Average | |
5-DAV Summarised Carried Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | 5-day Average | |
Available Channels | Route_IF.Neutral.GSM.transmission.available_circuits | busy_hour | |
Blocking (%) | Route_IF.Neutral.GSM.transmission.%_outgoing_congestions | busy_hour | |
Busy Hour | busy_hour | busy_hour | |
Capacity | Route_IF.Neutral.GSM.transmission.capacity | busy_hour | |
Carried Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | busy_hour | |
Defined Channels | Route_IF.Neutral.GSM.transmission.circuits | busy_hour | |
GOS | Route_IF.Neutral.GSM.transmission.grade_of_service | busy_hour | |
Lost Traffic (E) | Route_IF.Neutral.GSM.transmission.lost_traffic | busy_hour | |
Offered Traffic (E) | Route_IF.Neutral.GSM.transmission.offered_traffic | busy_hour | |
Offered Utilisation | Route_IF.Neutral.GSM.transmission.offered_utilisation | busy_hour | |
Route | Route_IF.name | User-defined | |
Week_of | User-defined |
This graph shows the number of attached users and the % number of registered users attached.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.HLR |
Primary Object | HLR |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | HLR |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: % Subscribers in VLRs (Line Chart) | |||
% Subscribers in VLRs | HLR.Neutral.GSM.mobility.%_active_subscribers | User-defined | |
Component 2: Subscribers (Line Chart) | |||
In HLR | HLR.Neutral.GSM.mobility.subscribers | User-defined | |
In all VLRs | HLR.Neutral.GSM.mobility.vlr_subscribers | User-defined |
This graph shows the total traffic profile for all routes connecting an MSC to a POI (a POI route).
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Interconnect Traffic Graph (Line Chart) | |||
Traffic (E) | Route_IF.Neutral.GSM.transmission.bothway_traffic | User-defined |
This graph shows the total traffic profile for all routes connecting an MSC to an MSC (a trunk route).
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Inter-switch Traffic Graph (Line Chart) | |||
Traffic (E) | Route_IF.Neutral.GSM.transmission.bothway_traffic | User-defined |
This shows the performance of LAC paging attempts within a Location Area
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.LAC |
Primary Object | LAC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | LAC |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: % Eventual Response (Line Chart) | |||
% Eventual Response | LAC.Neutral.GSM.page.%_success | User-defined | |
Component 2: % Page/Repage Response (Line Chart) | |||
% Page/Repage Response | LAC.Neutral.GSM.page.%_response | User-defined | |
Component 3: Pages Without Response (Line Chart) | |||
Pages Without Response | LAC.Neutral.GSM.page.unresponses | User-defined | |
Component 4: Total Paging Attempts (Line Chart) | |||
Total Paging Attempts | LAC.Neutral.GSM.page.total_pages | User-defined |
This report shows the availability of a set of linksets and failures and unavailability on the constituent links.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Linkset |
Primary Object | Signalling_LinkSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, Signalling_LinkSet, Signalling_Point |
Date Ranging | No |
Period Selection | Daily (Raw), Daily, Weekly, Monthly |
Summary Selection | Total |
Filtering | Signalling_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) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: SS7 Linkset Availability Report (Link KPIs) (Table) | |||
# Links | Signalling_LinkSet.Neutral.GSM.signalling_linkset.links | User-defined | |
Link Failures | Signalling_LinkSet.Neutral.GSM.signalling_linkset.total_failures | User-defined | |
Not displayed (for filtering only) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage | User-defined | |
Linkset | Signalling_LinkSet.name | User-defined | |
Links Unavailable (s) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_time | User-defined |
This report shows the availability of a set of linksets and failures
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Linkset |
Primary Object | Signalling_LinkSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, Signalling_LinkSet, Signalling_Point |
Date Ranging | No |
Period Selection | Daily (Raw), Daily, Weekly, Monthly |
Summary Selection | Total |
Filtering | Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time (min) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: SS7 Linkset Availability Report (Linkset KPIs) (Table) | |||
% Linkset In-service | Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_available | User-defined | |
Linkset | Signalling_LinkSet.name | User-defined | |
Not displayed (for filtering only) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage | User-defined | |
Linkset Unavailable (s) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time | User-defined |
This report shows the utilisation of a set of linksets through the traffic carried on their constituent links.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Linkset |
Primary Object | Signalling_LinkSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, Signalling_LinkSet, Signalling_Point |
Date Ranging | No |
Period Selection | Daily (Raw), Daily, Weekly, Monthly |
Filtering | Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffic (min), Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_traffic (min), Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Linkset Utilisation Report (Table) | |||
# Links | Signalling_LinkSet.Neutral.GSM.signalling_linkset.links | Total | |
Linkset | Signalling_LinkSet.name | User-defined | |
TX Usage (Octets) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffic | transmitted_busy_hour | |
TX SIF/SIO Octets | Signalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_sif_sios | transmitted_busy_hour | |
TX MSUS | Signalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_msus | transmitted_busy_hour | |
TX Busy Hour | transmitted_busy_hour | transmitted_busy_hour | |
TX Average Link (Octets) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_outgoing_traffic | transmitted_busy_hour | |
RX Usage (Octets) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_traffic | received_busy_hour | |
RX SIF/SIO Octets | Signalling_LinkSet.Neutral.GSM.signalling_linkset.received_sif_sios | received_busy_hour | |
RX MSUS | Signalling_LinkSet.Neutral.GSM.signalling_linkset.received_msus | received_busy_hour | |
RX Busy Hour | received_busy_hour | received_busy_hour | |
RX Average Link (Octets) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_incoming_traffic | received_busy_hour | |
Not displayed (for filtering only) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage | User-defined |
This graph shows network incoming and mobile originating call statistics for the specified MSC over the selected days.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.MSC |
Primary Object | MSC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | MSC |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: MSC Calls Graph (Line Chart) | |||
Attempts | MSC.Neutral.GSM.traffic.call_attempts | User-defined | |
Failures | MSC.Neutral.GSM.traffic.call_failures | User-defined |
This graph is a bar chart showing the percentage data coverage of a selected MSC over a selected number of days. The graph uses the MSC.Traffic table to select a single traffic type and determines the total time for which data was collected for that traffic type on the selected days. Traffic type data is reported per MSC so if data is available for one traffic type from a MSC it is available for all traffic type from the MSC.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.MSC |
Primary Object | MSC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | MSC |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: MSC Data Coverage (Bar Chart) | |||
% Data Coverage | MSC.Neutral.GSM.traffic.%_data_coverage | User-defined |
This graph shows the handover performance of a MSC for inter-cell intra-MSC handover and incoming and outgoing inter-MSC handover.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.MSC |
Primary Object | MSC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | MSC |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Incoming Inter-MSC (Line Chart) | |||
Attempts | MSC.Neutral.GSM.handover.incoming_intermsc_attempts | User-defined | |
Failures | MSC.Neutral.GSM.handover.incoming_intermsc_failures | User-defined | |
Component 2: Inter-Cell Intra-MSC (Line Chart) | |||
Failures | MSC.Neutral.GSM.handover.interbsc_failures | User-defined | |
Successes | MSC.Neutral.GSM.handover.interbsc_successes | User-defined | |
Component 3: Outgoing Inter-MSC (Line Chart) | |||
Attempts | MSC.Neutral.GSM.handover.outgoing_intermsc_attempts | User-defined | |
Failures | MSC.Neutral.GSM.handover.outgoing_intermsc_failures | User-defined |
This report shows handover performance at the MSC level for either all MSCs in a region or all MSCs in the network during a selected time period. The report shows intra-MSC handover attempts and failures and incoming and outgoing inter-MSC handover attempts and failures.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.MSC |
Primary Object | MSC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, MSC |
Date Ranging | No |
Period Selection | Daily (Raw), Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering | MSC.Neutral.GSM.handover.%_data_coverage (min) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: MSC Handover Report (Table) | |||
Busy Hour | busy_hour | busy_hour | |
Incoming Inter-MSC Handover % Failure | MSC.Neutral.GSM.handover.%_incoming_intermsc_failure | User-defined | |
Incoming Inter-MSC Handover Attempts | MSC.Neutral.GSM.handover.incoming_intermsc_attempts | User-defined | |
Incoming Inter-MSC Handover Failures | MSC.Neutral.GSM.handover.incoming_intermsc_failures | User-defined | |
Inter-Cell Handover % Failure | MSC.Neutral.GSM.handover.%_interbsc_failure | User-defined | |
Inter-Cell Handover Attempts | MSC.Neutral.GSM.handover.interbsc_attempts | User-defined | |
Inter-Cell Handover Failures | MSC.Neutral.GSM.handover.interbsc_failures | User-defined | |
MSC | MSC.name | User-defined | |
Not displayed (for filtering only) | MSC.Neutral.GSM.handover.%_data_coverage | User-defined | |
Outgoing Inter-MSC Handover % Failure | MSC.Neutral.GSM.handover.%_outgoing_intermsc_failure | User-defined | |
Outgoing Inter-MSC Handover Attempts | MSC.Neutral.GSM.handover.outgoing_intermsc_attempts | User-defined | |
Outgoing Inter-MSC Handover Failures | MSC.Neutral.GSM.handover.outgoing_intermsc_failures | User-defined |
This graph shows the performance of the paging function for the MSC
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.MSC |
Primary Object | MSC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | MSC |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Global Paging (Line Chart) | |||
Failed to Respond | MSC.Neutral.GSM.page.global_unresponses | User-defined | |
Pages and Repages | MSC.Neutral.GSM.page.total_global_pages | User-defined | |
Component 2: Location Area Paging (Line Chart) | |||
Failed to Respond | MSC.Neutral.GSM.page.local_unresponses | User-defined | |
Pages and Repages | MSC.Neutral.GSM.page.total_local_pages | User-defined |
This graph shows the key traffic performance statistics for an MSC specifically the total switched traffic and total failed calls. Total switched traffic must be calculated by summing traffic from the appropriate traffic categories.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.MSC |
Primary Object | MSC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | MSC |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: % Failed Calls (Line Chart) | |||
% Failed Calls | MSC.Neutral.GSM.traffic.total_switched_traffic.%_call_failure | User-defined | |
Component 2: Total Switched Traffic (Line Chart) | |||
Total Switched Traffic | MSC.Neutral.GSM.traffic.total_switched_traffic.traffic | User-defined |
This report shows key switched traffic statistics for a single MSC or all MSCs in a region or all MSCs in the network during a selected time period. The report shows attempts, calls, failures, %failures, answered, % answered and traffic for all traffic types.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.MSC |
Primary Object | MSC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, MSC |
Date Ranging | No |
Period Selection | Daily (Raw), Daily, Weekly, Monthly |
Summary Selection | traffic_type_busy_hour, Total |
Filtering | MSC.Neutral.GSM.traffic.%_data_coverage (min) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: [ Traffic Type ] (Table) | |||
% Answered Calls | MSC.Neutral.GSM.traffic.%_answered_calls | User-defined | |
% Failed Calls | MSC.Neutral.GSM.traffic.%_call_failure | User-defined | |
Answered Calls | MSC.Neutral.GSM.traffic.answered_calls | User-defined | |
Attempts | MSC.Neutral.GSM.traffic.call_attempts | User-defined | |
Calls | MSC.Neutral.GSM.traffic.call_successes | User-defined | |
Failed Calls | MSC.Neutral.GSM.traffic.call_failures | User-defined | |
MSC | MSC.name | User-defined | |
MSC Busy Hour | traffic_type_busy_hour | traffic_type_busy_hour | |
Not displayed (for filtering only) | MSC.Neutral.GSM.traffic.%_data_coverage | User-defined | |
Traffic | MSC.Neutral.GSM.traffic.traffic | User-defined |
This report shows key switched traffic statistics for a single MSC or all MSCs in a region or all MSCs in the network during a selected time period. The report shows the total switched traffic calls, failures % failures, answered, %answered and traffic.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.MSC |
Primary Object | MSC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, MSC |
Date Ranging | No |
Period Selection | Daily (Raw), Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering | MSC.Neutral.GSM.traffic.total_switched_traffic.%_data_coverage (min) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: MSC Switched Traffic Report (Total Switched Traffic Type) (Table) | |||
% Answered Switched Calls | MSC.Neutral.GSM.traffic.total_switched_traffic.%_answered_calls | User-defined | |
% Failed Switched Calls | MSC.Neutral.GSM.traffic.total_switched_traffic.%_call_failure | User-defined | |
Switched Traffic | MSC.Neutral.GSM.traffic.total_switched_traffic.traffic | User-defined | |
Switched Calls | MSC.Neutral.GSM.traffic.total_switched_traffic.call_successes | User-defined | |
Switched Attempts | MSC.Neutral.GSM.traffic.total_switched_traffic.call_attempts | User-defined | |
Not displayed (for filtering only) | MSC.Neutral.GSM.traffic.total_switched_traffic.%_data_coverage | User-defined | |
MSC Busy Hour | busy_hour | busy_hour | |
MSC | MSC.name | User-defined | |
Failed Switched Calls | MSC.Neutral.GSM.traffic.total_switched_traffic.call_failures | User-defined | |
Answered Switched Calls | MSC.Neutral.GSM.traffic.total_switched_traffic.answered_calls | User-defined |
For each MSC this report shows calls, answered calls and traffic to each destination recorded by the MSC.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.MSC |
Primary Object | MSC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, MSC |
Date Ranging | No |
Period Selection | Daily (Raw), Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering | MSC.Neutral.GSM.destination.%_data_coverage (min) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: MSC Traffic Dispersion Report (Table) | |||
% Answers | MSC.Neutral.GSM.destination.%_answered_calls | User-defined | |
Answers | MSC.Neutral.GSM.destination.answered_calls | User-defined | |
Traffic | MSC.Neutral.GSM.destination.traffic | User-defined | |
Not displayed (for filtering only) | MSC.Neutral.GSM.destination.%_data_coverage | User-defined | |
MSC | MSC.name | User-defined | |
Destination | User-defined | ||
Calls | MSC.Neutral.GSM.destination.total_calls | User-defined | |
Busy Hour | busy_hour | busy_hour |
This graph shows the performance of a support processor associated with a node against time
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Processor |
Primary Object | Processor |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Processor |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Average |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Processor Load (Line Chart) | |||
% Load | Processor.Neutral.GSM.cpu.load_pc | User-defined |
This graph shows the congestion on a selected route
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Route_IF |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: % Congestion (Line Chart) | |||
% Congestion | Route_IF.Neutral.GSM.transmission.%_outgoing_congestions | User-defined | |
Component 2: Congestions (Line Chart) | |||
Congestions | Route_IF.Neutral.GSM.transmission.outgoing_congestions | User-defined | |
Component 3: Defined and Available Circuits (Line Chart) | |||
Available Circuits | Route_IF.Neutral.GSM.transmission.available_circuits | User-defined | |
Defined Circuits | Route_IF.Neutral.GSM.transmission.circuits | User-defined | |
Component 4: Outgoing Bids (Line Chart) | |||
Outgoing Bids | Route_IF.Neutral.GSM.transmission.bids | User-defined |
This report shows all routes that will reach exhaustion in the specified forecast. The report shows carried traffic, % congestion, % 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 routes.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, MSC, Route_IF |
Date Ranging | Yes |
Period Selection | Weekly |
Summary Selection | busy_hour, 3-day Average, 5-day Average |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Route Exhaustion Report (Table) | |||
End Date % Blocking | Route_IF.Neutral.GSM.transmission.%_outgoing_congestions | busy_hour | |
End Date % Utilisation | Route_IF.Neutral.GSM.transmission.offered_utilisation | busy_hour | |
End Date Capacity | Route_IF.Neutral.GSM.transmission.capacity | User-defined | |
End Date Grade Of Service | Route_IF.Neutral.GSM.transmission.grade_of_service | busy_hour | |
End Date Lost Traffic (E) | Route_IF.Neutral.GSM.transmission.lost_traffic | busy_hour | |
End Date Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | busy_hour | |
Exhaustion Date | Route_IF.Neutral.GSM.transmission.forecast.linear_exhaustion_date | User-defined | |
Is Exhausted | Route_IF.Neutral.GSM.transmission.is_exhausted | User-defined | |
Route | Route_IF.name | User-defined | |
Samples | Route_IF.Neutral.GSM.transmission.number_of_samples | User-defined | |
Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | User-defined | |
Traffic Growth (Erlangs/week) | Route_IF.Neutral.GSM.transmission.forecast.linear_traffic_growth | User-defined |
This chart shows the trend in the principal route interface parameters: busy hour traffic, 3-DAV and 5-DAV traffic
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Route_IF |
Date Ranging | Yes |
Period Selection | Weekly |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Route Interface Offered Traffic Graph (Line Chart) | |||
Capacity | Route_IF.Neutral.GSM.transmission.capacity | User-defined | |
Weekly 3-DAV Value | Route_IF.Neutral.GSM.transmission.traffic | 3-day Average | |
Weekly 5-DAV Value | Route_IF.Neutral.GSM.transmission.traffic | 5-day Average | |
Weekly Busy Hour Value | Route_IF.Neutral.GSM.transmission.traffic | busy_hour |
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.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Route_IF |
Date Ranging | Yes |
Period Selection | Weekly |
Summary Selection | busy_hour, 3-day Average, 5-day Average |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: [N]-Day Route Interface Traffic Forecast Graph (Line Chart) | |||
Capacity GOS=[GOS1] | Route_IF.Neutral.GSM.transmission.forecast.capacity | User-defined | |
Coefficient of Regression | Route_IF.Neutral.GSM.transmission.forecast.linear_regression_coefficient | User-defined | |
Growth is [linear_traffic_growth] Erlangs/week | Route_IF.Neutral.GSM.transmission.forecast.linear_traffic_growth | User-defined | |
Route Interface [will reach exhaustion on date|will not reach exhaustion in this period] | Route_IF.Neutral.GSM.transmission.forecast.linear_exhaustion_date | User-defined | |
Standard Error of Regression | Route_IF.Neutral.GSM.transmission.forecast.linear_regression_error | User-defined | |
Traffic | Route_IF.Neutral.GSM.transmission.traffic | User-defined | |
Traffic Forecast | Route_IF.Neutral.GSM.transmission.forecast.traffic | User-defined |
This report shows all routes 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, % congestion, % 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.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, MSC, Route_IF |
Date Ranging | Yes |
Period Selection | Weekly |
Summary Selection | busy_hour, 3-day Average, 5-day Average |
Filtering | Route_IF.Neutral.GSM.transmission.offered_utilisation (max), Route_IF.Neutral.GSM.transmission.forecast.utilisation (max) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Route Low Utilisation Report (Table) | |||
Capacity | Route_IF.Neutral.GSM.transmission.capacity | User-defined | |
End Date % Congested | Route_IF.Neutral.GSM.transmission.%_outgoing_congestions | busy_hour | |
End Date % Utilisation | Route_IF.Neutral.GSM.transmission.offered_utilisation | busy_hour | |
End Date Grade of Service | Route_IF.Neutral.GSM.transmission.grade_of_service | busy_hour | |
End Date Lost Traffic (E) | Route_IF.Neutral.GSM.transmission.lost_traffic | busy_hour | |
End Date Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | busy_hour | |
Forecast % Utilisation | Route_IF.Neutral.GSM.transmission.forecast.utilisation | busy_hour | |
Route | Route_IF.name | User-defined | |
Samples | Route_IF.Neutral.GSM.transmission.number_of_samples | User-defined | |
Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | User-defined |
This report shows the forecast circuit requirements for a set of routes 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 routes, the report shows the sample size, the correlation coefficient of the forecast, the actual and required number of circuits and the selected dimensioning parameter in the latest busy hour and then the required circuits 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 with weekly busy hour values.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, MSC, Route_IF |
Date Ranging | Yes |
Period Selection | Weekly |
Summary Selection | busy_hour, 3-day Average, 5-day Average |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Route Required Circuits Report (Table) | |||
End Date Defined Circuits | Route_IF.Neutral.GSM.transmission.circuits | busy_hour | |
End Date Grade Of Service | Route_IF.Neutral.GSM.transmission.grade_of_service | busy_hour | |
[N3] Days Forecast Extra Circuits | Route_IF.Neutral.GSM.transmission.forecast.extra_circuits | User-defined | |
[N1] Days Forecast Required No. Of Circuits | Route_IF.Neutral.GSM.transmission.forecast.required_circuits | User-defined | |
Samples | Route_IF.Neutral.GSM.transmission.number_of_samples | User-defined | |
Route | Route_IF.name | User-defined | |
Latest Actual Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | User-defined | |
Latest Actual Required No. Of Circuits | Route_IF.Neutral.GSM.transmission.required_circuits | User-defined | |
End Date Utilisation | Route_IF.Neutral.GSM.transmission.offered_utilisation | busy_hour | |
End Date Lost Traffic (E) | Route_IF.Neutral.GSM.transmission.lost_traffic | busy_hour |
This graph shows the traffic profile for a selected route.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Route_IF |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Answer Seize Ratio (Line Chart) | |||
% Answer Seize Ratio | Route_IF.Neutral.GSM.transmission.%_outgoing_answered | User-defined | |
Component 2: Calls (Line Chart) | |||
Incoming | Route_IF.Neutral.GSM.transmission.incoming_calls | User-defined | |
Outgoing | Route_IF.Neutral.GSM.transmission.outgoing_calls | User-defined | |
Component 3: Traffic (Line Chart) | |||
Incoming | Route_IF.Neutral.GSM.transmission.incoming_traffic | User-defined | |
Outgoing | Route_IF.Neutral.GSM.transmission.outgoing_traffic | User-defined |
This report shows key route traffic statistics for either all routes or all routes in a specified region or all routes from a specified MSC or all routes of a certain type during a selected time period.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, MSC, Route_IF |
Date Ranging | No |
Period Selection | Daily (Raw), Daily, Weekly, Monthly |
Summary Selection | incoming_busy_hour, outgoing_busy_hour, busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Bothway (Table) | |||
% Utilisation | Route_IF.Neutral.GSM.transmission.offered_utilisation | User-defined | |
ASR | Route_IF.Neutral.GSM.transmission.%_bothway_answered | User-defined | |
Available Circuits | Route_IF.Neutral.GSM.transmission.available_circuits | User-defined | |
Busy Hour | busy_hour | busy_hour | |
Calls | Route_IF.Neutral.GSM.transmission.bothway_calls | User-defined | |
Congestion | Route_IF.Neutral.GSM.transmission.%_outgoing_congestions | User-defined | |
Defined Circuits | Route_IF.Neutral.GSM.transmission.circuits | User-defined | |
GOS | Route_IF.Neutral.GSM.transmission.grade_of_service | User-defined | |
Route | Route_IF.name | User-defined | |
Traffic | Route_IF.Neutral.GSM.transmission.bothway_traffic | User-defined | |
Component 2: Incoming (Table) | |||
ASR | Route_IF.Neutral.GSM.transmission.%_incoming_answered | User-defined | |
Busy Hour | incoming_busy_hour | incoming_busy_hour | |
Calls | Route_IF.Neutral.GSM.transmission.incoming_calls | User-defined | |
Route | Route_IF.name | User-defined | |
Traffic | Route_IF.Neutral.GSM.transmission.incoming_traffic | User-defined | |
Component 3: Outgoing (Table) | |||
ASR | Route_IF.Neutral.GSM.transmission.%_outgoing_answered | User-defined | |
Busy Hour | outgoing_busy_hour | outgoing_busy_hour | |
Calls | Route_IF.Neutral.GSM.transmission.outgoing_calls | User-defined | |
Congestions | Route_IF.Neutral.GSM.transmission.%_outgoing_congestions | User-defined | |
Route | Route_IF.name | User-defined | |
Traffic | Route_IF.Neutral.GSM.transmission.outgoing_traffic | User-defined |
This graph shows the trend in utilisation of a route: traffic (offered and carried), % utilisation and calculated GOS.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Route_IF |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: % Utilisation (Line Chart)
Graph Overlay Value: User-defined 100% overlay |
|||
% Utilisation | Route_IF.Neutral.GSM.transmission.offered_utilisation | User-defined | |
Component 2: Carried Traffic (E) (Line Chart) | |||
Critical Traffic (overlay) | Route_IF.Neutral.GSM.transmission.capacity | User-defined | |
Traffic (E) | Route_IF.Neutral.GSM.transmission.bothway_traffic | User-defined | |
Component 3: GoS (Line Chart)
Graph Overlay Value: User-defined Desgin GOS overlay |
|||
Grade Of Service | Route_IF.Neutral.GSM.transmission.grade_of_service | User-defined | |
Component 4: Offered Traffic (E) (Line Chart) | |||
Critical Traffic (overlay) | Route_IF.Neutral.GSM.transmission.capacity | User-defined | |
Traffic (E) | Route_IF.Neutral.GSM.transmission.offered_traffic | User-defined |
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.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Linkset |
Primary Object | Signalling_LinkSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, Signalling_LinkSet, Signalling_Point |
Date Ranging | Yes |
Period Selection | Weekly |
Summary Selection | received_busy_hour, transmitted_busy_hour |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: SS7 Linkset Exhaustion Report (Table) | |||
Capacity | Signalling_LinkSet.Neutral.GSM.signalling_linkset.capacity | User-defined | |
Designed Link Failures | Signalling_LinkSet.Designed_Link_Failures | User-defined | |
Exhaustion Date | Signalling_LinkSet.Neutral.GSM.forecast.linear_exhaustion_date | User-defined | |
In-Failure Capacity | Signalling_LinkSet.Neutral.GSM.signalling_linkset.in_failure_capacity | User-defined | |
Is Exhausted | Signalling_LinkSet.Neutral.GSM.signalling_linkset.is_exhausted | User-defined | |
Links | Signalling_LinkSet.Neutral.GSM.signalling_linkset.links | User-defined | |
Linkset Name | Signalling_LinkSet.name | User-defined | |
MSUs | Signalling_LinkSet.Neutral.GSM.signalling_linkset.msus | User-defined | |
Samples | Signalling_LinkSet.Neutral.GSM.signalling_linkset.number_of_samples | User-defined | |
Traffic | Signalling_LinkSet.Neutral.GSM.signalling_linkset.traffic | User-defined | |
Traffic Forecast | Signalling_LinkSet.Neutral.GSM.forecast.traffic | User-defined | |
Traffic Growth | Signalling_LinkSet.Neutral.GSM.forecast.linear_traffic_growth | User-defined |
This graph shows the link availability for a selected SS7 link
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Link |
Primary Object | Signalling_Link |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Signalling_Link |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Total % Link Availability (Line Chart) | |||
% Link Availability | Signalling_Link.Neutral.GSM.link.%_available | Total | |
Component 2: Total % Local Busy (Line Chart) | |||
% Local Busy | Signalling_Link.Neutral.GSM.link.%_local_inhibition_time | Total | |
Component 3: Total Link Failures (Line Chart) | |||
Link Failures | Signalling_Link.Neutral.GSM.link.failures | Total |
This graph shows the linkset availability of the constituent links for a selected SS7 linkset.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Linkset |
Primary Object | Signalling_LinkSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Signalling_LinkSet |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Total % Link Availability (Line Chart) | |||
% Link Availability | Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_%_available | Total | |
Component 2: Total Link Failures (Line Chart) | |||
Link Failures | Signalling_LinkSet.Neutral.GSM.signalling_linkset.total_failures | Total |
This graph shows the linkset availability for a selected SS7 linkset.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Linkset |
Primary Object | Signalling_LinkSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Signalling_LinkSet |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Total % Linkset Availability (Line Chart) | |||
% Linkset Availability | Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_available | Total | |
Component 2: Total Linkset Failures (Line Chart) | |||
Linkset Failures | Signalling_LinkSet.Neutral.GSM.signalling_linkset.failures | Total |
This graph shows the linkset transmission and reception utilisation for a selected SS7 link.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Linkset |
Primary Object | Signalling_LinkSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Signalling_LinkSet |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | received_busy_hour, transmitted_busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Signalling Linkset MSUs on Linkset (Line Chart) | |||
RX | Signalling_LinkSet.Neutral.GSM.signalling_linkset.received_msus | User-defined | |
TX | Signalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_msus | User-defined | |
Component 2: Signalling Linkset Traffic (Octets) (Line Chart) | |||
Incoming | Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_traffic | User-defined | |
Outgoing | Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffic | User-defined |
This report shows the utilisation of a set of linksets through the traffic received on their constituent links.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Linkset |
Primary Object | Signalling_LinkSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, Signalling_LinkSet, Signalling_Point |
Date Ranging | No |
Period Selection | Daily (Raw), Daily, Weekly, Monthly |
Summary Selection | received_busy_hour, Total |
Filtering | Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: SS7 Linkset Utilisation Report (RX) (Table) | |||
# Links | Signalling_LinkSet.Neutral.GSM.signalling_linkset.links | User-defined | |
Linkset | Signalling_LinkSet.name | User-defined | |
Not displayed (for filtering only) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage | User-defined | |
RX Average Link (Octets) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_incoming_traffic | User-defined | |
RX Busy Hour | received_busy_hour | received_busy_hour | |
RX MSUS | Signalling_LinkSet.Neutral.GSM.signalling_linkset.received_msus | User-defined | |
RX SIF/SIO Octets | Signalling_LinkSet.Neutral.GSM.signalling_linkset.received_sif_sios | User-defined | |
RX Usage (Octets) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_traffic | User-defined |
This report shows the utilisation of a set of linksets through the traffic transmitted on their constituent links.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Linkset |
Primary Object | Signalling_LinkSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, Signalling_LinkSet, Signalling_Point |
Date Ranging | No |
Period Selection | Daily (Raw), Daily, Weekly, Monthly |
Summary Selection | transmitted_busy_hour, Total |
Filtering | Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: SS7 Linkset Utilisation Report (TX) (Table) | |||
# Links | Signalling_LinkSet.Neutral.GSM.signalling_linkset.links | User-defined | |
Linkset | Signalling_LinkSet.name | User-defined | |
TX Usage (Octets) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffic | User-defined | |
TX SIF/SIO Octets | Signalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_sif_sios | User-defined | |
TX MSUS | Signalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_msus | User-defined | |
TX Busy Hour | transmitted_busy_hour | transmitted_busy_hour | |
TX Average Link (Octets) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_outgoing_traffic | User-defined | |
Not displayed (for filtering only) | Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage | User-defined |
This graph shows the link utilisation for a selected SS7 link.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Link |
Primary Object | Signalling_Link |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Signalling_Link |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | received_busy_hour, transmitted_busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: MSUs (Line Chart) | |||
Received | Signalling_Link.Neutral.GSM.link.received_msus | User-defined | |
Transmitted | Signalling_Link.Neutral.GSM.link.transmitted_msus | User-defined | |
Component 2: SIF and SIO Octets (Line Chart) | |||
Received | Signalling_Link.Neutral.GSM.link.received_sif_sios | User-defined | |
Transmitted | Signalling_Link.Neutral.GSM.link.transmitted_sif_sios | User-defined | |
Component 3: Traffic (Line Chart) | |||
Incoming | Signalling_Link.Neutral.GSM.link.incoming_traffic | User-defined | |
Outgoing | Signalling_Link.Neutral.GSM.link.outgoing_traffic | User-defined |
This graph shows the routeset availability for a selected SS7 routeset
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Routeset |
Primary Object | Signalling_RouteSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Signalling_RouteSet |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: % Routeset Availability (Line Chart) | |||
% Availability | Signalling_RouteSet.Neutral.GSM.routeset.%_available | User-defined | |
Component 2: Total Routeset Failures (Line Chart) | |||
Total Failures | Signalling_RouteSet.Neutral.GSM.routeset.failures | User-defined |
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.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Linkset |
Primary Object | Signalling_LinkSet |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Signalling_LinkSet |
Date Ranging | Yes |
Period Selection | Weekly |
Summary Selection | received_busy_hour, transmitted_busy_hour |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Heading (Line Chart) | |||
Coefficient of Regression | Signalling_LinkSet.Neutral.GSM.forecast.linear_regression_coefficient | User-defined | |
Growth is {linear_traffic_growth} | Signalling_LinkSet.Neutral.GSM.forecast.linear_traffic_growth | User-defined | |
Linkset [will reach exhaustion on {linear_exhaustion_date}|will not reach exhaustion in this period] | Signalling_LinkSet.Neutral.GSM.forecast.linear_exhaustion_date | User-defined | |
Standard Error of Regression | Signalling_LinkSet.Neutral.GSM.forecast.linear_regression_error | User-defined | |
Component 2: SS7 Signalling Linkset Traffic Forecast Graph (Line Chart) | |||
Capacity | Signalling_LinkSet.Neutral.GSM.forecast.capacity | User-defined | |
Forecast Traffic | Signalling_LinkSet.Neutral.GSM.forecast.traffic | User-defined | |
Traffic | Signalling_LinkSet.Neutral.GSM.signalling_linkset.traffic | User-defined | |
In-Failure Capacity | Signalling_LinkSet.Neutral.GSM.forecast.in_failure_capacity | User-defined |
This report shows key route traffic statistics for a set of routes in a selected time period. The report shows available & defined circuits, % congestion, 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.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.Route |
Primary Object | Route_IF |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | Region, MSC, Route_IF |
Date Ranging | No |
Period Selection | Weekly |
Filtering | Route_IF.Neutral.GSM.transmission.traffic (min), Route_IF.Neutral.GSM.transmission.grade_of_service (min), Route_IF.Neutral.GSM.transmission.lost_traffic (min), Route_IF.Neutral.GSM.transmission.offered_utilisation (min) |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: Summary Route Traffic Report (Table) | |||
3-DAV Summarised Carried Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | 3-day Average | |
5-DAV Summarised Carried Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | 5-day Average | |
Available Circuits | Route_IF.Neutral.GSM.transmission.available_circuits | busy_hour | |
Blocking (%) | Route_IF.Neutral.GSM.transmission.%_outgoing_congestions | busy_hour | |
Busy Hour | busy_hour | busy_hour | |
Capacity | Route_IF.Neutral.GSM.transmission.capacity | busy_hour | |
Carried Traffic (E) | Route_IF.Neutral.GSM.transmission.traffic | User-defined | |
Defined Circuits | Route_IF.Neutral.GSM.transmission.circuits | busy_hour | |
Grade of Service | Route_IF.Neutral.GSM.transmission.grade_of_service | busy_hour | |
Lost Traffic (E) | Route_IF.Neutral.GSM.transmission.lost_traffic | busy_hour | |
Offered Traffic (E) | Route_IF.Neutral.GSM.transmission.offered_traffic | busy_hour | |
Offered Utilisation | Route_IF.Neutral.GSM.transmission.offered_utilisation | busy_hour | |
Route | Route_IF.name | User-defined |
This graph shows the total switch traffic for the appropriate traffic categories totalled for all MSCs in the network.
Report Feature | Details |
---|---|
Report Tree Branch | GSM.Engineering.Core Network.System |
Primary Object | MSC |
Drill-down Behaviour |
Parameter | Options |
---|---|
Object Selection | |
Date Ranging | Yes |
Period Selection | Raw, Daily, Weekly, Monthly |
Summary Selection | busy_hour, Total |
Filtering |
Label | Attribute/KPI | Summary Type | Overlay |
---|---|---|---|
Component 1: System Traffic (MSC) Graph (Line Chart) | |||
Traffic (E) | MSC.Neutral.GSM.traffic.total_switched_traffic.traffic | User-defined |
This section lists the data availability definitions for the network objects previously described.
Grouping Object | KPI Type | Reporting Object | Defining KPI Group |
---|---|---|---|
HLR | HLRs Reporting | HLR | HLR.Neutral.GSM.access |
MSC | MSCs Reporting | MSC | MSC.Neutral.GSM.page |