PI88054: IF RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE ADVANCED SETTING IS SET, IT NAMES THE THE TABS IN EXCEL SHEET INCORRECTLY.

APAR status

• Closed as documentation error.

Error description

• If RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE advanced setting is set
  to true in the report service, it names the the tabs in excel
  sheet to  <Product_line>,
  <Product_line>_2, <Product_line>_3.. and so on. Where as by
  default excel create page one_1, Page two_2.. so on.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Cognos Analytics                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * If RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE advanced setting is *
  * set to true in the report service, it names the the tabs in  *
  * excel sheet to  <Product_line>,                              *
  * <Product_line>_2, <Product_line>_3.. and so on.              *
  *                                                              *
  * However, as per the documentation below:                     *
  *                                                              *
  * https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0 *
  * /com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/c_cr_rptstd_frmat_re *
  * p_create_page_sets.html                                      *
  *                                                              *
  * The naming of the tabs in a report that contains page sets   *
  * that use Product line as the grouping item. In the Excel     *
  * output, worksheet tabs should be named Camping Equipment_1,  *
  * Golf Equipment_1, Camping Equipment_2, and so on.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update KC documentation                                      *
  ****************************************************************
  

Problem conclusion

• The corrected sentence now reads "In the Excel output, worksheet
  tabs are named Camping Equipment, Golf Equipment, Camping
  Equipment_2, Golf Equipment_2, and so on."
  https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com
  .ibm.swg.ba.cognos.ug_cr_rptstd.doc/c_cr_rptstd_frmat_rep_create
  _page_sets.html
  

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

Applicable component levels