SSAS DMV: Join using DataSet
In SSAS 2008 we have Dynamic Management View (DMV), which is basically XMLA discover command, wrapped as data mining select statement (DMX). On SSMS, if we connect to an SSAS instance, right click on the server name, New Query, DMX, type “select * from $system.discover_connections”, and click Execute, we will see a list of users currently connecting to that server.
The output is like this: (I only pick 1 row and transpose it so we can see the column names clearly)
Tags: dmv