How to stop or cancel your SSAS cube processing
It’s quite easy to do this operation.
First you need to find the following Id’s : SPID, ConnectionID and Session ID. You can get this by using the following DWV’s:
This will return all active connections to a particular SSAS Instance Database, along with useful information such as the ConnectionID as well as user, time and data based statistics
This DMV will return all active sessions on a particular SSAS database, this DMV can be linked to the connections DMV using the SESSION_CONNECTION_ID column.
<ConnectionID>insert the connection id</ConnectionID>
<SessionID>insert the session id</SessionID>
<SPID>insert the spid</SPID>