Product Documentation
Abstract
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.
Content
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:
DisableMTQViewConstruct( );
This function must appear in the Prolog procedure, it has no effect in any other procedure within a process.
[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Turbo Integrator","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF010","label":"HP-UX"}],"Version":"10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27048366