There’s a SSAS cube.
User’s use more than one end-user tool to access the cube.
How do you track the usage by End-User Tool?
By Default the SSAS Trace does not capture all End-User Tools like Excel, SSRS, Third-Party Tools.
So what do you do?
There’s a connection string property called Application Name that you can use to capture this information. Once you set it, the application name property will start showing up in the SSAS Trace:
you’ll have to modify ALL connection strings used to point to the cube though.
Connection String Properties (Analysis Services)
0 thoughts on “How to Track SSAS cube usage by End-User Tool?”
Reblogged this on Sutoprise Avenue, A SutoCom Source.