Versions Compared

Key

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

...

Screenshot: Rates Analysis section

Image Added

Creating a New Analysis Report 

...

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
Information BlockField Description
Filters

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

Outlook

.

  • Least costs list - shows the cheapest rate for each code in a particular rate table
  • Service
    Select a service for rates analysis
    OriginatorsSpecify origination clients for analysis
    Dst Code
    Dst Code Name
    ClientsTerminatorsIndicate termination clients for analysis
    Rate TablesDefine rate tables for analysis
    AccountsClient TagsSelect clients matching specified tags for analysis
    Rate Table

    Define rate tables for analysis

    Group by



    Select a grouping option from the following list:

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

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

    Additional Filters

    The accessible additional filters are:

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

    Specify a rate table that all other rate tables 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 several rates, type 1 in this field. Please note that this feature only works with the Master Table option.
    TagIndicate a tag, which relates to a specified rate table
    Get margins forDefine a rate table, from which the respective margins will be taken. 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, to which the current report in the selected format will be sent.

    Currency

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

    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 checkbox

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


    ...