IBM Support

PI35814: EXCEL FUNCTION IS NOT CORRECTLY PROCESSED IN TM1WEB AFTER 10.2.2 FP2 UPGRADE

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

  • We have a websheet that uses the following function to perform
    some basic error checking for data being entered.
    
    =IF(AND(LEN($C$13)>1,LEN(K20)>0,K$5=1),IF($Z20<1,DBS(VALUE(K20),
    SERVER&":"&CUBE,SCENARIO,K$16,$A$12,$D20,$F20,$E20,$J20,$G20,$H2
    0,$I20,MEASURE),0),0)
    
    These functions all worked correctly in TM1 Perspectives 10.2.2
    FP2 and TM1Web 10.2 FP2. However, after upgrading to 10.2.2 FP2
    some of these functions have begun to fail to produce any result
    in TM1Web. A series of these functions of the first row of the
    data area still work, but all other rows produce no result.
    
    We have reproduced this with TM1Web build 10.2.20204.176
    
    The TM1 model is Amazons Prod_Reporting which is very large. We
    have this TM1 model running on sottcsbeast.canlab.ibm.com. The
    Websheet is in an application folder named Stuart.
    
    I've also attached some screenshots that explain how data is
    entered into this Websheet for testing.
    

Local fix

  • No. However we can still use this Websheet in Perspectives and
    have suggested working around the problem by temporarily
    removing the error checking logic.
    

Problem summary

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

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI35814

  • Reported component name

    TM1 WEB

  • Reported component ID

    5724W49WB

  • Reported release

    A22

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-02-25

  • Closed date

    2015-04-24

  • Last modified date

    2015-04-24

  • 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.2

Reference #: PI35814

Modified date: 24 April 2015