OLAPQueryLog analysis

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.

Itay Braun                Premier Field Engineer - SQL Server                    Microsoft Services - UK

E-Mail: itayb@microsoft.com          Mobile: +44-796-928-9996       Blog: http://sqlblogcasts.com/blogs/thepremiers/

Veni              Vidi              Fixit