KPI Report

[justdream]

Experts,
do you a have a professional sample of weekly KPI report???

It will be so nice, if you could share

[hassen]

Hi bro

could you tell me wich tool you are using or may be manually just for information in order to help you.

br hassen

[justdream]

Hi bro

could you tell me wich tool you are using or may be manually just for information in order to help you.

br hassen

My tool is SPOTS, it gives me reporta in Excel format
just show me what you have and I think I can play around it using Excel, etc

[justdream]

also, is there especial tool to do these issues, as I see that doind the smae excersie every week, means a lot of repeated steps

so I think may be there are special tools to handle these issues

[justdream]

Experts, how to remove cells that have RXLev less than -90 dBm from my KPI report?

how to define these cells?

Please advice

[hassen]

Hi bro

could you share report to see and try to find a solution because i don't have any idea
about spots,i think it is old tool because now we use metrica or business object much easy to ceate a template for daily or weekly busy hour ....
and these tools use a raw data for processing.
note: my friend as you know in telecom field statistics fonction are not linear so you have to make difference between average 7 days and weekly kpi.

br hassen

[justdream]

Hi bro

could you share report to see and try to find a solution because i don't have any idea
about spots,i think it is old tool because now we use metrica or business object much easy to ceate a template for daily or weekly busy hour ....
and these tools use a raw data for processing.
note: my friend as you know in telecom field statistics fonction are not linear so you have to make difference between average 7 days and weekly kpi.

br hassen

ok, mon ami but I have to tell you that I made many tests and i have found that SPOTS give me an average Carried traffic when I go for weekly or daily stats (just for traffic, I know it's not logic "there's somethign wrong here")

The reports you can get from SPOTS is normal Excel sheet with your Object, Dates, KPIs, values

so you have to play with Excel to let your report looks like professional ones and easy to read
anyway, here's attached a sample

finally, I didn't understabd the clients' request to remove cells with RXLev below -90 dBm (Do you understand it?)

[hassen]

ok, mon ami but I have to tell you that I made many tests and i have found that SPOTS give me an average Carried traffic when I go for weekly or daily stats (just for traffic, I know it's not logic "there's somethign wrong here")

The reports you can get from SPOTS is normal Excel sheet with your Object, Dates, KPIs, values

so you have to play with Excel to let your report looks like professional ones and easy to read
anyway, here's attached a sample

finally, I didn't understabd the clients' request to remove cells with RXLev below -90 dBm (Do you understand it?)

Hi bro

if clients request to remove cells with RXLev below -90 dBm i think they want to check indoor coverage or manage traffic.
and i think the only way is to decrease access min in idle mode.
i will check if there is possibility to limite value of causes for KPI for example (drop due to high TA if ms exceed TA=63) .
and ask oss team if they can schedule for weekly recording from data base of STS
in order to get weekly KPi because there is table (administration scheduling ) to put
the first day of the week) and the system compresse raw data for hour and keep historique and compresse hourly data for day ....until week and month.
and i think from your tool you can do some thing to get weekly KPI just read manual.

br hassen

[hassen]

Hi justdream

As example The drops counters due to Low Signal Strength will be pegged when the Signal Strength during the last Measurement Report before the call dropped is below the LOWSSDL Threshold ,LOWSSDL is BSC Exchange Property parameters which is used only for statistics purposes and does not affect the behavior of calls.
value is given in dBm.
Filtered DL signal strength values are compared with this value when analyzing urgency conditions.
Property type: Optional
Numeral 47-110
Default value: 104 .
so the kpi drop call due to low signal strength increase,(below the LOWSSDL Threshold),but in reality a part of drop is due to bad quality downlink,in this case we can suspect bad performance of Bts power control feature and need tune !

Br Hassen

[justdream]

Thanks a lot hassen
I can say in short that you are so smart and professional so I didn't understand you completely as my knowledge is still in the building level

anyway, I have another question my brother, if you have bad KPI due to hardware issue (some bad cells)

what do you do? just report these cells with required actions
or remove it from your calculations, in case of removing it (so kindly I need more details as I'm already doing that but I don't see it as logic approach)

Million thanks, my brother