PM74216: CORRUPTED EXCEL 2007 FILE IS CREATED WHEN LAYER NAME CONTAINS SPACE CHARACTER.

APAR status

• Closed as program error.

Error description

• When a layer name contains space character and the report is
  exported to Excel 2007 format as multiple sheets, the file is
  corrupted and we can't open it.?
  

Local fix

• 1 remove a space from each layer name on PowerPlay Client.
  2 remove a space from each category name on PowerPlay Transforme
  r.
  3 save as Excel 2002 on PowerPlay Client, open it with Excel 200
  7 and save it as Excel 2007 format.
  4 choose 'Single Worksheet' option as 'Excel Export for Layered
  Reports' settings on 'Preferences'.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Cognos Series 7 version 7.5.0 Fix Pack 2          *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• 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

  COG S7 PWRPLAY

• Fixed component ID

  5724W43PC

Applicable component levels

• R750 PSN

     UP