Skip to Content
avatar image
Former Member

Error with a rapport in format CSV

Hello everyone,

I'm having an issue with a webi repport... in the body of the report I am using the next formule ='A'+[object], because I'm interested to add the letter A at the beginnig of the field. everything works fine in the repport, however, if i try to export it as a CSV file, the column where i have the formule, only shows the information of the object, no matters if i create a variable before or add the letter "A" in the body of the repport.

This situation happens if i try to make a planification or i if try to export the document direct from the Webi interface.

do you have any explanation of this behavior? what should i configurer in the webi server in order to fix this problem?

thanks in advance.

Moises

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 07, 2016 at 02:48 PM

    Hi Moises,

    when you export to CSV, only the data from the query is exported. If you want to export the content of the report as .CSV, you need to use the HTML interface.

    Regards,

    Rogerio

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      below are the picture showing how to export report data to csv.

      If you want to schedule as csv, what can be done is insert a dummy column between each column of the report, set its value to ',' (comma), including the header. Then schedule it as Plain text, then change the name of the report to something.txt without adding the file extension.

      I´m assuming your scheduling the report to a network folder

      Regards,

      Rogerio

  • Apr 07, 2016 at 02:48 PM

    This is because the CSV export from Webi does not actually export the report and any formulas. Instead, it exports the raw data from all of the data sets used in the report. This is the way it has always worked.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded