Types of Facts

Fact

A fact table typically has two types of columns, foreign keys to dimension tables and measures those that contain numeric facts. A fact table can contain fact’s data on detail or aggregated level.

Eg: Sales, Cost, and Profit

Types of Facts

1. Non-Additive
2. Semi-Additive
3. Additive

Additive

Additive facts are facts that can be summed up through all of the dimensions in the fact table.

Eg: Sales fact

Semi-Additive

Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others.

Eg: Daily balances fact can be summed up through the customers dimension but not through the time dimension.

Non-Additive

Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.

Eg: Facts which have percentages, Ratios calculated.