-----------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
how to explain health care project and which reports we can create in health care doain?
--------------Explain Table of contents?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
what is online view?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Give the advantages of cognos?
What is model?
How can I schedule reports in cognos?
what do u mean by bridge group? where we r using this one?
Why cognos scenario is used?
explain how to create powerplay reports?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What are the other methods working as deployment functionality?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder