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 number
PM78243
Reported component name
TM1 PERSPECTIVE
Reported component ID
5724W49PE
Reported release
952
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-12-02
Closed date
2013-05-13
Last modified date
2013-05-13
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5.2","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
21 September 2021