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

Standard

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:

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

Credit:

Erik Veerman

Resources:

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.