Interested to Buy Any Domain ? << Click Here >> for more details...
what are the types of facts ? explain them?
- 2 Answers
- 23086 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
How can we Maintain the Cube Security by Category level and Dimension level ?
how you create security to reports?
What is the difference between Standard and Metrics folder?
What do you mean by query studio?
What is main difference mapplets and mapping?
what is hints in cognos and where we use it.
What is dtm?
What is difference between data mart and data warehouse?
Name the types of report?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Can you define fan trap?
what are slowly changing dimensions? Why we are used scd?
What you mean by drill across?
what is the role of cognos comsultant?what actually it means?pls reply
