-----------Types of Fact Tables?
Answer Posted / sharath.dwh
THERE ARE 3 TYPES OF FACTS
1)ADDTIVE:FACTS THAT CAN BE SUMMED
2)SEMI ADDITIVE:FACTS THAT CAN BE SUMMED UP FOR SOME OF THE
DIMENSIONS AND NOT OTHERS.
EX:BANK BALANCE
3)NON ADDITIVE:CAN'T BE SUMMED.
EX:RATIO,AVG,VARIANCE
| Is This Answer Correct ? | 28 Yes | 8 No |
Post New Answer View All Answers
Explain is there any comparison available for cognos reportnet vs crystal reports?
What is the difference between Standard and Metrics folder?
How can you link a query to a data container manually in Report Studio?
4. How many dimensions did you use in your reports?
------------- How to identify the Revenue Column in Report?
What is the use of Cognos scenario?
What are the types of hierarchies?
Can you define fan trap?
Can you define cognos decision stream?
What are the components of report net?
What is meant by drill down?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
Cleared COG-112 with 100% score today. What next certification should i go for?
What is the function of cognos dispatcher?
what are the special features in cognos reportnet?