Types of Facts

qTypes of Facts

vAdditive: All the KPIs are group by

  Eg: Sales Fact Quantity like sum(),avg() etc

vSemi Additive: Some KPIs are group by

  Eg: Account balance. A sum() function on balance does not give a useful result but max() or min() balance might be useful. Consider price rate or currency rate. Sum is meaningless on rate; however, average function might be useful.

vNon_Additive: Non-additive measures are those which can not be used inside any numeric aggregation function like sum(), Avg()

  Eg: Ratio , percentage

vFact_less_fact: Does not contains any measures only KPIs

KPI: Key performance Indicator