cancel
Showing results for 
Search instead for 
Did you mean: 

Strange data displayed when Exporting a webi report to CSV format

Former Member
0 Kudos

When I schedule a webi report and try to export it as excel or text file the structure and data in the file is correct but when I try to export the same report in CSV format the structure and data in the exported file changes unexpectedly.

The actual columns in the report which needs to be exported are the variables created and when I try to export this report in CSV format, I see data based on BO query and not the variables(column headings and data from the BO query).

I have gone through many threads and from one of the thread came to know it is a known issue in Webi and by default it will dump the query data and will show the query object names.

https://archive.sap.com/discussions/thread/3448059

Is there any solution to this problem yet ? I need to schedule this report to run daily and client wants the report in CSV format.

Please Help !!

amitrathi239
Active Contributor
0 Kudos

what is the expected format in CSV? comma seprated or some other?

Former Member
0 Kudos

Comma seperated

Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor

Follow these steps to convert report data into CSV file.

Create one single variable and put all your objects/variable in this.

e.g =[Year]+","+[City]+","+[Margin]+","+[Sales revenue]

Header row Year,City,Margin,Sales revenue

If you will get some multi-value error then drag dimension objects in the table and later right click and hide.I have added City & year objects for same reason.

Save the report and right click & schedule.

Schedule->Format->select format "Text"

Schedule->Format->select option "use specfic name" and maully add ".csv" in the name. uncheck the option "add file extension"

Former Member

Hello Amit,

Thanks a lot for the help ! It worked as expected.

Answers (0)