A fact table is used to store descriptions (attributes) of an event or entity, whereas these attributes usually change slowly.

Measurable values (facts) must always be additive to prevent incorrect aggregations. Non-additive facts (e.g., ratios) should always be calculated only in the report.

A fact table should always contain atomic (lowest level) data to allow for flexible aggregation and to answer queries at any level of granularity.