EnableMTQViewConstruct

EnableMTQViewConstruct enables multi-threaded query processing when calculating a view to be used as a TurboIntegrator datasource for a single TurboIntegrator process. When MTQQuery=F in the tms1.cfg file, EnableMTQViewConstruct can be called to override this value on a TurboIntegrator process.

This function is valid in TM1® TurboIntegrator processes only.

Syntax

Note: If the value of the MTQ parameter is 1 (or OFF), this functionality is turned off entirely and cannot be overridden.

The value of MTQQuery can be overridden on a single TurboIntegrator process by calling the EnableMTQViewConstruct function.

If MTQQuery=F in the tms1.cfg file on the server where this function is run, EnableMTQViewConstruct can be called to override this value on a single TurboIntegrator process.

You can enable EnableMTQViewConstruct in either the Prolog or Epilog section of a TurboIntegrator process. For efficiency, enable EnableMTQViewConstruct in the first, or very close to the first, statement in the Prolog section of your process.

Example

Use the following TurboIntegrator commands to enable multi-threaded query processing when calculating a view to be used as a TurboIntegrator datasource for a single TurboIntegrator process.

EnableMTQViewConstruct()

See also DisableMTQViewConstruct.

After enabling EnableMTQViewConstruct in a process, it can only be disabled on the last line in the Epilog section. If you attempt to use disable DisableMTQViewConstruct anywhere else in the process, the process will not compile.

If the mode is enabled in one TurboIntegrator process, it remains enabled until explicitly disabled or until the chore completes. This means you can enable the mode in a process and then run a series of TurboIntegrator processes before disabling it.