We have created an offline cube on a network drive from SSAS 2008 and users are able to successfully access this serially using the Excel 2003 cube add-in or Excel 2007, in concert with version 10 driver, but when a user is already connected, the second
attempt to connect will get the message :
Connection to <filename> server, <dbname> database, <cubename> cube failed. OLAP Server error: The following system error occurred: The process cannot access the file because it is being used by another process. ., File system
error: An error occurred while opening the '<filename>' local cube file.
This is regardless of whether users connect specifying read-only and we have found it impossible to connect to a cube if the file has the read-only attribute set.
Is there any way to solve this without users taking copies onto their workstations?
View Complete Post