Basic OlapQueryLog Analysis

Written by Olaf Helper. Posted in SSAS Scripts

SSAS can log query execution information to a relational database. This Transact-SQL script provides a basic query which split the object path data to

server name
database ID
cube ID
measure group ID (!always the ID, not the friendly name!)

Further it calculates the granularity, count of cube dimensions & attributes With the basic query you can analyse query executions, like e.g.

overview query executions + total duration per object path
long / often running queries
execution history
how often hits a query the cache (duration = 0)
daily usage per server
and so on.

Remove the comments of the statement of your interest.