Take the 2-minute tour ×  There is a problem when several users
can process the same cube simultaniously and as a result
processing of cube fails. So I need to check if certain cube is
processing at current moment.  share|improve this question add
comment  3 Answers  I dont think you can prevent a cube from
being processed if someone else is already processing it. What
you can do to "help" is run a MDX query to check the last time
the cube was processed:   or check the sys.process table on the
realted sql server instance to see if it is running:  select
spid, ecid, blocked, cmd, loginame, db_name(dbid) Db,
nt_username, net_library, hostname, physical_io,
login_time, last_batch, cpu, status, open_tran, program_name
from master.dbo.sysprocesses where spid > 50   and loginame <>
'sa'   and program_name like '%Analysis%' order by physical_io
desc share|improve this answer Diego, thank you for your answer!
–  Alekzander Aug 10 '12 at 11:49 no problem, rememebr to vote
ans mark as answer if it helped you – 