Warehouse Concepts Question:
Explain What are non-additive facts in detail?
Answer:
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
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
| Previous Question | Next Question |
| Explain What is the difference between OLAP and datawarehosue? | What is cubes? |