Skip to Content
0

Strange data displayed when Exporting a webi report to CSV format

Mar 22, 2017 at 08:18 AM

92

avatar image

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 !!

10 |10000 characters needed characters left characters exceeded

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

0

Comma seperated

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Mar 22, 2017 at 10:20 AM
1

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"


untitled.png (31.7 kB)
untitled2.png (11.2 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello Amit,

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

1