TIP OF THE WEEK:

How to identify all through flights that depart from or arrive at any airport worldwide.

Example: How to find all through flights that depart from or arrive at MIA.

Start setting up your query using the yellow query filters:

Now expand the ROUTING folder, drag the Intermediate Airport Code object (blue cube) and drop it in the Query Filter Section.  As soon as you drop it in, the system will display the Filter Editor.  From the Operator drop down menu, select the option ‘Is Not Null’.  Then press OK.  This will allow you to create a filter indicating that the Intermediate Airport is not null.

Your five criteria should look like those listed in the image below:

Now select the following fields as Results Objects (blue cubes).

Click on Run Query and select as To/From Airport Code ‘MIA’ and week commencing date ‘2006-07-10’

Now Click OK to run the report.

MAX Online will display all through flights that depart from or arrive at MIA Airport.

MAXimum information
                 
Did you know that you can create your own filters by ‘dragging & dropping’ objects (‘blue’ cubes and ‘purple’ measures) in the Query Filter Section?

Example: Create a filter that shows all flights with a value ‘greater than’ 100.

Expand the FREQUENCY & CAPACITY folder.  Now ‘drag’ the ‘Frequency’ object (purple measure) and ‘drop’ it in the Query Filter Section.  The system will automatically display a new ‘Filter Editor’ as a pop up box.

From the ‘Operator’ drop down menu on the left, scroll down and then select the option ‘Greater Than’.  Now type your required value e.g. 100.  Press OK.

The images below illustrate the process outlined (click on the chart to view larger image).
Step 1:
:

Step 2: (click on the chart to view larger image)

The new filter (Frequency > 100) should match that shown below:

MAX Online gives you enormous flexibility to create and save your own criteria that match your exact requirements.