Interested to Buy Any Domain ? << Click Here >> for more details...
how can we improve performance of the reports?
- 6 Answers
- 10850 Views
- I also Faced
- E-Mail Answers
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 |
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What is Render Variable? where u can use?
Hi Experts, Can a single package be shared by multiple users?
Explain informatica architecture?
What are the roles defined by cognos platform?
what is the difference between list sequel and cross tab sequel?
where we use page break and page set. with example?
What is conditional Formatting?
Where do you edit cognos sql in report studio?
How can we find out cardinality between two tables?
Explain what is the difference between native sql and cognos sql?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
Teradata 
