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

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.

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

• 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

kalam

• Feb 12th, 2006

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.

• Jun 1st, 2006

Hi,

Example for semi additive facts like "balances"

Bala Dara

Anand

• Jun 23rd, 2006

Ratios, Averages & Variance facts..

mamatha

• Aug 1st, 2006

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

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

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 :

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.

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

• 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(%)

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?

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.

cognos_anu

• Jun 20th, 2017

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