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!