Interested to Buy Any Domain ? << Click Here >> for more details...
How to Improve the Performance of the Report? i need this
urgently .
- 4 Answers
- 11697 Views
- HSBC, I also Faced
- E-Mail Answers
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 |
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What do you mean by drill across?
What is the size of database for you project?
Can i apply drill through on master detail relationship report?
HI,can one suggest best institute for cognos Training in Hyderabad
What is the difference between ‘macro’ and ‘prompt?
hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...
Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya
difference between imprompt and reportnwt1.1
what use of surgate key in project
What is catalog and types of catalogs in cagonos and which is better?
why u need to publish the package?
Teradata 
