How to Identify the Top N Cells for CSSR and CDR: Steps and Best Practices

RAN
,
1

Hello Experts.

How to have top N cells in 3G regarding CSSR and CDR?

I mean steps and the best approach.

Admin note: this post was updated with image below.
CSSR and CDR

2

You need to find out based on CS or PS Failures first for both CSSR and CDR.

Then need to approach accordingly which are really impacting at network level you can identify such top offenders cells.

And further need to identify sub counters which are impacting.

3

To obtain the top N cells in a 3G network based on Call Setup Success Rate (CSSR) and Call Drop Rate (CDR), follow these steps:

1. Data Collection

  • CSSR: This metric typically reflects the percentage of successful call attempts over the total call attempts. Ensure that you’re collecting data for:

    • Successful call setups.
    • Total call attempts.

  • CDR: This metric represents the percentage of dropped calls out of the total successfully established calls. Ensure you’re collecting data for:

    • Dropped calls.
    • Successfully established calls.

2. Data Preprocessing

  • Filter Data: Filter out the cells that have an insufficient number of attempts, as they can skew the analysis.

  • Data Aggregation: Aggregate the data by cell. Calculate the CSSR and CDR for each cell using the formulas:

  • CSSR (%) = (\frac{\text{Successful Call Setups}}{\text{Total Call Attempts}} \times 100)

  • CDR (%) = (\frac{\text{Dropped Calls}}{\text{Total Successful Call Setups}} \times 100)

CSSR and CDR

3. Ranking

  • Sort Data:
    • For CSSR, sort the cells in descending order, as higher CSSR indicates better performance.
    • For CDR, sort the cells in ascending order, as a lower CDR indicates better performance.
    • Top N Cells: Select the top N cells from the sorted lists. You might need separate lists for CSSR and CDR.

4. Analysis

  • Cross-Reference: Compare the top N cells across both metrics to identify cells performing well in both CSSR and CDR.

  • Visualization: Use charts or tables to visualize the performance of these top cells, which can aid in further analysis or reporting.

5. Approach Enhancement

  • Thresholds: Set thresholds for CSSR and CDR to categorize cells (e.g., excellent, good, poor) and further refine the list.

  • Combine Metrics: If necessary, you could combine CSSR and CDR into a single score (e.g., weighted score) to rank cells comprehensively.

6. Automation and Monitoring

  • Scripts/Tools: Develop scripts or use network monitoring tools to automate data collection, processing, and ranking. This will help in regular monitoring of cell performance.

Example

Suppose you have data for 10 cells:

  • Cell A: CSSR = 98%, CDR = 0.5%
  • Cell B: CSSR = 95%, CDR = 1.2%
  • …
  • Cell J: CSSR = 92%, CDR = 0.8%