IBM Support

PM11724: DUPLICATE SERIES GENERATED ON A CHART IN EXCEL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you have two queries, A & B and the chart is based on a third
    query C which is a query based on a full outer join between A &
    B. When the report is ran in HTML the chart series display
    correctly. But when the report is ran in Excel 2002 or 2007, the
    chart displays multiple duplicate series. This is happening when
    the outer join displays missing rows from either of the queries.
    If both the
    queries have the same categories used in the join, the chart
    runs fine.
    Otherwise, the chart series get duplicated based on the query
    that has
    the extra categories due to the outer join.
    
    Note: This issue has also been tested in 8.4.1 and it exists
    there as well.
    

Local fix

Problem summary

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

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM11724

  • Reported component name

    COG8 BI REPORT

  • Reported component ID

    5724W12RS

  • Reported release

    840

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-04-07

  • Closed date

    2011-09-13

  • Last modified date

    2011-09-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

    COG8 BI REPORT

  • Fixed component ID

    5724W12RS

Applicable component levels

  • RA11 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":"840","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
13 September 2011