Unanswered: How to do a bulk update of the cells in a cellset
I'm running Analysis Server and accessing the cubes via Excel VB script using ADO and MDX. The cubes are on the server while Excel is being executed on a client PC.
I have extracted a cellset from the cube (which is enabled for writeback) via MDX query in the VB script. Now I want to writeback (or initialize) the value of all the cells in the cellset to 0 from the VB scipt. There are about 2500 cells in the cellset. What is the most efficient way to do this writeback so that it will not require large bandwidth between the client PC and the server. The client PC has only a dial up connection to the server.