Smartview slow to get to "Multiple Grid" option
SummarySmartview slow to get to "Multiple Grid" option
I am testing prior to conversion from Excel 2010/Essbase Excel Add-in to Excel 2013/Smartview on a 64 bit machine. I have a 30,000 row pull that takes about 4 min to Excel 2010/Excel Add-In,
6 minutes with Excel 2010/Smartview (both 32-bit), but on a faster desktop with Excel 2013/Smartview 64-bit it takes up to 20 minutes.
Strange thing is that when using ad-hoc analysis with the Excel 2010/Smartview/32-bit laptop, it takes about 30 seconds to get the pop-up screen that asks "You have a range selected. Would your like to change this sheet to support multiple grids?" option, and on the Excel 2013/Smartview/64-bit desktop it can take up to 10 minutes to get to that selection, then 6 to 10 additional minutes to return the results. Both machines have 8GB of RAM, the 32-bit laptop is Intel i5 2.0GHz, the 64 bit desktop is Intel i3 3.3GHz.