Hi,

I got a problem on generating OLAP cube by analytic builder workbook.
the error is show as below:

Error message:
Error 5204 while dropping existing SQL server database.
Cause: There are one or more open connections on the SMDB or Staging
database.
Processing terminated.

I have dropped all related databases manaually, but error still exists.

Another error is :
Error Object variable or with block variable not set
Location:Create_Olap_Dtb/Create_Cube_Real
Analytics Builder processing halted unexpectedlly.

I have no idea on this error.

Anyone can help me to solve these problems?

Thanks in advance

Ongwp