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...