what are the types of facts ? explain them?
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
Cleared COG-112 with 100% score today. What next certification should i go for?
Define datastores in cognos?
what is the difference between list report and crosstab report?
How to generate cubes in cognos?
What is called materialized view?
how u will determine the performence tune will occur either in report or system
Can you define slice?
What is the difference between a cascading report and drill through report?
how you create security to reports?
What is the use of cognos decision stream?
What are various types of gateways in cognos?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What are the different uses of a repository manager?
What is a Query Subject?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com