Databases Reference
In-Depth Information
[%Aircraft Type ID],
[# Departures Scheduled],
[# Departures Performed],
[# Available Seats],
[# Transported Passengers],
[# Transported Freight]
FROM
Flights.csv
(txt, utf8, embedded labels, delimiter is ',', msq);
6.
Save the entire document and then execute the script by clicking on the
Reload
button from the toolbar.
After finishing the script execution, if we open the
Table Viewer
window (
Ctrl
+
T
),
we can analyze the subset ratio for the
%Aircraft Type ID
field, seen here:
Notice that the subset ratio is
100%
in the
Flights
table, but below 100 percent in
the
Aircrafts
table. In other words, there are now flights with no corresponding
dimension data.
Having facts without an associated dimension is undesirable. When we use the
dimension in a dashboard, facts that are not associated all get grouped under a
hyphen symbol. Since this is basically a null value, this group of facts can not be
easily selected by the user.