Answers

Question and Answer:

  Home  Data Warehouse Concepts

⟩ Explain What are non-additive facts in detail?

A fact may be measure, metric or a dollar value. Measure and metric are non additive facts.

Dollar value is additive fact. If we want to find out the amount for a particular place for a particular period of time, we can add the dollar amounts and come up with the total amount.

A non additive fact, for eg measure height(s) for 'citizens by geographical location' , when we rollup 'city' data to 'state' level data we should not add heights of the citizens rather we may want to use it to derive 'count'

which cant be summed up with any columns in the table(all dimension keys)

EX: ratio columns,profit margin

 151 views

More Questions for you: