Answer Posted / krishna

To display the 3rd record of emp table we can write query as
select * from emp where rownum<4 minus select * from emp
where rownum<3;

How to apply securities for reports in cognos connection?

2490

---

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4668

---

how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

2056

---

What is the difference between ‘macro’ and ‘prompt?

1015

---

What is the function of cognos dispatcher?

1164

---

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1014

---

how to create measures and dimensions?

1039

---

What are products of cognos?

945

---

What is the difference between drill through, drill across?

1033

---

What are all the types of gateway used in Cognos?

985

---

What are the ways to import data into catalog?

1044

---

How can I test reports in cagonos?

920

---

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4346

---

What are the methods by which it non-durable model could be changed into the durable model?

914

---

What is the difference b/w macros and prompt?

1056

---