IBM Support

PK91208: COALESCE STATEMENT IGNORED IN QUERY SUBJECT THAT PULLS DATA FROM TWO DATA SOURCES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When a coalesce statment is used in a query subject that pulls
    data from an outer join between tables in seperate data sources,
    the first value is shown even when it should be substituted for
    the second value in the coalesce statement.
    

Local fix

  • use an if/then statement instead
    

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

    PK91208

  • Reported component name

    COG BI FRAMEWK

  • Reported component ID

    5724W12FM

  • Reported release

    840

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-13

  • 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":"SSCHNWR","label":"Framework and Map Manager v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"840","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013