Interested to Buy Any Domain ? << Click Here >> for more details...
what are the types of facts ? explain them?
- 2 Answers
- 23255 Views
- Business Objects, Informatica, Syntel, Teradata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / arkchowdary
Types of Facts------------------ Additive Fact,
Semi-Additive Fact,
Non-Additive Fact.
Perodic Fact,
Accumilative Fact
| Is This Answer Correct ? | 10 Yes | 8 No |
what is model and how to create model and how to test model?
What is the difference between cognos 8.2 and cognos 8.3?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
----------0Diff b/w Report Functions and Database functions?
what is requery in cognos?
How do you test the reports? Explain the Unit testing procedures after developing the reports?
What is content Manager?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
Where do you edit cognos sql in report studio?
What are all the types of indexes in Cognos?
----------How to cretae a Template?
How to create multilingual reorts?
Teradata 
