Case 15. Generating Reports in the QoE Analytics Section

Statistics from DPI are accumulated in the QoE cluster. To generate a report, go to the QoE Analytics section of the operator interface — where access to QoE is available.
The following sections are accessible:

• NetFlow;
• Raw Full NetFlow;
• Clickstream;
• Raw Clickstream;
• DNS Flow;
• Raw DNS Flow.

1. Select the section and report (1).
2. Choose the time period for displaying data in the report (2);
3. Set filters for the report (5).

Data in the report can be displayed in table or chart format. In reports where chart display is available, you can select the chart type (11): spline area, area, stacked area, line, or stacked bar chart.

The generated report can be exported in the following formats:

• Table in Excel, TabSeparated, CSV, PDF, or PNG formats (9). You can set the number of rows per page (10), and this number will be reflected in the exported report;
• Chart — in PNG and PDF formats (12).

Filters in reports enable users to refine data based on specific criteria, making it easier to locate necessary information within large datasets.

Report filtering is available in the QoE analytics sections: Netflow, Raw full netflow, Clickstream, and Raw clickstream.
Before applying filters, a time interval must be selected using the "Period" field:

There are two ways to specify a period:

1. Custom range — manually set the Start and End time;
2. Quick ranges — predefined date and time intervals available from a list.

This filter is used to track activity for a specific subscriber, IP pool, or subscriber list.
Search can be performed by IP or Login. If one filter does not return the expected results, try using another.

1. Select the appropriate filter:

• "Subscriber" for IP-based search;
• "Login" for username-based search.
  

2. Configure the filter using one of the following options:

Single subscriber	IP: Login:
Subscriber pool	IP:
Subscriber list	IP: Login:

3. Enable the filter by checking the box next to it;
4. Click "Apply".

This filter helps identify subscribers who have accessed a specific resource or a list of resources.

1. Select the "Host" filter;
2. Choose the "=" or "like" operator;
3. Enter the resource name;
4. Enable the filter by checking the box next to it;
5. Click "Apply".

To filter by a list of resources, use the method outlined in Case 1. Searching for a subscriber in QoE → Subscriber list.

This filter is used to refine data by an IP address with a subnet mask.

1. Select the "Subscriber" filter;
2. Choose the "in CIDR's" operator;
3. Enter the IP address with the subnet mask;
4. Enable the filter by checking the box next to it;
5. Click "Apply".

This filter applies when searching for subscribers assigned a specific application protocol.

1. Select the "Application Protocol" filter;
2. Choose the "=" or "like" operator;
3. Enter the protocol name;
4. Enable the filter by checking the box next to it;
5. Click "Apply".

Filters set up in the scenarios section can be saved as profiles for quick reuse in future reports. To do this:

1. Click the "+" button on the left side of the filter configuration window, under the "Saved" tab, to create a profile and assign it a name:
   
2. Configure the necessary filters and enable them. Examples: FIlters use cases
3. Click the "Save Filter" button
   

Filter profiles are stored within a specific section. This means profiles created in the "NetFlow" section can be applied to all reports in that section but will not be accessible in "Raw Full NetFlow," "Clickstream," or other sections.

For ease of use, you can customize the number of rows and columns displayed in the report table. To modify these settings, click the gear icon located below the table.

In the window that appears, create a settings profile:

For a table report, you can adjust:

1. Column visibility;
2. Row limit;
3. Report name;
4. Display filter;
5. Page orientation.
6. By clicking the "Save settings" button, you can store the customized settings for quick access in future reports.

For a chart report, you can adjust:

1. Items visibility;
2. Chart step;
3. Chart type;
4. Report name;
5. Display filter;
6. Page orientation.
7. By clicking the "Save settings" button, you can store the customized settings for quick access in future reports.

Determines whether a string adheres to a simple regular expression. Regular expressions can contain the following metasymbols:

• % represents any number of characters (including none).
• _ represents any single character.