My first Publication Agile-Data-Warehouse-Design-eBook | Page 311

292
Appendix B
NA
NAn Non-Additive fact. A fact that cannot be aggregated using sum; for example,
Temperature NA. Non-additive facts can be aggregated using other func-
tions such as min, max, and average.
A non-additive dimension of a semi-additive fact. The numbered version is
used to relate non-additive dimensions to specific semi-additive facts when
multiple SAs exist in the same table. 8
DF
DF=
formulae Derived Fact. A fact that can be derived from other columns within the same
table. May be followed by a simple formula referencing other facts or
date/time details by number; for example, Unit Price DF=Revenue
/Quantity. 8
[UoM]
[UoM1,
UoM2,...] Unit of measure. Unit of measure symbol or description; for example, Order
Revenue [$] or Delivery Delay [days].
Lists multiple units of measure required for reporting, with the default stan-
dard unit (UoM1) first. All quantities are stored in the standard UoM to pro-
duce an additive fact. 2, 4