sri
Answered On : Oct 24th, 2005
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'
Hope this answers the question

3 Users have rated as useful.
Login to rate this answer.
Types of Facts
There are three types of facts:
- Additive: Additive facts are facts that can be summed up through all of the dimensions in the fact table.
- 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.
- Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.
Cheers,
Sithu

1 User has rated as useful.
Login to rate this answer.
tH
Answered On : Jan 27th, 2006
Factless Fact - same as non additive facts ... it can be counted but cannot be measured directly...
Login to rate this answer.
ravi kumar guturi
Answered On : Mar 14th, 2006
Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.
Login to rate this answer.
Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table
Login to rate this answer.