What is Aggregate Advisor in Cognos?

Aggregate advisor in Cognos is used for analyses the dynamic cubes and after implementation enhances the performance of the cubes. It can also run the pre-existing reports and suggest aggregates that directly correspond to these reports. Aggregate advisor creates in-memory recommendations to be fit within the limited size for the in-database recommendations. Aggregate advisor in Cognos makes two types of recommendations. They are:

• In Memory Recommendations: They are aggregate recommendations that can be implemented by the Cognos Business Intelligence server during the cube is created. It is deposited in the content store.
• In Database Recommendations: This type of recommendation is automatically implemented in the model and database.