Answer Posted / palzkumar

Three types of Fact...

1. Additive Fact: Additive facts are facts that can be
summed up through all of the dimensions in the fact table.

2. Semi-Additive Fact: Semi-additive facts are facts that
can be summed up for some of the dimensions in the fact
table, but not the others.

eg : Bank Balances - you can take a bank account as Semi-
Additive since a current balance for the account can't be
summed as time period; but if you want see current balance
of a bank you can sum all accounts current balance.

3. Non-Additive Fact: Non-additive facts are facts that
cannot be summed up for any of the dimensions present in
the fact table.
Eg: . Ratios, Averages & Variance

rgds,
palz

What is zero-foot print?

1007

---

What are the considerations regarding performance kept in mind while setting up cognos?

949

---

What do you mean by query studio?

931

---

how to connect datamarts

2772

---

how to create measures and dimensions?

1066

---

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

2006

---

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

3286

---

how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

2273

---

What are the types of studio?

1136

---

When we save a report in report studio with what extn it save?

1050

---

how to perform back drill through in cognos 8 what is the use of it

2520

---

How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

2035

---

What is set to be cardinality?

1163

---

What is called Cognos powerplay?

1070

---

What is drill down and slicing and dicing whats the difference between them?

1056

---