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:

Erik Veerman

Resources:

Connection String Properties (Analysis Services)