IBM Support

PI22464: TM1 10.2.2: EXCEL SHEET DOES NOT WORK IN TM1WEB

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 made a migration from TM1 10.1.1 to 10.2.2.   Customer
    made a migration from TM1 10.1.1 to 10.2.2.   As a part of this
    customer are converting websheets from xls (Microsoft Excel
    2003) to xlsx (Microsoft Excel 2010) using the built in
    conversion tool in Perspectives.  In one of our websheets
    customer have an issue with a TI process that adds an element
    (line number) to a dimension.   Running the process works in
    10.1.1 with the new element being added to the dimension
    resulting in a new line being shown in the websheet, both in TM1
    Web and the Contributor client.  In 10.2.2 the dimension is
    updated and a new line is added in the websheet, but the line
    number is not shown. It works in Excel 2010, but not in TM1 Web
    and TM1 Contributor.  The first element in the dimension is
    hidden in the websheet and unhiding it resolves the problem.
    However, in the way the websheets are designed, this solution is
    not optimal as the appearance will be changed.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to TM1 10.2 RP2 FP2                                  *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI22464

  • 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-07-22

  • Closed date

    2014-12-19

  • Last modified date

    2014-12-19

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

Modified date: 19 December 2014