what are the types of facts ? explain them?
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 mean by cognos powerhouse?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com
What is Parametermap?
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
How do we convert from Numeric to be Words?
How can create users and permissions in cognos?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is the enterprise class platform architecture of cognos 8?
How security is concerned with Reportnet? Explain its implementing steps.
how to perform back drill through in cognos 8 what is the use of it
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt