Expanding Planning/Essbase node takes 3-5 minutes and then error "Server was unable to process request" is displayed
Verify that the Calc Manager service is not HUNG and/or Running. The service can consume CPU/Memory, so ensure your Java Heap Size Min/Max is properly setup in your windows registry for Calc Manager
Wednesday, September 19, 2018
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:
- 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 - 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
- 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.
Subscribe to:
Posts (Atom)