How to Improve the Performance of the Report? i need this
urgently .
- 4 Answers
- 10784 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 |
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
wat is called Model dimension?
Define dimensions?
if there are list,crosstab,chart how can you apply a single filter to all object?
How to hide/unhide the prompts which are not used by unauthorized users?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
How to do Performence Tunning in Cognos Reports?
What is Cognos Powerhouse and what is it used for?
how to create cubes in transformer ?
Can you define snapshot?
Cleared COG-112 with 100% score today. What next certification should i go for?
Teradata 
