Apply Aggregate Advisor results to a different server

Aggregate Advisor results are stored on the IBM® Cognos® Analytics server where they were generated.

The results are stored in the folder <BI_server_installation_location>/logs/XQE/ROLAPCubes/<cube_name>/advisor/recommendations

To apply in-memory aggregate recommendations to a different server you can either create a deployment that contains the model, including in-memory aggregate definitions, and deploy it to the new server or you can use Cognos Dynamic Query Analyzer.

To use Cognos Dynamic Query Analyzer, copy the results .xml file to the equivalent folder on the destination server. You can then connect Cognos Dynamic Query Analyzer to the new server and apply the results.