View or Download Report to Excel in Cognos Analytics
Modified on: Thu, 11 Feb, 2021 at 10:16 AM
How to generate Cognos Analytics Report for Excel
When you see the report in your list, click on the More (...) menu. You will see an option to 'Run as'. Then you can select Excel, etc. (See snapshots below)
'Excel Data' has NO formatting, this is raw data with column headers, which is preferred by third parties for importing.
'Excel' has formatting for ease of viewing especially if you have subtotal and total rows.
See also: On apscn.org > SMS > 20.4 Training Documentation > in the Cognos section if you pull the Cognos Analytics Training Guide, instructions for this item begin on page 14. or On apscn.org > FMS > Financial Management System - 5.2 Cognos Analytics Training Documentation, instructions for this item begin on page 23.
Was this answer helpful?
Sorry we couldn't be helpful. Help us improve this article with your feedback.