Ericsson KPI List With Formule

Formula Id

Formula name

BSS_73 BSS_75 BSS_76 BSS_74 BSS_50 BSS_49 BSS_48 BSS_45 BSS_46 BSS_39 BSS_36 BSS_38 BSS_80 BSS_82 BSS_59 BSS_60 BSS_8 BSS_9 BSS_10 BSS_11 BSS_12 BSS_15 BSS_13 BSS_30 BSS_23 BSS_29 BSS_72 BSS_100 BSS_77 BSS_78 BSS_79

TCH SSR

Category

TCH DCR

KPI

MPD SQI Good Ericsson

TCH traffic TCH seizures TCH seizure failures TCH normal attempts TCH Normal seizures TCH defined channels TCH available channels TCH congestion time

Traffic

AMR HR traffic HR and AMR_HR traffic

FR TCH seizures FR TCH traffic HO cause DL level HO cause DL quality HO cause OMC invoked HO cause Powerbudget HO cause UL quality HO other cause HO Cong Ericsson SDCCH traffic SDCCH drop percentage SDCCH seizures

CS KPI

Mobility

Signaling

PS Blocking TBF drop PS Mbyte PS Mbyte EGPRS PS Mbyte GPRS

Packet data

PS KPI

Report Id

Report name

Formula Id

Formula name

Nokia implementation counter name

TN_R_4

KPI

BSS_73

TCH SSR

decode(sum(TASSALL),0,0,100*(sum(TCASSALL)/sum (TASSALL)))

TCH DCR

decode(sum(CLTCH.TCASSALL),0,0,100*(sum(CELTC HF.TFNDROP + CELTCHF.TFNDROPSUB + CELTCHH.THNDROP + CELTCHH.THNDROPSUB)/sum(CLTCH.TCASSALL)))

MPD

sum(CELTCHF.TFTRALACC) sum(CELTCHF.TFNSCAN) sum(CELTCHH.THTRALACC) sum(CELTCHH.THNSCAN) sum(CELTCHF.TFNDROP) sum(CELTCHF.TFNDROPSUB) sum(CELTCHH.THNDROP) sum(CELTCHH.THNDROPSUB)

SQI Good Ericsson

decode(sum(TSQIGOOD + TSQIACCPT + TSQIBAD + TSQIGOODSUB + TSQIACCPTSUB + TSQIBADSUB + TSQIGOODAF + TSQIGOODAH + TSQIGOODSUBAF + TSQIGOODSUBAH + TSQIACCPTAF + TSQIACCPTAH + TSQIACCPTSUBAF + TSQIACCPTSUBAH + TSQIBADAF + TSQIBADAH + TSQIBADSUBAF + TSQIBADSUBAH),0,0,100*(sum(TSQIGOOD + TSQIACCPT + TSQIGOODSUB + TSQIACCPTSUB + TSQIGOODAF + TSQIGOODAH + TSQIGOODSUBAF + TSQIGOODSUBAH + TSQIACCPTAF + TSQIACCPTAH + TSQIACCPTSUBAF + TSQIACCPTSUBAH)/sum(TSQIGOOD + TSQIACCPT + TSQIBAD + TSQIGOODSUB + TSQIACCPTSUB + TSQIBADSUB + TSQIGOODAF + TSQIGOODAH + TSQIGOODSUBAF + TSQIGOODSUBAH + TSQIACCPTAF + TSQIACCPTAH + TSQIACCPTSUBAF + TSQIACCPTSUBAH + TSQIBADAF + TSQIBADAH + TSQIBADSUBAF + TSQIBADSUBAH)))

TN_R_4

TN_R_4

TN_R_4

KPI

KPI

KPI

BSS_75

BSS_76

BSS_74

sum(decode(sum(CELTCHF.TFNSCAN),0,0,su m(CELTCHF.TFTRALACC)/sum(CELTCHF.TFNS CAN) + decode(sum(CELTCHH.THNSCAN),0,0,sum(C ELTCHH.THTRALACC)/sum(CELTCHH.THNSCA N))

TN_R_16 TCH Traffic

BSS_50

TCH traffic

TN_R_16 TCH Traffic

BSS_49

TCH seizures sum(CELTCHF.TFMSESTB + CELTCHH.THMSESTB)

TN_R_16 TCH Traffic

BSS_48

TN_R_16 TCH Traffic

BSS_45

TN_R_16 TCH Traffic

BSS_46

TN_R_16 TCH Traffic

BSS_39

TN_R_16 TCH Traffic

BSS_36

TN_R_16 TCH Traffic

BSS_38

TCH available decode(sum(TAVASCAN),0,0,sum(TAVAACC/ channels TAVASCAN)) - FPDCH TCH congestion time sum(TFTCONGS + TFTCONSUB)

TN_R_4

KPI

BSS_80

AMR HR traffic

TN_R_4

KPI

BSS_82

HR and AMR_HR decode(sum(CELTCHH.THNSCAN),0,0,sum(CELTCHH traffic .THTRALACC)/sum(CELTCHH.THNSCAN))

TN_R_13

TCH Full Rate

BSS_59

FR TCH seizures

BSS_60

FR TCH traffic /sum(TFNSCAN))

TCH Normal seizures TCH defined channels

sum(CELTCHF.TFCALLS - CELTCHF.TFCONGSAS - CELTCHF.TFCONGSASSUB sum(TASSALL) sum(CELTCHF.TFCASSALL + CELTCHF.TFCASSALLSUB + CELTCHH.THCASSALL +CELTCHH.THCASSALLSUB) sum(TNUCHCNT)

decode(sum(THV3NSCAN),0,0,sum(THV3TRALACC)/s um(THV3NSCAN))

sum(TFMSESTB)

decode(sum(TFNSCAN),0,0,sum(TFTRALACC)

TCH Full

TN_R_13 Rate

TCH seizure failures TCH normal attempts

TN_R_12

SDCCH Traffic

TN_R_12

SDCCH Quality SDCCH Traffic

TN_R_4

KPI

TN_R_11

BSS_30

decode(sum(CNSCAN),0,0,sum(CTRALACC)/s SDCCH traffic um(CNSCAN))

BSS_29

BSS_72

PS Blocking

decode(sum(PSCHREQ),0,0,100*(sum(PREJTFI + PREJOTH)/sum(PSCHREQ)))

BSS_100

TBF drop

sum(CELGPRS2.LDISTFI + CELGPRS2.LDISRR + CELGPRS2.LDISOTH) sum(CELQOSEG.DLBGEGDATA + CELQOSEG.ULBGEGDATA + CELLQOSG.DLBGGDATA + CELLQOSG.ULBGGDATA)/8000

BSS_23

PS KPI Traffic TN_R_8

decode(sum(CMSESTAB,0,0,100*(sum(CNDR OP)/sum(CMSESTAB)))

SDCCH drop percentage SDCCH seizures

sum(CMSESTAB)

TN_R_4

KPI

BSS_77

PS Mbyte

TN_R_4

KPI

BSS_78

sum(CELQOSEG.DLBGEGDATA + PS Mbyte EGPRS CELQOSEG.ULBGEGDATA)/8000

TN_R_4

KPI

BSS_79

PS Mbyte GPRS

TN_R_3

Handover Handover

TN_R_3

BSS_13

BSS_8 Handover

TN_R_3

BSS_9 Handover

TN_R_3

BSS_10

sum(CELLQOSG.DLBGGDATA + CELLQOSG.ULBGGDATA)/8000

sum(CELTCHF.TFCONGSHO + CELTCHF.TFCONGSHOSUB + CELTCHH.THCONGSHO + CELTCHH.THCONGSHOSUB)

HO Cong Ericsson HO cause DL HOTOKCL level (Comment: Sum of same counter from both object types) HO cause DL HODWNQA quality (Comment: Sum of same counter from both object types) HO cause HOATTBL OMC invoked

Handover

TN_R_3

HO cause Powerbudget

BSS_11 Handover

TN_R_3

BSS_12 Handover

TN_R_3

BSS_15

HOTOLCL (Comment: Sum of same counter from both object types)

HO cause UL HOUPLQA quality (Comment: Sum of same counter from both object types) HO other cause

HOATTLS

Implemented formula (In RS)

Nokia implementation table name

Object level

100*decode(CLTCH.TASSALL,0,0,(CLTCH.TCASSALL/ CLTCH.TASSALL)) MADEBP_PS_CLTCH_ESCE_{time]

e3gn_id, bsc_id, esce_id

100*decode(CLTCH.TCASSALL,0,0,(CELTCHF.TFNDR OP + CELTCHF.TFNDROPSUB + MADEBP_PS_CELTCHF_ESCE_{time} CELTCHH.THNDROP + MADEBP_PS_CELTCHH_ESCE_{time} CELTCHH.THNDROPSUB)/(CLTCH.TCASSALL)) MADEBP_PS_CLTCH_ESCE_{time}


decode((CELTCHF.TFNDROP+CELTCHF.TFNDROPS UB+CELTCHH.THNDROP+CELTCHH.THNDROPSUB), 0,0, (CELTCHF.Period_duration*(decode(CELTCHF.TFNSC AN,0,0,CELTCHF.TFTRALACC/CELTCHF.TFNSCAN)+ decode(CELTCHH.THNSCAN,0,0,CELTCHH.THTRALA CC/CELTCHH.THNSCAN)) /(CELTCHF.TFNDROP+CELTCHF.TFNDROPSUB+CE MADEBP_PS_CELTCHF_ESCE_{time} LTCHH.THNDROP+CELTCHH.THNDROPSUB))) MADEBP_PS_CELTCHH_ESCE_{time}


100*decode((CELLSQI.TSQIGOOD + CELLSQI.TSQIACCPT + CELLSQI.TSQIBAD + CELLSQI.TSQIGOODSUB + CELLSQI.TSQIACCPTSUB + CELLSQI.TSQIBADSUB + CELLSQI.TSQIGOODAF + CELLSQI.TSQIGOODAH + CELLSQI.TSQIGOODSUBAF + CELLSQI.TSQIGOODSUBAH + CELLSQI.TSQIACCPTAF + CELLSQI.TSQIACCPTAH + CELLSQI.TSQIACCPTSUBAF + CELLSQI.TSQIACCPTSUBAH + CELLSQI.TSQIBADAF + CELLSQI.TSQIBADAH + CELLSQI.TSQIBADSUBAF + CELLSQI.TSQIBADSUBAH), 0,0,(CELLSQI.TSQIGOOD + CELLSQI.TSQIACCPT + CELLSQI.TSQIGOODSUB + CELLSQI.TSQIACCPTSUB + CELLSQI.TSQIGOODAF + CELLSQI.TSQIGOODAH + CELLSQI.TSQIGOODSUBAF + CELLSQI.TSQIGOODSUBAH + CELLSQI.TSQIACCPTAF + CELLSQI.TSQIACCPTAH + CELLSQI.TSQIACCPTSUBAF + CELLSQI.TSQIACCPTSUBAH) /(CELLSQI.TSQIGOOD + CELLSQI.TSQIACCPT + CELLSQI.TSQIBAD + CELLSQI.TSQIGOODSUB + CELLSQI.TSQIACCPTSUB + CELLSQI.TSQIBADSUB + CELLSQI.TSQIGOODAF + CELLSQI.TSQIGOODAH + CELLSQI.TSQIGOODSUBAF + CELLSQI.TSQIGOODSUBAH + CELLSQI.TSQIACCPTAF + CELLSQI.TSQIACCPTAH + CELLSQI.TSQIACCPTSUBAF + CELLSQI.TSQIACCPTSUBAH + CELLSQI.TSQIBADAF + CELLSQI.TSQIBADAH + CELLSQI.TSQIBADSUBAF + CELLSQI.TSQIBADSUBAH)) MADEBP_PS_CELLSQI_ESCE_{time}


(CELTCHF.Period_duration/60)*(decode((CE LTCHF.TFNSCAN),0,0,(CELTCHF.TFTRALACC)/ (CELTCHF.TFNSCAN)) + decode((CELTCHH.THNSCAN),0,0,(CELTCHH. THTRALACC)/(CELTCHH.THNSCAN)) )

MADEBP_PS_CELTCHF_ESCE_{time } MADEBP_PS_CELTCHH_ESCE_{time } e3gn_id, bsc_id, esce_id MADEBP_PS_CELTCHF_ESCE_{time } MADEBP_PS_CELTCHH_ESCE_{time (CELTCHF.TFMSESTB + CELTCHH.THMSESTB) } e3gn_id, bsc_id, esce_id MADEBP_PS_CELTCHF_ESCE_{time } MADEBP_PS_CELTCHH_ESCE_{time } (CELTCHF.TFCALLS - CELTCHF.TFCONGSAS - CELTCHF.TFCONGSASSUB - CELTCHF.TFMSESTB e3gn_id, +bsc_id, CELTCHH.THCALLS esce_id - CELTCHH.TH (CLTCH.TASSALL) (CELTCHF.TFCASSALL + CELTCHF.TFCASSALLSUB + CELTCHH.THCASSALL +CELTCHH.THCASSALLSUB)

MADEBP_PS_CLTCH_ESCE_{time} e3gn_id, bsc_id, esce_id MADEBP_PS_CELTCHF_ESCE_{time } MADEBP_PS_CELTCHH_ESCE_{time } e3gn_id, bsc_id, esce_id

(CLTCH.TNUCHCNT)

MADEBP_PS_CLTCH_ESCE_{time}


decode((CLTCH.TAVASCAN),0,0,((CLTCH.TAV MADEBP_PS_CLTCH_ESCE_{time} AACC)/(CLTCH.TAVASCAN))) telenor_doping_rnpparameter


(CELTCHF.TFTCONGS + CELTCHF.TFTCONSUB) decode(CLTCHHV3.THV3NSCAN,0,0,(CLTCHHV3.THV 3TRALACC/CLTCHHV3.THV3NSCAN)*(CLTCHHV3.PE RIOD_DURATION/60) ) decode(CELTCHH.THNSCAN,0,0,(CELTCHH.THTRAL ACC/CELTCHH.THNSCAN)*(CELTCHH.PERIOD_DUR ATION/60))

MADEBP_PS_CELTCHF_ESCE_{time} e3gn_id, bsc_id, esce_id e3gn_id, bsc_id, MADEBP_PS_CLTCHHV3_ESCE_{time} esce_id e3gn_id, bsc_id, MADEBP_PS_CELTCHH_ESCE_{time} MADEBP_PS_CELTCHH_ESCE_{time} esce_id MADEBP_PS_CELTCHF_ESCE_{time } e3gn_id, bsc_id, esce_id

CELTCHF.TFMSESTB sum(decode(TFNSC AN,0,0,TFTRALACC/TFNSCAN)*(Period_dura MADEBP_PS_CELTCHF_ESCE_{time tion/60)) } e3gn_id, bsc_id, esce_id

decode( CLSDCCH.CNSCAN,0,0, (CLSDCCH.CTRALACC/ CLSDCCH.CNSCAN)*(CLSDCCH.Period_durati on/60)) MADEBP_PS_CLSDCCH_ESCE_{time} e3gn_id, bsc_id, esce_id 100*decode(CLSDCCH.CMSESTAB,0,0,(CLSD CCH.CNDROP/CLSDCCH.CMSESTAB)) MADEBP_PS_CLSDCCH_ESCE_{time} e3gn_id, bsc_id, esce_id CLSDCCH.CMSESTAB 100*decode(CELGPRS2.PSCHREQ,0,0,((CELGPRS2. PREJTFI + CELGPRS2.PREJOTH)/CELGPRS2.PSCHREQ))

MADEBP_PS_CLSDCCH_ESCE_{time} e3gn_id, bsc_id, esce_id e3gn_id, bsc_id, MADEBP_PS_CELGPRS2_ESCE_{time} esce_id

(CELGPRS2.LDISTFI + CELGPRS2.LDISRR + CELGPRS2.LDISOTH)

MADEBP_PS_CELGPRS2_ESCE_{time}

(CELQOSEG.DLBGEGDATA + CELQOSEG.ULBGEGDATA + CELLQOSG.DLBGGDATA + CELLQOSG.ULBGGDATA)/8000

MADEBP_PS_CELQOSEG_ESCE_{time} MADEBP_PS_CELLQOSG_ESCE_{time}

(CELQOSEG.DLBGEGDATA + CELQOSEG.ULBGEGDATA)/8000

MADEBP_PS_CELQOSEG_ESCE_{time}

(CELLQOSG.DLBGGDATA + CELLQOSG.ULBGGDATA)/8000

MADEBP_PS_CELLQOSG_ESCE_{time}

(CELTCHF.TFCONGSHO + CELTCHF.TFCONGSHOSUB + CELTCHH.THCONGSHO + CELTCHH.THCONGSHOSUB) (NECELHO.HOTOKCL + NICELHO.HOTOKCL) (NECELHO.HODWNQA + NICELHO.HODWNQA) (CELEVH.HOATTBL)

MADEBP_PS_CELTCHF_ESCE_{time } MADEBP_PS_CELTCHH_ESCE_{time } MADEBP_PS_NECELHO_EENC_{TIM E_AGG},MADEBP_PS_NICELHO_EIN C_{TIME_AGG} MADEBP_PS_NECELHO_EENC_{TIM E_AGG},MADEBP_PS_NICELHO_EIN C_{TIME_AGG} MADEBP_PS_CELEVH_ESCE_{TIME _AGG}

e3gn_id, bsc_id, esce_id e3gn_id, bsc_id, esce_id e3gn_id, bsc_id, esce_id e3gn_id, bsc_id, esce_id


e3gn_id, bsc_id, esce_id, eenc_id

e3gn_id, bsc_id, esce_id, eenc_id e3gn_id, bsc_id, esce_id

(NECELHO.HOTOLCL + NICELHO.HOTOLCL) (NECELHO.HOUPLQA + NICELHO.HOUPLQA) (CELEVH.HOATTLS)

MADEBP_PS_NECELHO_EENC_{TIM E_AGG},MADEBP_PS_NICELHO_EIN C_{TIME_AGG} e3gn_id, bsc_id, esce_id, eenc_id MADEBP_PS_NECELHO_EENC_{TIM E_AGG},MADEBP_PS_NICELHO_EIN C_{TIME_AGG} e3gn_id, bsc_id, esce_id, eenc_id MADEBP_PS_CELEVH_ESCE_{TIME _AGG} e3gn_id, bsc_id, esce_id

Help Info to be included in the reports

Unit

Status

TCH Setup Success Rate

%

M4 - Report tested OK internally

TCH Drop Call Rate

%


Minutes pr. Drop

Minutes


Signal quality Indicator Good Ericsson

%


? TCH traffic. Fullrate + halfrate TCH traffic.

Number of successful TCH seizures. # Fullrate + Halfrate TCH seizures. Number of TCH setup attempts that "disapear" (Not blocking or successful setup). Fullrate + halfrate # TDH seizure failures.



M0 - Further information needed

# Number of normal TCH setup attempts.


Number of successful normal TCH setup Fullrate + halfrate normal seizures


#

# two dualrate halfrate channels are defined Number of defined TCH channels. When M4 - Report on one tested timeslot OK internally they will be calculated as

Number of available TCH channels. When two dualrate halfrate channels are avaialble on one timeslot, they count as one avaialble channel. GPRS default area included, but not # dedicated GPRS area.


Number of seconds there all TCH channels are full allocated.

sec


AMR Halfrate traffic

?


Halfrate and AMR Halfrate traffic

?


#

Successful TCH seizures

M4 - Report tested OK internally ?

TCH fullrate traffic


?

SDCCH traffic


SDCCH drop rate

%


#

Successful SDCCH seizures Persentage of all packet access request that were rejected

M4 - Report tested OK internally %

M4 - Report tested OK internally Drops due to suspend and flush are not counted.

#

Datavolum for EGPRS and GPRS uplink and downlink in class for background traffic.

Mbyte

Datavolum for EGPRS uplink and downlink in class for background traffic. GPRS traffic not included.

Mbyte

Datavolum for GPRS uplink and downlink in class for background traffic.

Mbyte




M4 - Report tested OK internally The 'TCH congestion at handover' counters are incremented when an allocation attempt of a channel for handover fails due to no idle channels are available. In the case of an allocation attempt of TCH/F channels for an HSCSD connection, the counters TFCONGSHO and TFCONGSHOSUB are stepped by one only if the allocation fails and that is no new channels allocated. The counters TFCONGSHO and TFCONGSHOSUB are not incremented for the Configuration change attempts for Multislot connections initiated by the MSC or by the BSC. # Number of handovers due to downlink signal strength


#


#


#


Number of handovers due to bad downlink radio quality Number of handovers started by OMC

Number of handover due to good signal strength

#


#


#


Number of handovers due to bad uplink quality Number of handovers with cause unknown

Ericsson KPI List With Formule

Recommend Documents