Use Case 4: Global parameter filtering based on a secondary parameter

Service providers often define the extent of coverage area using a specific parameter as a threshold value. In Nemo Analyze, it is possible to use this threshold value for filtering out the irrelevant data coming from outside coverage area. By setting a threshold condition for a parameter value, you can define a global filter that will be applied to all subsequent Nemo Analyze operations (apart from Crystal Reports report templates).

For the purposes of this use case, all data with Received Signal Code Power (RSCP) of -100 or higher will be considered measurement data from coverage area. The global filter created based on this condition will exclude all data with RSCP values lower than -100 from all subsequent Nemo Analyze operations. In other words, all Nemo Analyze operations will be filtered based on a secondary parameter, RSCP best active set. Filtering by secondary parameter enables the filtering of a primary parameter data set based on a selected secondary one. The resulting data set will contain only those values from the primary data set that coincide with the values in the secondary one. All parts of the primary data set that do not contain RSCP value of -100 or higher will not be considered measurement data from coverage area and thus will be excluded from the processed data set.

To define a global filter, select Utilities | Global Filters from the Ribbonbar.

To add a new filter, click Edit.

The Analyze Wizard – Filters dialog opens.

To add a filter, click Add. An empty filter line is added.

Select <Secondary parameter> from the Name drop-down menu. Click the … button in the Value column to browse for a secondary parameter.

The Analyze Wizard – Secondary Measurement Parameters dialog opens. Select the parameter

RSCP best active set and click Next.

To add a filter, click Add. An empty filter line is added. Select the parameter RSCP from the Name drop-down menu. Next, select the operator >= (i.e. greater or equal) from the operator drop-down menu. Finally, enter the value -100 in the Value field.

Click Finish.

This returns you to the first Analyze Wizard – Filters dialog. Click Finish.

All subsequent operations performed with Nemo Analyze during this session will be filtered based on the set threshold condition. To save the filter for use also during subsequent Nemo Analyze sessions, click Save.

The Save Filter dialog opens.

Click OK.

To activate a saved filter set, select a saved filter set in the Saved global filter sets and click the Set Active button.

To remove a global filter, select the filter in the Saved global filter sets field and click Delete.

It is also possible to set a particular cell as filter by right-clicking on map on top of base station sector and selection Create Global Filter From Cell ID... From then on, all workbooks and queries will be

limited in the way that results are returned only from those points where the cell in question has been serving.

8.5 Filtering data and creating custom KPIs

Custom KPIs can be created either by correlating parameters using the Query Manager or, to create more complex KPIs, by using the KPI Workbench (see p. 356).

With the correlate parameters functionality it is possible to create events based on complex search criteria, create events showing problems and reasons for problems, and create a CSV table from the measurement data for export purposes.

You can create new Correlate parameters KPIs in the Query manager. In the Ribbonbar, select Tools | Query manager | Add… | Correlate parameters. The created KPI will be added to the User- branch in the Parameters view in the Workspace. The correlate parameters functionality can also be used for creating a custom KPI by right-clicking on a device in the Workspace, and selecting

Correlate Parameters, and Next. In this case the new KPI will not be saved. Right-click on a device in the Workspace, and select Correlate Parameters.

In the Correlate Parameters dialog, select the parameters that you want to correlate. You can add two or more parameters in the Selected view.

There are three different Modes available: Show values when first parameter changes (left outer join), Show values when any of the parameters changes (outer join), and Show values when all parameters are valid (inner join).

The Show values when first parameter changes (left outer join) mode creates an output row for every value of the first selected parameter. For other selected parameters, it gives the current, previous, or next value from the time stamp of the first parameter. This mode can used to find all events of a certain type in the measurement data, and the values of other parameters at the time the event occurred. For example, it can be used to find all dropped calls (the first parameter), the last TX power, Best active Ec/N0, and Best active RSCP values prior to each drop.

After selecting the parameters to be correlated, click Next. In this example you can find six different parameters in the Selected view, Call dropped, Percentage of “DL power up” commands, Percentage

of “UL power up” commands, Ec/N0 best active set, and RSCP best active set.

Select the data view in which the data will be displayed, for example, a grid, and click Finish. The correlation data is opened in the selected data view.

The Show values when any of the parameters changes (outer join) mode creates an output row when any of the selected parameters changes. This mode can also be used when exporting data to

Excel. In the example below, there are three parameters in the Selected view, RX level full, Ec/N0

best active set, and BLER DL. Click Next. The correlation data is opened in the selected data view.

As you can see, there are no values for RX level full and RAC in rows 4600-4616, and no values for Ec/N0 and BLER DL in rows 4614-4620.

The Show values when all parameters are valid (inner join) mode creates an output row when any of the selected parameters changes, and all the parameters are valid. This mode can be used when generating input for scatter graph, or when creating events based on custom search criteria. In the example below you can see a custom KPI: all rows where Ec/N0 < -7, BLER DL, and RSCP < -79 are shown.