Kpi Formula 20131106 2g Dashboard Report Huawei
Kpi Formula 20131106 2g Dashboard Report Huawei
Kpi Formula 20131106 2g Dashboard Report Huawei
DATE
Installed Capacity
1
1.1 HLR
2.1 BSC
2.4.1 Macro
2.4.2 Micro
2.4.3 IBS
SUBSCRIBERS DATA
3
3.1.1 Registered
3.1.2 Un-Registered
3.2.2 Detached
GPRS
3.4
SMS Usage
4
NETWORK USAGE
5
NBH Period
6 RF KPIs
Total Uptime(mins)
2G to 3G HOSR
7 Switch(MSS) KPIs
7.1 TSR/SCR
7.2 ASR(overall)
7.2.1 TTSL - TTSL NLD
ASR(NBH)
8 Switch(MGW) KPIs
Data Retainability
10
11 Data Quality
13.6 BHCA/Sub
17 Total Sites
POI utilized> 90 %
18 Data Traffic
MAX of {([Local Zone].[Short Message Service].[SMMO SUCCESS TIMES] + [Local Zone].[Short Message Se
NBH Period
CM33:Call Drops on Traffic Channel/ (K3013A:Successful TCH Seizures (Traffic Channel)+ CH323:Successful Inc
CH343:Successful Incoming External Inter-Cell Handovers – CH313:Successful Outgoing Internal Inter-Cell Han
External Inter-Cell Handovers) * 100*%
(CH313:Successful Outgoing Internal Inter-Cell Handovers + CH333:Successful External Outgoing inter-Cell Hand
Cell Handover Commands + CH331:Outgoing External Inter-Cell Handover Commands
CM33:Call Drops on Traffic Channel/ (K3013A:Successful TCH Seizures (Traffic Channel)+ CH323:Successful Inc
CH343:Successful Incoming External Inter-Cell Handovers – CH313:Successful Outgoing Internal Inter-Cell Han
External
(CH313:Successful Outgoing Internal Inter-Cell Handovers Inter-Cell Handovers)
+ CH333:Successful * 100*%
External Outgoing inter-Cell Ha
Internal Inter-Cell Handovers (Reconnection to Old Channels) + CH332D:Failed Outgoing External Inter-Cell Hando
(Outgoing Outgoing
(CH313:Successful Internal Inter-Cell CH311:Handover
Internal Inter-Cell Commands
Handovers + CH331:Outgoing
+ CH333:Successful External
External Inter-Cell
Outgoing Hand
inter-Cell Ha
Internal Inter-Cell Handovers (Reconnection to Old Channels) + CH332D:Failed Outgoing External Inter-Cell Hando
([TRX].[Receive Quality Measurement
(Outgoing Distribution
Internal Inter-Cell per TRX].[NCS413A:Number
CH311:Handover of MRs on Uplink
Commands + CH331:Outgoing External TCHF (Receive
Inter-Cell HandQu
Measurement Distribution per TRX].[NCS413B:Number of MRs on Uplink TCHF (Receive Quality Rank 1)] + [TR
[Cell].[KPIper
Distribution Measurement
([TRX].[Receive per Cell].[K3014:Traffic
Quality Measurement
TRX].[NCS413C:Number of MRs onVolume
Distribution Uplink on TCH]
TCHF * 60/[Cell].[Call
per TRX].[NCS412A:Number
(Receive Drop
QualityofRank
MRs 2)]Measurement
on +Downlink per Cell].[C
TCHF
[TRX].[Receive (Recei
Quali
Quality Measurement Distribution per TRX].[NCS412B:Number of MRs on Downlink
[NCS413D:Number of MRs on Uplink TCHF (Receive Quality Rank 3)] + [TRX].[Receive Quality Measurement TCHF (Receive Quality
DistriR
Measurement Distribution per TRX].[NCS412C:Number of MRs on Downlink TCHF (Receive
MRs on Uplink TCHF (Receive Quality Rank 4)] + [TRX].[Receive Quality Measurement Distribution per TRX].[NCS Quality Rank 2)] + [T
([TRX].[Receive
Distribution
(Receive QualityQuality
per Rank Measurement
TRX].[NCS412D:Number
5)] Distribution
+ [TRX].[Receive of MRsper
Quality on TRX].[NCS413A:Number
Downlink
Measurement TCHF (Receive
Distribution of MRs on
Quality
per Uplink
Rank 3)] +TCHF
TRX].[NCS413G:Number (Receive
[TRX].[Receive
of MRs QuQ
6)] Measurement
+ [TRX].[Receive Distribution
TRX].[NCS412E:Number per TRX].[NCS413B:Number
of MRs
Quality Measurement on Downlink TCHF
Distribution of MRs on
per(Receive Uplink
Quality
TRX].[NCS413H:Number TCHF
Rank 4)](Receive
+ Quality
of[TRX].[Receive
MRs on Uplink Rank 1)](Rece
Quality
TCHF + [TR
Meas
([TRX].[Receive
Distribution
[NCS412F:Number
Quality Measurement Quality
of MRs Measurement
per TRX].[NCS413C:Number
on Downlink
Distribution Distribution
of MRs
TCHF per Quality
(Receive
per TRX].[NCS415A:Number TRX].[NCS412A:Number
on Uplink TCHF of(Receive
Rank
MRs 5)]on Qualityof MRs(Receive
Rank
+ [TRX].[Receive
Uplink TCHH on
2)] +Downlink
Quality TCHF
[TRX].[Receive
Measurement
Quality Rank(Recei
Quali
Dis
0)] +
of Quality
[NCS413D:Number Measurement
MRs on Downlink
Distribution of MRs Distribution
on Uplink
TCHF (Receive Quality
per TRX].[NCS415B:Number per
TCHF TRX].[NCS412B:Number
(Receive
of Rank
MRs on Quality
6)] Uplink Rank
+ [TRX].[Receive 3)]
TCHH (Receiveof
+ MRs on Downlink
[TRX].[Receive
Quality Measurement
Quality TCHF
Quality
Rank 1)] + (Receive
Measurement
Distribution
[TRX].[Receive Quality
Distri
per TRX].[
Quali R
Measurement
MRs
TCHF on(Receive
[NCS415C:Number Distribution
Uplink TCHF
Quality
MRs onper
of (Receive
Rank 7)]TRX].[NCS412C:Number
Quality Rank(Receive
+ [TRX].[Receive
Uplink TCHH Quality of
Quality MRs
4)] + [TRX].[Receive on
2)]Downlink
RankQuality
Measurement TCHF (Receive
Measurement
Distribution
+ [TRX].[Receive Quality
Distribution
per perRank 2)]
TRX].[NCS
TRX].[NCS414A:Number
Quality Measurement + [T
Distri
MRs on Uplink TCHH (Receive Quality Rank 3)] + [TRX].[Receive Quality Measurement Distribution per TRX].[NCSQ
Distribution
(Receive
Quality Rank per
Quality
0)] +TRX].[NCS412D:Number
Rank 5)] + [TRX].[Receive
[TRX].[Receive Quality of MRs
Quality
Measurementon Downlink
Measurement TCHF (Receive
Distribution
Distribution per Quality
per Rank 3)] +
TRX].[NCS413G:Number
TRX].[NCS414B:Number [TRX].[Receive
of MRs onof MRs
Down
6)] TRX].[NCS412E:Number
+ [TRX].[Receive
[TRX].[Receive
(Receive Quality
Quality
Quality Rank of MRs on
Measurement
5)]Measurement
+ [TRX].[Receive Downlink
Distribution
Quality TCHF
Distribution
per per(Receive Quality Rank
TRX].[NCS413H:Number
TRX].[NCS414C:Number
Measurement Distribution 4)]MRs
perof +
of[TRX].[Receive
MRs on UplinkTCHH
on Downlink
TRX].[NCS415E:Number Quality
TCHF Meas
(Rece
of(Recei
MRs o
[NCS412F:Number
Quality Measurement
4)] + Quality of
Measurement
[TRX].[Receive MRs
Quality on Downlink
Distribution
Distribution
Measurement TCHF (Receive
per TRX].[NCS415A:Number
perDistribution Quality
TRX].[NCS414D:Number Rank
of MRs 5)]
ofon +
MRs[TRX].[Receive
Uplink
per TRX].[NCS415G:Number TCHH
on Downlink Quality
(Receive
of MRs TCHH Measurement
Quality
(Receive
on Uplink Rank
TCHH Dis
0)]
Quality
(Rece R+
of MRs on Downlink
Distribution
Measurement TCHF (Receive
per TRX].[NCS415B:Number
Distribution
Quality Quality
of Rank
MRs on
per TRX].[NCS414E:Number
Measurement 6)] Uplink
Distribution + per
[TRX].[Receive
ofTCHH Quality
MRs (Receive
on Downlink
TRX].[NCS415H:Number Measurement
Quality
TCHH Rank
of MRs Distribution
1)]on
(Receive+ [TRX].[Receive
Quality
Uplink per(Receiv
Rank
TCHH TRX].[
Quali
4)] + [T
TCHF (Receive
[NCS415C:Number Quality
of MRs Rank
on 7)] +
Uplink[TRX].[Receive
TCHH (Receive Quality
QualityMeasurement
Rank 2)] + Distribution
[TRX].[Receive per
Distribution per TRX].[NCS414F:Number of MRs on Downlink TCHH (Receive Quality Rank 5)] + [TRX].[Receive TRX].[NCS414A:Number
Quality Measurement DistriQ
Quality
MRs on Rank 0)]TCHH
Uplink + [TRX].[Receive
TRX].[NCS414G:Number Quality
(Receive Quality
of MRs on Measurement
Rank Distribution
3)] + [TRX].[Receive
Downlink TCHH per TRX].[NCS414B:Number
Quality
(Receive QualityMeasurement Distribution
Rank 6)] + [TRX].[Receive ofper
MRs on Down
TRX].[NCS
Quality Mea
[TRX].[Receive
(Receive Quality
Quality Rank 5)]Measurement
+ [TRX].[ReceiveDistribution per TRX].[NCS414C:Number
Quality Measurement
[NCS414H:Number Distribution
of MRs on Downlink of
perTCHHMRs(Receive
on Downlink
TRX].[NCS415E:Number
Quality TCHH of(Recei
Rank MRs
7)]) o
+ Quality
4)]((All Measurement
[TRX].[Receive
EOS Causes) Quality Distribution
Measurement
- (CAUSE013_switch perequipment
TRX].[NCS414D:Number
Distribution of MRs on Downlink
per TRX].[NCS415G:Number
congestion + CAUSE027_switch of MRs TCHH (Receive
on Uplink
equipment TCHH
failure Quality
+ (Rece
CAUSE R
Measurement Distribution
CAUSE061_no CR resource per TRX].[NCS414E:Number
Quality Measurement
+ CAUSE062_no Distribution of MRs on Downlink
per TRX].[NCS415H:Number
CCB resource TCHH
+ CAUSE082_No A interface (Receive
of MRs Quality
on Uplink
resource Rank
forTCHH 4)] +
(Receiv
a bearer serv[T
Distribution per TRX].[NCS414F:Number
+ CAUSE151_no of MRs on Downlink
free circuit + CAUSE170_device TCHH (Receive
congestion Quality Rank
+ CAUSE186_no 5)] + [TRX].[Receive
available bearer capabiliQ
TRX].[NCS414G:Number of MRs on Downlink TCHH (Receive Quality Rank 6)] + [TRX].[Receive Quality Mea
CAUSE162+CAUSE166+CAUSE016+CAUSE155+CAUSE175+CAUSE239+CAUSE254+Causes172)) /
(sum of incoming answer times and outgoing [NCS414H:Number of MRs onofDownlink
answer times)/((sum incomingTCHH
seizure(Receive
times andQuality Rank 7)])
outgoing seizu
ASR Calculation For this category
([Trunk Group].[Trunk Group Traffic].[INCOMING SEIZURE TRAFFIC] + [Trunk Group].[Trunk Group Traffic].[Outg
(pm4h_ad.toseb([Trunk Group].[Trunk Group Traffic].[Number of Bidirectional Available Circuits for Outg
([Trunk Group].[Trunk Group Traffic].[INCOMING SEIZURE TRAFFIC] + [Trunk Group].[Trunk Group Traffic].[Outg
(pm4h_ad.toseb([Trunk Group].[Trunk Group Traffic].[Number of Bidirectional Available Circuits for Outg
[Local Zone of caller].[GSM Subscriber Originated Calls].[Call Setup Time]/[BSC Office Direction].[MSC CS
[SMMO
((([Location TIMES] - [SMMO FAIL
Section].[Location FOR FACILITY
Management NOT SUPPORTED]
Service].[Number + [SMMO
of no suitable FAIL
cells FOR location
update CIPHER MODE
failure]SETTIN
+ [Loca
Service].[Number
SMMT of illegal
Failures =([SMMT equippment
Failures due to update AUTHENTICATION
Absentlocation FAILURE]))/[SMMO
failure] + [Location
Subscribers]+[SMMT TIMES]
Section].[Location
Failures * 100)
Management Ser
due to Busy Subscribers]+[SMMT
location
[SMMT failure]due
Failures + [Location
to IllegalSection].[Location
Subscribers]+[SMMT Management
Failures Service].[Number
due to Local-based of network
Service failure update Failures
Barring]+[SMMT location df
pm4h_ad.countingh(([Cell].[Outgoing
Management Service].[Number of LAIInternal
prohibitInter-Cell
update Handover
location Measurement
failure] + perSection].[Location
[Location Cell].[CH313:Successful
ManagemeOut
Failures due to Roaming Restriction]+[SMMT
[Cell].[Outgoing HandoverFailures due to per
SM Cell].[CH333:Successful
Delivery Failures]+[SMMT Failures External
due to Subsc
prohibit update External
location Inter-Cell
failure]
Unidentified + [Location
Subscribers]+[SMMT
Measurement
Section].[Location
Failures due Management
to User Group]+[SMMT
Outgoing
Service].[Number
Failures of
dueother Inter
cause
to ZC-base u
External Inter-Cell Handover Measurement per Cell].[CH332D:Failed Outgoing External Inter-Cell
Section].[Location Management Service].[Number of update location failure due to non protocol user] + [Locati Handovers (Rec
[Outgoing Internal Inter-Cell
Service].[Number of PLMNHandover Measurement
prohibit access per Cell].[CH312D:Failed
update location failure] + [LocationOutgoing Internal Inter-Cell
Section].[Location HandovS
Management
([Cell].[Outgoing Internal Inter-Cell Handover Measurement per Cell].[CH311:Outgoing
failure due to ARD] + [Location Section].[Location Management Service].[Number of HLR unknow user updateInternal Inter-Cell Handolo
External Inter-Cell Handover Measurement per Cell].[CH331:Outgoing External
[Location Management Service].[Number of Roaming prohibit update location failure] + [Location Section].[Locat Inter-Cell Handover
local subscription
[Location roam restrict
Section].[Location update location
Management failure]) + ([Location
Service].[Successful PeriodicSection].[Location Management
Location Updates]/[Location Service].[
Section].[Lo
Inter_VLR] + [Location Section].[Location ManagementofService].[Number of Normal
Periodic Location Update] * 100 Location Update Intra_VL
Management Service].[Successful Normal Inter-VLR Location Updates] - [Location Section].[Location Manageme
([Location Section].[Traffic
VLR Location Updates] Measurement Of Paging].[AIM interface
- [Location Section].[Location Management first Service].[Number
paging response number]
of Location+ [Location Sec
Update rejec
[AIM interface repeat paging response number])/[Location Section].[Traffic Measurement
Management Service].[Successful Normal Inter-VLR Location Updates] + [Location Section].[Location Manageme Of Paging].[AIM interf
VLR Location Updates]))/([Location
greatest([Certain Section].[Location
M3UA Signaling Link].[M3UA Management
Signaling Link Service].[Number
Traffic].[Receive of Normal
Load],[Certain M3UALocation
SignalingUpda
Link
[Location Management Service].[Number of Normal
Load]) Location Update Intra_VLR])
Not Reporting
Not Reporting
Err:512
Err:512
([A9303:Number of Failed Downlink EGPRS TBF Establishments due to No Channel]+[A9203:Number of Failed Upl
No Channel])/([A9201:Number of Uplink EGPRS TBF Establishment Attempts]+[A9301:Number of Downlink EGPR
Not Reporting
Not Reporting
Not Reporting
Not Reporting
([Cell].[Uplink EGPRS RLC Data Transfer Capabilty Measurement].[TL9237:Throughput of Uplink EGPRS RLC Da
Data Transfer Capabilty Measurement].[TL9023:Throughput of Uplink GPRS RLC Data B
([Cell].[Downlink EGPRS RLC Data Transfer Capabilty Measurement].[TL9338:Throughput of Downlink EGPRS RLC
RLC Data Transfer Capabilty Measurement].[TL9123:Throughput of Downlink GPRS RLC Da
([Cell].[Uplink EGPRS RLC Data Transfer Capabilty Measurement].[TL9237:Throughput of Uplink EGPRS RLC Da
Data Transfer Capabilty Measurement].[TL9023:Throughput of Uplink GPRS RLC Data B
([Cell].[Downlink EGPRS RLC Data Transfer Capabilty Measurement].[TL9338:Throughput of Downlink EGPRS RLC
RLC Data Transfer Capabilty Measurement].[TL9123:Throughput of Downlink GPRS RLC Da
([Cell].[Uplink EGPRS RLC Data Transfer Capabilty Measurement].[TL9237:Throughput of Uplink EGPRS RLC Da
Data Transfer Capabilty Measurement].[TL9023:Throughput of Uplink GPRS RLC Data B
([Cell].[Downlink EGPRS RLC Data Transfer Capabilty Measurement].[TL9338:Throughput of Downlink EGPRS RLC
RLC Data
([Cell].[Uplink GPRS RLC Data Transfer
Transfer Capabilty
Capabilty Measurement].[L9001:Total
Measurement].[TL9123:Throughput
Number of
of Downlink GPRS
Uplink GPRS RLC
RLC DaB
Data
Data Transfer Capabilty Measurement].[L9101:Total Number of Downlink GPRS RLC Data Blocks] + [Cell].[Uplink
Measurement].[L9201:Total Number of Uplink EGPRS RLC Data Blocks] + [Cell].[Downlink EGPRS RLC Data T
[L9301:Total Number of Downlink EGPRS RLC Data Blocks])/(3600 * 50)
HOUR
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NBH
NBH
NBH
NBH
NBH
NBH
NA
NA
NA
NA
NA
NBH
NBH
NA
BBH
BBH
BBH
BBH
BBH
NBH
NBH
NBH
NBH
NBH
NBH
Average of 24hrs
Average of 24hrs
Average of 24hrs
Average of 24hrs
Average of 24hrs
NBH
NBH
NBH
NBH
NBH
NBH
BBH
BBH
BBH
BBH
BBH
BBH
NBH
NA
NBH
NBH
BBH
BBH
BBH
NBH
NBH
NBH
BBH
BBH
NBH
24hrs
24hrs
24hrs
NBH
24hrs
24hrs
NBH
NBH
NBH
24hrs
24hrs
24hrs
NBH
24hrs
24hrs
NBH
NBH
NA
NA
24hrs
24hrs
NA
24hrs
NA
24hrs
24hrs
DBH
DBH
DBH
DBH
DBH
DBH
NA
DBH
DBH
NA
NA
DBH
DBH
DBH
NA
DBH
NA
NA
NA
NA
NA
NA
NA
NA
NBH
NBH
NA
BBH
NA
NA
NA
DBH
DBH
NBH
NBH
24hrs
24hrs
24hrs