IBM Support

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

Product Documentation


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:

  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
  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":"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"}}]

Document Information

Modified date:
17 June 2018