We can learn a lot about cube usage and actual aggregation usage from the OLAPQueryLog table. I attached here my demo from Tech Ready 6. In the attached file you can find a Word document which guides you what to do, T-SQL Scripts and SSRS reports. More details in a proper post when I'll be back from Seattle. Please let me know if you found a bug. Thanks, Itay Braun Premier Field Engineer - SQL Server Microsoft Services - UK E-Mail: itayb@microsoft.com Mobile: +44-796-928-9996 Blog: http://sqlblogcasts...