IBM Support

PM43421: DIFFERENT RESULTS OF CALCULATIONS IN INTERACTIVE HTML AND BATCH WHEN USING COALESCE FUNCTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When running a report in interactive HTML, a calculation is
    returning the correct results. When the same report is run as
    PDF, XLS, or in batch the list column of the calculation will be
    empty. ?This is due to a coalesce(<data item>;0) function, which
    is used in the calculation. In interactive HTML a 0 is returned
    for this function. In all other formats this will be pushed to
    the database and a NULL is returned. As the calculation summates
    the result of the coalesce function to a different value, and
    value + NULL = NULL, the empty column is returned.
    

Local fix

  • Make sure to convert the coalesce result into a 0, when it is re
    turning NULL.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
    * Pack 1                                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM43421

  • Reported component name

    COG8 BI REPORT

  • Reported component ID

    5724W12RS

  • Reported release

    841

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-11

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWW","label":"Report Authoring v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"841","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013