Databases Reference
In-Depth Information
4.
Rename the sheet by entering
Reports
in the
Title
input box from the
General
tab. Click on
OK
to close the
Properties
dialog.
5.
From the new sheet, remove the objects that we do not need: the container
object and the scatter chart at the center, and the distance
statistics box.
Now we're ready to start adding our reporting objects.
KPIs per airline, origin, and destination country
Our first requirement is to create a table that shows
Load Factor %
,
Performed vs
scheduled flights,
, and
Air time %
. We also want to be able to alternate the dimension
so we can see these KPIs by
Airline
,
Origin Country
, and
Destination Country
.
Cyclic and Drill-down groups
Since we want to be able to switch between dimensions in our table, we will be using
a cyclic group. As we saw before, cyclic groups can be used to dynamically switch
the dimension of a chart. We can cycle through the dimensions by clicking on the
circular arrow, or by selecting a specific dimension by clicking on the drop-down
arrow or right-clicking on the circular arrow.
In
Chapter 2
,
Seeing is Believing
, we described a way to create drill-down and cyclic
groups. However, there is another approach, which we will follow here:
1.
Select
Settings
|
Document Properties
from the menu bar to open the
Document Properties
window.
2.
Go to the
Groups
tab and click on
New
.
3.
Make sure that the
Cyclic Group
radio button is selected in the
Group
Settings
dialog window.
4.
Enter
Airline_Origin_Destination
in the
Group Name
input box.