Improve performance for TM1 data
If you experience unacceptable performance when you work with Cognos® data, the administrator of the TM1®
system might be able to change cube or system settings to improve performance.
To help
the TM1 administrator evaluate the performance issue, provide
the administrator with the details of the data you are using and a description of actions that
result in unacceptable performance.
The following are examples of TM1 settings that affect performance.
- VMM (}CubeProperties)
- For each cube, this property determines the amount of RAM reserved on the server for the storage of stargate views. The more memory made available for stargate views, the better performance will be. Sufficient memory must be available for the TM1 server to load all cubes.
- VMT (}CubeProperties)
- If the time required to calculate a cube view surpasses the specified threshold, TM1 attempts to store a stargate view. If there is not enough memory available to store the stargate view, TM1 purges the oldest stargate view that is not currently in use, and continues to purge views in this manner until sufficient memory is made available.
The IBM® Cognos TM1 Operation documentation includes more information about the CubeProperties and other tuning options.