Answer Posted / vishwamithra

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
------------------------------------------------------------
----------There are two types of Fact Tables namely :

1) Cummulative Fact Table : Facts collected over a period
of time are called CFT.

2) Snapshot Fact Table: Facts collected at adhoc basis are
called SFT.
-----------

what are the names of the reports that you prepared?

1042

---

I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

2020

---

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.

4521

---

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

906

---

What is the report studio?

979

---

What is main advantage datawarehousing over oracle?

943

---

What is a Pivot?

1042

---

New coloums are added in database, then how you know in report level

1512

---

how to test reports in cognos?

966

---

What is the difference between set functions and filter function in dimensional data?

2845

---

Diff b/w Crossproduct and Outerjoin?

2218

---

-----------------What is Direct and Conventional loading?

2122

---

What is defined as Query studio?

1024

---

Can you define bitmap index?

1010

---

4. How many dimensions did you use in your reports?

1890

---