how to improve the report performance?
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
Is This Answer Correct ? | 15 Yes | 1 No |
What are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8?
how to improve the report performance?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows
how to find the rank in report studio? i need steps for this question.
What are links & Segments in Cognos Framework Manager?
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt
How to configure the Cognos configurations to work in the Windows 2000 Server machine?
What are the different types of OLAP. Which one is Cognos Powercube?
How we check the errors before running the report?
What is a dimension?
9. What was the most complex type of report you dealt with?