Publishing data from Writeback excel sheet get freezes while the cube is processing
I have a writeback excel file which publishes the data back to the database, but while the cube is processing the publish button freezes in the excel file for that period of time approx 6-7 min till cube is processing. It only publishes data after the cube has finished processing. Is there any way or option to reduce the freeze time or completely eliminate this problem so that even during cube processing i can writeback data to the table in the database. Any ideas on this?