Dynamic Cubes: Aggregate Cube not being used

[andy_mason_84]

Hi All,

So we have built a aggregate table in our DB and built an aggregate cube as part of our Dynamic Cube model.

The model validates with no issues.  Just one warning regarding filters which is fine.

The cube publishes fine and the workload log in QueryService says it restarted successfully.

However when I then interact with the cube and use the dimensions and measures that are in the Agg cube it still goes to the fact table and ignores the Agg Cube all together.

Any ideas why it would do this or what would stop it using the Agg Cube?

Cheers,

AM