on 03-22-2017 8:18 AM
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 !!
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Amit,
Thanks a lot for the help ! It worked as expected.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.