As of TM1 10.2.2 Fix Pack 6 (FP6), multi-threaded query (MTQ) is used by default to execute a view extract that is the data source for a TurboIntegrator process.
In previous versions of TM1, you had to execute a ViewConstruct in TurboIntegrator (sometimes in an entirely separate process) to take advantage of MTQ when a cube view was the TurboIntegrator data source.
As of TM1 10.2.2 FP6, this is no longer the case. By default, MTQ is used directly on the execution of a cube view data source, provided the following conditions are met:
- The MTQ parameter must be enabled in Tm1s.cfg and set to a value of 2 or greater. By default, this parameter is not enabled in the Tm1s.cfg file for TM1 10.2.2 FP6 For details on the MTQ parameter, see http://www.ibm.com/support/knowledgecenter/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_inst.10.2.2.3.doc/c_tm1_inst_mtq.html.
- When defining the view extract for the TurboIntegrator data source, the Skip Consolidated Values option must be disabled and the Skip Zero/Blank Values must be enabled.
If you do not want to use MTQ when executing a view data source, you can disable MTQ in the TurboIntegrator process by adding the following function to the Prolog of the process:
This function must appear in the Prolog procedure, it has no effect in any other procedure within a process.
17 June 2018