BI Cube Update

[deleted_user]

Hi, our team has a series of cubes that we have update on a nightly basis, we've recently been running into errors (error code 1012) during our update cycle (which occurs at 2am), we receive the following error:

ERROR: File is already locked by another user.
ERROR: The physical cube cannot be deleted.
NOTE: The SAS System stopped processing this step because of errors.
ERROR: Cube "HMMKT_ACQ_CMPGNS" exists. You must use the DELETE_PHYSICAL option in PROC OLAP to remove the physical cube before
NOTE: The SAS System stopped processing this step because of errors.

We're essentially deleting the cube then rebuilding it with our new data.
Is there a way for us to somehow determine if our cube is being used before our update kicks off, also, if we can; can we then terminate the connection so we can proceed with our normal update procedure?

Thanks,
Casey

[GertNissen]

Have a look at this paper "How to Update Cubes on an Active SAS® OLAP Server" http://support.sas.com/techsup/technote/ts712.pdf