on 04-07-2016 3:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
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.