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 |
we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?
I have to apply drill through 1,2,7 out of 10 in order method, how can i do?
What is the difference between a data mart and a data warehouse?
Which service handles requests for cognos connection,query studio and event studio.
what is sdibling function tell me the some functions
what is dynamic sort?
New coloums are added in database, then how you know in report level
what are the limitations of cognos reportnet?
11 Answers IBM, Nestle, TCS,
What is difference between data mart and data warehouse?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT
----------------What is meant by DSS?