Skip to Content
avatar image
Former Member

Schedule webi document to CSV format - modify date format

Hi,

The problem is when we schedule a WEbi document to CSV format. The date format is not the format of the webi REPORT.

It's yyyy/mm/dd hh.mm.ss instinct dd/mm/yyyy.

We apply then a date format in the universe and it does'nt fix the problem. .

Using WEBI application : We tried the export to CSV from webi as explain in the SAP note, but is not possible to chose "blank" for the text qualifier , only --> " or--> '.

In our case CSV is mandatory , produced automatically every day without manual intervention with the correct date format. Is it any issue ?

https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0CBwQFjAA&url=http%3A%2F%2Fwww.sapimprovementfinder.com%2Fpublic%2Findex.php%2Fnote%2Fexport%3Fn%3D0001907457&ei=wA5XVKDJJoPUarvggZgE&usg=AFQjCNFJPTzdGKWfjhQzxNvrQAKwlDrHMw&bvm=bv.78677474,d.d2s

Version 1 from 09.09.2013 in English

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 07, 2017 at 09:13 AM

    have you checked from BI Launch Pad (HTML Mode)?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 27, 2017 at 10:22 PM

    Hi, Finally I found the solution

    Yes with html mode but not choosing the option "Export to CSV" directly the date format is not respected,

    Choosing --> Export the report --> then choosing format "ARCHIVE CSV"

    ddropboxdropboxroi-crmroi-10-clientsmdfexport-arch.png

    So the problem with WEBI JAVA is "Blank" for texte qualifier is not available.

    Thank's.

    Add comment
    10|10000 characters needed characters exceeded