Interested to Buy Any Domain ? << Click Here >> for more details...
How to Improve the Performance of the Report? i need this
urgently .
- 4 Answers
- 11597 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 |
Name the types of gateway?
Whrer u can save the Report net documentation in our local system?
Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......
difference between stored procedure and function?
advantages of cascade prompt ???
What are various types of gateways in cognos?
What is cognos powerhouse?
What are the batches and it’s details?
Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith
what is the difference between group span and level span
What is the information present in the cognos configuration file?
What are initial page components of Cognos connection?
Teradata 
