Cognos Analytics

 View Only

  • 1.  Dynamic tab labeling in excel output

    Posted 12 days ago

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



  • 2.  RE: Dynamic tab labeling in excel output

    IBM Champion
    Posted 12 days ago

    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


  • 3.  RE: Dynamic tab labeling in excel output

    Posted 12 days ago

    Hi,

     

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

     

    Roger

     




    Original Message


  • 4.  RE: Dynamic tab labeling in excel output

    IBM Champion
    Posted 11 days ago

    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


  • 5.  RE: Dynamic tab labeling in excel output

    Posted 11 days ago
    Edited by Piper Wilson 11 days ago

    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



  • 6.  RE: Dynamic tab labeling in excel output

    Posted 11 days ago

    Did you apply the setting in both the batch and report service. If not then that's probably your issue. We are on 11.2.4 but this has always worked just fine.

     

     

     

     

     

    Eric Muller

     

    Reporting & Analytics Engineer

    Information Management

     

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

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

     




    Original Message


  • 7.  RE: Dynamic tab labeling in excel output

    Posted 11 days ago

    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.



    Original Message


  • 8.  RE: Dynamic tab labeling in excel output

    Posted 10 days ago

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



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

    Original Message