IBM Support

PH03975: EXCEL MERGES THE VALUES IN THE REPEATER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • In Cognos 10.2.1 reports, a repeater will dynamically create
    columns based on the max number of items returned by the
    repeater for any row on the report. In Cognos 11, the repeater
    is merging all values returned into a single column. There is no
    way to revert back to the behavior available in Cognos 10.2.1
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    *                                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Analytics 11.1.2                       *
    ****************************************************************
    Configuration Instructions:
    
    Advanced server property
    "RSVP.EXCEL.XLS2007_ALLOW_MERGE_REPEATER_CELLS"
    When set to true, merge repeater cells in excel 2007 into a
    single column since this is the behavior of all other formats.
    When set to false, repeater cells are divided into multiple
    columns. The Excel 2007 output is different than all other
    formats.
    Default: true
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH03975

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    B0A

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-10-11

  • Closed date

    2019-06-05

  • Last modified date

    2019-06-05

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 December 2020