jyothsna

• May 12th, 2006

 

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. Current Balance and Profit Margin are the facts.Current Balance is a semi-additive fact, as it makes sense to add them up for all accounts (what's the total current balance for all accounts in the bank?), but it does not make sense to add them up through time (adding up all current balances for a given account for each day of the month does not give us any useful information). Profit Margin is a non-additive fact, for it does not make sense to add them up for the account level or the day level.

crishnathk

 Profile Answers by crishnathk 

• Dec 27th, 2006

 

hi jyotsna good morning,

can u plz fwd some more examples regarding semi-additive & non-additive facts.

cud u plz tell me what is granularity?

here is my mailid:crishnathk@gmail.com

thq

harikrishna