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

Can you define report item?

1100

---

Can you define fan trap?

1312

---

explain how to create powerplay reports?

1065

---

What are the different uses of a repository manager?

1169

---

Please explain the different stages in creating a report in cognos report net?

1056

---

how to merge 2 crosstabs thans

2685

---

how to create measures and dimensions?

1173

---

What do you mean by drill through report?

1016

---

Explain difference between powerplay transformer and power play reports?

992

---

----------------Diff b/w Dimensional modeling and Relational modeling?

15093

---

What is difference between data mart and data warehouse?

1019

---

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1968

---

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

2149

---

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

2804

---

which type of project we r going to snowflake schema

2021

---