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

Any Cognos planning Queries Rise

5 Answers  

---

Can you define dimension?

0 Answers  

---

What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?

3 Answers  

---

How to pass parameter value into html design page?

1 Answers  

---

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

0 Answers   IBM,

---

wt is tupple , Embed function ? wt is regular dimension ?

1 Answers  

---

How can I schedule reports in cognos?

0 Answers  

---

1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 Answers  

---

What are the different ways of adding data in Transformer?

3 Answers   Cognos, IBM,

---

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers  

---

what is the difference between java script and html in cognos?

1 Answers   IBM,

---

what is a prompt value in report studio and variables ?

0 Answers  

---