The SAS Output Delivery System and reporting techniques

BI Cube Update

Reply
N/A
Posts: 0

BI Cube Update

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
SAS Employee
Posts: 160

Re: BI Cube Update

Have a look at this paper "How to Update Cubes on an Active SAS® OLAP Server" http://support.sas.com/techsup/technote/ts712.pdf
Ask a Question
Discussion stats
  • 1 reply
  • 139 views
  • 0 likes
  • 2 in conversation