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
(4)
3,194 times
Add to favorites
Databases
9/21/2011
E-mail Twitter del.icio.us Digg Facebook