Answer / kumar

1) Try to use the less no. of Queries& Outer Joins.
2) If any calculation are used frequently, that need to do
at ETL level since data will be loaded with taht
Calculation.
3) avoid the Joins at Report Level.
4) Remove the unwanted Columns @ Report level.
5) Adding filters to reduce the amount of data to perform
the report well.
6) if we are using any specific filters for mutiple report
we need to create that filters at FM level as Stand alone
Filters.
7) We prefer Drill through to Master Detail Report to
reduce the time taking.
8) We prefer Conditional block to Render Variable for
Performance.
9) Use Local Cache ,If we run the any Report Frequently it
will reduce the Time.



I added My Experience points,I think few more are thare.


Thank You
Kumar

Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....

0 Answers  

---

What is Stich Query in Reportnet?

10 Answers  

---

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

1 Answers   TCS,

---

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?

1 Answers   IBM,

---

is there any possibility to hide items other than render variable?

2 Answers   IBM,

---

write a query to display the third record from the employee table?

6 Answers   HCL,

---

What is the abrevation of .PPR? (Power play report) or anything new?

1 Answers  

---

what is exact catalog size?

4 Answers   IBM,

---

what are the tabs in cognos ?

2 Answers  

---

How to do deployment?

5 Answers  

---

How security is concerned with Reportnet? Explain its implementing steps.

1 Answers   iFlex,

---

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

1 Answers   IBM,

---