PM91099: IBM COGNOS 10.2.X DQM LIST REPORT CALCULATION USING ROUND FUNCTION SHOWS INCONSISTENT DECIMAL FORMAT.

APAR status

• Closed as program error.

Error description

• List report column "C" based on calculated Data Item has
  conditional clause which dynamically formats some of the decimal
  values using round
  function:?---------------------------------?case
  [Parameter]?when('a') then(round((19,82+38,18*[Data
  Item]);1))?when('b') then(round(2*(power(10;(-0,17*(5-[Data
  Item]))));1))?...?when('c') then(130)?when('d') then(2,9)?else
  null?end?---------------------------------?So, parameters "a",
  "b" has a round function.??Another column "80% C1" has
  calculation:?---------------------------------?0,8*[C]?---------
  ------------------------??When
  running under DQM, list report column for  "C" and "80% C", some
  of the values have inconsistent decimal formatting showing one
  decimal only, when other have 2:?--- ?          C I        80%
  C?A?  56,1?         44,88? (56,1 *0,8 = 44,88) correct?B
  115,6? 92,5?         (Note: 115,6 * 0,8 = 92,48!)
  incorrect?---??Under CQM same shows as?---?          C I
  80% C?A?  56,1?         44,88?B         115,6? 92,48?---??Found
  in product versions: IBM Cognos 10.2.x 64bit, Informix 11.70
  DQM, but also ?reported in Cognos BI 10.2.1. ?
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.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

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels

• RA21 PSN

     UP