PM34120: CELL REFERENCES USED IN SUBNM FUNCTIONS IN TM1 WORKSHEETS STOP WORKING

APAR status

• Closed as program error.

Error description

• This is a regression issue.??Functionality affected is only in
  Excel/Perspectives.??This problem does NOT occur with TM1Web
  Websheets.????In 9.4.1 FP1, the following item was listed as
  fixed:??TM-6292 ??If a TM1 SUBNM function uses formulas or cell
  references in any of its parameters, the value evaluates
  properly, but when double-clicked it will not open the subset
  editor.????The problem has re-emerged in 9.4.1 FP3 as well as
  9.5.1.????In addition, the documentation (TM1 Reference  Guide >
  TM1 Worksheet Functions > Worksheet Function Overview >
  SUBNM)for both versions still includes the following
  note:??Note: Do not use cell references as arguments with the
  SUBNM function. Cell references prevent the function from
  correctly calling and launching the Subset Editor when you
  double-click the cell that contains the SUBNM
  function.??Documentation will also be updated appropriately once
  the defects have been resolved.????
  

Local fix

• If this functionality is required in Perspectives, then abide by
   what is stated in the documentation (included below) until this
   issue has been fixed.
  ("Note: Do not use cell references as arguments with the SUBNM f
  unction. Cell references prevent the function from correctly cal
  ling and launching the Subset Editor when you double-click the c
  ell that contains the SUBNM function.
  Documentation will also be updated appropriately once the defect
  s have been resolved.")
  

Problem summary

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

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• 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 PERSPECTIVE

• Fixed component ID

  5724W49PE

Applicable component levels

• RA10 PSN

     UP