etl-new

• Jun 24th, 2005

 

Non-additive facts are facts that cannot be summed up for any of 
the dimensions present in the fact table. Example: temparature,bill number...etc

Kenny

• Jul 18th, 2005

 

fact table typically has two types of columns: those that contain numeric facts (often called measurements), and those that are foreign keys to dimension tables.  
 
A fact table contains either detail-level facts or facts that have been aggregated. Fact tables that contain aggregated facts are often called summary tables. A fact table usually contains facts with the same level of aggregation.  
 
Though most facts are additive, they can also be semi-additive or non-additive. Additive facts can be aggregated by simple arithmetical addition. A common example of this is sales. Non-additive facts cannot be added at all.  
 
An example of this is averages. Semi-additive facts can be aggregated along some of the dimensions and not along others. An example of this is inventory levels, where you cannot tell what a level means simply by looking at it.

senkumar79

 Profile Answers by senkumar79 Questions by senkumar79

• Oct 4th, 2005

 

If the columns of a fact table is not able in the position to aggregate then it is called non-additive facts.

sithusithu

 Profile Answers by sithusithu 

• Jan 17th, 2006

 

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

Cheers,

Sithu

vineela

• Jul 18th, 2007

 

Non additive facts are the facts that do not participate in arithmetic caliculations. for example in stock fact table there will be opening and closing balances along with qty sold and amt etc. but opening and closing balances were never used in arithmetic calculations.

sharuvijay

 Profile Answers by sharuvijay Questions by sharuvijay

• Jan 28th, 2009

 

Non Additive facts cannot be aggregrated along with dimenstion in the fact table. For eg. Age, weather