CalculationThresholdForStorage in TM1s.cfg

Post Reply
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

CalculationThresholdForStorage in TM1s.cfg

Post by EvgenyT »

Hi Gents,

Just glancing over tm1s.cfg parameters, I stumbled upon CalculationThresholdForStorage (https://www.ibm.com/support/knowledgece ... _Storage_1) with description of:

"Defines a minimum number of rule calculations required for a single cell or Stargate view, beyond which the IBM® Cognos® TM1® server stores the calculations for use during the current server session....
When a user requests rule-derived values from the Cognos TM1 server, either from a single cell or a Stargate view, the server usually has to perform multiple rule calculations to arrive at the requested rule-derived values"

My interpretation of this parameter is: If parameter set to 10 then once a user request for a particular rule-driven cell hits the threshold, then TM1 engine builds an index that allows to arrive to the result faster by bypassing intermediate calculations?

Please share your thought on this subject

Thanks

ET
Post Reply