ASExecutionLog ?

Is there a tool for Analysis Services that acts like the RSExecutionLog database for Reporting Services? Basically, I'm looking for out of the box functionality to save off the OlapQueryLog records into a different db similar to what is available for Reporting Services.

have you ever seen this?

http://www.databasejournal.com/features/mssql/article.php/10894_3618581_3
|||

Thanks for the reply. Perhaps the OlapQueryLog is not the ideal place to find the functionality I'm looking for. I'm looking for something similar to what is offered with Reporting Services and the RSExecutionLog database to capture who is hitting the cubes and what their requests are.

|||

There is not exactly the same functionality, but you could probably get similar functionality using a trace. If you are just after recent activity there is the automatic flight recorder trace, but this only has a recent window of activity. If you want more control over what data is captured and how long the data is retained, then you would want to setup your own trace.

Ideally you would not want the hassle or overhead of continuously running the Profiler UI somewhere. I have not explored the options with unattended traces to be sure what is possible here. Judging by the output of a DISCOVER_TRACES call it should be possible to get SSAS to dump to a file which you could read in later with SSIS. You might need to use XMLA or AMO to create these traces, I could not see a way to do it from Profiler. I don't think you can get SSAS to dump directly to a SQL table directly, you would need to write an application to listen for the trace events and then write them out if you needed this type of functionality. With AMO, it's not too hard to write your own trace listener.