We have been working on the performance of Smart View in recent months. One of the areas of improvement that has been identified is the communication between the server and the client.
The good news is that all of the main providers (APS, Planning and HFM) have the ability to use GZIP compression when sending data back and forth with the Smart View client. As you can expect, the performance gains can be significant with large queries.
The bad news is that APS and Planning do not turn on this compression by default. You must enable this feature.
In APS, there is a setting in the essbase.properies file which must be set to false:
smartview.webservice.gzip.compression.disable=false
In Planning, a SYSTEM PROPERTY must be set (with the lowest value = 1):
SMARTVIEW_COMPRESSION_THRESHOLD
Experiment with the settings, you might be pleasantly surprised with the results. I know I have been.
