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

How can you link a query to a data container manually in Report Studio?

0 Answers  

---

In how many ways we can apply the security to a cube in Transformer? Explain?

1 Answers   Wipro,

---

What do you mean by drill through report?

0 Answers  

---

What is Star schema group?

1 Answers   IBM,

---

What are links & Segments in Cognos Framework Manager?

1 Answers   Systime,

---

What are cognos connection initial page components?

0 Answers  

---

---------- Purpose of Factless Facttable?

2 Answers   Bank Of America,

---

What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?

1 Answers   IBM,

---

What is the difference between a cascading report and drill through report?

0 Answers  

---

How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,

---

Hi,Can anyone tell me training centre for cognos in Mumbai?

4 Answers  

---

can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com

1 Answers  

---