Skip to Content
avatar image
Former Member

Strange data displayed when Exporting a webi report to CSV format

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.

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 22, 2017 at 10:20 AM

    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)
    Add comment
    10|10000 characters needed characters exceeded