How to see how many people are accessing a ssas cube?

Question

I wanted to know how many people are accessing a particular ssas cube. Please let me know the process to find them.

Answer 1

I don't think there's a simple way to get connected users from a cube. You can use a couple of different tools to collect that information (along with lot's of other information as well).

To get a list for users currently connected to a SSAS instance, you might use SQL Server Profiler. Then you can filter one cube from the resulting data.

For tracking users extended period of time, you can use Extended events

Both of these tools create data for a lot of data and you'll need to parse distinct users from that is some way.

Answer 2

To see the current sessions:

SELECT * FROM $System.DISCOVER_SESSIONS