Versions Compared

Old Version 2

changes.mady.by.user Anastasiia Kovalinas

Saved on

compared with

New Version Current

changes.mady.by.user Anastasiia Kovalinas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel
titleIn this article
Table of Contents

Report Queries

...

List 

This section allows you to view, execute and manage the already existing templates of Routing Analysis, Profit Report, xDR's List, Mismatches ReportReport Queries of Active Sessions, Balance Report, Customer Dynamics, Invoicing Report, LCR Lists, Orig-Term Report, and Summary Report, Profit Report, Rates Analysis, Routing Analysis, Summary Report, and xDRs List. Moreover, you can send reports to email to send reports to email to keep yourself informed about the traffic status without the need to login log in to the system and request query reports. The section structure is as follows:

Screenshot:  Reports Templates Report Queries section main window

Image RemovedImage Added

ColumnDescription
IDTemplate Query ID
TitleNameName of the templatequery
Report QueryTemplate Query details
WatchTo EmailTool to run a report automatically at the exact time and send the results to the list of emailsResellerName of the Reseller

The section contains the following functional icons:

IconDescription

Image Added

Allows creating a new report query

Allows previewing a templatequery

 

Allows running a respective report by this templatequery

Indicates that

 To send

sending a report via

email watch option

email option is enabled.


Info

You can enable/disable the to email rule after it's been created in the system by clicking the indication icon.


Indicates that To send sending a report via email watch optionemail option is disabled.

To start managing, choose the respective template query from the section and click on the name to open the settings.

Creating a Report

...

Query

You can create a report query either using a New Report Query button in the main section, or

...

All reports templates are created from the respective sections while generating reports.  To add If you are adding a new templatequery from the report section, you need to: 

  1. open the target report section;
  2. fill in a query form with respective parameters;
  3. click the Save Query button;
  4. in a pop-up window with template settings, fill in all required fields (screenshot and field description is provided down below);
  5. click Apply to save a template. 

Screenshot: New Template Query form

Image AddedImage Removed

Report the templateIndicate a Reseller for report users under specified Reseller. To enable this option, select one parameter from the drop-down list available for users according to the settings of the Reseller field

This tool allows generating reports at the appropriate time and sending results to specified emails.

Information BlockDescription
NameHere you can specify parameters for the template that will be used while running reportsTitleSpecify a name of Reseller the template
Visibility

It allows controlling the visibility of respective reports templates whether you want to keep templates private or leave them visible for

other users:

  • Public -
  • available for all users of the same Reseller; 
  • Private - accessible strictly for the creator.
Watch
Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning)   Attention

Please note that this tool is not available for Web output type, only for CSV/Excel XLS/Excel XLSx.

RecipientsSpecify emails of recipients. Here you can indicate your own or other users' email, even those of 3rd parties.Run TimeDetermine an appropriate time to generate a report automatically, it could be several times, for example, 10:00, 12:00, 18:00Run Time TimezoneIndicate a timezone for a selected report run timeDays of WeekDefine days of a week to generate a report automatically. For example, you can run a report only on Monday or each day of the week.ReportHere, a report type will be prefilled.Filters / OutputReport Query

Here you need to specify filters that will be used for generating a correct report and choose the output type to view the report

Panel
borderColor#FFBABA
bgColor#FFBABA
borderWidth2px
borderStylesolid

Image Removed Warning

  • If you create the report template and the Watch option is enabled, the client will receive the file with a report even when there are no statistics for a specified period.
  • Please be aware that the templates previously existing in the Reports to email section could not be restored automatically. Note that you can recreate them if needed.

Reports Templates List 

This section allows you to view, execute and manage the already existing templates of Routing Analysis, Profit Report, xDR's List, Mismatches Report, Orig-Term Report, and Summary Report. Moreover, you can send reports to email to keep yourself informed about the traffic status without the need to login to the system and request reports. The section structure is as follows:

Screenshot: Reports Templates section main window

Image Removed

...

To Email Tab

After creating the Query, you can manage whether to allow generating reports at the specific times and send results to specified emails. For this, open the needed Report Query, and click the To Email tab:

Screenshot: To Email tab

Image Added

Information BlockDescription
GeneralStatus

Specify if this function is on:

  • Enabled
  • Disabled
Output Type

Specify a file type to be sent:

  • CSV
  • Excel
RecipientsUsersDefine system Users to send a Query to (can be empty if the Extra Emails field is filled in)
Extra EmailsSpecify the needed extra email addresses (can be empty if the Users field is filled in)
SchedulingRun Times

The section contains the following functional icons:

...

Image Removed

...

Image Removed 

...

Image Removed

...

Image Removed

...

To start managing, choose the respective template from the section and click on the name to open the settings.

Creating a Report Template

All reports templates are created from the respective sections while generating reports. To add a new template, you need to: 

  1. open the target report section;
  2. fill in a query form with respective parameters;
  3. click the Save Query button;
  4. in a pop-up window with template settings, fill in all required fields (screenshot and field description is provided down below);
  5. click Apply to save a template. 

Screenshot: New Template form

Image Removed

Information BlockDescription Report NameHere you can specify parameters for the template that will be used while running reportsTitleSpecify a name of the templateResellerIndicate a Reseller for the report templateVisibility

It allows controlling the visibility of respective reports templates whether you want to keep templates private or leave them visible for users under specified Reseller. 

To enable this option, select one parameter from the drop-down list:

  • Public - available for users according to the settings of the Reseller field; 
  • Private - accessible strictly for the creator.
Watch

This tool allows generating reports at the appropriate time and sending results to specified emails.

Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning)   Attention

Please note that this tool is not available for Web output type, only for CSV/Excel XLS/Excel XLSx.

RecipientsSpecify emails of recipients. Here you can indicate your own or other users' email, even those of 3rd parties.Run Time
Determine an appropriate time to generate a report automatically, it could be several times, for example, 10:00, 12:00, 18:00
Run
Time
Times TimezoneIndicate a timezone for a selected report run time
Days of the WeekDefine days of
a
the week to generate a report automatically. For example, you can run a report only on Monday or each day of the week.
Report QueryHere you need to specify filters that will be used for generating a correct report and choose the output type to view the report


Panel
borderColor#FFBABA
bgColor#FFBABA
borderWidth2px
borderStylesolid

Warning

If you create the report

template

query and the

Watch

To Email option is enabled, the client will receive the file with a report even when there are no statistics for a specified period

.Please be aware that the templates previously existing in the Reports to email section could not be restored automatically. Note that you can recreate them if needed

.