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 the difference between cognos 8.2 and cognos 8.3?
What r the names of the reports that you prepared?
which difficult you faced in your project?
How to create measures and Demensions?
What is the metric store database?
What is defined as catalog and types of catalogs in Cognos?
Can you define a catalog and types of catalogs in cognos?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is stitched Query?
----------------------What are the User Securities?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
What is Dynamic Grouping? what is diff between grouping n levelspan?