BO 4.0 save as csv file format issue

[Former Member]

Hi All,

We are using BO 4.0 Webi for reporting on SAP BW 7.3 system. Some of our reports have to be scheduled to bring the output in CSV file format. When I schedule the report in CSV format, the final output has data in two sets. The first set has the list of columns which I have selected in my report. Starting on the next row I get to see the second set of data with all the objects selected in the query panel including the detail objects.

We only need the data for the columns which is selected in the report, but it is bringing the dump from all the objects in the dataprovider.

Can anyone tell me how to get rid of the second set of data in the same csv file ?

Thanks,

Prasad

[Henry_Banks]

Hi,

CSV format is reserved for 'data only' dataprovider dumps. it exports the entire webi microcube (query results)

You don't get that option when going 'save as' - which preserves the report formatting - in which case you should consider .xls

regards,

H