Hello everyone,

I have the following question: I have a page set that repeats internal pages via Master/Detail. The output is Excel. How do I get the labels of the tabs in Excel to be equal to the value of a data field? 

The default behavior of v11.2 is that the tabs are named as the page is named in the report definition, i.e. Page_1, Page_2 etc. 

However, I would like the tabs to be labeled Customername_1, Customername_2 (a different customer) and so on.

How can I achieve this?

Greetings from Germany
Roger

------------------------------
Roger Lewin All for One SE
Senior Technical Consultant - Analytics
All for One SE
Dortmund
------------------------------

Hi Roger,

there's an extended property that has to be set on (Batch) Report Service called "RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE". Set it to "true" und Cognos puts the data item instances as worksheet names into the Excel file - if applicable.

See:

https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=sa-dynamically-naming-worksheet-tabs-in-excel-2007-reports

------------------------------
Robert Dostal
Team Leader BI
GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
Ingelfingen
------------------------------

Original Message:
Sent: 5/7/2024 10:57:00 AM
From: Robert Dostal
Subject: RE: Dynamic tab labeling in excel output

Hi Roger,

there's an extended property that has to be set on (Batch) Report Service called "RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE". Set it to "true" und Cognos puts the data item instances as worksheet names into the Excel file - if applicable.

See:

https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=sa-dynamically-naming-worksheet-tabs-in-excel-2007-reports

------------------------------
Robert Dostal
Team Leader BI
GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
Ingelfingen
------------------------------

Hi Roger,

that's strange. In our systems we just have to activate the setting and it works. May it is something related to your report?
I can only suggest to open a support ticket at IBM and try to find out which setting maybe blocks the system from applying the data to the worksheet names.

------------------------------
Robert Dostal
Team Leader BI
GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
Ingelfingen
------------------------------

Original Message:
Sent: Tue May 07, 2024 12:57 PM
From: Roger Lewin
Subject: Dynamic tab labeling in excel output

Hi,

 

I already tried it, but maybe I did something wrong or it doesn't work at all?

 

Roger

 

Original Message:
Sent: 5/7/2024 10:57:00 AM
From: Robert Dostal
Subject: RE: Dynamic tab labeling in excel output

Hi Roger,

there's an extended property that has to be set on (Batch) Report Service called "RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE". Set it to "true" und Cognos puts the data item instances as worksheet names into the Excel file - if applicable.

See:

https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=sa-dynamically-naming-worksheet-tabs-in-excel-2007-reports

------------------------------
Robert Dostal
Team Leader BI
GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
Ingelfingen
------------------------------

Original Message:
Sent: 5/8/2024 4:24:00 AM
From: Roger Lewin
Subject: RE: Dynamic tab labeling in excel output

Hi,

 

I edited the report service and restarted the whole cognos service afterwards. Strangely enough the new setting disappeared .... Imho that's the reason why It didn't work. Let's go the ticket way.

 

Thanks nonetheless and all the best

Roger

Have you set the advanced properties in Cognos admin i.e. RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE TRUE

------------------------------
Trevor Fyfe
------------------------------

Original Message:
Sent: Wed May 08, 2024 02:02 AM
From: Eric Mueller
Subject: Dynamic tab labeling in excel output

Try this https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=sa-dynamically-naming-worksheet-tabs-in-excel-2007-reports

 

Eric Muller

 

Reporting & Analytics Engineer

Information Management

 

DAS UK Group, Trinity Quay, 2 Avon Street, Bristol, BS2 0PT 

http://www.das.co.uk/

 

DAS Legal Expenses Insurance Company processes your personal information in accordance with our Privacy Notice. You can find our Privacy Notice online at www.dasinsurance.co.uk/legal/privacy-statement.

This email is from DAS Legal Expenses Insurance Company Limited, part of the DAS UK Group. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or legally privileged material. If you receive this message in error, please send it back to us before deleting it. Do not use, copy, retain or disclose the information contained in this message or in any attachments.

DAS Legal Expenses Insurance Company Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority (FRN202106) and the Prudential Regulation Authority.

On 16 November 2022, the registered office address for each of the DAS UK Group businesses – DAS UK Holdings Limited, DAS Legal Expenses Insurance Company Limited, DAS Law Limited and DAS Services Limited – changed to: DAS Parc, Greenway Court, Bedwas, Caerphilly CF83 8DW.  Please use this address for all postal correspondence from now on.

Registered in England and Wales. Company Number: 103274. Website: www.das.co.uk

This email has been scanned for viruses by Mimecast.