PM78243: TM1 ELEMENT DATA ENTRY FORMAT PROBLEM IN EXCEL

APAR status

• Closed as program error.

Error description

• TM1 Element Data Entry format Problem in Excel??Problem
  title?Incorrect DBRW results in Excel when row formatting set to
  to "general" or "number" from non-sliced view.?Problem
  description?In our account dimension we have instances where we
  have a sub-account with the string represented as 95520.962 for
  example. This would roll-up to a consolidation of 95520. From a
  slice, the correct results are displayed, however, if the user
  was to just type accounts into Excel and the formatting is
  general or number, Excel is returning the results of the
  consolidated account against every line. It is
  ignoring?everything after the ".". See attachment for example.
  In the past Excel would throw an error and return *KEY_ERR. We
  are running 9.5.20200.22178.?.?Business impact ( BusImpact )?We
  are going live with a new system in January and this issue
  represents a severe floor which could result in users reporting
  incorrect numbers which is unacceptable. It was only coincidence
  that we found the problem.?.
  

Local fix

• Change format of the data entry cell to "text"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Please upgrade to IBM Cognos TM1 10.1.1 Fix Pack 1           *
  ****************************************************************
  

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

• RA11 PSN

     UP