visit oagmax.com
home arrivals departures announcements tips
 
  Tuesday 18th April 2006  
   

TIP OF THE WEEK:

Printer friendly verison  Print Version
   

How to spot critical values in your reports.

Start by creating an Alerter

Example: To identify all flights out of LHR with an overall weekly frequency greater than 50.

Start setting up your query using the yellow query filters:

Departure Airport Code DEPARTURE FROM folder
All Flights excluding surface SERVICE folder
Operating Flights Only CODESHARE folder
Week Commencing Date PERIOD folder
Non-Stop Flights Only ROUTING folder

Now select the following fields as Results Objects.

Carrier Airline Name AIRLINE folder
Departure Airport Code DEPARTURE FROM folder
Frequency FREQUENCY & CAPACITY folder

Click on Run Query and select LHR as the Departure Airport Code and 2006-05-08 as the Week Commencing Date.

Once you have run the report, click on the data that is contained within the Frequency column.  Now click on the red triangle Alerter icon that is positioned in the Report toolbar.  The Alerter icon is displayed in the following format.

Next page

 

 

 

visit oagmax.com
home arrivals departures announcements tips
 
 

In the pop up dialog box, click New.  The Alerter Editor will be displayed.  Enter an Alerter Name e.g. LHR Weekly Frequencies

From the Operator drop down menu select the Greater than option and then type in the Operand section the value of 50.  Now click Format.  

The Alerter Display pop up box is displayed.  From the Text Section select Font Bold, Size 8 and Background Color Yellow

Press OK in the Alerter Display, OK in the Alerter Editor and OK in the Alerter.  In the results table OAG MAX Online shows all airlines whose weekly number of flights is greater than 50, departing out of LHR..

To remove the Alerter click on the data within the Frequency column.  Click on the Alerter icon. Select Remove and choose OK.

 

Back Next

 

 

 

visit oagmax.com
home arrivals departures announcements tips
 
 

MAXimum information

Have you tried the new MAX Reports that we set up for you last week? Did you try to conduct a trend analysis for airlines?

If not, go to the home page of OAG MAX Online, click on Airline Reports within the MAX Reports section.  Expand the Airline Reports menu by clicking on the plus ‘+’ symbol.  Now expand the list to view the Trend Analysis – Airlines option, select the Weekly sub option. 
There are three report templates available.  MAX Y05 (based on Arrival Flights), MAXY10 (based on Departing Flights) and MAX Y15 (based on Departing & Arrival flights).

These report templates produce a weekly or monthly frequency trend for all airlines departing from or arriving at any airport worldwide.

A selection of multiple periods of time is also available for you. The results show the total number of flights by operating airline over any given period of time.

Example:  Pick up report template e.g.  MAXY10.

Step 1    Select Departing Airport Code MIA
Step 2    Select three different weeks

  • 2006-05-15
  • 2006-06-12
  • 2006-07-10

Step 3    Run the Report

 

Back