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?
Problem:
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.
Credit:
Resources:
Connection String Properties (Analysis Services)
Reblogged this on Sutoprise Avenue, A SutoCom Source.