-----------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


Please Help Members By Posting Answers For Below Questions

What are the two types of framework manager?

654


Write various indexes used in cognos?

532


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?

668


What are the types of hierarchies?

540


what is requery in cognos?

2046






what are the errors faced while bursting the reports and how to solve those errors?

1544


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2286


Explain the difference between native sql and cognos sql?

491


What is difference between data mart and data warehouse?

526


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

1637


What do you mean by Drill down and Drill Up?

546


please please give me some banking calculations in framework manager.

1628


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.

4052


Explain is there any comparison available for cognos reportnet vs crystal reports?

520


What is the report studio?

578