ERICSSON Business Objects KPIs Generation Process Documentation

(1)

ERICSSON Business Objects KPIs generation Process documentation

I. Process

II. The table below describes the process for generating Radio BSS

Voice KPIs

Stage Description

1. Log in to Business Objects application 2. Create New report using BSDR81 Universe

3. Select raw counters as per below detailed procedure

4. Insert a new report to separate the Raw Counters report with calculated KPIs 5. Use below formulas to create KPIs in the New report

6. 7.

III. The table below describes the process for generating Radio BSS

Data KPIs

Stage Description

1. Log in to Business Objects application 2. Create New report using CELLGPRS Universe

3. Select raw counters as per below detailed procedure

6. 7.

IV. The table below describes the process for generating Core CS KPIs

Stage Description

1. Log in to Business Objects application

2. Create New report using CN_MSC, CN_MGW, ROUTE Universes 3. Select raw counters as per below detailed procedure

6. 7.

(3)

V. The table below describes the process for generating Core PS KPIs

Stage Description

1. Log in to Business Objects application

2. Create New report using CN_GSN, S_C_GSN Universes 3. Select raw counters as per below detailed procedure

6. 7.

Purpose and scope

This document describes the Ericsson Network Statistics generation procedure using business objects. It describes both Core and Radio KPIs counters.

Scope

This document covers:

1. Procedure to generate Ericsson KPIs 2. Counters to create Core, GPRS, Radio KPIs 3. KPIs counters descriptions

It does NOT cover:

1. Platform dependency procedure

2. Business objects installation and configurations

Applies to:

1. Performance Management Team 2. Network Optimization Team

Frequency

The procedures in this document will be carried out once, but amendments can be implemented anytime if need be.

(4)

VI. Radio BSS Data KPIs

Before you begin you need to have business object installed and configured To create Radio voice KPIs in Business Objects.

Step Action

1. Log in to Business Objects application 2. Go to FileNew

3. New report wizard will appear. Select Generate a standard Report then click Begin 4. Specify data access. Select universe click NEXT

5. Select a universe, Select BSDR81 Universe from the available list of universes, then finish 6. Query panel will appear with 3 frames.

a.) Classes and Objects

This frame lists all the KPIs counters and Objects types b.) Result Objects

This section is used to build the query c.) Conditions

This section is used to build query conditions

(5)

New report wizard, then select begin button

(6)

Select Universe BSDR81, then Finish Note:

Repeat this exercise for core and GPRS. Select universes as per the guidelines

Query Panel.

Result Objects Section Classes and Objects

Section

Conditions Section Search the counter by

(7)

Drag and drop the objects from the Classes and objects into results Objects See below counters and formulas for the KPIS

VII. KPIs Formulas

a) Radio KPIs formulas

No KPI Name Formula

1 SDCCH Blocking Rate 100*(<CCONGS> +<CCONGSSUB>) / (<CCALLS> + <CCALLSSUB>) 2 SDCCH Drop Rate 100*(<CNDROP> - <CNRELCONG>)/<CMSESTAB>

3 TCH Blocking Rate 100 * (<CNRELCONG> + <TNRELCONG>) / <TASSALL>

4 Call Setup Success Rate 100*(1- ((<CNDROP> - <CNRELCONG>)/<CMSESTAB>))*(<TCASSALL> /<TASSALL> ) 5 Call Drop Rate

100*(<TNDROP>/(<TCASSALL>+ (<SUMIHOSUCC>-<SUMIABSUCC>-<SUMIAWSUCC>)-(<SUMOHOSUCC>-<SUMOABSUCC>-<SUMOAWSUCC>)))

6 TCH Availability 100 * <C_TAVA> /<TNUCHCNT> 7 TCH TRAFFIC CARRIED <C_TTRALACC>

8 FR TRAFFIC <TFTRALACC> 9 HR TRAFFIC <THTRALACC>

10 Handover Success Rate 100 *(<SUMOHOSUCC> + <SUMEOHOSUCC>) / (<SUMOHOATT> + <SUMEOHOATT>) 11 TCH Assignment Success Rate 100 * <TCASSALL> / <TASSALL>

12 Random Access Success Rate 100*(<CNROCNT>/(<CNROCNT>+<RAACCFA>))

13 SQI Samples 100*(<TSQIGOODAF>+ <TSQIGOODSUBAF>+<TSQIGOODAH>+ <TSQIGOODSUBAH>+<TSQIGOOD>+<TSQIGOODSUB>)/((<TSQIGOOD>+ <TSQIGOODSUB>+<TSQIACCPT>+ <TSQIACCPTSUB>+<TSQIBAD>+ <TSQIBADSUB>)+(<TSQIGOODAF>+ <TSQIGOODSUBAF>+<TSQIACCPTAF>+ <TSQIACCPTSUBAF>+<TSQIBADAF>+ <TSQIBADSUBAF>)+(<TSQIGOODAH>+ <TSQIGOODSUBAH>+<TSQIACCPTAH>+ <TSQIACCPTSUBAH>+<TSQIBADAH>+ <TSQIBADSUBAH>)) 14 AMR_Traffic_HR <THV3TRALACC>/<THV3NSCAN> 15 AMR_Traffic_FR <TFV3TRALACC>/<TFV3NSCAN> 16 Erlang Minutes Per Drop <RPL>*<C_TTRALACC>/<TNDROP>

17 Cell Availability 100*((1440-<Total DowntimeMins>)/1440) 18 Total DowntimeMins =Round((<BDWNACC>/6) ,0)

(8)

b) Radio GPRS KPIs

No. KPIs KPI Formula

1 GPRS UL Throughputs(Kbits) <ULMSGTHR>/<ULMSGDATA> 2 GPRS DL Throughputs(Kbits) <DLMSGTHR>/<DLMSGDATA> 3 EGPRS UL Throughputs(Kbits) <ULMSEGTHR>/<ULMSEGDATA> 4 EGPRS DL Throughputs(Kbits) <DLMSEGTHR>/<DLMSEGDATA> 5 Hard Blocking Rate 100*(<FAILDLTBFEST>/<DLTBFEST>)

6

Soft Blocking Rate

((((<MUTIL12>)+(<MUTIL23>)+(<MUTIL34>)+(<MUTIL45>))*1+((<MUTIL1 3>)+(<MUTIL24>)+(<MUTIL35>))*2+((<MUTIL14>)+(<MUTIL25>))*3+(<M UTIL15>)*4)/(((<MUTIL22>)+(<MUTIL12>))*2+((<MUTIL13>)+(<MUTIL23 >)+(<MUTIL33>))*3+((<MUTIL14>)+(<MUTIL24>)+(<MUTIL34>)+(<MUTIL 44>))*4+((<MUTIL15>)+(<MUTIL25>)+(<MUTIL35>)+(<MUTIL45>)+(<MU TIL55>))*5))*100 7 TBF Drop Rate ((<PREEMPTTBF>+<MOVECELLTBF>)/(<DLTBFEST>-<FAILDLTBFEST>))*100

8 Total GPRS Vol (<DLMSGDATA>+<ULMSGDATA>)/8 9 Total EGPRS Vol (<DLMSEGDATA>+<ULMSEGDATA>)/8

(9)

VIII. KPI counters descriptions

a) Radio voice counters

No. KPIs Counters Descriptions

1 BDWNACC

Accumulated number of scans of the cell where the BCCH was unvailable.

2 CCALLS Call attempt counter

3 TNRELCONG

Number of released TCH due to radio resource congestion

4 CCONGS Congestion counter.

5 SUMIHOSUCC Incoming handover success

6 SUMOHOSUCC outcoming handover success

7 TAVASUB Available channels accumulated for subcell.

8 TASSATT Number of assignment attempts on TCH

9 TNUCHSUB Number of defined channels subcell.

10 C_TAVA=(TAVAACC / TAVASCAN)

Available TCH channels accumulator / Number of accumulations of available TCH channels counter.

11 TFTRALACC Traffic level accumulator full rate

12 TNUCHCNT Number of defined channels.

13 THTRALACC Traffic level accumulator half rate

14 TDWNACC Cell downtime accumulator

15 TNDROP Number of dropped connections

16 TDWNSCAN

Number of accumulations of Cell downtime accumulator

17 C_TTRALACC Full Rate + Half Rate Traffic

18

TCONGSAS=((TFCONGSAS + THCONGSAS + TFCONGSASSUB + THCONGSASSUB)

TFCONGSAS:Number of congestion at assignment

FR

THCONGSAS: Number of congestion at assignment

HR

TFCONGSASSUB: Number of congestion at

assignment, overlaid subcell FR

THCONGSASSUB: Number of congestion at

assignment, overlaid subcell HR

19

TCONGSHO=

(TFCONGSHO+THCONGSHO+TFCONGSHOSUB + THCONGSHOSUB))

TFCONGSHO:Number of full rate congestion at

handover

THCONGSHO: Number of half rate congestion at

handover

TFCONGSHOSUB: Number of full rate congestion at

handover, overlaid subcell

THCONGSHOSUB: Number ofhalf rate congestion

at handover, overlaid subcell

20 TCALLS Call attempt counter

21 CNDROP Dropped connections due to failure.

(10)

23 CCALLSSUB Call attempt counter for subcell.

24 CMSESTAB

Successful MS channel establishment on SDCCHs.

25 TASSALL Assignment attempts for all MS power classes

26 CNRELCONG

Number of SDCCH released due to radio resource congestion.

27 CNROCNT Number of random accesses.

28 RAACCFA Failed random accesses.

29 PDRAC Number of packet data random accesses.

30 CNUCHCNT Number of defined SDCCH channels.

31 SUMEOHOATT Outcoming extranal handover attempt

32 SUMIABSUCC incoming handover success to better cell

33 SUMIAWSUCC incoming handover success to worst cell

34 SUMOABSUCC outgoing handover success to better cell

35 SUMOAWSUCC outgoing handover success to worst cell

36 SUMEIABSUCC incoming external handover success to better cell 37 SUMEIAWSUCC incoming external handover success to worst cell 38 SUMEOABSUCC outgoing external handover success to better cell 39 SUMEOAWSUCC outgoing external handover success to worst cell

40 SUMIHOATT incoming handover attempt

41 SUMOHOATT outgoing handover attempts

42 SUMEIHOSUCC incoming external handover success

43 SUMEIHOATT incoming external handover attempts

44 SUMEOHOSUCC incoming external handover success

45 TCASSALL Assignment complete for all MS power classes

46 TSQIBADSUB

Number of measurements with unsatisfactory speech quality in overlaid subcell.

47 TSQIGOODSUB

Number of measurements with good speech quality in overlaid subcell.

48 TSQIACCPTSUB

Number of measurements with acceptable speech quality in overlaid subcell.

49 TSQIGOODSUBAF

Number of measurements with good speech quality in overlaid subcell, AMR FR.

50 TSQIGOODAH

Number of measurements with good speech quality, AMR HR.

51 TSQIACCPTAF

Number of measurements with acceptable speech quality, AMR FR.

52 TSQIACCPTSUBAF

Number of measurements with acceptable speech quality in overlaid subcell, AMR FR.

53 TSQIBADAF

Number of measurements with unsatisfactory speech quality, AMR FR.

54 TSQIBADSUBAF

Number of measurements with unsatisfactory speech quality in overlaid subcell, AMR FR.

55 TSQIGOODSUBAH

Number of measurements with good speech quality in overlaid subcell, AMR HR.

(11)

56 TSQIACCPTAH

Number of measurements with acceptable speech quality, AMR HR.

57 TSQIBADAH

Number of measurements with unsatisfactory speech quality, AMR HR.

58 TSQIBADSUBAH

Number of measurements with unsatisfactory speech quality in overlaid subcell, AMR HR.

59 TSQIGOODAF

Number of measurements with good speech quality, AMR FR.

60 TSQIGOOD

Number of measurements with good speech quality.

61 TSQIBAD

Number of measurements with unsatisfactory speech quality.

62 TSQIACCPT

Number of measurements with acceptable speech quality

63 THV3TRALACC AMR half rate Traffic level accumulator

64 THV3NSCAN

Number of accumulations of AMR half rate traffic level counter.

65 TFV3TRALACC AMR Full rate Traffic level accumulator

66 TFV3NSCAN

Number of accumulations of AMR Full rate traffic level counter.

67 TSQIACCPTSUBAH

Number of measurements with acceptable speech quality in overlaid subcell, AMR HR.

b) Radio GPRS counters

No. KPIs Counters Descriptions

1 CS12ULSCHED

Number of RLC data blocks scheduled by MAC protocol for CS-1/2 and RLC ack mode, UL. TBFs carrying EIT excluded.

2 CS12DLSCHED

Number of RLC data blocks scheduled by MAC protocol for CS-1/2 and RLC ack mode, DL. TBFs carrying EIT excluded.

3 MC19ULSCHED

Number of RLC data blocks scheduled by MAC protocol for MCS-1-9 and RLC ack mode, UL. TBFs carrying EIT excluded.

4 AVAILRBLKS

Number of available 20 ms RLC blocks on all allocated PDCHs (DL and UL).

5 USEDDLRBLKS Number of occupied (scheduled) radio blocks DL.

6 USEDULRBLKS Number of occupied (scheduled) radio blocks UL.

7 ULINTBGVOL Total number of Interactive & Background PFCs UL.

8 DLINTBGVOL Total number of Interactive & Background PFCs DL.

9 ULGMMVOL Total number of GMM/SM signaling UL

10 DLGMMVOL Total number of GMM/SM signaling DL

11 ULMSGDATA

Accumulated LLC data volume for interactive/background, GPRS capable MSs, UL.

12 DLMSEGDATA

Accumulated LLC data volume for interactive/background, EGPRS capable MSs, DL.

13 ULMSEGDATA

Accumulated LLC data volume for interactive/background, EGPRS capable MSs, UL.

(12)

14 ULMSGTHR

Accumulated LLC data volume for interactive/background, GPRS capable MSs, UL.

15 DLMSGTHR

Accumulated weighted LLC throughput for interactive/background, GPRS capable MSs, DL.

16 DLMSEGTHR

Accumulated weighted LLC throughput for interactive/background, EGPRS capable MSs, DL.

17 ULMSEGTHR

Accumulated weighted LLC throughput for interactive/background, EGPRS capable MSs, UL.

18 DLMSGDATA

Accumulated LLC data volume for interactive/background, GPRS capable MSs, DL.

19 DLTBFEST Number of DL TBF establishment requests.

20 MUTIL15 Number of DL TBFs scanned where 1 out of 5 PDCHs are reserved.

34 FAILDLTBFEST

Number of unsuccessful DL TBF establishment requests due to lack of resources.

35 MOVECELLTBF

Number of released TBFs due to move of cell and GPRS support is removed.

(13)

IX. Document control information

Document status

Document Number ERICSSON Business Objects KPIs generation Process documentation

Version 1.0

Issue Date 1-Dec-11

Owner NSN-Performance Management Team

confidentiality Private and Confidential

Document history

The history of changes made to this document is shown below.

Version Date Summary of Changes

1.0 1-Dec-11 First Issue

Approval

This document has been approved for publishing by:

Reviewed by: Authorized by:

Distribution

Controlled copies of this document are distributed as follows

ERICSSON Business Objects KPIs Generation Process Documentation