How to Track SSAS cube usage by End-User Tool?


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:

SSAS Cube Connection String Application Nameyou’ll have to modify ALL connection strings used to point to the cube though.

SSAS Cube SSRS Excel usage


Erik Veerman


Connection String Properties (Analysis Services)


0 thoughts on “How to Track SSAS cube usage by End-User Tool?

What do you think? Leave a comment below.