Cognos improve report performance in model

·         Default aggregation properties

·         Uses properties

·         Joins

·         Limited local

·         Remove loop's

·         Proper determinants

·         Removing non supported function in model

·         Cardinality

·         Try to use cube

·         Make sure all the "Joins" and "Join strategy" are correct.

·         Check for the cardinality.

·         Create summary tables (one of the best approach in increasing the performance)

·         Use Power play cubes as data sources.

·         You can remove loop's at that time you can improve performance at model level

·         use indexes you can improve performance

·         Change the property of query processing to Limited local or database only.