IBM Support

TM1 10.2.2 Fix Pack 6 - Using multi-threaded query to execute a view as a TurboIntegrator data source

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:

  1. 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.
  2. 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":"BU002","label":"Business Analytics"},"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":""}]

Document Information

Modified date:
17 June 2018

UID

swg27048366