Smart View Performance with Hyperion Planning Applications

Below are some of the the tuning parameters to improve Smartview communication with Hyperion Planning, when using Webforms:

1. Add the following Windows registry settings on the client machine where Smartview is deployed:
   [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings] 
   "ReceiveTimeout"=dword:001b7740
   "KeepAliveTimeout"=dword:001b7740
   "ServerInfoTimeout"=dword:001b7740
2. Change Smartview Options to improve performance on large retrievals:
   • in Formatting: Select the option to Use Excel Formatting. Without this option, Smart View will reformat each cell based on the grid operations you perform. It will also mark cells as “dirty” each time you change data values. These activities add system overhead to all Refreshes, making them take longer.
   • in Advance -> Compatibility: Select the option Improve Metadata Storage
   • In Data Options: Select Suppress No Data/Missing, Zero
3. In Excel -> Tools -> Save tab, disable the 'Save Auto-recover info every' which can have a negative impact on large queries that take time to render.