Hi,

I'm working on SSAS tabular model 2014. I wanted to capture the usage (user, queries, datetime etc) of tabular model so I tried to setup OlapQueryLog for tabular model similar to Multidimensional model. However it looks like OlapQueryLog does not work on tabular model. Is there any workaround to get the usage report of tabular model (Trace, AMO code or CodePlex)? Please advice.

Thanks,

Suresh.

There's a good comparison of the methods available here - https://jessekraut.wordpress.com/2014/05/15/ssas-tabular-logging-methods/

My auditing was more about user access to models; see which ones were being used/how often rather than capturing query traces for performance so i used a linked server and the DMV views to upsert connection data to a logging table at specific intervals. The client weren't willing to use the astrace service on codeplex so i had to recreate that wheel