Answer Posted / joydeep

go through the generated sql and try to compare it with the
regular sql code by running the sql in the navigator. that
will give you an estimate of the time difference.

secondly try to check the joins. avoid outer joins as far
as possible.

thirdly try to add prompts and filters if possible to
reduce the number of records to be pulled into the query.

Diff b/w Crossproduct and Outerjoin?

2337

---

What is called a slice?

1082

---

what is the role of cognos comsultant?what actually it means?pls reply

2370

---

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

2271

---

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

2103

---

What is the use of powerhouse?

1145

---

What is dtm?

1218

---

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3608

---

Define olap designer?

1192

---

is cognos 7 is better than cognos 8

2211

---

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

3348

---

What do you understand by the term 'aggregate advisor?'

1013

---

--------------Diff b/w ODS and OLAP?

3252

---

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2623

---

Can you explain the advantage of using shortcuts?

1074

---