how can we improve performance of the reports?
Answers were Sorted based on User's Feedback
Answer / thakkalapelly anil
TO improve the performence of the report move all the
calculations and filters from report level to the frame
work manager.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / prasad
1. Check the Governor Settings.
2. Dont use the Not in function in the query.
3. Check the client/server balancing.
4. Avoid using complex calculations
5. Check the table qualifying and weighting.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / karti
avoid complex report
check filter condition,use less filter
avoid unwanted calculation
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shree uday
Follow this Steps
1. Dont use the Not in function in the query.
2. Check the Governor Settings.
3. Check the table qualifying and weighting.
4. Check the client/server balancing.
5. Avoid using complex calculations
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / arkchowdary
To set Governer Settings we can improve the performance.
Ex: Quesry Execution limit.
Avoid using complex calculations
Check the table qualifying and weighting.
| Is This Answer Correct ? | 0 Yes | 0 No |
how u provide security to reports??how u provide security to packages ?
where we use page break and page set. with example?
Hi,Can anyone tell me training centre for cognos in Mumbai?
advantages of cascade prompt ???
what was the actual purpose of portfolio in cognos ?
Can you explain dynamic query mode?
in u r data u having duplicates how to fetch the latest data in our report?
what is exact catalog size?
what is cognos architechure
How to configure the Cognos configurations to work in the Windows 2000 Server machine?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?