Answer Posted / harish

based on salary top 10 records for emp table

select * from ( select * from emp order by sal desc)where rownum<=10;

What is the function of cognos dispatcher?

1176

---

Mention the difference between ‘macros’ and ‘prompt’?

1096

---

Can you define pivot?

1041

---

Diff b/w Crossproduct and Outerjoin?

2242

---

What is main advantage datawarehousing over oracle?

970

---

4. How many dimensions did you use in your reports?

1916

---

how to perform single sign in cognos by using url?

1115

---

How to generate cubes in cognos?

925

---

Can you define cognos decision stream?

971

---

9. What was the most complex type of report you dealt with?

2173

---

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2239

---

Can you define cognos impromptu?

993

---

Can you define slice?

997

---

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1972

---

What is metric store database?

974

---