IBM Support

PI29561: NOT POSSIBLE TO WRITE VALUES INTO TM1WEB SHEET CELL, WHEN EXCEL OPTION "SHOW A ZERO IN CELLS THAT HAVE ZERO VALUE" IS DEACTIVATE

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

  • Customer installed TM1 version 10.2.2 FP1.   After installation
    of FP1 they can not enter numbers into blank cells of a
    websheet, empty cells not showing the numeric zero value. But
    using the TM1 Web Cube Viewer they can enter values into blank
    cells of a cube view.  Using an english web browser, to enter a
    numbers into blank cells of a websheet fails with the english
    error message:  "Stop. A numeric value is required."   Using a
    german web browser, to enter a numbers into blank cells of a
    websheet fails with the german error message:  "Stop.
    Numerischer Wert erforderlich."   It works in TM1 Web version
    10.2.2
    

Local fix

  • Deactivate Excel option "Show a zero in cells that have zero val
    ue".
    

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

    PI29561

  • Reported component name

    TM1 WEB

  • Reported component ID

    5724W49WB

  • Reported release

    A22

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-11-13

  • 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 #: PI29561

Modified date: 24 April 2015