Troubleshooting
Problem
The following steps will remove the column headers from a list when exporting to CSV and EXCEL DATA.
Note: This is only valid for Cognos Analytics 11.1.7 and up
Set Advanced Setting
- Launch IBM Cognos Administration.
- On the Configuration tab, click Dispatchers and Services.
- Click the dispatcher name.
- In the list of the dispatcher services, find BatchReportService, and in the Actions column, click the Set properties icon.
- Click the Settings tab.
- Click Edit beside Advanced settings
- Note : You might have to Select the Override the settings acquired from the parent entry check box to add the parameter
- Under Parameter add RSVP.DISPLAY_HIDDEN_TITLES
- Then set the value to false
- Click OK twice
- The repeat steps 4-8 for the ReportService
Reporting
In Reporting set Column Titles to Hide in the properties of the List
Now run the report in CSV or EXCEL DATA and the column headers will gone.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl5QAAS","label":"Reporting-\u003EOutput formats and rendering"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.7;11.2.1"},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM Cognos Analytics
Component:
Reporting->Output formats and rendering
Software version:
11.1.7, 11.2.1
Document number:
6522986
Modified date:
06 May 2025
UID
ibm16522986
Manage My Notification Subscriptions