IBM Support

PI23785: In TM1 Web 10.2.0.2 selecting a new websheet always triggers a recalculation

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • The customer is running multiple TM1 applications whose frontend
    are websheets displayed by TM1 Web.  The server components (TM1
    Admin Server, TM1 Server, TM1 Web) are running in their data
    center in Germany.  An user's web browser may run anywhere, for
    instance in Argentina, creating a WAN connection about 13.000 Km
    long.  The customer upgraded from TM1 Web 9.5.2 to TM1 Web
    10.2.0.2  Since running TM1 Web 10.2.0.2 they experience a
    disturbing performance pattern they did not see when using TM1
    Web 9.5.2: A user opens two or more websheets in his TM1 Web
    Client.  He jumps to a new websheet: Using the mouse he selects
    a new websheet.  This selection always triggers a recalculation
    of the newly selected websheet which lasts 40 seconds and longer
    despite the fact that he made no changes anywhere: He is just
    jumping from one websheet to the next.  The customer experiences
    this disturbing performance pattern despite setting the two
    known TM1 Web 10.2.0.2 parameters driving recalculation,
    "RecalcOnActivate" and "UseBookRecalcSetting", to "false".  It
    seems that the recalculation time of the newly selected websheet
    depends on two factors: - It grows with the distance between the
    user's web browser and the server components of their TM1
    application located in Germany. - It grows with the websheets
    complexity: The bigger it is, the more TM1 and Excel formulas it
    has the longer the recalculation time.  This performance pattern
    negatively affects the user acceptance of their TM1 Web 10.2.0.2
    driven applications.  From the customer's point of view this
    performance pattern is a defect, especially as TM1 Web 9.5.2 did
    NOT display such a performance pattern.   Thus the customer is
    requesting a patch to get rid of this performance pattern:
    Jumping to a new websheet, using the mouse to select a new
    websheet shall not trigger a recalculation. TM1 Web 10.2.0.2
    shall work as did TM1 Web 9.5.2
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to TM1 10.2.2 FP1                                    *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI23785

  • Reported component name

    TM1 WEB

  • Reported component ID

    5724W49WB

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-08-13

  • Closed date

    2014-10-07

  • Last modified date

    2014-10-07

  • 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

    TM1 WEB

  • Fixed component ID

    5724W49WB

Applicable component levels

  • RA22 PSN

       UP



Document information

More support for: Cognos TM1
TM1 Web

Software version: 10.2

Reference #: PI23785

Modified date: 07 October 2014