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 |
-----------Types of Fact Tables?
6 Answers Bank Of America, CTS,
What are all types of Batches?
What are the components of the report studio?
Is it possible to create drill through access to other report from PDF report?
Can you define framework manager?
What is meant by Tabular SQL in Cognos Report net
Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?
What is loop in frameworkmanager ?
What are the types of catalogs in cognos?
1)How to bursting the cross tab report? 2)What is meant by Object explorer? 3)What is cascade report?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..