-----------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
What are the two types of framework manager?
Write various indexes used in cognos?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What are the types of hierarchies?
what is requery in cognos?
what are the errors faced while bursting the reports and how to solve those errors?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
Explain the difference between native sql and cognos sql?
What is difference between data mart and data warehouse?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
What do you mean by Drill down and Drill Up?
please please give me some banking calculations in framework manager.
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
Explain is there any comparison available for cognos reportnet vs crystal reports?
What is the report studio?