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

Question

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

[Deleted User] · Answer

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

Thomas Dodds · Answer

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.

Michael Verzijl · Answer

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?