Cognos Analytics

 View Only
Expand all | Collapse all

Crosstab with Column Headers for grouped rows using Cognos for Microsoft Office = NOK

  • 1.  Crosstab with Column Headers for grouped rows using Cognos for Microsoft Office = NOK

    IBM Champion
    Posted Mon July 15, 2024 03:15 AM
      |   view attached

    Hello Cognoids,

    business department requested to have column headers in crosstab.

    Found solution by adding empty cells to crosstab and then hiding the edge of the crosstab and the fact cells with boxtype none. 

    This works well in HTML and Excel. But not when using Cognos for Microsoft Office.

    HTML

    Excel

    This works well when exporting to Excel.

    Cognos for Microsoft Office

    Importing the reports into Excel using Cognos for Microsoft office shows the "hidden" cells again.

    Attaching the report sample specs.

    Any ideas on how to achieve column headers in crosstab when using Cognos for Microsoft Office?

    Might this be a bug?

    Regards,

    Ralf

    #Cognos Analytics with Watson



    ------------------------------
    Ralf Roeber
    https://linkedin.com/in/ralf-roeber/
    ------------------------------

    Attachment(s)



  • 2.  RE: Crosstab with Column Headers for grouped rows using Cognos for Microsoft Office = NOK

    Posted Wed July 17, 2024 08:24 AM

    Hi Ralf, 

    I spoke with someone who knows this area well and he feels that this is working correctly and that they area you are looking at is expected to either have a messure in it or nothing.  You should log an IBM Idea:  https://ideas.ibm.com/

    Greg



    ------------------------------
    Greg McDonald
    Product Manager - Cognos Analytics
    IBM
    greg.mcdonald@ca.ibm.com
    https://www.linkedin.com/in/greg-mcdonald-6743961/
    ------------------------------



  • 3.  RE: Crosstab with Column Headers for grouped rows using Cognos for Microsoft Office = NOK

    IBM Champion
    Posted Sat October 05, 2024 06:04 AM
    Edited by Ralf Roeber Sat October 05, 2024 06:17 AM

    Hello Greg,

    if the layout works well in HTML and Excel, but not in IBM Cognos for Microsoft Office, I would rather interpret this as: the renderer providing the data to CfMO is ignoring the "box type: none" parameter, which might be intended by the programmer, but not by the user. 

    Same happens exporting to XML and CSV. The corner element containing the measure is being exported, all though the boxtype says: none. If there was a "simple" if around the exporting of the corner containing the measure, then it would be working as expected.

    IBM Ideas: CA-I-4437

    Regards,

    Ralf



    ------------------------------
    Ralf Roeber
    https://linkedin.com/in/ralf-roeber/
    ------------------------------



  • 4.  RE: Crosstab with Column Headers for grouped rows using Cognos for Microsoft Office = NOK

    Posted Sat October 05, 2024 12:24 PM

    Hi Ralf,

    Thank you, I have sent the IBM Idea on for review and feedback. 

    I will let you know!

    Greg



    ------------------------------
    Greg McDonald
    Product Manager - Cognos Analytics
    IBM
    greg.mcdonald@ca.ibm.com
    https://www.linkedin.com/in/greg-mcdonald-6743961/
    ------------------------------