<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1763249257255837&amp;ev=PageView&amp;noscript=1">
Schedule time to talkFree trial


Over the years, the Analyser platform has undergone advancements and alterations in order to ensure users can have maximum flexibility to create the best analysis they need.

See below the version updates we have introduced.

New Exclude Scheduled Flights in Connections Analyser.

This release of Analyser contains important new functionality in Connections Analyser. One of the main uses of Connections Analyser is to be able to model the impact on connections from adding a new phantom flight. Exclude scheduled flights takes this a step further, it allows a user to delete current scheduled flights to model the impact on connections from taking these flights out. A user can combine Exclude Scheduled Flights with Phantom Flights to exclude flights and add in new flights to model how this effects connectivity. Also in this release a new search option has been added to Schedules Analyser to search by State.


Exclude Scheduled Flights

Exclude Scheduled Flights is in a new section called ‘Customise Flights’ with Phantom Flights. 

Figure 1 – New Customise Flights section

To start to use Exclude Scheduled Flights click the blue arrow to take you to the right-hand panel.

Figure 2 – Exclude Scheduled Flights section in right hand panel

Figure 2 shows how Exclude Scheduled Flights looks in the right hand panel. There are two options here; you can either make a new search to search for flights to exclude (click ‘Search Schedules’ button) or you can select a saved selection of flights from previous searches or edit/delete groups.

Saved flight selections are shown in the right-hand panel under ‘Saved Flights’ or these can be found in the middle panel as well.

When you click on ‘Search Schedules’ a new panel shows in the right-hand side. Here you can search for schedules you would like to exclude from your query. Click 'Find Out More' below to read the release notes for this new functionality and to go through a worked example. 


State Search in Schedules Analyser

From customer feedback we have added the option to search by 'State' in Schedules Analyser. The ‘State’ search is a radio button located with Airport, City, Country and Region in the middle input panel under Origin & Destination in all reports. The user can also exclude by 'State'. 'State' dimensions are also included in the Power Table under dimensions.

 State is located in the input screen here:

Figure 3 - New State search option

New Power Table Dimensions are called:

  • Dep State Code
  • Dep State Name
  • Arr State Code
  • Arr State Name



New Search by Departure and Arrival Time Window in Mapper.

This new release of Analyser gives Mapper customers the ability to search for flights by departure and arrival time window. The map will use the user's selections and plot this on the map. User's also can exclude a departure and arrival time window. This is similar to the functionality in Schedules Analyser.


Figure 1 - Departure and Arrival time window in Analyser input Screen


Figure 2 - Map of scheduled flights from Chicago O'Hare International Airport (ORD) between 06:00 and 07:00 for January 2018

Figure 2 shows an example of this new feature. The map shows departures from Chicago O'Hare International Airport (ORD) between 06:00 and 07:00 for January 2018. This shows there are only flights to USA, Canada and Mexico in this time window.

To continue to improve the quality of our releases and deployments, this release also includes changes in our backend processes. The improved process ensures that the deployment for production is of highest quality, is always built in a standard robust method and minimises build/deployment issues.

New Exclude Carrier Functionality in Connections Analyser

This release of Analyser contains new functionality to Connections Analyser. A user can now exclude a carrier’s schedule from their query in both the Connections Analysis Report and the Missed Connections Report. We have also made some performance upgrades to Connections Analyser.

Connections Analyser – Exclude Carrier

We have received feedback from our customers that they would like to build connections excluding a carrier in Connections Analyser. In both the Connections Analysis Report and the Missed Connections Report we have added this functionality. The exclude carrier functionality works in the same way as other Analyser modules.

Under the ‘Carrier’ input box shows the text ‘Add Exclusion’:


When a user clicks ‘Add Exclusion’ an input box appears below the carrier box allowing the user to select a carrier to exclude. The groups icon also allows the user to use saved groups of carriers to exclude.


Connections Analyser – Performance

Connections Analyser uses staging tables in its flow to store user query data. These staging tables are then used for showing results on screen. Over years, these tables have grown a lot without maintenance and this puts a burden on the Database server when it executes its queries. 

The back end data load process for Connection Analyser has been updated so that our staging tables remain optimised to only recent data. The daily maintenance job now removes stale data from ALL the staging tables.

Since these staging tables are now optimised to only hold recent data:

  • The UI rendering will be quicker.
  • Any SQL query for the staged CA data will be quicker.
  • There will be less load on the server.


  • Bug Fix – Changing the colour of the lines in Mapper was not working for both Display and Highlight. This has now been fixed.

Analyser Maintenance Release

In this new release of Analyser we have a mixture of maintenance work and bug fixes to Schedules and Connections Analyser, the Job Bin and Scheduled Reports.

Schedules and Connections Analyser

  • Schedules Analyser - Top X Report – The Top X report previously searched by Airport Name instead of Airport Code. This meant if an airport changed its name there would be multiple lines of data which made it difficult to analyse. In this release we have changed the report to search by airport code and then apply the latest airport name. This eliminates the problem.  
  • Schedules Analyser - Stops option box in all reports was not big enough to populate the selected parameter >, < or =. This has now been changed.
  • Bug - Connections Analysis Report – If a report was run using the job bin, the user had selected the connections tab only and it generated no results, the UI in Analyser when downloading this report would just keep running so it looks like the report is still running. This has been fixed so the download option still gives an output if there is no data and the UI has been fixed. 

Job Bin

  • Job Bin – If a user deleted a report that had been run in the job bin there was no pop up message to ask if the user would like to delete the job. A pop up box with a message has been added in this release.

Scheduled Reports

  • Update to scheduled reports emails with the correct OAG branding and the email body address for OAG has changed to 1 Capability Green, Luton, Bedfordshire, LU1 3LU.
  • Bug - Scheduled Report – The rolling dates option in Schedules Analyser was not working. This has now been fixed.


  • Add server name being used by the browser in view-source so that we can see which server is being used.

We are very excited to release a new version of Analyser. This version is a maintenance release including a few bug fixes.

Firstly, we have changed the default chart in results pages to a column chart apart from the Schedules Bank Structure Report which will stay as an area chart. Line Charts are still available using the ‘Modify Graph’ option in the menu at the top right-hand corner of the chart. 

In Traffic Analyser Connections Report, Full Y and Disc Y columns for Estimated Passengers and Avg Fare, First, Business, Premium, Full Y and Disc Y for Average Fare were missing. These existed in the Classic Version of Analyser therefore we have added these columns in.

Lastly in DOT Analyser DB1B Detailed Report we have added Frequent Flyers in to every query and created an option to exclude them in 'Fare Class' dropdown box:


Bug Fixes

  • If a user ran a report in Analyser including the map in the results page, then clicked back to run a different report, the map was keeping parts of the original query. This has been fixed.
  • All 'Season' options under 'Period' were not working in Schedules Analyser, this has been fixed.

New functionality in Traffic Analyser: Addition of Load factor, Estimated Revenue Calculation, Pro Rata Fares and Average/Online fare in High Charts 

This release contains the following exciting NEW features in Traffic Analyser:

  • Load Factor Calculation
  • Total Revenue Calculation
  • Pro Rata Fares Calculation
  • Average and Online Fares in High Charts

New! - Load Factor

The Segment Report in Traffic Analyser has been renamed to 'Segment & Load Factor Report' and now includes load factor! Load factor is a metric to show how full an aircraft is. It is calculated using Estimated Pax in Traffic Analyser divided by Total Seats from Schedules Analyser. 

Load Factor is now available in the Segment tab in the results page of the Segment & Load Factor Report. 


Figure 1 - New results page showing load factor for LHR to JFK for the year 2016

New! - Total Revenue Calculation

A new metric called Total Est. Revenue has been added to the Power Table Report in Traffic Analyser. The current Total Revenue metric calculates revenue by class whereas our new metric Total Est. Revenue calculates using Total Est. Pax multiplied by AvgFare Total. This new metric allows for the data to be manipulated in Excel.

Example - LHR-JFK Jan 2016:


Total Est. Revenue = Total Est. Pax x AvgFare Total
Total Est Revenue = 119,558 x 890 = $106,361,697
AvgFare Total = 106,364,697 / 119,558 = $890

New! - Pro-Rata Fare Calculation

Two new metrics in the Traffic Analyser Power Table have been added as part of this release called Pro Rata Avg Fare and Pro Rata Seg Dist Share (%). The current Average Fare metric shows the average fare for a routing including connections. The new metric Pro Rata Avg Fare breaks this down to each flight in a connecting journey using distance and allocates a fare to each flight. 

Example - For the routing LHR-LAX-SFO the average fare is $985. LHR-LAX segment accounts for 94% of the total distance and therefore has a pro rata average fare of $927 (985 x 0.94 = $927).


'Pro Rata Seg Dist Share' metric gives the share of the segment of interest as a percentage of the total routing distance. 

These two metrics can only be used with traffic type Segment in the Power Table.


New results page, New Analyser version history, maintenance release for DOT Analyser and bug fixes for other modules

New Results Page

Results pages in all reports now have a 'My Report' slide out panel at the right-hand side of the screen to show what report parameters have been selected. All results pages also now have a title to show which report is being queried. 

New Results Page 2

Figure 1 - New results page in Schedules Analyser - Capacity Report with 'My Report' slide out panel open

Analyser Version History 

On the Analyser homepage, we have added a button called 'Version History' which links through to a new web page showing the history of Analyser. Each new release has a drop down section giving a summary of what has been included in the release. There is a 'Read More' link at the bottom of each section which goes to a new web page with more detailed release notes for that release. 


Figure 2 - Screenshot of Analyser home page with 'Version History' button


The new DOT Analyser enables users to quickly analyse US DOT data to look at passenger and capacity trends, average fares and measure financial performance

DOT Analyser is the final module of the Analyser suite to be given the new Analyser look and feel. As part of this development we have added tree structure's in the Power Table's for Dimensions and Metrics to make them easier to use and we have made financial ratios in Form 41 more visible. 

New features include:   

  • Easily view all possible input parameters
  • Report selections automatically appearing on screen
  • 6 Power Tablee
  • Tree structure for dimensions and metrics to easily choose required fields
  • Combined T100 Domestic and International data to easily analyse both
  • New 'Data Overview' button to see when the data has been updated
  • Addition of Job Bin functionality to run multiple reports at the same time


Figure 1 - T100 Segment Report Page


New functionality for Mapper and bug fixes for Connections Analyser


We received a lot of feedback from customers about being able to drag and drop labels in Mapper so we have developed this functionality as well as being able to cluster labels together. 

Figure 1 - Mapper output before moving MTY, GDL and MEX

Figure 2 - Mapper output after moving MTY, GDL and MEX

Figure 3 - Mapper output clustering labels

Bug Fixes in Connections Analyser

  • After uploading a CSV phantom flight file that has terminals in them, when reviewing the flight in the edit panel the terminals were showing 0 instead of a value. Fixed.
  • ‘Select All’ still showing as checked on QSI edit panel when just a few QSI coefficients had been chosen. Fixed. 
  • Effective dates on phantom flight edit panel showing previous day’s date after save and then reopen. This is to do with the timezone of the browser. Fixed. 

Analyser maintenance release

Bug fixes for the Analyser suite.

All Analyser

  • Sort columns in results table was not working, this has been fixed.


  • Mapper colour picker pop up position fixed for IE/older browsers. Was appearing half outside the browser window.
  • Passenger/cargo dropdown picker added to Mapper parameters.
  • Mapper regions now hardcoded to WW1. Was using Schedules Analyser region setting but will not work if only subscribing to Mapper as no region set.

Connections Analyser

  • Fix for period dates on Connections Analyser - saved/load reports not loading correctly.
  • Phantom Flights elapsed time / arrival time / arrival day calculation now fixed for airports such as CCP – IQQ. 

Traffic Analyser

  • Period picker not showing latest Prelim travel date. Was wrong year. Now fixed.

Schedules Analyser

  • Schedules Analyser Capacity Report now returning data for pre-2005 when Flight Type set to Both. It was failing before.

Now using Google maps, this intuitive and powerful mapping and marketing tool now lets you plot and customise route maps with ease

  • Access rich historical data and full future data in OAG's schedules database with over 900 airlines
  • View existing routes and 'custom' routes in one map with new query options
  • Plot unserved routes
  • Use the new range functionality to highlight opportunities
  • Match your corporate colours to stay on-brand with rich customisation options


Figure 1 - New Mapper Screen and Customise Options


All new Reference module in Analyser is now here

As part of the Next Generation Analyser Suite we have created a new Reference module in Analyser to bring all our reference data together in one place: 

  • Eight standard reference reports
  • Two Quick Reports 'Airport Terminal' and 'Airport by Carrier'
  • Integration of mapping within Distance Calculator
  • Multiple routing comparisons in Distance Calculator using circuity calculation


Figure 1 - Distance Calculator output including Google maps and circuity calculation


Maintenance Release for Connections Analyser

Bug Fixes for Connections Analyser
  • Selecting Doubles only from Trip Type. Validation error no longer blocks this selection.
  • Tool tip styling on Connection Parameters.
  • 0000 and arrival day marker showing 1 on Phantom Flights for UK port such as EDI. Now correctly shows as 0.
  • Calendar drop down end-year showing as 2017 for all subscribers. Calendar drop down now fixed to end current year + 1, e.g., 2018.
  • Users that only subscribe to CA are unable to run reports. Users who subscribe to other modules along with CA can use it ok.
  • When a user selects directs and doubles, Connections Analyser only produces directs and singles. 
  • Ensuring year 2018 comes out in the drop down list for users who just subscribe to Connections Analyser. 
  • When month is selected as the period type and the year 2018 is selected in CA, the year 2018 now appears on the report page correctly when a job is opened from the Job Bin. Previously it was loading as 2017.
  • Advanced carrier selections not loading on report page when job opened from Job Bin. 

A new simple screen and improved interface with enhanced functionality to model phantom flights

Connections Analyser is the third product to be given the Analyser new look and feel including enhanced functionality to model phantom flights.

New features include:

  • Easily view all possible input parameters
  • Report selections automatically appearing on screen
  • Interactive graphical options make Connections Analyser data simpler
  • Customise and configure output to your specific needs
  • Utilise enhanced functionality and logic to model your Phantom flights


New Connections Analyser UI visual

Figure 1 - New Connections Analysis results page


All new look Traffic Analyser is here including a new look and feel, and improved fares

Next Generation Traffic Analyser is now live with a new look and feel, improved interface, increased functionality and improved fares. Traffic Analyser is the second product to be given the Analyser new look and feel.

New features include:

  • Graphical options make Traffic Analyser data simpler
  • Standalone Segment report – this was previously part of the O&D report
  • Online fare data for Europe, Middle East and Asia Pacific Airlines
    • Weighted average fares for 56 airlines
    • Historical monthly data to January 2015

TA2Figure 1 - New Traffic Analyser results page including new online fares column


Maintenance Release for Schedules Analyser

Bug Fixes for Schedules Analyser
  • Period / date picker (lose focus) – retain selection when not clicking away from entry box
  • No map message – error message when map does not display
  • User preferences in IE11 formatting – across rather than down page
  • Arr city name – misconnect with reference table
  • Polling issue – remove / rearrange code to phase results ping
  • Purchased years / regions messaging – information on home page re subscription
  • Powertable – moving column selections when customising table returns ‘undefined’ in IE
  • Equipment group not updating parameters once selected
  • O&D pairs when uploading to custom box – cursor defaulting to next line and report looks for airport or airport pair
  • Regions URL issue – customers with select region version require minor code change to deliver reports
  • IE11 caching – F12 open allows reports to run, edit code for IE11
  • Session connection ping – lengthen period for checking
  • JDBC connections issue

Schedules Analyser now has a new fresh look and feel with a simple screen and improved interface

We are very excited to announce our Next Generation Schedules Analyser. We have given the product a fresh new look and feel, made it more user friendly, added graphing functionality and improved the interface:
  • Easily view all possible input parameters when running reports, such as airline capacity, bank structure, changes, power tables and custom reporting
  • Run reports without having to see the information you do not need
  • Your report selections now automatically appear on screen so you can check the criteria as you work
  • You can now easily select the report columns you need with configurable columns on all reports
  • New graph options makes analysing data simpler. Ready-made visuals are now at your fingertips! Eye-catching graphs and maps powerfully illustrate your analysis for presentations and other business documents.

Figure 1 - Schedules Analyser new home page with Job Bin, Saved Reports and Scheduled Reports


Schedules Analyser Results Page

Figure 2 - New Schedules Capacity Report results page including new graph options, map and results table


Classic Schedules Analyser went live in August 2012 with Connections, Traffic and DOT Analyser following

Classic OAG Analyser Timeline