If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

No in memory aggregates recommended?

Started by jbertrand, 19 Oct 2016 12:49:48 AM

Previous topic - Next topic

jbertrand

Hi all. I've designed a cube for a client, and previously I had a whole bunch of in memory aggregates recommended. They've now upgraded to 11.0.4.0, and DQA is coming back with "no in memory aggregates recommended". I'm not sure if it's because of the changes in the SSO config etc., but it just seems strange. DQA authenticates to the server, and runs through the procedure (Cube Structure and Workload selected), and I can see a number of SQL statements executed on the warehouse. Then it ends with no recommendations.

Granted, the fact table is quite small, around 2.2 million rows, but I would have thought there would be at least 1 aggregate up to a Week/Month level grain?

Does anyone know of an easy way to troubleshoot this?

Thanks in advance!