PM27671: MISSING CHART WHEN RUNNING CHART REPORT WITH NULL VALUES OR "<" CHARACTER TO EXCEL 2007 FORMAT

APAR status

• Closed as program error.

Error description

• A chart is created which contains a "less than" (<) character in
  the name of a Category on the chart.  It also contains data
  items on the Categories or Series with a division calculation
  where either the numerator or denominator of the division
  contain NULL data.  When this report is run as Excel 2007
  format, when the output is opened in Excel 2007 the chart is
  missing from the report.  If the output is opened in Excel 2003
  using the excel converter it throws the error "The converter
  failed to open the file".
  

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