Naming duplicate sheets in Excel 2007 reports (Cognos Analytics 12.0.1 only)

In IBM® Cognos Analytics 12.0.1, the advanced property RSVP.EXCEL.XLS2007_SUFFIX_PAGENUMBER, when set to true (default), provides a consistent way of naming duplicate sheets in Excel 2007 reports.

Note: The RSVP.EXCEL.XLS2007_SUFFIX_PAGENUMBER and RSVP.EXCEL.NUMBEREDSHEETNAMES properties are removed in Cognos Analytics 12.0.2. For more information, see Removing Excel sheet numbering.

The following naming logic is applied:

  • The suffix _duplicate_increment is added to duplicate sheet names, where the duplicate_increment always starts with 2 for the first duplicate of a given name, and increments by 1 for each subsequent duplicate. For example: Camping Equipment, Camping Equipment_2, Camping Equipment_3 or Products, Products_2, Products_3.
  • The prefix s_duplicate_increment is no longer added to the sheet names.

    This naming logic was used in Cognos Analytics 12 and prior versions.

  • The sheet names never exceed the Excel 31 character limit, including the situations when the duplicate sheet naming logic is applied.
This naming behavior affects the property RSVP.EXCEL.NUMBEREDSHEETNAMES in the following ways:
  • When RSVP.EXCEL.NUMBEREDSHEETNAMES is set to true, its behavior is overwritten.
  • When RSVP.EXCEL.NUMBEREDSHEETNAMES is set to false, there are no significant changes in its behavior, only fixes and improvements.

For more information, see Page breaks, page sets, and page layers.

About this task

If you need to retain the prior behavior of handling duplicate names, you can set the value of RSVP.EXCEL.XLS2007_SUFFIX_PAGENUMBER to false. However, this change is not recommended because you'll lose valuable improvements to Excel 2007 reports.

Procedure

  1. Follow the steps in the topic Configuring advanced settings for specific services.
  2. On the Set advanced settings - ReportService page, in the Parameter column, type RSVP.EXCEL.XLS2007_SUFFIX_PAGENUMBER.
  3. In the Value column, type false.