How to Improve the Performance of the Report? i need this
urgently .
Answers were Sorted based on User's Feedback
Answer / kumar
1. check the governor settings.
2.Avoid using 'NOT' function in the query
3.Avoid using more no:of filters, complex calculations and
complex reports.
4.Move all the calculations and filter conditions from
report level to FM level.
5.Check the client server balancing
6. check the table qualifying and weighting
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / venkat m
turn of automatic summaraize and group for tabular model
processing database it is more faster than limited local process
write simple case statemants
set sorting a field either at the tabular model level or
query level but not both
use cognos functions equivalent functions in database
use facts in the report directly donot create shortcurts for
facts under query
use page breaks instead of sectioned
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / arkchowdary
-----------Improve the performance of the Report-----------
By GovernerSettings we will improve the performance.
By reducing the filters and by reducing the joins.
making the report more simple can improve the performance
of the report
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / g
By reducing the filters and by reducing the joins.
making the report more simple can improve the performance
of the report
| Is This Answer Correct ? | 2 Yes | 2 No |
What are the methods by which it non-durable model could be changed into the durable model?
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
Whrer u can save the Report net documentation in our local system?
where we use page break and page set. with example?
3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?
1 Answers IBM, Thomson Reuters,
what is difference btw summary filter and detail filter, plz explain with example
10 Answers IBM, TCS,
What are all the components of Report Studio?
-----------With out using DrillThrough how to do Reports?
----------0Diff b/w Report Functions and Database functions?
what are the joins present in reportnet?which is most widely used?
4 Answers Covansys, IBM, Satyam,
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
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,