rameshr

• Nov 3rd, 2006

 

hi....

this is ramesh.....(if any one feel there is some conceptual problem with my solution plz let me now)

there are three types of facts...

1.additive

2.semi additive

3. non-additive

additve means when a any measure is queried of the fact table if the result relates to all the diemension table which are linked to the fact

semi-additve when a any measure is queried from the fact table the results relates to some of the diemension table

non-additive when a any measure is queried from the fact table if it does n't relate to any of the diemension and the result is driectly from the  measures of the same fact table ex: to calculate the total percentage of loan just we take the value from the fact measure(loan) divide it with 100 we get it without the diemension...

calltomadhu

 Profile Answers by calltomadhu 

• Nov 6th, 2006

 

hi,

additive means it can be summrized by any other column.

semi additive means it can be summrized by some columns only.

Akhilesh

• Nov 9th, 2006

 

hi can u give one example of additive  and semi additive facts it ll be better for understand

Akhi

murali

• Nov 26th, 2006

 

average monthly balance of your bank account is a semi-additive fact.

ramakrishna

• Sep 22nd, 2007

 

A measurable data on which simple addition can be performed is called fully additive such measurable data's no need to combine two or more dimensions for it's meaning
Ex:
Product wise total sales
Branch wise total sales

A measurable data on which simple addition can't be performed is called semi additive such measurable data's need to combine two or more dimensions for it's meaning
Ex: customer wise total sales amount ---------> Has no meaning

customer wise product total sales amount

If any one have doubt about this let me now