CSSR Zero with Zero TCH Attepts

[dext]

Hi All

The CSSR of many sites in our network is fluctuating and goes down to zero with zero attempts, we are having very low and zero at attempts frequently as our network is new, can someone tell me what is the problem in our formulae that it is giving zero CSSR with Zero attempts, It should rather give CSSR 100% with zero attempts. Thank you

CSSR formulae being used : (1-([Number of SDCCH drops due to loss of contact with RANA(Times)]+[Number of SDCCH drops due to radio link failure(Times)]+[Number of SDCCH drops due to LAPD link failure(Times)]+[Number of SDCCH drops due to OMC-R forced release(Times)]+[Number of release indications due to T200 expired on SDCCH(Num)]+[Number of the release indication messages on SDCCH due to unsolicited DM response(Num)]+[Number of release indications due to sequence error on SDCCH(Num)])/([Number of SDCCH seizure attempts for assignment(Times)]+[Number of signaling TCH/F seizure attempts for assignment(Times)]+[Number of signaling TCH/H seizure attempts for assignment(Times)]))*(1-(([Number of voice TCH/F seizure failure for assignment(Times)]+[Number of data TCH/F seizure failure for assignment(Times)]+[Number of voice TCH/H seizure failure for assignment(Times)]+[Number of data TCH/H seizure failure for assignment(Times)])/([Number of voice TCH/F seizure attempts for assignment(Times)]+[Number of data TCH/F seizure attempts for assignment(Times)]+[Number of voice TCH/H seizure attempts for assignment(Times)]+[Number of data TCH/H seizure attempts for assignment(Times)])))*(1-([Number of signaling TCH/F assignment failure for assignment(Times)]+[Number of voice TCH/F assignment failure(Times)]+[Number of data TCH/F assignment failure(Times)]+[Number of signaling TCH/H assignment failure(Times)]+[Number of voice TCH/H assignment failure(Times)]+[Number of data TCH/H assignment failure(Times)])/([Number of signaling TCH/F assignment success for assignment(Times)]+[Number of voice TCH/F assignment success(Times)]+[Number of data TCH/F assignment success(Times)]+[Number of signaling TCH/F assignment failure for assignment(Times)]+[Number of voice TCH/F assignment failure(Times)]+[Number of data TCH/F assignment failure(Times)]+[Number of signaling TCH/H assignment success(Times)]+[Number of voice TCH/H assignment success(Times)]+[Number of data TCH/H assignment success(Times)]+[Number of signaling TCH/H assignment failure(Times)]+[Number of voice TCH/H assignment failure(Times)]+[Number of data TCH/H assignment failure(Times)]))

Br
Dext

[auto_art]

# ideally it must ignore cells-nodes without attempts and calculates CSSR for cells having >0 attempts, ur performance database must be designed that way only.

otherwise u must analyse the given counters and add a condition so it gives the null output when attempts are zero..

e.g.

case when (CCALSS != 0 ) AND (TASSALL != 0 ) then
((TASSALL/CCALLS) ) * 100
else NULL
end
above just an example for undestanding.

[dext]

Thanks

I did something like that. but now CSSR is 100% when the site is down also, i think need to define some condition in excel .

[jeff]

Hi Dext,

Which vendor is that? From your formula its neither E******* nor Huawei.

Have you checked the vendor documentation on suggested formula?