Author Topic: No in memory aggregates recommended?  (Read 796 times)

Offline dnewing

  • Full Member
  • ***
  • Join Date: Nov 2013
  • Posts: 21
  • Forum Citizenship: +0/-0
No in memory aggregates recommended?
« on: 19 Oct 2016 12:49:48 am »
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, 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!