Versions Compared

Key

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

...

Information blockField Description
Filters

On the Filters menu, select required parameters for the report. To cancel any filter, click on the delete sign next to the filter.
You can start a quick search by typing filters' names in the field at the top of drop-down menu with filters.

Outlook

Choose the form of the rate analysis report for data display. Please note that this field is mandatory and should be filled in to make a report.

  • Rates comparison - compares rates in general and particular rates, assigned to certain Clients and Accounts.
  • Least costs list - shows the cheapest rate for each code in a particular rate table
ServiceSelect a service for rates analysis
OriginatorsSpecify origination clients for analysis.
TerminatorsIndicate termination clients for analysis
Rate TablesDefine rate tables for analysis.
Group By

Select a grouping option from the following list:

  • Code - aggregation by default output.
  • Code Name - grouping by rate rows with the same names and rates for all codes in each rate table

This option is intended to simply grouping option, the system will automatically group data in specified columns.

Additional Filters

The accessible additional filters are:

  • Events: Code, Code Name, Code Country
  • Extras: Actual On, Master Table, Lowest Position, Get Margins For, Tag, Rate Age
Events settings
CodeSpecify a code of needed destination.
Code NameDefine a code name of the desired destination.
Code CountryEnter a code of the respective country.
Extra settings
Actual onDefine the Effective Date of rates.
Master tableTable

Specify a rate table that all other rates table will be compared to.

Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning)   Attention

Please note that this field is active only during rate tables analysis


Lowest PositionEnter the number of the position from the full list of rates. For example, if you are looking for the cheapest destination in the several rates, tape type 1 in this field. Please note that this feature only works with Master tableTable option.
TagIndicate a tag which retales to a specified rate table
Get margins forDefine a rate table which respective margins will be taken from. It is used to analyze margins.
Rate ageSpecify the number of days
Output



This information block contains settings of the report output data.

Type

Choose a format of the report from a drop-down list: 

  • Web
  • CSV
  • Excel XLS
  • Excel XLSx

If CSV, Excel XLS or Excel XLSx type has been selected, an additional Send to field will be displayed. In this field, you can specify emails of the clients, where the current report in the selected format will be sent to.

Currency

Specify a currency of the report. All values will be automatically converted in the report to the specified currency.

Code Deck

Select a code deck from a drop-down list. All codes in the following report will be presented according to the specified code deck.

Simulate long codes check box

 Check if a rate table does not have codes which are presented in other tables for simulating them using shorter codes.

Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning)   Attention

If you check the Simulate long codes check box, the system will try to simulate the longest available code with shorter one. For example, we analyze two rate tables, one of which has code 380, and the other has 380 and 38044 codes.
When mentioned check box is active, the first rate table will have unavailable 38044 code simulated with the price of available 380. Rates like these have Simulated label when you hover the mouse pointer over them and are colored in light-red, light-green and grey respectively.


...