Databases Reference
In-Depth Information
To illustrate this, let's create a new bar chart with the
Aircraft Group
field as dimension, which is an aircraft attribute, and
Sum ([# Departures
Performed])/1000
as the expression. We will end up having something like
the following:
On the other hand, we cannot just remove these dimensionless records from the fact
table as it will skew the total amounts.
While the appropriate response is always discussed with and decided by the
business users, a very common approach is to add dummy dimension values to the
dimension table. To do this in our current example, let's follow these steps:
1.
Open the
Script Editor
window.
2.
At the end of the script, add the following code:
Temp_Aircraft_Type_ID:
LOAD DISTINCT
[%Aircraft Type ID] as Temp_Aircraft_Type_ID
RESIDENT [Aircrafts];