PM55660: PERFORMANCE WHEN RUNNING AGGREGATE FUNCTIONS AGAINST TM1

APAR status

• Closed as program error.

Error description

• When having a large sparse cube and running an aggregate/total
  etc. function in a nested crosstab performance decreases
  dramatically. This can even lead to TM1 not responding and the
  need to restart the TM1 server.  Without having the aggregation
  in the crosstab the report runs in a few seconds. With the
  aggregation set it takes more than half an hour or even failes
  with an exception on TM1.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos TM1 9.5.2 Fix Pack 3                   *
  *                                                              *
  * Configuration Instructions:                                  *
  *                                                              *
  * Add the following switches to tm1s.cfg:                      *
  * CognosMDX.AggregateByAncestorRef=true                        *
  * CognosMDX.PrefilterWithPXJ=true                              *
  * CognosMDX.UseProviderCrossJoinThreshold=1000                 *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG8 BI REPORT

• Fixed component ID

  5724W12RS

Applicable component levels

• RA10 PSN

     UP