Interested to Buy Any Domain ? << Click Here >> for more details...
How to Improve the Performance of the Report? i need this
urgently .
- 4 Answers
- 11531 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 |
how to connect datamarts
Why cognos scenario is used?
What are all the types of indexes in Cognos?
What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.
How applying "Level Span" in Cognos 8.3?
what are the enhancements in cognos reportnet ?
How do you Parametermap variables in Quiries?
hi my name is siraj i want to know cognos queriy language
how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please
fiscal year means what???
How do we create row level security in cognos8?
wt is tupple , Embed function ? wt is regular dimension ?
Teradata 
