Thanks Thanks:  0
Page 1 of 2 12 LastLast
Showing results 1 to 10 of 11

Thread: BSC KPI from Cells KPI

  1. #1
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,979


    Default BSC KPI from Cells KPI

    Friends, I have problem in my Stats tool, consequently I just have cells KPI values and I want know how to calculate the KPI vlaues for the whole BSC

    Do you have any idea about how to do that in accuarte way?

    Ex: I have all the values of 'CDR, TCHLoss, CSR' of the cells of BSC01
    Now I want to calculate the KPI values but for BSC01

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Posts
    Many
     

  3. #2
    Senior Member Reputation: 447
    Join Date
    2008-09-02
    Location
    Suisse
    Posts
    218


    Default

    You must know the expression of your KPI absolutely necessary for instance,
    I take the case of CDR:

    Let us imagine that BSC includes 3 cells only

    CDR(cell1)= call_success_cell1 / total_call_cell1
    CDR(cell2)= call_success_cell2 / total_call_cell2
    CDR(cell3)= call_success_cell3 / total_call_cell3

    For calculate CDR (BSC):
    CDR(BSC)= [call_success_cell1+call_success_cell2+call_success_cell3] / [total_call_cell1+total_call_cell2+total_call_cell3]

    Are you agree

  4. #3
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,979


    Default

    Quote Originally Posted by mboti View Post
    You must know the expression of your KPI absolutely necessary for instance,

    I take the case of CDR:

    Let us imagine that BSC includes 3 cells only

    CDR(cell1)= call_success_cell1 / total_call_cell1
    CDR(cell2)= call_success_cell2 / total_call_cell2
    CDR(cell3)= call_success_cell3 / total_call_cell3

    For calculate CDR (BSC):
    CDR(BSC)= [call_success_cell1+call_success_cell2+call_success_cell3] / [total_call_cell1+total_call_cell2+total_call_cell3]

    Are you agree
    I think your idea is logic one

  5. #4
    VIP Member Reputation: 571
    Join Date
    2008-06-01
    Posts
    1,078


    Default

    Quote Originally Posted by justdream View Post
    Friends, I have problem in my Stats tool, consequently I just have cells KPI values and I want know how to calculate the KPI vlaues for the whole BSC

    Do you have any idea about how to do that in accuarte way?

    Ex: I have all the values of 'CDR, TCHLoss, CSR' of the cells of BSC01
    Now I want to calculate the KPI values but for BSC01
    Hi
    there are Counters for BSC Level Statistics an also for cell level
    all KPI are related to Cell Statistics or Cell Relation Statistics except CP Load on Average,Number of paging messages in BSC,and
    Discarded Paging Mess due to Paging Congestion of all Pages are related to BSC level.
    so if you want to calculate KPI in busy hour how it is possible and you know each site has its own busy hour ?
    if you work on E/// equipment from Alex doc you can find STS formulat for KPI.
    br hassen
    Last edited by hassen; 2009-12-02 at 05:45 AM

  6. #5
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,979


    Default

    you are right my friend that each site has its' own Busy Hour...so do you know how stats softwares calculate the busy hour for each BSC?

  7. #6
    VIP Member Reputation: 1289
    Join Date
    2008-08-13
    Posts
    430


    Default Use counter

    Quote Originally Posted by justdream View Post
    Friends, I have problem in my Stats tool, consequently I just have cells KPI values and I want know how to calculate the KPI vlaues for the whole BSC

    Do you have any idea about how to do that in accuarte way?

    Ex: I have all the values of 'CDR, TCHLoss, CSR' of the cells of BSC01
    Now I want to calculate the KPI values but for BSC01
    Dear friend,

    I have some experience with this problem

    -Define KPI formulas by counter.

    -Get all counter from system.

    -Use a database management system like Access or SQL.... creat some

    queries to caculate KPI that you want.

    -With BSC, MSC or Vendor level, you sum all counter and caculate by

    formulas.

    I hope it can help you.

    Rgs

  8. #7
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,979


    Default

    Experts another urgent and important question:

    Now I have the KPI for all BSCs but the KPI is not good, so we want to remove bad cells that degrade the KPI then recalculate the KPI to

    Now the question:
    what's the best methodology to do this task?

    - check cells KPI and remove worst cells
    - or check Raido Commander alarms then remove that cells with alarms

    what's the best methodology from the accuracy and time point of view

  9. #8
    VIP Member Reputation: 571
    Join Date
    2008-06-01
    Posts
    1,078


    Default

    Quote Originally Posted by justdream View Post
    you are right my friend that each site has its' own Busy Hour...so do you know how stats softwares calculate the busy hour for each BSC?
    hi

    for KPI we use counters on BSC level
    for TROUBLESHOOTING ,and for deep investigation we prefere counter ie STS on cell level.

    br hassen
    Last edited by hassen; 2009-12-10 at 06:23 PM

  10. #9
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,979


    Default

    @Hassen
    so if you want to calculate KPI in busy hour how it is possible and you know each site has its own busy hour ?

    excuse me my friend, as I get confused, if I have big problems in BSC at BH 11:00
    so I check the cells performance at 11:00 or at it's own BH

  11. #10
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,979


    Default

    Experts, do you have an explanations for this issue:
    I have checked the KPI for one BSC at the busy Hour
    it; was so bad

    so I exported the radio commander alarms for this BSC at the same busy hour
    then I have removed these cells with radio commander (critical + major) alarms

    then I have rechecked the BSC KPI again after removing these cells with alarms but no big enhancement, we can say that the change is trivial

    so what's going on? can you explain to me?

    Thanks in advance

Bookmarks

Bookmarks

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •