process_kpi/lte_kpi_requirements.md

LTE CAPACITY REPORT

Based on gsm and wcdma exemple let's build LTE capacity report

Required Input

• File : LTE BH report with columns :
  • PERIOD_START_TIME
  • MRBTS/SBTS name
  • LNBTS name
  • LNCEL name
  • DN
  • Cell Avail excl BLU
  • E-UTRAN Avg PRB usage per TTI DL
• Number of last day for the analysis
• Number of days for threshold
• Availability threshold
• PRB usage per TTI DL threshold
• Max difference between PRB usage over cells of the same BTS

TASK

• Pivot KPI in BH report per KPI (Cell Avail excl BLU, E-UTRAN Avg PRB usage per TTI DL)
• Calculate Average and Max of PRB usage per TTI DL
• Calculate Average and Max of Cell Avail excl BLU
• Count number of Days with Cell Avail excl BLU below Availability threshold
• Count number of Days with PRB usage per TTI DL exceeded PRB usage per TTI DL threshold
• Create separate DF per sector and band based on LNCEL name
  • _1_L800: column_name = Sector_1_L800
  • _2_L800: column_name = Sector_2_L800
  • _3_L800: column_name = Sector_3_L800
  • _1_L1800: column_name = Sector_1_L1800
  • _2_L1800: column_name = Sector_2_L1800
  • _3_L1800: column_name = Sector_3_L1800
  • _1_L2300: column_name = Sector_1_L2300
  • _2_L2300: column_name = Sector_2_L2300
  • _3_L2300: column_name = Sector_3_L2300
  • _1_L2600: column_name = Sector_1_L2600
  • _2_L2600: column_name = Sector_2_L2600
  • _3_L2600: column_name = Sector_3_L2600
  • _1S_L1800: column_name = Sector_1S_L1800
  • _2S_L1800: column_name = Sector_2S_L1800
  • _3S_L1800: column_name = Sector_3S_L1800
• Merge DFs per sector LNBTS name
• Concat dfs per Bands