OBIEE Report export to CSV has extra columns which are excluded from the result view.

Helan Kumar

OBIEE Report export to CSV has extra columns which are excluded from the result view.

Excel exports works fine (eg : 500 records in total which is basically grouping by the column which is there in the exclude list)

CSV exports brings more (eg : 1000+ records)

How do we handle this ?

OBIEE Version : 11.1.1.7.150120

Thanks, Helan

Michael Verzijl

Remove the columns from the criteria tab. CSV export is not looking at how you formatted the results, but uses the criteria tab for export.

Also see doc 2023149.1

Helan Kumar

Is there a way to handle this, because my result set will vary if i remove this column from the criteria / exclude section.

Michael Verzijl

In my opinion your report is created incorrectly if you are dependent on certain columns to be there. Have you checked your RPD to see if all is setup correctly?

Thomas Dodds

OBIEE as a data-pump is not the intended use ... the export to CSV doesn't care what you've got formatted or set in the exclude part of a visualization.  It runs the query and dumps all the rows and columns given what's in the Criteria tab.

[Deleted User]

+1'000 - CSV: https://en.wikipedia.org/wiki/Comma-separated_values