What are non-additive facts?

Editorial / Best Answer

Answered by: Praveen

  • Aug 15th, 2005


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

Showing Answers 1 - 14 of 14 Answers

Jisha

  • Jul 12th, 2005
 

Non additive facts are those measures in the fact table which cannot be added at all. eg.Averages

sampath

  • Jul 24th, 2005
 

Fact tables in which data in columns data cannot be aggregated or calculations cann't be possibel for producing the expected results or known as non-additive facts.

  Was this answer useful?  Yes

Praveen

  • Aug 15th, 2005
 

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

Hero

  • Sep 27th, 2005
 

Facts which can't be summerised by addition. Example : Avergae

kalam

  • Feb 12th, 2006
 

Any examples for semi-additive..

  Was this answer useful?  Yes

Vishwas Gupta

  • May 1st, 2006
 

Basically all the measure can be summed up. These definations of additiive,semi-additive and non-additive measures is based upon the requirements. If you want to sum up a measure for some dimensions but not for others then it become your semi-additive..and while creating a cube you take care of this thing.

Anand

  • Jun 23rd, 2006
 

Ratios, Averages & Variance facts..

  Was this answer useful?  Yes

mamatha

  • Aug 1st, 2006
 

non additive facts are facts which are not used in arthimetical calculations

crishnathk

  • Dec 28th, 2006
 

good morning situ,

can v differentiate b/w the factless fact table & non-additive facts ?cud u explain with example?

here is my mailid:crishnathk@gmail.com

cheers,

harikrishna.....

  Was this answer useful?  Yes

srinivas

  • Apr 2nd, 2007
 

hi,

you can take a bank account as semiadditive since a current balance for the account can't be summed as time period; but if you want see current balance of a bank you can sum all accounts current balance.

siraj.khan

  • Aug 3rd, 2007
 

There are basically three types of Facts :
1) Additive Facts
2) Non- Additive Facts
3) Semi-Additive facts

Additive facts are those facts which we can aggregate or we can add.For e.g 2+7=9.
Non-additive facts are those facts which we can't aggregate or add For example we can't 4%+8%.
Semi-additive facts are those facts which we can aggregate according to the context.

  Was this answer useful?  Yes

amnon

  • Aug 20th, 2008
 

A fact that cannot be logically added between records, such as average, and that must be combined in a computation with other facts before being added across records.

ypinky

  • Jul 26th, 2010
 

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

example-percentage(%)

  Was this answer useful?  Yes

Srikant

  • Nov 20th, 2016
 

Hi Siraj,
Regarding the Non-additive facts example, we can add 4% & 8% and get 12% of whatever we are looking at. So How does percentage become non-additive?

  Was this answer useful?  Yes

Srikant

  • Nov 20th, 2016
 

Please give me a fact table where I cannot add the percentage. Especially if the percentage is calculated for that particular fact table. Are we saying that percentages stored in the fact table might not be the percentage w.r.t same denominator? But that would just mean we are not violating granularity unless the denominator is different for different dimensions but at the same granularity.

  Was this answer useful?  Yes

cognos_anu

  • Jun 20th, 2017
 

The facts which cannot be summed up across any dimension.
for e.g. Percentage, temperature

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions