Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
[Smart View] Switching between sheets of workbook takes too long
Hello Everyone,
We have a client who use Smart View for reporting heavily. They have recently moved from on-premise to PBCS. They were using essbase connection in their on-premise sheets.
On the cloud when they connect their sheets to Smart View and then navigate between multiple sheets, Smart View refreshes the whole sheet again which takes a few seconds and breaks the flow of user experience.
The sheets also have a large number of Excel formulas, which are not the issue because I have tested this behavior with calculation mode of Excel set to manual as well.
Is there a way to prevent Smart View from refreshing the contents of the sheet while switching between tabs? This lag does not occur when the sheet is not connected to PBCS.
Thanks in advance !
Answers
-
What's the office versioN?
-
Office 365 and smart view is 900.
-
i've done more testing. The lag only appears when the workbook is opened and connected to Planning the first time. It gets stuck for a few minutes but after that it operates normally.
-
Do you have external links in the file?
-
There are no external links but a lot of Excel formulas. However the behaviour remains the same even when the calculation mode in excel is set to manual.
-
We have the same issue with 0365 2016, no issues on legacy windows 7 so can't be network or the backend, seems to be whenever we move to a newer version of 0365 semi annual or monthly, recently we had the issue since day 1 on o365 and maanged to finally fix it by removing a 3rd party templates addin, however the issue returned so painful, just stuck, I'll post the details on Monday see if are in the same boat?
-
Our client's issue was solved by issuance of a one time patch by development on the client's pods. It had something to do with how Smart View data is parsed on the server side. This even increased Smart View retrieval performance on adhoc grids.
-
Use office 2010
-
Hi Imran,
Can you send us the details on this, was this something done on the oracle database side in terms of patching or an update to the SmartView add-in?, we're on Windows 10 citrix 0365 tried both semi annual and annual, ram cpu increase has no improvement on the performance the lag and latency is pretty bad when performing an refresh or adhoc in Essbase specifically, overall it gets slower as the day goes on,
-
Hide the sheet POV, and test if it's still happening.
Best Regards,
