Slow performance when running Trial Balance with Drilldown in 10.1

Technote (troubleshooting)


Problem(Abstract)

Running a Trial Balance report in Controller 10.1 takes much longer than when using Controller 8.

Symptom

For example, in one real-life example:

  • Controller 8.x - Report takes approximately 3 seconds
  • Controller 10.1 - takes about 12 seconds.


Cause

There are several possible causes for slow TBWD performance.

  • For more examples see separate IBM Technote #1619672.

This IBM Technote specifically relates to the scenario where the cause is a code production problem ( APAR PM61165) in Controller 10.1.

Resolving the problem

Upgrade to Controller 10.1.1 (10.1.1305) or later.

  • Alternatively, if using Controller 10.1.395 or earlier, it is possible to instead upgrade to Controller 10.1.397 or later)


For example, in one test environment, it was found that the code fix improved the report time from approximately 50 seconds to 10-15 seconds.

Related information

APAR PM61165 - TRIAL BALANCE WITH DRILLDOWN SLOWER IN 1
1597310 - Cognos Controller 10.1.1 now available for do
1619672 - ** Troubleshooting ** Slow performance when u

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Controller
Controller

Software version:

10.1

Operating system(s):

Windows

Reference #:

1589186

Modified date:

2012-12-06

Translate my page

Machine Translation

Content navigation