Monday, November 04, 2013

TM1 CFG File - ViewConsolidationOptimizationMethod

I see a lot of client's cfg file and its amazing how many of them are out of date or contain the wrong settings for the version of TM1 they are on.
One of the parameters that I always suggest adding in is ViewConsolidationOptimizationMethod=TREE
The reason why is because of the documentation you can find here: http://pic.dhe.ibm.com/infocenter/ctm1/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_inst.10.1.0.doc%2Fc_viewconsolidation_optimizationmethod_1.html&path%3D0_1_21_2_93

Specifically its says "This setting provides the best performance in normal operations"