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.

3,063 times
Add to favorites
E-mail Twitter Digg Facebook