IBM Business Analytics

 View Only

 Cognos Analytics CSV Report Issue

Maliq Winter's profile image
Maliq Winter posted 08/12/26 04:50 PM

Hi, I have a Cognos report that I am attempting to download as a CSV. I have all relevant columns in a list. When running the report as HTML, the columns I have selected all show as chosen. When running the report as a CSV or Excel file, certain columns do not show up. All columns have the same properties and all come from one SQL query. Any idea what might be causing this?

Marc Reed's profile image
Marc Reed IBM Champion posted 08/13/26 01:56 AM

When running a report to CSV the report only runs one query and exports all the columns in that query, regardless of how the columns are used on a page.

Couple of questions.

  • How many queries are in the report? When run as CSV only one query is run - this is the first object in the report.
  • What happens if you export to XL data as this has the same properties as CSV - first query all columns.
  • Within the troublesome query what happens if you view tabular data, then export that tabular data to CSV
Patrick Neveu's profile image
Patrick Neveu IBM Champion posted 08/13/26 03:03 AM

Hi Maliq,

Which version do you use? Would you be able to reproduce using the samples report?

Do you see all the columns if you check the Cognos SQL used for this report?

Best regards,

Patrick Neveu

Related Content