There are various types of Auditing in the Microsoft BI stack. There is auditing in SSRS, SharePoint, SSAS and not forgetting SQL has its own auditing.
Today I am looking at the SSAS auditing – you can find out more about it on TechNet.
Olaf Helper has published some TSQL code for querying the audit data -on the Script Center.
But first, we need a table to store the data, here is a TSQL script for creating the table: