Tips to improve Cognos Report Studio reports Performance

Tips - may help improve report performance

Improving Cognos Report performance is always a challenge. Here are a few items that will allow you accomplish the task:

• Change the order in which items are queried from the database.
• Create sections without creating master detail relationships. Share queries between lists and repeaters.
• Review SQL generated by report and queries.
• Avoid using functions with limited support, as indicated by the quality of service indicators.
• Use Select & Search prompts instead of value prompts if your list of prompts is long. 
• Provide your own prompt values in a prompt to avoid accessing the database. 
• Suppress null cells using filters. 
• Set page breaks without creating master detail relationships. 
• Do not put filters on non-identifiers.
• Use database functions when possible.
• Use fixed width objects in PDF reports by setting their Size & Overflow properties.

Thank for reading... let me know if you nee additional information on any of these.

:)