Answer Posted / 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
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Name the types of gateway?
What are the different uses of a repository manager?
Why is auto-regression used in forecasting used on cognos platform?
What are the components of the report studio?
Can you define cognos powerplay?
What is the use of Cognos scenario?
Can you explain the advantage of using shortcuts?
Can you explain new content durability?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What are the services provided in cognos 8?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
What is looping and how to avoid it in framework manager?
Define cognos report net?
What is the function of cognos dispatcher?
What are all the advantages of Cognos?