Welcome to Part 2 in our Smart View Troubleshooting Series. Click here for Part 1 if you missed it!
A client was using Smart View 184.108.40.206.400 and imported a financial report into Excel via Smart View. The import settings were as shown in the screen below, and the import succeeded without issue.
The report populated, fully formatted, into Excel. After updating Essbase data, she wanted to refresh the report to see the impact of changes.
SmartView’s refresh function should normally refresh the selected rows and columns, but in this instance we would inconsistently receive the message: “No pages updated” when trying to refresh the financial report.
Even when no changes have occurred, the expected behavior after selecting a Smart View report refresh is “Number of pages updated: #”
The culprit in this instance was a data retrieve timeout causing the FR refresh to fail. We determined this by utilizing Smart View’s built-in diagnostics tools. We explore these tools in more detail in: Smart View Troubleshooting Pt. 3 – Diagnostics and Profiling.
For now, let’s move forward with the issue at hand. Our goal is to refresh a previously imported Hyperion Financial report via Smart View. The issue is that the report’s data request is timing out and needs to be extended. The resolution in this case is identical to the solution posted previously, but let’s walk through the fix again:
- Click Here to download a REG registry file to the user’s PC. This file contains the following registry settings to install onto the user’s PC[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]
- Run the ‘Smart View Timeout Settings.reg’ file
- Click Run in the ‘Open File – Security Warning’ dialog box
- Click Yes in the ‘User Account Control’ dialog box
- Click Yes in the ‘Registry Editor’ dialog box
- Click OK
The settings are a one-time step on the PC and will take effect for the user immediately. We recommend to distribute these instructions to all new users as a part of an administrative check list.
Having other Smart View issues? Check out the rest of our Smart View Troubleshooting series, or let us know your troubles in the comments!