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 migrate reports to cognos 8 from previous versions
What is defined as Cognos Impromptu?
What is slowely changing dimensions?why we are used SCD?
What are the types of catalogs in cognos?
What is the difference between the content store and content manager?
How to pass multiple values from picklist prompt to sub report filter?
write the sql query to display 5th and 10th row in a table?
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
How security is concerned with Reportnet? Explain its implementing steps.
I have to apply drill through 1,2,7 out of 10 in order method, how can i do?
i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....
Is there any comparison available for Cognos Reportnet Vs Crystal reports?