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

What is the difference b/w macros and prompt?

0 Answers  

---

What is a Framework manager?

0 Answers  

---

In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?

1 Answers  

---

Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480

7 Answers  

---

fiscal year means what???

8 Answers   iFlex, iGate,

---

architecture of cognos8

1 Answers   IBM, Sonata,

---

What are the different type of securities can we apply in framework manager?

1 Answers  

---

why u need to publish the package?

5 Answers   IBM,

---

what is the use of lock and unlock

1 Answers  

---

how many types of keys are there i.e primary key and foreign key etc..?

2 Answers   IBM,

---

how you create security to cubes ?????

4 Answers   iFlex, iGate,

---

can any one explain about blue prints&performance tuning in cognos? 

1 Answers   TCS,

---