sri

• 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

sithusithu

 Profile Answers by sithusithu 

• Jan 17th, 2006

 

 

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

tH

• Jan 27th, 2006

 

Factless Fact - same as non additive facts ... it can be counted but cannot be measured directly...

ravi kumar guturi

• 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.

siteshkumar

 Profile Answers by siteshkumar 

• Jul 8th, 2008

 

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