You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Smartview slow to get to "Multiple Grid" option

edited Aug 2, 2018 2:36AM in Essbase 5 comments

Summary

Smartview slow to get to "Multiple Grid" option

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!