Skip to Content
0

Schedule webi document to CSV format - modify date format

Aug 07, 2017 at 03:32 AM

65

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Aug 07, 2017 at 09:13 AM
0

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


blank.png (14.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 27, 2017 at 10:22 PM
0

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.


Share
10 |10000 characters needed characters left characters exceeded