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

Write various indexes used in cognos?

967

---

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2016

---

What are cognos connection initial page components?

1134

---

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

2548

---

Can you define drill across?

974

---

What is the difference between drill through, drill across?

1079

---

Can you define folder?

959

---

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

1551

---

What is a Pivot?

1140

---

What are shortcuts? Where it can be used? What are the advantages?

1070

---

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2365

---

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3297

---

What are query items?

1018

---

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11733

---

What is difference between primary key and unique key constraints?

986

---