IBM Support

PM97528: CELL PROTECTION LOCKS ALL CELLS ON TM1 10.2 WEBSHEETS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Cell protection locks all cells on TM1 10.2 Websheets. In TM1
    Perspectives 10.2 we can lock specific cells and use the Excel
    protection feature. On the worksheet only the locked cells will
    be protected. However, when we upload the worksheet to TM1Web,
    all cells are protected. TM1Web 10.2 appears to protect all
    cells instead of only protecting the locked cells.??This change
    in behavior will have an obvious impact for anyways who upgrades
    Websheets where Excel cell locking and protection was used for
    security.??The only documentation that I could find regarding
    this topic is this:
    http://pic.dhe.ibm.com/infocenter/ctm1/v10r2m0/index.jsp?topic=%
    2Fcom.ibm.swg.ba.cognos.tm1_ug.10.2.0.doc%2Fc_cell_pwd_protectio
    n_websheets_n43829.html.
    

Local fix

Problem summary

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

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM97528

  • Reported component name

    TM1 SERVER

  • Reported component ID

    5724W49SE

  • Reported release

    A11

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-20

  • Closed date

    2013-12-24

  • Last modified date

    2013-12-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 SERVER

  • Fixed component ID

    5724W49SE

Applicable component levels

  • RA20 PSN

       UP



Document information

More support for: Cognos TM1
TM1 Server

Software version: 10.1.1

Reference #: PM97528

Modified date: 24 December 2013