IBM Support

PM63785: Export to Excel 2007 loses data formatting when using multiple measures in PowerPlay Studio

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Formatting symbols like "%" and "$" are lost when exporting to
    Excel 2007 format if more than one measure is used in a
    PowerPlay Studio report.  ??Not all measures need to be
    formatted.??This issue doesn't seem to occur if only one
    formatted measure is used.??Reports exported to Excel 2002
    format are not affected.
    

Local fix

  • Use Excel 2002 format
    

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM63785

  • Reported component name

    COG8 BI POWPLAY

  • Reported component ID

    5724W12PS

  • Reported release

    A11

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-02

  • Closed date

    2013-06-11

  • Last modified date

    2013-12-16

  • 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":"SSC6Q3Z","label":"PowerPlay Studio"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 December 2013