Optimize CubeView performance in Excel
I have Cubeview which takes ~50 secs to refresh in OS.
When I insert same Cubeview in excel and refresh in excel (OS Excel-Addin); it takes over 2 mins.
It is simple insert and refresh i.e. I do ...
Forum Discussion
I have a smilar issue. Changing these settings does not reduce the time to refresh the workbook. Also if I populate lots of cells (ca. > 100) in the CV in Excel it takes very long that the cells get yellow (indicating that data is not in DB). When I hit submitt Excel crashes. So I think the Addin is not made for massdata submission or lager CubeViews.