Answer Posted / suresh

Fact tables have 4 types:
1)Additive Fact table
which can be summed ex:Sales,we can summed sales amount
2)Non-Additive fact table
which can not be summed ex:
3)Semi Additive fact table
That can be summed up for some of the
dimensions and not others.
EX:
4)Fact less fact table:which does not contain measures.

ex:student :faculty,year,course details..there is no measures

Can you explain the advantage of using shortcuts?

983

---

how to create measures and dimensions?

1024

---

What are the types of studio present in Cognos?

987

---

what is power prompt in cognos ep7series?what is the use of this?

3623

---

What is model?

912

---

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

14870

---

faq's on cognos

3999

---

What is the difference between a data mart and a data warehouse?

993

---

which type of project we r going to snowflake schema

1929

---

How do you improve the performance of the Cognos Analytics report

972

---

Can you define transformer?

894

---

2. What functional area you worked on.

2274

---

What errors and types of errors you faced in Cognos ReportNet?

4096

---

What is the report studio?

979

---

What is the difference b/w macros and prompt?

1037

---