Basic OlapQueryLog Analysis

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.

4 Star
3,628 times
Add to favorites
E-mail Twitter Digg Facebook