Original Message:
Sent: Sat October 05, 2024 06:03 AM
From: Ralf Roeber
Subject: Crosstab with Column Headers for grouped rows using Cognos for Microsoft Office = NOK
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/
Original Message:
Sent: Wed July 17, 2024 08:24 AM
From: GREG MCDONALD
Subject: Crosstab with Column Headers for grouped rows using Cognos for Microsoft Office = NOK
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/
Original Message:
Sent: Mon July 15, 2024 03:14 AM
From: Ralf Roeber
Subject: Crosstab with Column Headers for grouped rows using Cognos for Microsoft Office = NOK
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/
------------------------------