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 is surrogate key give example?
what is materialised view? why we use it in data warehousing?
what is mean by complex starschema ,star schemagrouping?
..Architectural difference between cognos reportnet and cognos8?
What is difference between data mart and data warehouse?
hi my name is siraj i want to know cognos queriy language
Can i apply drill through on master detail relationship report?
what is report burn and where it occurs
what are the types of scheduling and what are the errors faced while scheduling then how to solve those errors?
1 Answers Dr Reddys, TCS, Thomson Reuters,
can anybody tell me when do use 'running total'...give an example for the usage of running total
What is the use of report studio?
What are all types of prompt?