SAP Knowledge Base Article - Public

2411695 - Edit/ Remove Header from exported Canvas report output files

Symptom

  • Is it possible to remove header from exported Canvas report output files?
  • How to edit/ remove header when Canvas report output file is placed to SFTP without manual intervention?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Schedule a Canvas report to SFTP or export it offline
  2. Open the output file when it is placed to SFTP server.
  3. Output file will have below lines at the top of the file:
    1. "Exported to CSV on <Timestamp>" 
    2. Example: "Exported to Excel on Wednesday, December 07, 2016 (Eastern Standard Time -05:00)"

 Header in ORD file.png

Cause

The header is there so that the customer knows that they have exported the correct version of that report.
For example, it helps distinguish between reports that are scheduled on a weekly basis where the data may be different from week to week.

Resolution

  • Currently there is no such functionality available in product which will remove header while exporting Canvas report or placing the report output file to SFTP.
  • It is not possible to edit it or to change the time zone as well.
  • The second row that is blank in the output file is also expected and cannot be removed.

Keywords

canvas, exported to excel on, exported to csv on, first row, secord row, Remove, Header, ORD, export, two, lines, Online, Report, Designer, Center, legacy, detailed, advanced, csv, xls, excel, timestamp, export, server  , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM suite all versions