Cognos Export Excel Worksheet Naming

[DHanssen]

Hello,

I would like to create reports that can be exported in the Excel 2007 (.xlsx) file format where the worksheets within the file have naming other than the generic "Page Name" + "_#" convention.

First Ask: Can the numbering suffix (e.g. "_1", "_2", "_3") be turned off?

Second Ask: Can dynamic naming be used for Pagesets? (e.g. "Invoices_America", "Invoices_Europe", ... if grouped by a "Region" field)? Per IBM's Cognos documentation, there appears to be an administration option that could facilitate this but I assume it's not available as a Concur user: https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=sa-dynamically-naming-worksheet-tabs-in-ex...

Thank you.

[KevinD]

@DHanssen there is a way to do the dynamic naming, but it might not be in the way you think. You can create a Cognos report that is made up of several report pages. Each page would have a query that would return data for either the region, department, cost center, etc. Whatever it is you are looking for. Each report page would be named accordingly. For example, if I had the North America, APAC and EMEA regions, I would name each report page accordingly. That would be what appears on the Excel tabs. As for the automatic adding of the underscore and tab number, I've reached out to some of my reporting contacts to see if it is possible to remove these from the tab name.