Interested to Buy Any Domain ? << Click Here >> for more details...
what are the types of facts ? explain them?
- 2 Answers
- 23082 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 |
-------------How you design DWH?
What are shortcuts? Where it can be used? What are the advantages?
Can you define a datastore in cognos?
fiscal year means what???
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
How do you improve the performance of the Cognos Analytics report
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
how u migrate reports to cognos 8 from previous versions
What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?
1 Answers Cognizant, Niteo, SacSoft,
Teradata 
