PDA

View Full Version : E******* SGSN KPIs Formulae



gopal441
2016-06-06, 01:04 PM
3G Inter SGSN RAU

100-PERCENT(SUM(ATTINTERSGSNRAUPDATEUMTS)-SUM(SUCCINTERSGSNRAUPDATEUMTS)-(SUM(MMUNSUCCINTERSGSNRAUCC14U)+SUM(MMUNSUCCINTERSGSNRAUCC9U)+SUM(MMUNSUCCINTERSGSNRAUCC10U)),
SUM(ATTINTERSGSNRAUPDATEUMTS),2)



2G Inter SGSN RAU
SUM(ATTINTERSGSNRAUPDATE) - SUM(SUCCINTERSGSNRAUPDATE) - (SUM(MMUNSUCCINTERSGSNRAUCC14G) + SUM (MMUNSUCCINTERSGSNRAUCC9G)+SUM(MMUNSUCCINTERSGSNRAUCC10G))
SUM(ATTINTERSGSNRAUPDATE)


2G PDP Context Success
100- PERCENT((DISCARDEDSESSIONMGMNT+GPRSSMSGSNUNSUCCACTIVATIONS)-
(SMUNSUCCACTPDPCTXTCC26G+SMUNSUCCACTPDPCTXTCC27_28G+SMUNSUCCACTPDPCTXTCC29G+SMUNSUCCACTPDPCTXTCC32_33G),
(SMATTACTPDPCTXTG)+(DISCARDEDSESSIONMGMNT))
3G PDP Context Success E*******-
100-PERCENT((SMATTACTPDPCTXTU-SMSUCCACTPDPCTXTU)-(SMUNSUCCACTPDPCTXTCC26u+SMUNSUCCACTPDPCTXTCC27_28U+SMUNSUCCACTPDPCTXTCC29U+SMUNSUCCACTPDPCTXTCC32_33U),
(SMATTACTPDPCTXTU))


2G Attach Success
100- PERCENT(((DISCARDEDGPRSATCH)+(DISCARDEDCOMBIATCH)+(GPRSMMSGSNUNSUCCATCHREQUESTS)) -((MMUNSUCCATCHCC7G)+(MMUNSUCCATCHCC8G)+(MMUNSUCCATCHCC11G)+(MMUNSUCCATCHCC13G)+(MMUNSUCCATCHCC14G)+(MMUNSUCCATCHCC15G)),
((DISCARDEDGPRSATCH)+(DISCARDEDCOMBIATCH)+(ATTCOMBIATCH)+(ATTGPRSATCH)+(ATTIMSIATCH))))

3G Attach Success

100-PERCENT((UNSUCCGPRSATCHUMTS)- (MMUNSUCCATCHCC7U+MMUNSUCCATCHCC8U+MMUNSUCCATCHCC11U+MMUNSUCCATCHCC13U+MMUNSUCCATCHCC14U+MMUNSUCCATCHCC15U),
(ATTGPRSATCHUMTS))