Skip to Content
Author's profile photo AMIT KUMAR

How to schedule Webi report output in CSV or custom format

This document will describe how to schedule Webi report output in CSV or custom format (PIPE).

Default options are available to schedule webi query data in CSV or export report data in CSV with CSV as achieve option.

  • Default CSV format: This option in report scheduling enable to export webi query data in CSV (comma separated values) format. This option helps if all calculations are handled at database or universe level.
  • CSV as archive: SAP introduced new feature from BI 4.1 to save as report data in CSV format with option CSV as achieve. This option enable the option to export report data in CSV format. But this is specific to report export. This is not available with report scheduling yet.

With the above two options the  gap still persists i.e. how to schedule webi report output in CSV or custom format.

When is this helpful?

  • If data is coming from multiple webi queries.
  • If calculations are achieved by reports variables/report level filters.
  • If expected format is other than that CSV. e.g. PIPE separated values.

Here I am taking data from e-fashion universe to demonstrate how can we schedule report data in CSV or custom format.

  1. This is the report data which I want to schedule at File system or FTP location.
  2. Create variable Var_Main.Sample like:Var_main =Char(34)+[Year]+Char(34)+”,”+Char(34)+[State]+Char(34)+”,”+Char(34)+[City]+Char(34)+”,”+Char(34)+[Store name]+Char(34)+”,”+Char(34)+[Sales revenue]+Char(34)+”,”+Char(34)+[Quantity sold]+Char(34)
  3. Drag Var_main variable in report and update header as per required definition.
  4. Export the report.
  5. Right click and schedule the report.
  6. Under the Format “select Plain Text”.
  7. Under the Destination select destination (File system/FTP/Email) and add the title and manually add .csv in the use specific name. Uncheck the option “add extension”
  8. Schedule the report.
  9. Final output as:

Similarly for PIPE create another variable.

Sample like:

=”|”+[Year]+”|”+”,”+”|”+[State]+”|”+”,”+”|”+[City]+”|”+”,”+”|”+[V_Store Name]+”|”+”,”+”|”+[Sales revenue]+”|”+”,”+”|”+[Quantity sold]+”|”


Points to be noted:

  • This option will only work if file delivery location is (BI Inbox/EMAIL/FTP/File System/SFTP server).This option will not work if default location is enterprise.
  • SAP disabled the add extension feature from BI 4.2 and re-enabled from BI 4.2 SP03 Patch 8.Without add extension this option won’t work.

For more details check mentioned sap note.

2369625 – ‘Add File Extension’ option is missing for email schedule destination in SAP BusinessObjects BI Platform 4.2 SP3




Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Sulochan Gupta
      Sulochan Gupta

      It is very much informative content, thanks for sharing with community.

      Author's profile photo Timi Jones
      Timi Jones

      Awesome document Amit !!!


      Author's profile photo Former Member
      Former Member

      I have no idea what I am missing in doing this. This works and returns data but only when returning one record. While I was building this I was using one record for testing. When I finished my build and removed my file ID filter, I return no data. I have also tried adding one record at a time but as soon as there is more than one record, I have no data.

      What am I missing?



      Author's profile photo AMIT KUMAR
      Blog Post Author

      Add employee number object as second column and right click and hide it.if it will not work then share your formula please.

      Author's profile photo Juliana Limetre Galarraga Lucas
      Juliana Limetre Galarraga Lucas

      Very helpful!! Thanks for sharing. =D

      Author's profile photo Guruprasad Iyer
      Guruprasad Iyer

      Its strange why SAP did not add native CSV support for schedule in the first, anyways Amit your solution worked great.




      Author's profile photo Nalin Mishra
      Nalin Mishra

      Can We export multiple tabs while scheduling option CSV ? If My report is having two tabs and both tabs should be export after scheduling.



      Kirti Rane