how can we improve performance of the reports?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by the term 'aggregate advisor?'

533


which type of project we r going to snowflake schema

1593


What is the difference between low affinity and high affinity connections?

544


-----------------What is Determination Model?

1680


What are all the components of Report Studio?

651






What is zero-foot print?

582


what are the filters in framework manager and report studio?

574


What is metric store database?

556


What is the advantage of using shortcuts?

634


What is Additive function?

1545


How do you Parametermap variables in Quiries?

1757


What are the other methods working as deployment functionality?

513


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1478


What is the importance of having monitor service in cognos?

572


What errors and types of errors you faced in Cognos ReportNet?

3472