PM43794: INCONSISTENT UPDATE-BEHAVIOUR OF DBRW-FORMULAS

APAR status

• Closed as program error.

Error description

• If you have an Excel-slice with DBRW-formulas and you perform
  some update-actions on this sheet (like F9 or F2 or in VBA
  ActiveSheet.Calculate) and some row-elements for the
  DBRW-formula are wrong (not existing in the dimension or an
  empty cell  in Excel) you receive a different output in the
  Excel-cell where the DBRW-formula is available ? looks like
  inconsistent results.??Using F9 you receive *KEY_ERR, using F2
  you receive #NA if the row-element has a wrong (not existing)
  element-name, using F2 you receive *KEY_ERR if the row-element
  is empty as element-name and using ActiveSheet.calculate in VBA
  you receive mixed results with *KEY_ERR and #NA as
  well.????Further question: the customer has a lot of
  compare-checks for string-value is *KEY_ERR ? how can the
  customer check #NA in the cell or what should he do ?????Hint:
  ??Using these functions with the TM1 8.4.3-Client or 9.0-Client
  all delivers the same consistent result *KEY_ERR in the
  concerned Excel-rows (cells)??
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos TM1 9.5.1 FP1 or Upgrade to IBM Cognos *
  * TM1 9.5.2 FP1 or 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

• R951 PSN

     UP