IBM Support

Cognos TM1 10.2 Multi-threaded Query calculation fix

Flash (Alert)


Abstract

A calculation issue when using multi-threaded query has been identified that may manifest when used with cubes with complex rules.

Content

This issue has been identified in the following versions of TM1 software:

  • Cognos TM1 10.2
  • Cognos TM1 10.2 FP1

The following issue occurs in the Cognos TM1 10.2 server when using Multi-Threaded Query:

  1. Customers who are applying MTQ to models with reasonably complex rules (i.e. to rules that have cross-cube references with recursiveness depth more than 2) could intermittently suffer from incorrect calculations unless they have disabled MTQ application to the single cell consolidation:
    MTQ.SingleCellConsolidation=false

    Workaround: Set MTQ = 0 or 1 or leave this parameter out of the tm1s.cfg altogether. This will turn off the multi-threaded query functionality entirely.

    Alternatively you can leave MTQ = x (x being some number greater than 1) and add the following parameter to your tm1s.cfg file:
    MTQ.SingleCellConsolidation=false
    which will prevent MTQ from being applied in these scenarios where there is the potential for an incorrect result.

    APAR PI08600 has been logged for this issue.

An interim fix which corrects this issue is available for download from Fix Central. All fixes will require Cognos TM1 10.2 FP1 to be installed first.

Customers using either Cognos TM1 10.2 or Cognos TM1 10.2 FP1 are strongly recommended to upgrade to FP1 if they haven’t already and apply the interim fix.

The content of this Alert is based on the best-available information as of the date of its publication. While every attempt has been made to provide guidance on the known issues at the time of publication, the Alert may not describe all of the circumstances under which the issue described above may occur, and may not provide a resolution for every occurrence of the issue. We continue to work to provide a comprehensive solution. All additional information will be documented in subsequent editions of this Alert and posted on the IBM website http:/ibm.com/support.

WARNING: Failure to follow these important instructions may result in the display and storage of incorrect data values. You are responsible for implementing these changes to ensure that your system remains current with this alert. Under no circumstances is IBM or its suppliers responsible for loss of or damage to, your data.

Document information

More support for: Cognos TM1

Software version: 10.2

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1664467

Modified date: 28 February 2014