My Excel 2010 reports are using CubeValue formulas (each report has from few hundreds to tens of thousands of CubeValue formulas; data are pulled from SSAS 2008). Reports worked
fine untli recently when I start observing huge variability in the performance. A workbook refresh could vary from 15 seconds to 10 minutes.
Issue is obviously not caused by server performance, but rather by network latency: Laptop connected thru WIFI refreshes way slower than the same laptop connected by vire (Also
different machienes are performing very differently while connected thru the same network).
The problem could be probably solved by sending all the MDX queries generated by CubeValue formulas as one batch, but I can't found any settings in the Excel that would enable this
Did anyone encounter similar problem? Could you please advise me o
View Complete Post