We are running Essbase version 188.8.131.52 and Smartview 184.108.40.206 (Build 122).
I have some users that would like to load some data via Excel into an ASO cube. I am aware this would be slower than using BSO.
I have tried both HSSETVALUE and the ad-hoc with submit data and I get an error 'You do not have sufficient access to perform a lock on this database'.
I am pretty sure this is because of the 'lock and send' nature of submit data and the fact you can't lock a block on ASO because no blocks exist.
I have read something about the 'classic add-in' having the option of not locking before sending. What is this? I actually don't think I have it. I have Excel 2010 and everything is consolidated under one ribbon I think from memory.
What are my options? The cube is big and an ASO for a reason, there's a large number of big dimensions. I could change the Excel sheets to load to SQL Server and run via a rules file. But I would rather load from Excel.