Smartview settings for Citrix environment – Performance issues

There are no specific recommendations for Citrix. The usual support process when it comes to issues encountered in Citrix environments is to reproduce the issue outside of Citrix:

If reproducible, then it is Smart View related issue
If not reproducible, then it is Citrix related issue.
The following tuning parameters improve Smartview communication wih Hyperion Planning server when using webforms:

Add the following registry settings on the client machine where Smartview is deployed:
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]
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/Mising, Zero
In Excel -> Tools -> Save tab, disable the ‘Save Autorecover info every’ which can have a negative impact on large queries that take time to render.
The most efficient performance will result from small, focused queries on a specific subset of data. Zooming in on extremely large dimensions will cause slow performance. If you absolutely must zoom in on larger dimensions, suppressing rows that have no data or zero data will help. Also it is important to make sure that the JVM heap size allocated to the Planning server is enough (parameters -Xmx and -Xms).



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s