PDA

View Full Version : KPI Formula needed



dacoder
2015-10-11, 06:37 PM
hi
can anyone provide formula to calculate following kpi:
1. Total Voice Traffic(Erl)
2. Total DL Payload (MB)
3. Total UL Payload (MB)

RNC is BSC6900 R14

thanks

vikrant.entc
2015-10-13, 03:22 PM
Hi dacoder,

Please find formulas below:

1. Voice Traffic- (VS.RB.AMRWB.DL.12.65+VS.RB.AMRWB.DL.23.85+VS.RB.AMRWB.DL.23.05+VS.RB.AMRWB.DL.19.85+VS.RB.AMRWB.DL.18.25+VS.RB.AMRWB.DL.15.85+VS.RB.AMRWB.DL.14.25+VS.RB.AMRWB.DL.8.85+VS.RB.AMRWB.DL.6.60+VS.RB.AMR.DL.12.2+VS.RB.AMR.DL.10.2+VS.RB.AMR.DL.7.95+VS.RB.AMR.DL.7.4+
VS.RB.AMR.DL.6.7+VS.RB.AMR.DL.5.9+VS.RB.AMR.DL.5.15+VS.RB.AMR.DL.4.75)*{SP}/60

2. Total DL Payload (MB)- ((VS.HSDPA.MeanChThroughput.TotalBytes)/(1024*1024))+((VS.PS.Bkg.DL.8.Traffic+VS.PS.Bkg.DL.16.Traffic+
VS.PS.Bkg.DL.32.Traffic+VS.PS.Bkg.DL.64.Traffic+
VS.PS.Bkg.DL.128.Traffic+VS.PS.Bkg.DL.144.Traffic+
VS.PS.Bkg.DL.256.Traffic+VS.PS.Bkg.DL.384.Traffic+
VS.PS.Int.DL.8.Traffic+VS.PS.Int.DL.16.Traffic+
VS.PS.Int.DL.32.Traffic+VS.PS.Int.DL.64.Traffic+
VS.PS.Int.DL.128.Traffic+VS.PS.Int.DL.144.Traffic+
VS.PS.Int.DL.256.Traffic+VS.PS.Int.DL.384.Traffic+
VS.PS.Str.DL.8.Traffic+VS.PS.Str.DL.16.Traffic+
VS.PS.Str.DL.32.Traffic+VS.PS.Str.DL.64.Traffic+
VS.PS.Str.DL.128.Traffic+VS.PS.Str.DL.144.Traffic+
VS.PS.Str.DL.256.Traffic+VS.PS.Str.DL.384.Traffic+
VS.PS.Conv.DL.Traffic)/(8*1024*1024))

3. Total UL Payload (MB)- ((VS.HSUPA.MeanChThroughput.TotalBytes)/(1024*1024))+((VS.PS.Bkg.UL.8.Traffic+VS.PS.Bkg.UL.16.Traffic+VS.PS.Bkg.UL.32.Traffic+VS.PS.Bkg.UL.64.Traffic+
VS.PS.Bkg.UL.128.Traffic+VS.PS.Bkg.UL.144.Traffic+
VS.PS.Bkg.UL.256.Traffic+VS.PS.Bkg.UL.384.Traffic+
VS.PS.Int.UL.8.Traffic+VS.PS.Int.UL.16.Traffic+
VS.PS.Int.UL.32.Traffic+VS.PS.Int.UL.64.Traffic+
VS.PS.Int.UL.128.Traffic+VS.PS.Int.UL.144.Traffic+
VS.PS.Int.UL.256.Traffic+VS.PS.Int.UL.384.Traffic+
VS.PS.Str.UL.8.Traffic+VS.PS.Str.UL.16.Traffic+
VS.PS.Str.UL.32.Traffic+VS.PS.Str.UL.64.Traffic+
VS.PS.Str.UL.128.Traffic+VS.PS.Conv.UL.Traffic)
/(8*1024*1024))

dacoder
2015-10-15, 01:53 PM
hiwe haven't activated AMR feature in our network. What changes would be needed for the formula then?thanks

dacoder
2015-12-22, 12:38 AM
anyone? AMR feature not activated. So what is the correct formula to measure voice traffic (Erl)?

dacoder
2015-12-27, 04:00 PM
ok i found one formula to calculate total traffic:
{(VS.RB.AMR.DL.12.2+VS.RB.AMR.DL.10.2+VS.RB.AMR.DL.7.95+VS.RB.AMR.DL.7.4+VS.RB.AMR.DL.6.7+VS.RB.AMR.DL.5.9+VS.RB.AMR.DL.5.15+VS.RB.AMR.DL.4.75)+(VS.RB.CS.Conv.DL.64)*2}*{SP}/60

can anyone tell me why this counter VS.RB.CS.Conv.DL.64 is multiplied by 2 in the formula?

thanks