1

Topic: SSAS 2008R2 Olap audit

Colleagues, help to understand. Is olap a cube on SSAS 2008R2 and it is necessary to understand what user when and as long a cube used also what data selected.
Access is given through AD, and Olap client Excel 2013.

2

Re: SSAS 2008R2 Olap audit

We use Extended Events. Here so created session:

<Create xmlns = "http://schemas.microsoft.com/analysisservices/2003/engine">
<ObjectDefinition>
<Trace>
<AutoRestart> true </AutoRestart>
<ID> MDXLog </ID>
<Name> MDXLog </Name>
<XEvent xmlns = "http://schemas.microsoft.com/analysisservices/2011/engine/300/300">
<event_session name = "MDXLog" dispatchLatency = "0" maxEventSize = "0" maxMemory = "4" memoryPartition = "none" eventRetentionMode = "AllowSingleEventLoss" trackCausality = "true" xmlns = "http://schemas.microsoft.com/analysisservices/2003/engine">
<event package = "AS" name = "QueryEnd"/>
<target package = "package0" name = "event_file">
<parameter name = "filename" value = "D:\MSSQL_DATA\MSAS13.MSSQLSERVER\OLAP\Log\MDXLog.xel"/>
<parameter name = "max_file_size" value = "3"/>
<parameter name = "max_rollover_files" value = "1000"/>
</target>
</event_session>
</XEvent>
</Trace>
</ObjectDefinition>
</Create>

Further files are periodically read, the information is saved in basis.

3

Re: SSAS 2008R2 Olap audit

ondorsal;
In properties  servers adjust  in the DB table, and then it analyze

4

Re: SSAS 2008R2 Olap audit

StarikNavy;
I  how it to make?
I am connected to Analysis Services there are Services-parameters, but there is nothing about . Can not there I search?

5

Re: SSAS 2008R2 Olap audit

ondorsal;
http://prntscr.com/gr4z1h

6

Re: SSAS 2008R2 Olap audit

on titles of properties, there are descriptions