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 am curious if you have tried opening this using Spreadsheet, and seeing what the refresh time is in there. I believe that's a direct connection to the database and may tell you if it's an issue with the add-in or with the cube view design itself somehow.
Thank you Bob. Great suggestion for troubleshooting. I tired and indeed the refresh time reduces to 1 mins 20 secs (down from 2 mins 20 secs). One step closer...I believe next step is to diagnose what is slowing in excel addin.