Interested to Buy Any Domain ? << Click Here >> for more details...
what are the types of facts ? explain them?
- 2 Answers
- 23252 Views
- Business Objects, Informatica, Syntel, Teradata, I also Faced
- E-Mail Answers
Answer Posted / palzkumar
Three types of Fact...
1. Additive Fact: Additive facts are facts that can be
summed up through all of the dimensions in the fact table.
2. Semi-Additive Fact: Semi-additive facts are facts that
can be summed up for some of the dimensions in the fact
table, but not the others.
eg : Bank Balances - you can take a bank account as Semi-
Additive 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.
3. Non-Additive Fact: Non-additive facts are facts that
cannot be summed up for any of the dimensions present in
the fact table.
Eg: . Ratios, Averages & Variance
rgds,
palz
| Is This Answer Correct ? | 47 Yes | 1 No |
Post New Answer View All Answers
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
What are the components used in web tier?
how you create security to reports?
What is the advantage of using shortcuts?
-----------Diff b/w OLAP and RDBMS?
What are all the advantages of Cognos?
What do you understand by ‘ibm predictive maintenance and quality’?
What are the services provided in cognos 8?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
Can you explain cognos planning?
What are the different types of reports present in cognos?
What are the types of folder present in cognos?
What is the difference b/w macros and prompt?
How is cognos model organization works?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
