WebsheetRowThreshold and WebsheetColumnThreshold parameters for websheet scrolling and navigation in TM1 Web 10.2 FP1
IBM® Cognos® TM1® Web 10.2 FP1 includes new parameters designed to improve the overall user experience of scrolling and navigating in a websheet.
Use the WebsheetRowThreshold and WebsheetColumnThreshold parameters to configure the amount of rows and columns in a websheet that completely fetch on loading. If the sheet fits roughly within the number of rows and columns specified with the new parameters, it will be fully loaded on start up.
If a sheet is larger than the values set with the parameters, then Cognos TM1 Web fetches additional data on demand as you scroll beyond the buffers of the previously loaded data.
Note that the time to load a websheet might increase as compared to the Cognos TM1 10.2.0 release. However, once loaded, the program does not need to fetch additional data as you move around in the websheet so overall navigation performance can improve.
To configure these new parameters, edit their values in the Cognos TM1 Web configuration file, tm1web_config.xml, located here:
<TM1 installation directory>\webapps\tm1web\WEB-INF\configuration
Note: When you upgrade to Cognos TM1 10.2 FP1, example entries for these parameters are contained in a new sample configuration file named tm1web_config.xml.new.
<!-- The threshold used to fully load all rows in a Websheet on initial load. -->
<add key="WebsheetRowThreshold" value="150" />
<!-- The threshold used to fully load all columns in a Websheet on initial load. -->
<add key="WebsheetColumnThreshold" value="50" />